Creating multiple snapshots in Jaspersoft creates error

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Risk Analytics
• CA Secure Cloud SaaS - Arcot A-OK (WebFort)
• CLOUDMINDER ADVANCED AUTHENTICATION
• CA Secure Cloud SaaS - Advanced Authentication
• CA Secure Cloud SaaS - Identity Management
• CA Secure Cloud SaaS - Single Sign On

Issue/Introduction

When creating multiple snapshots in Jaspersoft it would create an error. If creating a snapshot one at a time, the issue doesn't happen. What would be the resolution to create multiple snapshots in Jaspersoft?

Environment

Release: CAIDMB99000-12.6.8-Identity Manager-B to B
Component:

Resolution

This issue occurs in Oracle Database when creating snapshots. A fix to this would be to set this config in the Oracle Datebase:

alter system set processes=2000 scope=spfile;

alter system set sessions=2000 scope=spfile;