Posts made by vikky-noelle

Hey, I am trying to password protect my PDFs using one of your platform-suggested libraries https://www.npmjs.com/package/jsreport-pdf-password?activeTab=readme
Everytime I try to install it, I get this error.

npm ERR! code 1
npm ERR! path D:\chrome-pdf\GIT_REPO\project-report-server\node_modules\hummus
npm ERR! command failed
npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build $EXTRA_NODE_PRE_GYP_FLAGS
npm ERR! 'node-pre-gyp' is not recognized as an internal or external command,
npm ERR! operable program or batch file.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\user1\AppData\Local\npm-cache\_logs\2023-09-06T03_33_09_562Z-debug-0.log

I installed node-gyp too and got a different set of error.

npm ERR! code 1
npm ERR! path D:\chrome-pdf\GIT_REPO\project-report-server\node_modules\hummus
npm ERR! command failed
npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build $EXTRA_NODE_PRE_GYP_FLAGS
npm ERR! Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\user1\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build=$EXTRA_NODE_PRE_GYP_FLAGS --module=D:\chrome-pdf\GIT_REPO\project-report-server\node_modules\hummus\binding\hummus.node --module_name=hummus --module_path=D:\chrome-pdf\GIT_REPO\project-report-server\node_modules\hummus\binding --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v93' (1)
npm ERR! node-pre-gyp info it worked if it ends with ok
npm ERR! node-pre-gyp info using node-pre-gyp@0.17.0
npm ERR! node-pre-gyp info using node@16.15.0 | win32 | x64
npm ERR! node-pre-gyp WARN Using needle for node-pre-gyp https download
npm ERR! node-pre-gyp info check checked for "D:\chrome-pdf\GIT_REPO\project-report-server\node_modules\hummus\binding\hummus.node" (not found)
npm ERR! node-pre-gyp http GET https://hummus.s3-us-west-2.amazonaws.com/hummus/v1.0.108/node-v93-win32-x64-unknown.tar.gz
npm ERR! node-pre-gyp http 404 https://hummus.s3-us-west-2.amazonaws.com/hummus/v1.0.108/node-v93-win32-x64-unknown.tar.gz
npm ERR! node-pre-gyp WARN Tried to download(404): https://hummus.s3-us-west-2.amazonaws.com/hummus/v1.0.108/node-v93-win32-x64-unknown.tar.gz
npm ERR! node-pre-gyp WARN Pre-built binaries not found for hummus@1.0.108 and node@16.15.0 (node-v93 ABI, unknown) (falling back to source compile with node-gyp)
npm ERR! node-pre-gyp http 404 status code downloading tarball https://hummus.s3-us-west-2.amazonaws.com/hummus/v1.0.108/node-v93-win32-x64-unknown.tar.gz
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.1.0
npm ERR! gyp info using node@16.15.0 | win32 | x64
npm ERR! gyp info ok
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.1.0
npm ERR! gyp info using node@16.15.0 | win32 | x64
npm ERR! gyp info find Python using Python version 3.10.11 found at "C:\Users\user1\AppData\Local\Microsoft\WindowsApps\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\python.exe"
npm ERR! gyp ERR! find VS
npm ERR! gyp ERR! find VS msvs_version not set from command line or npm config
npm ERR! gyp ERR! find VS VCINSTALLDIR not set, not running in VS Command Prompt
npm ERR! gyp ERR! find VS could not use PowerShell to find Visual Studio 2017 or newer, try re-running with '--loglevel silly' for more details
npm ERR! gyp ERR! find VS looking for Visual Studio 2015
npm ERR! gyp ERR! find VS - not found
npm ERR! gyp ERR! find VS not looking for VS2013 as it is only supported up to Node.js 8
npm ERR! gyp ERR! find VS
npm ERR! gyp ERR! find VS **************************************************************
npm ERR! gyp ERR! find VS You need to install the latest version of Visual Studio
npm ERR! gyp ERR! find VS including the "Desktop development with C++" workload.
npm ERR! gyp ERR! find VS For more information consult the documentation at:
npm ERR! gyp ERR! find VS https://github.com/nodejs/node-gyp#on-windows
npm ERR! gyp ERR! find VS **************************************************************
npm ERR! gyp ERR! find VS
npm ERR! gyp ERR! configure error
npm ERR! gyp ERR! stack Error: Could not find any Visual Studio installation to use
npm ERR! gyp ERR! stack     at VisualStudioFinder.fail (C:\Users\user1\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:122:47)
npm ERR! gyp ERR! stack     at C:\Users\user1\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:75:16
npm ERR! gyp ERR! stack     at VisualStudioFinder.findVisualStudio2013 (C:\Users\user1\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:364:14)
npm ERR! gyp ERR! stack     at C:\Users\user1\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:71:14
npm ERR! gyp ERR! stack     at C:\Users\user1\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:385:16
npm ERR! gyp ERR! stack     at C:\Users\user1\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:54:7
npm ERR! gyp ERR! stack     at C:\Users\user1\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:33:16
npm ERR! gyp ERR! stack     at ChildProcess.exithandler (node:child_process:406:5)
npm ERR! gyp ERR! stack     at ChildProcess.emit (node:events:527:28)
npm ERR! gyp ERR! stack     at maybeClose (node:internal/child_process:1092:16)
npm ERR! gyp ERR! System Windows_NT 10.0.22621
npm ERR! gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\user1\\AppData\\Roaming\\npm\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "configure" "--fallback-to-build=$EXTRA_NODE_PRE_GYP_FLAGS" "--module=D:\\chrome-pdf\\GIT_REPO\\project-report-server\\node_modules\\hummus\\binding\\hummus.node" "--module_name=hummus" "--module_path=D:\\chrome-pdf\\GIT_REPO\\project-report-server\\node_modules\\hummus\\binding" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v93"
npm ERR! gyp ERR! cwd D:\chrome-pdf\GIT_REPO\project-report-server\node_modules\hummus
npm ERR! gyp ERR! node -v v16.15.0
npm ERR! gyp ERR! node-gyp -v v9.1.0
npm ERR! gyp ERR! not ok
npm ERR! node-pre-gyp ERR! build error
npm ERR! node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\user1\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build=$EXTRA_NODE_PRE_GYP_FLAGS --module=D:\chrome-pdf\GIT_REPO\project-report-server\node_modules\hummus\binding\hummus.node --module_name=hummus --module_path=D:\chrome-pdf\GIT_REPO\project-report-server\node_modules\hummus\binding --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v93' (1)
npm ERR! node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\user1\AppData\Roaming\npm\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
npm ERR! node-pre-gyp ERR! stack     at ChildProcess.emit (node:events:527:28)
npm ERR! node-pre-gyp ERR! stack     at maybeClose (node:internal/child_process:1092:16)
npm ERR! node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (node:internal/child_process:302:5)
npm ERR! node-pre-gyp ERR! System Windows_NT 10.0.22621
npm ERR! node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\user1\\AppData\\Roaming\\npm\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build" "$EXTRA_NODE_PRE_GYP_FLAGS"       
npm ERR! node-pre-gyp ERR! cwd D:\chrome-pdf\GIT_REPO\project-report-server\node_modules\hummus
npm ERR! node-pre-gyp ERR! node -v v16.15.0
npm ERR! node-pre-gyp ERR! node-pre-gyp -v v0.17.0
npm ERR! node-pre-gyp ERR! not ok

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\user1\AppData\Local\npm-cache\_logs\2023-09-06T03_43_27_858Z-debug-0.log

Why am I getting this error? How do I sort this out?

Can I also increase workers to somehow increase the performance or concurrency of reports being generated?

I am using AWS instance. It is a t2.medium dedicated to the server but js Report is running on docker using ECS service. The ECS service restricts it to 1024MBs of ram memory. I am not sure about the memory usage but it crashes with less memory.

Hey, I have a free version of JSreport deployed we have made changes in the template, and the jsReport server crashed. I increased the memory to 1024MBs and the server is very slow compared to the instance running in our dev environment.

Any idea as to why this happens? Or how can I make jsReport faster, does having multiple templates make it slower in general? (I hope not because we are thinking of having all templates in one instance of jsReport)

How will I remove an entire column as well?

I tried this on my end and it does not work properly. Does this work on excel that I am making?

{{xlsxRemove "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row" 0}}

{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}}
<row>
    <c t="inlineStr"><is><t>I should have no style</t></is></c>
    <c t="inlineStr"><is><t>I should have no style</t></is></c>
</row>
{{/xlsxAdd}}

{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}}
<row>
    <c t="inlineStr"><is><t>I should be red</t></is></c>
    <c t="inlineStr"><is><t>I should be red</t></is></c>
</row>
{{/xlsxAdd}}

{{xlsxRemove "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row[0].c" 0}}

{{{xlsxPrint}}}

This does not work. It removes the last cell and not the one at the 0th index.

Can you create a new playground or post the code here?

Hey, I am working with xlsx recipe, and I was wondering how I can remove a specific column from the excel sheet?

I have a server deployed on AWS with a RAM of 1GB, it is dockerized and was running fine until recently where I started getting the error.

Worker terminated due to reaching memory limit: JS heap out of memory
Error [WORKER_CRASHED]: Worker terminated due to reaching memory limit: JS heap out of memory
    at new NodeError (node:internal/errors:371:5)
    at Worker.[kOnExit] (node:internal/worker:276:26)
    at Worker.<computed>.onexit (node:internal/worker:198:20)

I tried increasing the NODE_OPTIONS=--max-old-space-size=6096 but nothing changed, it even crashes the whole instance of js report and the server gives 503 error, I looked at the documentation but the template I am using is not huge at all.

Any help is appreciated!

Hey, I have created a new user, now I wish to access the templates I have created from the admin user. Is there a way to do that? I don't wish to manually give permission to every file being consumed by a template ofcourse.

I wish to map templates to urls, for example:
www.example.com/api/generate/invoice serves templates from the invoice folder.
www.example.com/api/generate/summary serves templates from the summary folder.

Will someone from the jsReport team help us for doing it correctly if need be?

So basically if I mark a server with development true, it will be identified as a dev instance and I can host this on services like AWS for use in my dev team?

Because we have a QA environment and a dev environment only accessed by our team, I wish to use it independently here without restrictions.

How do you guys distinguish between a production instance and a dev instance? Because I see that dev instances are free. This has me a bit confused as well.

What is a dev instance according to your definition?
The website has this * The server is considered as production if it is used by users outside of the dev team. This means that the continuous integration server is considered as development for example. However UAT server can be considered as production if it is reached by the users outside of the dev team. How do you even know what users are from a dev team?

Hey, I read through the Buy page of the website and I had a certain doubt.

Can I use the same license for multiple instances that I run, I wish to have 2 instances/machines that have jsReport in it?

I can use the same with the free version, limitation being the 5 templates we can use.

Thank you so much for answering!

For someone who faces something similar in the future.
I got it sorted out, apparently, AWS has a feature that checks if a service is healthy or not by checking an endpoint at a set interval of time. By default it is set for the route / whereas jsReport we can set it as /api/ping It is something I missed, therefore even though there was apt memory for jsReport to operate because the health endpoint failed, AWS assumed that the service is down or has some issues in it. Thereby the 503 error.

Note, that this error earlier was happening because of less memory assigned to it.

Thank you so much for answering this even though it was in the documentation!

How much memory does jsReport need? I have assigned 1024MB to it and it still gives me 503. It has me confused.

Is there a way that we only run the jsReport server and not the studio?
I don't really need the studio and want to use the API endpoints that are exposed. I am assuming this will reduce the size and memory usage considerably?