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

Postgresql Persistance provider: Entry_id not updating in stream and value_stream table.

abhiramk
Garnet

Postgresql Persistance provider: Entry_id not updating in stream and value_stream table.

Hello,

 

One of our thingworx instance database(postgresql is being used as default persistance provider) is corrupted so, I have taken the pg_dump of whole db and then created new database and restored old pg_dump to new one and then i have updated the platform-settings.json accordingly. After these changes, application is working fine but i have observed that 'id' field (entry_id which will do auto increment internally) is not getting updated for new entries in stream and value_stream tables.

 

Can someone please provide the inputs to handle this. Did anyone faced this kind of issue?

 

-thanks,
Abhiram

Announcements

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