Postgresql Persistance provider: Entry_id not updating in stream and value_stream table.
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?