Symptom
Below error occurs during the migration step using the migration object "Routing" in the Migrate Your Data app.
An exception with the type CX_SY_OPEN_SQL_DB was raised, but was not handled locally or declared in a RAISING clause (Message No. DMC_RT_MSG 0).
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the 'Migrate Your Data' app.
- Navigate to the migration project.
- Select the 'Routing' migration object.
- Perform the migration step.
Cause
This issue arises because a large SQL statement is generated during the execution of the BAPI 'BAPI_ROUTING_CREATE'.
Resolution
Reduce the amount of sub-data in sheet 'Material Task List Assignment'.
See Also
SAP Help Portal - System Limitations
Keywords
exception, CX_SY_OPEN_SQL_DB, migration, Migrate Your Data, Routing, BAPI_ROUTING_CREATE, SQL, Material Task List Assignment, System Limitations, reduce , KBA , CA-LT-MC , S/4HANA Migration Cockpit , Problem
SAP Knowledge Base Article - Public