Prime API V2.2 missing data

• Tried to load data from Prime API V2.2 ClientSessions to test environment and now working on loading data to our production environment and seeing some 500K records missing .As 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.

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.

• Will check this setting and see what if the data gets purged is it gone for good.

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