Prime API V2.2 missing data

[praveen.batchu1]

Hi, We did load data from Prime API V2.2 ClientSessions back in January to our test environment and now we are working on loading data to our production environment and we see some 500K records missing and I remember Spencer Zier saying data doesn't change much. Could you please explain what might cause this? Also we are upgrading Prime API to version 3.0 is there going to be much change between the two?

Thanks in advance....

[dkeysell]

Could it be due to data retention settings for client data in your Prime Infrastructure? Under Administration > Settings > System Settings > Client and User > Client the default setting is to retain Client Session history for 32 days. Older than that and the data is purged from PI.

[praveen.batchu1]

Hi Duncan, Thanks for your response. I will check this setting with my network team, what if the data gets purged is it gone for good?

[dkeysell · Accepted solution]

Hi Praveen, Yes if that is the root cause. If you can login as UI root user to your PI server, you can run query to see how many client session info records are left in the system. Go to page : https://<your server>/webacs/dbQueryAction.do

select count(*) from clientsessioninfo

Duncan