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

Question

PradeepPydi

Member since 2017

240 posts

Anthem

Posted: Dec 11, 2018

Last activity: Dec 13, 2018

Posted: 11 Dec 2018 8:20 EST
Last activity: 13 Dec 2018 11:10 EST

Closed

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

Report

Hi Team,

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

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 [email protected] - Not returning connection 2 for database "pegadata" to the pool as it previously encountered the following error
User ID: [email protected]
Last SQL: (unknown)
java.sql.SQLException: ORA-01000: maximum open cursors exceeded

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 [email protected] - 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.

To see attachments, please log in.

Low-Code App Development