Skip to main content
L
Lo_ry9610-Marble
10-Marble
April 30, 2024
Question

Error when executing SQL queries

  • April 30, 2024
  • 2 replies
  • 1127 views

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 

2 replies

B
bchaudhary_4480085-Regular Member
5-Regular Member
April 30, 2024

Hello @Lo_ry96 

 

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

 

Regards,

Bhawna

L
Lo_ry9610-MarbleAuthor
10-Marble
May 2, 2024

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 

Rocko
Rocko19-Tanzanite
19-Tanzanite
May 2, 2024

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.

 

Terms & ConditionsCookie settingsAccessibility statement