Bug
The Migrate Storage geoprocessing tool exceeds the Oracle default ‘open_cursors’ limit of 300 when a large number of feature classes are migrated at one time. This is caused by a cursor leak in ArcSDE for Oracle.
| Bug ID Number | NIM034426 |
|---|---|
| Submitted | April 18, 2008 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 9.3 |
| Version Fixed | 9.4 |
| Status | Fixed |
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;
Steps to Reproduce
Bug ID: NIM034426
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App