cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

how to increase execution time to run query in Database-Thing from thingworx

AP_10343008
13-Aquamarine

how to increase execution time to run query in Database-Thing from thingworx

We created Database-Thing using Database ThingTemplate. If the query executed for more than 60 seconds, execution stopped and throwing below error.

Error:

Unable to Invoke Service Query on Database-Thing : Execute Query failed: net.snowflake.client.jdbc.SnowflakeSQLException: SQL execution canceled

 

The input query takes 3 minutes to fetch output. But Thingworx connectivity is not allowing to execute query more than 1 minute. Kindly let me know how to increase execution time to run query in Database-Thing.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Arun_C
16-Pearl
(To:Arun_C)

Hi @AP_10343008 ,

 

Also you can try directly increase the service timeout in database's entity service info level itself.

 

Arun_C_2-1694495487740.png

 

Thanks & Regards,

Arun C

 

 

View solution in original post

2 REPLIES 2

Hi @AP_10343008 ,

 

By updating the ScriptTimeout in Platform-Settings Json will helps to increase the service execution time in thingworx.

 

"BasicSettings": {
   ...
   "ScriptTimeout": 60
}

 

Kindly find the below attched articles it may helps you. 

Thanks & Regards,

Arun C

Arun_C
16-Pearl
(To:Arun_C)

Hi @AP_10343008 ,

 

Also you can try directly increase the service timeout in database's entity service info level itself.

 

Arun_C_2-1694495487740.png

 

Thanks & Regards,

Arun C

 

 

Top Tags