Skip to main content
L
LY_1083895510-Marble
10-Marble
September 2, 2024
Question

Thingworx Reporting capability

  • September 2, 2024
  • 2 replies
  • 1043 views

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.

2 replies

Rocko
Rocko19-Tanzanite
19-Tanzanite
September 2, 2024

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

L
LY_1083895510-MarbleAuthor
10-Marble
September 2, 2024

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
Rocko19-Tanzanite
19-Tanzanite
September 2, 2024

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.

N
nmutter16-Pearl
16-Pearl
September 10, 2024

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.

Terms & ConditionsCookie settingsAccessibility statement