Skip to main content
Lo_ry9610-Marble
10-Marble
Apr 30, 2024 2:24 PM UTC
Question

Error when executing SQL queries

Hello,

 

I'm having an issue with sql queries in thingworx that gives this error:  

 

"Unable to Invoke Service DBL_datalabdb_R_EQUIPER_SelectAll_SQL on DBL_datalabdb_SQLFourFusion : Execute Query failed. Please check Database logs for more details." 

 

any clue why it is giving this error? 

 

Ps: i have data coming in on applications (indirect link with db : ok)  which is strange 

3 replies

bchaudhary_4480085-Regular Member
5-Regular Member
Apr 30, 2024 4:29 PM UTC

Hello @Lo_ry96 

 

Could you pls confirm whether your DB is connected or not?

 

Regards,

Bhawna

Translate
Lo_ry9610-MarbleAuthor
10-Marble
May 2, 2024 7:17 AM UTC

Hello, 

 

could you elaborate on testing the connection to DB ?  do you mean try basic querry like GETDate ? 

yes i can execute getdate properly but that is the only querry that does not give the error mentionned above.. 

Lo_ry_0-1714634211914.png

 

 

Thanks 

Translate
Rocko
Rocko19-Tanzanite
19-Tanzanite
May 2, 2024 12:34 PM UTC

Have you checked Database logs for more details, as the message recommends?

Without having more details this could be anything, either on TWX side or on DB side. Wrong user, wrong password, missing privileges, wrong tablename, full disk and so on.

 

Translate
Terms & ConditionsAccessibility statement