2246480 - SUM error - SQL7725 in step MAIN_SHDRUN/SUBMOD_DIFFEXP/RUN_RDDDL4TB - SAP ASE for Business Suite

In the following scenarios:

• SAP ERP system upgrade to EHP8 using SUM 1.0 SP19 or SP20
• SUM DMO migration from SAP ASE to SAP HANA using SUM 1.0 SP19 or SP20

SUM fails in step MAIN_SHDRUN/SUBMOD_DIFFEXP/RUN_RDDDL4TB. Report RDDDL4TB aborts and exits with a shortdump in main instance. The dump refers to ASE Error SQL7725 on table TADIR as seen below:

Database Interface Information                                                                    |
----------------------------------------------------------------------------------------------------
|C|1|ERROR: -1 in function StartSelect (execute) [line 23315] [/bas/742_REL/src/dbs/syb/dbsyb.c#276|
|C|1|(7725) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Cursor 'SAP_C10' was declared|
|C|1|with a FOR UPDATE clause. This cursor was found to be read only. [/bas/742_REL/src/dbs/syb/dbs|
|C|1|sql statement is ==> SELECT * FROM "TADIR~" WHERE "TADIR~" ."PGMID" = ? AND "TADIR~" ."OBJECT"|
|C|1|D NOT "TADIR~" ."OBJ_NAME" IN ( SELECT "VIEWNAME" FROM "DD25L~" WHERE "DD25L~" . [/bas/742_REL|
|C|1|"AGGTYPE" = ? ) FOR UPDATE  [/bas/742_REL/src/dbs/syb/dbsyb.c#37060]                          |
|C|1|/* R3:RDDDL4TB:259 T:TADIR~ M:102 */ [/bas/742_REL/src/dbs/syb/dbsyb.c#37060]                 |
|C|1| /*22*/ [/bas/742_REL/src/dbs/syb/dbsyb.c#37060]                                              |
|B|E|***LOG BY4=> sql error 7725   performing PRE on table TADIR~ [dbdbslst#3763]                  |
|B|E|***LOG BY0=> [ASE Error SQL7725][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Cursor 'SAP_|
|B|1|dumping DbDbslStatement ... [/bas/742_REL/src/krn/dbi/dbsql/dbdbslstatement.cpp#1930]         |

 SQL error "SQL code: 7725" occurred while accessing table "TADIR~".

Database error text: "SQL message: [ASE Error SQL7725][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Cursor 'SAP_C17' was declared with a FOR  UPDATE clause. This cursor was found to be read only.#"

sql statement is ==> SELECT * FROM "TADIR~" WHERE "PGMID" = ? AND "OBJECT" = ? AND NOT "OBJ_NAME" IN  ( SELECT "DD25L~" ."VIEWNAME" FROM "DD25L~" WHERE "DD25L~" ."AGGTYPE" = ? ) FOR  UPDATE

/* R3:RDDDL4TB:307 T:TADIR~ M:000 */

E***LOG BY4=> sql error 7725  performing PRE on table TADIR~ [dbdbslst#4806]

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP NetWeaver 7.4, 7.5
• SUM 1.0 SP19 and SP20

SQL7725, FOR UPDATE, cursor, DELETE, NOT EXISTS, 792561, RDDDL4TB, SUM, DMO, EHP, upgrade , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem