Question

4
Replies
432
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 217 posts
Anthem
Posted: December 11, 2018
Last activity: December 13, 2018
Closed

com.pega.pegarules.pub.database.DatabaseException: ORA-01000: maximum open cursors exceeded

Hi Team,

While trying to import Pega Foundation for Healthcare 7.31 (PFHC_731.jar),running into the below mentioned oracle errors.

1)

2018-12-11 07:38:49,233 [jsse-nio-8488-exec-9] [TABTHREAD0] [ ] [ PegaRULES:07.10] (dbms.JdbcConnectionManagerImpl) ERROR va33tlvvpp304.XX.com|XX.XX.XX.XX Administrator@pega.com - Not returning connection 2 for database "pegadata" to the pool as it previously encountered the following error
User ID: Administrator@pega.com
Last SQL: (unknown)
java.sql.SQLException: ORA-01000: maximum open cursors exceeded

2)

2018-12-11 07:38:49,239 [jsse-nio-8488-exec-9] [TABTHREAD0] [ ] [ PegaRULES:07.10] (nal.ddlcomp.ImportDDLGenerator) ERROR va33tlvvpp304.XX.com|XX.XX.XX.XX Administrator@pega.com - Unable process table renaming on import for 'pegadata...pr_index_pegahc_data_network'
com.pega.pegarules.pub.database.DatabaseException: ORA-01000: maximum open cursors exceeded
: code: <none> SQLState: <none> Message: <none>

Please find the attachments for the logs.

Low-Code App Development System Administration Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.