When Loading E2b Files In Aers, Run Out Of Cursors Causing The Load To Fail (Doc ID 459335.1)

Last updated on MAY 13, 2010

Applies to:

Adverse Event Reporting System - Version: 4.5.2.37 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 13-May-2010***

Symptoms


AERS 4.5.2.37 in Production:
When loading large E2B files into AERS system, customers have encountered the following error:

ERROR
ORA-0100 - MAXIMUM OPEN CURSORS EXCEEDED



The issue can be reproduced at will with the following steps:

  1. Load 5 large XML files into Portal using AERS loading utility (about 2000 cases per XML file,
    size 15MB-20MB per file.).
  2. Then E2B files loaded into AERS by right click on file and choosing
    1. Import 
    2. E2B File.


Cause

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 hundreds of Community platforms