Thingworx Reporting capability

[LY_10838955]

Hi Everyone,

I am building some custom reports using Thingworx and FlexPLM query builder in QBR I have some 80000-1000000 data I am fetching these records but I am getting time out issue so what time shall I set for the script time to fetch the data default Timeout is 30 second.

Error: "Execution of Script terminated after : 67 seconds. Timeout configured for 30 seconds."

For this I need to increase service execution time for this 2 approaches I know :

1) Sql Service ---> Service Info ---> Time out Interval (sec)

2) Platform-settings.json ---> define script Time-out

How can I decide the timeout duration Please suggest some steps if anyboday have any idea?

or tell the value .

Thanks and Regards,
Lav.

[Rocko]

Running the SQL directly on the DB should give you an indication about the time needed.

[LY_10838955]

Hi @Rocko 

Before DB I should get the data in Thingworx for that I am using Javascript not sql

so is there any way to get the time.

Thanks 

Lav

[Rocko]

So the INSERT is timing out? Because you wrote "time to fetch the data". If so, try a smaller dataset, e.g. 10.000 rows only and see how long that takes, then multiply by x.

[nmutter]

If possible, you could also just set timeout to some big number e.g. 30minutes and execute your service and check how long it took. E.g. via network tab of browser, or via log statements. Do this like e.g. 10 times to get a feeling about the spread of execution time.

After you can set timeout accordingly.