Thingworx 9.0 backups are not suits in Thingworx 9.1

Question

Hi Everyone,
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
Spoiler (Highlight to read)SELECT workout_type_id,workout_type FROM "ref_workout_type" ;SELECT workout_type_id,workout_type FROM "ref_workout_type" ;
Like above query is running but not running below types query i.e JOINs
 
Spoiler (Highlight to read)SELECT mem.member_id,concat(us.first_name,' ',us.Last_name) as fullname,ci.city_name,us.is_active,mem.checkboxFROM "tbl_members" AS memJOIN "tbl_users" AS usON mem.user_id = us.user_idJOIN "tbl_user_info" AS uiON us.user_id = ui.user_idJOIN "ref_cities" AS ciON ui.city_id = ci.city_idSELECT mem.member_id,concat(us.first_name,' ',us.Last_name) as fullname,ci.city_name,us.is_active,mem.checkboxFROM "tbl_members" AS memJOIN "tbl_users" AS usON mem.user_id = us.user_idJOIN "tbl_user_info" AS uiON us.user_id = ui.user_idJOIN "ref_cities" AS ciON ui.city_id = ci.city_id
error is below, I have used this same querry in PostgreSQL it is running but thingworx its NOT

Spoiler (Highlight to read)Unable to Invoke Service getMemberForProgram on PostgreSQL_DB : Execute Query failed: org.postgresql.util.PSQLException: ERROR: syntax error at or near "AS" Position: 130Unable to Invoke Service getMemberForProgram on PostgreSQL_DB : Execute Query failed: org.postgresql.util.PSQLException: ERROR: syntax error at or near "AS" Position: 130

Is it thingworx version problem?
I don't know what happened and what I have to do next please suggest the way.

suverma · Answer

Hi @DT_316496

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.

Regards,

Sudeepta

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.