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

SOLVED
aschofield7777
Visitor

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

Re: SQL Queries no longer working after migrating to Thingworx 9.1

2 REPLIES 2

Re: SQL Queries no longer working after migrating to Thingworx 9.1

Re: SQL Queries no longer working after migrating to Thingworx 9.1

Thank you for your quick response, that works great!

 

Thank you

Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.