Article - CS297147

All SQL services on a (JDBC) Datatbase thing fail with error "Unable to Invoke Service <service_name> on <thing_name> : null" in ThingWorx Platform

Modified: 30-Jul-2023   


Applies To

  • ThingWorx Platform 8.3 F000 to 9.0 F000

Description

  • All SQL services on a (JDBC) Datatbase thing fail with error "Unable to Invoke Service <service_name> on <thing_name> : null"
  • isConnected property at Database thing shows true but still SQL services on thing fails with error : "Unable to Invoke Service <service_name> on <thing_name> : null"
    • This behavior is intermittent as sometimes SQL service runs successfully and sometime it fails with the error as above
  • Only relevant message is logged as DEBUG into the ApplicationLog when saving the Database thing :
[L: DEBUG] [O: c.t.t.d.DatabaseSystem] [I: db] [U: Administrator] [S: ] [T: http-nio-8080-exec-7] connection validation failed: null
 
​​​​​​​​​​​​​​
This is a printer-friendly version of Article 297147 and may be out of date. For the latest version click CS297147