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 for Oracle , 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.