SAP Knowledge Base Article - Preview

2009572 - Phase MAIN_SHDRUN/PARDIST_SHD terminated with dump DBIF_DSQL2_SQL_ERROR

Symptom

During the upgrade, Phase PARDIST_SHD fails with following error:

Severe error(s) occurred in phase MAIN_SHDRUN/PARDIST_SHD!

Last error code set: Single errors (code <= 8) found in logfile
'PARDSHD.ELG'

 

In PARDSHD.ELG file, we can following information:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DISTRIBUTION ERRORS and RETURN CODE in DS140424.<SID>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2 ED0305 Date, time...............: "04/20/2014", "14:42:01"
2 ED0307 Platform.................: "CUSTOMER"-"<SID>"("701")/"ORACLE/HP-UX/<hostname>"
2 ED0311 Tool.....................: "BATCH"/"LSDSBU02"
2 ED0315 Log......................: "F", "<DIR_SUM>/abap/tmp/DS140424.<SID>"
2 ED0302 =========================================================================
2EEDA489   Termination when editing object "/BIC/FBSDCIN03" mode flag " "

 

In Shadow Instance, jobs RDDGENBB_* get canceled due to dump DBIF_DSQL2_SQL_ERROR.

 If you check the DEV trace (dev_w* files under <SUM>/abap/<SID>/<instance>/work, not Main Instance) of the WP where the canceled job was run, there are similar error messages as below with the same timestamp when the dump occurred.

A  ABAP Program SDB2FORA                                .
A  Source SDB2FORA                                 Line 2752.
A  Error Code DBIF_DSQL2_SQL_ERROR.

.......

C     OCIStmtExecute() failed with -1=OCI_ERROR
C     SQL error 904:
C  *** ERROR => Error 904 in stmt_fetch() from oci_execute_stmt(), orpc=0
 [dbsloci.c    17793]

......

B  ***LOG BY2=> sql error 0          performing FET        [dbds         492]
B  ***LOG BY0=> ORA-00904: "INDEX_OWNER": invalid identifier [dbds         492]

 

As we see from the DEV trace, ORA-00904 error happens here and caused the problem. 


Read more...

Environment

SAP Systems based on NetWeaver 7.0 or above on Oracle database.

Product

SAP NetWeaver all versions

Keywords

KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-ORA-SYS , Database Interface / DBMS , Problem

About this page

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

Search for additional results

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