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

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

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

abhiramk
11-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

0 REPLIES 0
Top Tags