Skip to main content
5-Regular Member
March 2, 2021
Solved

SQL Queries no longer working after migrating to Thingworx 9.1

  • March 2, 2021
  • 1 reply
  • 1577 views

Recently we have migrated to Thingworx 9.1. Numerous database Things have been exported from Thingworx 8.3 and imported into Thingworx 9.1. Since then, none of our SQL query services appear to work with syntax errors. Please see example of this attached. 

 

The queries run without issue when using SQL Management Tool. Do anyone have any ideas why this could be?

 

Many thanks,

 

Amanda

Best answer by SachinSharma

Please refer below article for this issue,

https://www.ptc.com/en/support/article/CS334683

 

1 reply

16-Pearl
March 2, 2021

Please refer below article for this issue,

https://www.ptc.com/en/support/article/CS334683

 

5-Regular Member
March 2, 2021

Thank you for your quick response, that works great!

 

Thank you 🙂