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

SAP Knowledge Base Article - Preview

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

Symptom

You are running SAP applications on SAP ASE database in the following scenarios:

  • You are using SUM 1.0 SP19 or SP20 to upgrade your ERP system to EHP8
  • You are using SUM 1.0 SP19 or SP20 with DMO, to migrate your ASE system to SAP HANA

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]


Read more...

Environment

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

Product

SAP ERP 6.0

Keywords

SQL7725, FOR UPDATE, cursor, DELETE, NOT EXISTS, 792561, RDDDL4TB, SUM, DMO, EHP, upgrade , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.