topic Re: Thingworx Reporting capability in ThingWorx Developers

Thingworx Reporting capability

LY_10838955 — Mon, 02 Sep 2024 09:38:29 GMT

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.

Re: Thingworx Reporting capability

Rocko — Mon, 02 Sep 2024 11:21:45 GMT

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

Re: Thingworx Reporting capability

LY_10838955 — Mon, 02 Sep 2024 11:24:58 GMT

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

Re: Thingworx Reporting capability

Rocko — Mon, 02 Sep 2024 11:30:14 GMT

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.

Re: Thingworx Reporting capability

nmutter — Tue, 10 Sep 2024 15:05:09 GMT

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.