Timeout: Request failed to complete

djbrody

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)

djbrody

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)

djbrody


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

djbrody

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.

bjrmatos

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)

djbrody

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