We do DB refresh of our QA environment with Production every month. So, after every refresh do we have to regenerate the Jasper Keystore or do we have any workaround ?
At this point generating Key store is the best possible solution, I will keep you updated once we find out any other workaround.
Thanks Suman for the quick reply, Please do share when you find the workaround
You would need to regenerate the keystore after any refresh because the key store is saved in PPM database under table CMN_JASPER_KEYSTORES, so once the restore is done the keystore between file and database is not matching which is the reason you would need to do it.
This is how its is designed.
Created an Idea for the same.
Jaspersoft Key store generation after every DB refresh
This can be overcome in CA PPM 14.3 onwards with a command below
admin jaspersoft syncPPMContext -userName superuser -password superuser