My Oracle Support Banner

ORA-01000: Maximum Open Cursors Exceeded When Running Maintenance (Doc ID 1560937.1)

Last updated on JULY 10, 2018

Applies to:

Oracle Healthcare Terminology Server - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On HTB 6.1 version,

When attempting to run ETS maintenance program for 5.8k classification codes,
the following error occurs:

ERROR
-----------------------
[977 sec.] BUILD_CLASSIFICATION_END
[977 sec.] SQL_ERR_MT_PRG
[977 sec.] java.sql.SQLException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "APPS.HCT_CLASSIFICATION_BUILDER", line 256
ORA-06512: at "APPS.HCT_CLASSIFICATION_BUILDER", line 928
ORA-06512: at "APPS.HCT_CLASSIFICATION_BUILDER", line 1174
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced in Customer's environment with the following steps:
1. Run the ETS Maintenance program;



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.