Skip to main content
1-Visitor
August 28, 2020
Question

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

  • August 28, 2020
  • 0 replies
  • 628 views

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