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

SQL Queries no longer working after migrating to Thingworx 9.1

aschofield7777
4-Participant

SQL Queries no longer working after migrating to Thingworx 9.1

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

1 ACCEPTED SOLUTION

Accepted Solutions

2 REPLIES 2

Please refer below article for this issue,

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

 

Thank you for your quick response, that works great!

 

Thank you

Announcements