BUG

The Migrate Storage tool can exceed the Oracle default open_cursors limit of 300

Last Published: April 25, 2020

Description

The Migrate Storage geoprocessing tool (ArcToolbox > Data Management Tools > Database > Migrate Storage), when run on a batch of feature classes stored in Oracle, can exceed the Oracle open_cursors default limit of 300. When this happens, the tool returns the following generic message:

"ERROR 000955: Error encountered migrating the database storage of <connection>
Failed to execute MigrateStorage."

In addition, the SDE error log contains a message stating that the open_cursors limit has been exceeded.

Cause

Oracle cursors are incorrectly left open during the conversion of each feature class. Converting 200 or more feature classes can open enough cursors to exceed Oracle's default open_cursor limit of 300.

When the tool finishes migrating a batch of feature classes, the cursors are freed.

Workaround

Increase the Oracle database parameter open_cursor, or decrease the number of feature classes in the batch converted with the Migrate Storage tool.

To increase the open_cursor, connect to Oracle as the SYSTEM user and issue the following SQL statement:

Code:
ALTER SYSTEM SET OPEN_CURSORS=2000 SCOPE=BOTH;

Article ID:000010009

Software:
  • ArcMap 9 x
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic