SQL Queries no longer working after migrating to Thingworx 9.1

[aschofield7777]

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

[SachinSharma · Accepted solution]

Please refer below article for this issue,

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

[aschofield7777]

Thank you for your quick response, that works great!

Thank you