Reports generation abort in Publisher

book

Article ID: 86896

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

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.

Cause

Cause type:
Defect
Root Cause: This is a defect affecting Publisher 3.

Environment

OS: All
OS Version: ALL OS

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