Question

4
Replies
391
Views
PradeepPydi Member since 2017 204 posts
Anthem
Posted: 1 year ago
Last activity: 1 year 10 months ago
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
Share this page LinkedIn