I need to update a particular profile field value for all the user ids in my system. Since it is about 2000 users I have to write insert scripts to populate data into jiveuserprofile table.
During which I observed this table uses a primary key userprofileid .
Any idea the sequence from where this primary key is referred would help because if I start to insert with random sequence numbe,r the front end operations are failing until next val of the sequence greater the primary key value of the manually insert records.
Firstly I would recommend you do this using the Jive REST APIs as this would be a very simple call (https://developers.jivesoftware.com/api/v3/cloud/rest/PersonService.html#updatePerson(String, PersonEntity)) and would avoid any risk of breaking the Jive profile tables.
If you continue with a table update then have a look at the jiveid table and idtype = 459125536.