Creating multiple snapshots in Jaspersoft creates error

Document ID : KB000044036
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

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?

 

Answer:

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;