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

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

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

abhiramk
13-Aquamarine

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

0 REPLIES 0
Announcements


Top Tags