I have used Thingworx 8.5 then I have shifted all my backups in thingworx 9.0 it's fine and there is no issue with any entity but now when I have shifted all the Thingworx 9.0 backups into Thingworx 9.1.
It totally strange, some widgets that I have used in thingworx 9.0 mashups are gone.
I have used PostgreSQL queries in Thingworx 9.0 but after shifting backups in Thingworx 9.1 it's not running I haven't modified any query after shifting as it is I have shifted.
a select query is running in the database thing but not running JOINs query in the database things
Like above query is running but not running below types query i.e JOINs
error is below, I have used this same querry in PostgreSQL it is running but thingworx its NOT
Is it thingworx version problem?
I don't know what happened and what I have to do next please suggest the way.
The error appears to be a syntax error only. Could you attach Thingworx logs here after replicating the issue again, to get more information.
You have also mentioned about some of the widget disappeared in your Composer, can you let me know more about those widget, if they were OOTB or custom widgets.
Are you unable to search those widgets or it is possible that you have Clicked Yes on the pop-up message about replacement of Legacy Widget.
No, I haven't accepted the popup about the replacement of Legacy Widget. I just took Thingworx9.0 backups into Thingworx 9.1 but SQL JOINS queries not running on especially.
About syntax error, if a syntax error is there then how can the same query execute in PostgreSQL even in Thingworx 9.0
I have attached the log file pls check.
Regarding the failing SQL Query, I believe this is related to the following known issue : Line breaks in SQL Service (Database Thing) are not properly handled in ThingWorx 9.1.0.
Can you confirm if the query runs successfully when using one of the syntaxes mentioned in the resolution section is used ? (no line breaks)
Note that this bug has been corrected in upcoming ThingWorx 9.1.1.