Timeout: Request failed to complete



  • I changed the "reportTimeout": 240000, from 60000 but same issue

    Timeout: Request failed to complete in 15000ms
    logs:
    +0      Starting rendering request 1 (user: admin)
    +3      Rendering template { name: csv_game_rounds, recipe: text, engine: jsrender, preview: true }
    +6      Data item not defined for this template.
    +7      Resources not defined for this template.
    +14     Executing script dbo_games_rounds using http-server strategy
    +15893  Rendering request 1 finished with error in 15893 ms
    RequestError: Timeout: Request failed to complete in 15000ms
        at Request.userCallback (/home/ubuntu/jsreportapp/node_modules/mssql/lib/tedious/request.js:437:19)
        at Request.callback (/home/ubuntu/jsreportapp/node_modules/tedious/lib/request.js:56:14)
        at Connection.message (/home/ubuntu/jsreportapp/node_modules/tedious/lib/connection.js:2449:24)
        at Connection.dispatchEvent (/home/ubuntu/jsreportapp/node_modules/tedious/lib/connection.js:1279:15)
        at MessageIO.<anonymous> (/home/ubuntu/jsreportapp/node_modules/tedious/lib/connection.js:1139:14)
        at MessageIO.emit (events.js:315:20)
        at MessageIO.EventEmitter.emit (domain.js:529:15)
        at Message.<anonymous> (/home/ubuntu/jsreportapp/node_modules/tedious/lib/message-io.js:46:14)
        at Message.emit (events.js:327:22)
        at Message.EventEmitter.emit (domain.js:529:15)


  • RequestError: Timeout: Request failed to complete in 15000ms
        at Request.userCallback (/home/ubuntu/jsreportapp/node_modules/mssql/lib/tedious/request.js:437:19)
        at Request.callback (/home/ubuntu/jsreportapp/node_modules/tedious/lib/request.js:56:14)
        at Connection.message (/home/ubuntu/jsreportapp/node_modules/tedious/lib/connection.js:2449:24)
        at Connection.dispatchEvent (/home/ubuntu/jsreportapp/node_modules/tedious/lib/connection.js:1279:15)
        at MessageIO.<anonymous> (/home/ubuntu/jsreportapp/node_modules/tedious/lib/connection.js:1139:14)
        at MessageIO.emit (events.js:315:20)
        at MessageIO.EventEmitter.emit (domain.js:529:15)
        at Message.<anonymous> (/home/ubuntu/jsreportapp/node_modules/tedious/lib/message-io.js:46:14)
        at Message.emit (events.js:327:22)
        at Message.EventEmitter.emit (domain.js:529:15)


  • 
    2021-04-19T16:00:48.201Z - info: Starting rendering request 2 (user: admin)
    2021-04-19T16:00:48.202Z - info: Rendering template { name: csv_game_rounds, recipe: text, engine: jsrender, preview: true }
    2021-04-19T16:00:48.203Z - debug: Data item not defined for this template.
    2021-04-19T16:00:48.203Z - debug: Resources not defined for this template.
    2021-04-19T16:00:48.204Z - debug: Executing script dbo_games_rounds using http-server strategy
    2021-04-19T16:01:03.350Z - warn: Rendering request 2 finished with error in 15149 ms
    2021-04-19T16:01:03.352Z - warn: Error when processing render request 2 Timeout: Request failed to complete in 15000ms RequestError: Timeout: Request failed to complete in 15000ms
        at Request.userCallback (/home/ubuntu/jsreportapp/node_modules/mssql/lib/tedious/request.js:437:19)
        at Request.callback (/home/ubuntu/jsreportapp/node_modules/tedious/lib/request.js:56:14)
        at Connection.message (/home/ubuntu/jsreportapp/node_modules/tedious/lib/connection.js:2449:24)
        at Connection.dispatchEvent (/home/ubuntu/jsreportapp/node_modules/tedious/lib/connection.js:1279:15)
        at MessageIO.<anonymous> (/home/ubuntu/jsreportapp/node_modules/tedious/lib/connection.js:1139:14)
        at MessageIO.emit (events.js:315:20)
        at MessageIO.EventEmitter.emit (domain.js:529:15)
        at Message.<anonymous> (/home/ubuntu/jsreportapp/node_modules/tedious/lib/message-io.js:46:14)
        at Message.emit (events.js:327:22)
        at Message.EventEmitter.emit (domain.js:529:15)
    2021-04-19T16:01:03.354Z - warn: Error during processing request at https://reports.luckiihhr.com:5489/api/report/csv_game_rounds


  • other similar reports run fine

    2021-04-19T16:02:38.540Z - info: reporter initialized
    2021-04-19T16:02:43.969Z - debug: OData query on templates
    2021-04-19T16:02:45.524Z - debug: OData query on templates
    2021-04-19T16:02:47.910Z - info: Starting rendering request 1 (user: admin)
    2021-04-19T16:02:47.912Z - info: Rendering template { name: csv_all_funding_trans, recipe: text, engine: jsrender, preview: true }
    2021-04-19T16:02:47.914Z - debug: Data item not defined for this template.
    2021-04-19T16:02:47.915Z - debug: Resources not defined for this template.
    2021-04-19T16:02:47.917Z - debug: Executing script dbo_all_funding_transactions using http-server strategy
    2021-04-19T16:02:48.525Z - debug: Base url not specified, skipping its injection.
    2021-04-19T16:02:48.528Z - debug: Rendering engine jsrender using http-server strategy
    2021-04-19T16:02:48.577Z - debug: Compiled template not found in the cache, compiling
    2021-04-19T16:02:48.578Z - debug: Executing recipe text
    2021-04-19T16:02:48.579Z - info: Rendering request 1 finished in 669 ms
    2021-04-19T16:02:48.580Z - debug: Skipping storing report.

  • administrators

    hi! according to the error message, the error comes from an SQL client timeout, I guess you are executing an SQL query in a script, right? changing the "reportTimeout" options does not have any effect to external libraries, like the SQL client you are using, which seems to be the tedious package. you need to update your script and your query call to pass a bigger timeout option than the default (which seems to be 15s)



  • Correct it is a big sql query table. I will try that


Log in to reply
 

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