Related content:

Question

How to monitor data page generation?

Discussion

How to overcome PRIMARY KEY constraint SQL exception during Rules Migration as a part of upgrade?

Discussion

CPM 7.1.3 Upgrade - Script for generating DDL failed

Question

Question on DDL generation during Pega7 Platform Install

Discussion

ORA-28138: Error in Policy Predicate in DataOnly upgrade

Question

Upgrade.sh fails for data upgrade with - WARNING: Encountered database error attempting to load jar into Oracle: ORA-00604

Question

Upgrade Application Schema Wizard generates DDL that includes changes to internal columns

Question

While generating DDL for Pega7.2, i am unable to see rules schema in the system generated DDL file.

Question

Hotfixes during Pega 7 Upgrade

Discussion

db2 sql error sqlcode=-614, sqlstate=54008 during upgrade
Contact a Moderator

Discussion

1
Replies
92
Views
natan Member since 2012 32 posts
PEGA
Posted: June 4, 2015
Last activity: April 6, 2018
Closed

How to overcome ORA-0100 error during data upgrade DDL generation?

I got "ORA-0100: Maximum Open cursors exceeded" during the DDL generation of data upgrade. How can I get rid of this error?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Close popover
Moderation Team has archived post
Posted: 5 years ago

This is a DB error caused due to exceeded Maximum Open Cursors.


Increase Open_Cursors Value from 1000 to ~6000 to resolve the issue.
Share this page LinkedIn
Copied!