Error during System Copy Export

[Former Member]

Dear All,

I am doing system copy of our TEST EHP5 system. During copy sapinst throws following error :

Below two lines are from export_monitor.java.log

******************************

Unloading of 'SAPCLUST' export package: ERROR

Export Monitor jobs: running 6, waiting 5, completed 7, failed 1, total 19.

*********************************************************************

Below lines from SAPCLUST.log file

********************************************

/usr/sap/ZPR/DVEBMGS02/exe/R3load: START OF LOG: 20130312101144

/usr/sap/ZPR/DVEBMGS02/exe/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#15 $ SAP

/usr/sap/ZPR/DVEBMGS02/exe/R3load: version R7.20/V1.4 [UNICODE]

Compiled Jul  8 2012 19:50:52

/usr/sap/ZPR/DVEBMGS02/exe/R3load -ctf E /oracle/ZPR/oraarch/EXPZPR/ABAP/DATA/SAPCLUST.STR /oracle/ZPR/oraarch/EXPZPR/ABAP/DB/DDLORA_LRG.TPL SAPCLUST.TSK ORA -l SAPCLUS

T.log

(RTF) ########## WARNING ###########

        Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

/usr/sap/ZPR/DVEBMGS02/exe/R3load: job completed

/usr/sap/ZPR/DVEBMGS02/exe/R3load: END OF LOG: 20130312101144

/usr/sap/ZPR/DVEBMGS02/exe/R3load: START OF LOG: 20130312101144

/usr/sap/ZPR/DVEBMGS02/exe/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#15 $ SAP

/usr/sap/ZPR/DVEBMGS02/exe/R3load: version R7.20/V1.4 [UNICODE]

Compiled Jul  8 2012 19:50:52

/usr/sap/ZPR/DVEBMGS02/exe/R3load -e SAPCLUST.cmd -datacodepage 4102 -l SAPCLUST.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(DB) INFO: Export without hintfile

(GSI) INFO: dbname   = "ZPR20120907120936                                                                                                               "

(GSI) INFO: vname    = "ORACLE                          "

(GSI) INFO: hostname = "rlsapdr                                                         "

(GSI) INFO: sysname  = "HP-UX"

(GSI) INFO: nodename = "rlsapdr"

(GSI) INFO: release  = "B.11.31"

(GSI) INFO: version  = "U"

(GSI) INFO: machine  = "ia64"

(GSI) INFO: instno   = "0020311225"

(RTF) ########## WARNING ###########

        Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(EXP) TABLE: "AABLG" #20130312101147

(EXP) TABLE: "CDCLS" #20130312101436

(EXP) ERROR: DbSlExeRead failed

  rc = 103, table "CLU4"

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

/usr/sap/ZPR/DVEBMGS02/exe/R3load: job finished with 1 error(s)

/usr/sap/ZPR/DVEBMGS02/exe/R3load: END OF LOG: 20130312101436

*********************************************

Thanks and Regards,

Nirav

[former_member188883 · Accepted solution]

Hi Nirav,

Refer SAP note 1764859 - Error due to CLU4 or VER_CLUSTR after SUM SP6

Hope this helps.

Regards,

Deepak Kori

[former_member713022]

Hi, There are probably missing tables in your DB, access the log in \sapinst_instdir\ SAPCLUST.log and if applicable, and repeat the process.

[farkathulla_cikkanther]

Hello Nirav,

Delete temp tables from SE14-->Extras-->Invalid temp.tables and delete if you see any results. and try again.

also

Please check the SAP Note 662644 for SQL error 942.

Regards,

Farkath C

[Former Member]

Hello,

I am having the same issue. I am running export for a ECC 6.0 EHP5 system and there is one package failed and it is pointing to CLU4 table error.

Below is the error message.

(EXP) ERROR: DbSlExeRead failed

  rc = 103, table "CLU4"

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

I checked the table in SE14 and both the database object and runtime object are consistent.

Please help me resolving the issue.

[farkathulla_cikkanther]

Hello Junaid,

   Please check the fallowing note.

1909263 - table or view does not exist during abap export

Regards,

Farkath C

[Former Member]

Hi Nirav,

Please check SAP Note SAP 1764859: Error due to CLU4 or VER_CLUSTR after SUM SP6.

This issue means that the table which the R3load is trying to export exists on your ABAP dictionary only (not on your database). To solve this issue, you can create the table on database via R/3. Check the table "CLU4" via \SE14. There will be a button to check the consistency of the table, If this is not consistent, then you can click on button 'Create database table"

Rgds,

Sachin