Reports generation abort in Publisher

Document ID : KB000086896
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): 3

Error Message :
Error message in the server.log of the Publisher:
######################
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
######################

Patch level detected:Publisher 3.1.0
Reports generate an abort in Publisher with the specified error in the log.
Environment:
OS: All
OS Version: ALL OS
Cause:
Cause type:
Defect
Root Cause: This is a defect affecting Publisher 3.
Resolution:
Update to a fix version listed below or a newer version if available.

Install the patch FX24976  on the Publisher server and follow the procedure below.

IMPORTANT FOR ORACLE:

Run this command with system privileges:
ALTER SYSTEM SET open_cursors = 1000 SCOPE=BOTH


Fix Status: Released

Fix Version(s):
Publisher Server 3.1 - Available
Additional Information:
Workaround :
N/A