Excele output error when jsreport records are too many( only 2,614 )



  • Can you please help?

    The error I get is as follows:

    {"error":"Error rendering report: rendering has finished with errors:A critical error occurred while trying to execute the render command (2). Timeout during execution of html-to-xlsx recipe (1). caused by error (2):-> stackError: at onCriticalError (D:\snapshot\jsreport\node_modules\jsreport-cli\lib\commands\render.js:302:19) at D:\snapshot\jsreport\node_modules\jsreport-cli\lib\commands\render.js:201:16 at processTicksAndRejections (internal/process/task_queues.js:93:5)caused by error (1):-> stackError: at Client.render (D:\snapshot\jsreport\node_modules\jsreport-client\lib\client.js) at processTicksAndRejections (internal/process/task_queues.js:93:5) at async startRender (D:\snapshot\jsreport\node_modules\jsreport-cli\lib\commands\render.js:319:24) at async D:\snapshot\jsreport\node_modules\jsreport-cli\lib\commands\render.js:186:24 at async Commander.executeCommand (D:\snapshot\jsreport\node_modules\jsreport-cli\lib\commander.js:242:22)Remote stack: Error: at Timeout._onTimeout (D:\snapshot\jsreport\node_modules\script-manager\lib\in-process.js:23:10) at listOnTimeout (internal/timers.js:531:17) at processTimers (internal/timers.js:475:7)"}



  • Hi,

    did you try to increase the timeout? For example like this:

    var rs = new LocalReporting()                
                    .UseBinary(JsReportBinary.GetBinary())
                    .Configure(cfg => {
                        cfg.ReportTimeout = 120000;
                        return cfg;
                    })
                    .AsUtility()
                    .Create();
    

    Or in jsreport.config.json:

    { "reportTimeout": 120000 ... }
    

    We have some notes regarding HTML to xlsx conversion performance here
    https://jsreport.net/learn/html-to-xlsx#performance


Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.