2 Replies Latest reply: Sep 21, 2012 10:05 AM by sanjay khatri RSS

Error - SQL error 942, table or view does not exist in R3load import in SAPVIEW.log

Shivam Mittal
Currently Being Moderated

Hi All,

 

We are performing Unicode Migration on ECC 6.0 SR3, OS - WINDOWS, DB-Oracle 10.2.0.5

 

After all preparation Activities, We took System export and now in phase of System R3 Load Import.

 

In this step, during Import ABAP phase 18 jobs completed but job for SAPVIEW is failed with error:

 

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20120608063246

 

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:39

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe -ctf I G:\Export\ABAP\DATA\SAPVIEW.STR D:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\DDLORA.TPL SAPVIEW.TSK ORA -l SAPVIEW.log

 

 

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: job completed

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20120608063248

 

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20120608063248

 

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:39

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error

 

DbSl Trace: ORA-1403 when accessing table SAPUSER

 

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: /1CN/APASAP00001 created #20120608063250

 

(DB) INFO: /1CN/APNSAP00001 created #20120608063250

 

(DB) INFO: /1CN/APTSAP00001 created #20120608063250

 

(DB) INFO: /1CN/APTSAP00004 created #20120608063250

 

(DB) INFO: /1CN/APTSAP00005 created #20120608063250

 

(DB) INFO: /1CN/APTSAP00006 created #20120608063250

 

(DB) INFO: /1CN/ARMSAP_CARR created #20120608063250

 

(DB) INFO: /1CN/ARMSAP_CONN created #20120608063250

 

(DB) INFO: /1CN/ARMSAP_PART created #20120608063250

 

(DB) INFO: /1CN/ATXSAPD0001 created #20120608063250

 

(DB) INFO: /1CN/ATXSAPD0002 created #20120608063250

 

(DB) INFO: /1CN/ATXSAPD0003 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPD0004 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPD0201 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0100 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0103 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0104 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0105 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0106 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0107 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0108 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0110 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0111 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0112 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0113 created #20120608063251

 

(DB) INFO: /1CN/ATXSAPR0120 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPR0130 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPR0131 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPR0140 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPR0201 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRBR01 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRBR02 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRBR03 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRBR10 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRBR11 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRBR12 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRBR20 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRBR21 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRIN03 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRIN04 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRIN06 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPRIN07 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPS0100 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPS0101 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPS0102 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPW0201 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPW0202 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPX0100 created #20120608063252

 

(DB) INFO: /1CN/ATXSAPX0101 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0102 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0103 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0104 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0105 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0106 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0140 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0141 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0146 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0147 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPX0148 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPXBR01 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPXBR02 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPXBR03 created #20120608063253

 

(DB) INFO: /1CN/ATXSAPXBR11 created #20120608063253

 

(DB) INFO: /BEV1/CADD03VTV created #20120608063253

 

(DB) INFO: /BEV1/EMBWDP_A created #20120608063254

 

(DB) INFO: /BEV1/EM_SD_SLS created #20120608063254

 

(DB) INFO: /BEV1/LAKUNAG_V created #20120608063254

 

(DB) INFO: /BEV1/LAVMVA1_V created #20120608063254

 

(DB) INFO: /BEV1/LAVMVL1_V created #20120608063254

 

(DB) INFO: /BEV1/RBAA_V created #20120608063254

 

(DB) INFO: /BEV1/RBB1_V created #20120608063254

 

(DB) INFO: /BEV1/RBCA_MV created #20120608063254

 

(DB) INFO: /BEV1/RBCA_V created #20120608063254

 

(DB) INFO: /BEV1/RBDA_V created #20120608063254

 

(DB) INFO: /BEV1/RBEA_V created #20120608063255

 

(DB) INFO: /BEV1/RBFA_V created #20120608063255

 

(DB) INFO: /BEV1/RBY_V created #20120608063255

 

(DB) INFO: /BEV1/RE_MAT12 created #20120608063255

 

(DB) INFO: /BEV1/RPA1_V created #20120608063255

 

(DB) INFO: /BEV1/RPF1_V created #20120608063255

 

(DB) INFO: /BEV1/RPFA1_V created #20120608063255

 

(DB) INFO: /BEV1/RPFA2_V created #20120608063255

 

(DB) INFO: /BEV1/RPFAPR_V created #20120608063255

 

(DB) INFO: /BEV1/RPFAT_BWV created #20120608063255

 

(DB) INFO: /BEV1/RPFA_BWV created #20120608063255

 

(DB) INFO: /BEV1/RPFZT_BWV created #20120608063255

 

(DB) INFO: /BEV1/RPFZ_BWV created #20120608063255

 

(DB) INFO: /BEV1/RPFZ_SHV created #20120608063255

 

(DB) INFO: /BEV1/RPT1_V created #20120608063255

 

(DB) INFO: /BEV1/RPTT_M created #20120608063255

 

(DB) INFO: /BEV1/RPY1_V created #20120608063255

 

(DB) INFO: /BEV1/RPYA_V created #20120608063255

 

(DB) INFO: /BEV1/RPZ1_V created #20120608063255

 

(DB) INFO: /BEV1/RPZA_V created #20120608063255

 

(DB) INFO: /BEV1/RSIMA_BWV created #20120608063255

 

(DB) INFO: /BEV1/SR_SLS_BWV created #20120608063256

 

(DB) INFO: /BEV1/TSABERTV_V created #20120608063256

 

(DB) INFO: /BEV1/TSAGRP_BWV created #20120608063256

 

(DB) INFO: /BEV1/TSDD03VT_V created #20120608063256

 

(DB) INFO: /BEV1/TSKNVK_BWV created #20120608063256

 

(DB) INFO: /BEV1/TSZKK_BWV created #20120608063256

 

(DB) INFO: /BEV1/TS_DEBI created #20120608063256

 

(DB) INFO: /BEV3/CHBALLV2 created #20120608063256

 

(DB) INFO: /BEV3/CHBALLV3 created #20120608063256

 

(DB) INFO: /BEV3/CHBALLV4 created #20120608063256

 

(DB) INFO: /BEV3/CHBALLV5 created #20120608063256

 

(DB) INFO: /BEV3/CHBPAKNA1 created #20120608063256

 

(DB) INFO: /BEV3/CHBPAKNA1S created #20120608063257

 

(DB) INFO: /BEV3/CHBPAKNA2S created #20120608063257

 

(DB) INFO: /BEV3/CHBPAOBJS created #20120608063257

 

(DB) INFO: /BEV3/CHBPARTOBJ created #20120608063257

 

(DB) INFO: /BEV3/CHCBDGL created #20120608063257

 

(DB) INFO: /BEV3/CHDD02E071 created #20120608063257

 

(DB) INFO: /BEV3/CHDD02LOS created #20120608063257

 

(DB) INFO: /BEV3/CHDD03LOI created #20120608063257

 

(DB) INFO: /BEV3/CHLINV created #20120608063258

 

(DB) INFO: /BEV3/CHLINVS created #20120608063258

 

(DB) INFO: /BEV3/CHNODESTH created #20120608063258

 

(DB) INFO: /BEV3/CHOBJHDD3L created #20120608063258

 

(DB) INFO: /BEV3/CHOBJKNA1 created #20120608063258

 

(DB) INFO: /BEV3/CHOBJSE071 created #20120608063258

 

(DB) INFO: /BEV3/CHOBJSTVDR created #20120608063258

 

(DB) INFO: /BEV3/CHOBJUSER created #20120608063259

 

(DB) INFO: /BEV3/CHOBSUBCAH created #20120608063259

 

(DB) INFO: /BEV3/CHT052_TXT created #20120608063259

 

(DB) INFO: /BEV3/CHTADIRTV created #20120608063259

 

(DB) INFO: /BEV3/CHTO created #20120608063259

 

(DB) INFO: /BEV3/CHVABNHM created #20120608063259

 

(DB) INFO: /BEV3/CHVABSATZ created #20120608063259

 

(DB) INFO: /BEV3/CHVABSS created #20120608063259

 

(DB) INFO: /BEV3/CHVABSTVG created #20120608063259

 

(DB) INFO: /BEV3/CHVABSVG created #20120608063259

 

(DB) INFO: /BEV3/CHVALLG created #20120608063259

 

(DB) INFO: /BEV3/CHVANNU created #20120608063259

 

(DB) INFO: /BEV3/CHVBDIODPT created #20120608063300

 

(DB) INFO: /BEV3/CHVBKBDG created #20120608063300

 

(DB) INFO: /BEV3/CHVBKBFI created #20120608063300

 

(DB) INFO: /BEV3/CHVBKBFLG created #20120608063300

 

(DB) INFO: /BEV3/CHVBKBSD created #20120608063300

 

(DB) INFO: /BEV3/CHVBKBVV created #20120608063300

 

(DB) INFO: /BEV3/CHVBKKNTR created #20120608063300

 

(DB) INFO: /BEV3/CHVBKST created #20120608063300

 

(DB) INFO: /BEV3/CHVBKTM created #20120608063300

 

(DB) INFO: /BEV3/CHVBKVRKT created #20120608063300

 

(DB) INFO: /BEV3/CHVBPART created #20120608063300

 

(DB) INFO: /BEV3/CHVBTEXT created #20120608063300

 

(DB) INFO: /BEV3/CHVBWCTR2M created #20120608063300

 

(DB) INFO: /BEV3/CHVBWCTR2T created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_ALLC created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_ALTD created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_BENE created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_BKTD created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_BZAM created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_BZUM created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_BZVA created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_BZVU created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_CTR1 created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_CTRT created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_IMMD created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_IMTD created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_KBMD created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_KBTD created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_MPMD created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_MPTD created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_PRVL created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_SALE created #20120608063300

 

(DB) INFO: /BEV3/CHVBW_SLDO created #20120608063301

 

(DB) INFO: /BEV3/CHVBW_SRTM created #20120608063301

 

(DB) INFO: /BEV3/CHVBW_SRTY created #20120608063301

 

(DB) INFO: /BEV3/CHVBW_TEXT created #20120608063301

 

(DB) INFO: /BEV3/CHVBW_TREE created #20120608063301

 

(DB) INFO: /BEV3/CHVBW_VGTM created #20120608063301

 

(DB) INFO: /BEV3/CHVBW_VGTT created #20120608063301

 

(DB) INFO: /BEV3/CHVB_RG created #20120608063301

 

(DB) INFO: /BEV3/CHVB_WE created #20120608063301

 

(DB) INFO: /BEV3/CHVCALCC created #20120608063301

 

(DB) INFO: /BEV3/CHVCALCF created #20120608063301

 

(DB) INFO: /BEV3/CHVCALCT created #20120608063301

 

(DB) INFO: /BEV3/CHVCALCV created #20120608063301

 

(DB) INFO: /BEV3/CHVDATUM created #20120608063301

 

(DB) INFO: /BEV3/CHVEINBIN created #20120608063301

 

(DB) INFO: /BEV3/CHVEXTB created #20120608063301

 

(DB) INFO: /BEV3/CHVEZINS created #20120608063301

 

(DB) INFO: /BEV3/CHVFBTRG created #20120608063301

 

(DB) INFO: /BEV3/CHVFPROZ created #20120608063301

 

(DB) INFO: /BEV3/CHVGABS created #20120608063301

 

(DB) INFO: /BEV3/CHVGROUP created #20120608063301

 

(DB) INFO: /BEV3/CHVGUMS created #20120608063301

 

(DB) INFO: /BEV3/CHVIZINS created #20120608063301

 

(DB) INFO: /BEV3/CHVKONT created #20120608063301

 

(DB) INFO: /BEV3/CHVKPKPZL created #20120608063301

 

(DB) INFO: /BEV3/CHVLEIST created #20120608063301

 

(DB) INFO: /BEV3/CHVMINUM created #20120608063301

 

(DB) INFO: /BEV3/CHVPART created #20120608063301

 

(DB) INFO: /BEV3/CHVPOST created #20120608063301

 

(DB) INFO: /BEV3/CHVPRZABW created #20120608063301

 

(DB) INFO: /BEV3/CHVPRZGRZ created #20120608063301

 

(DB) INFO: /BEV3/CHVREGINF created #20120608063301

 

(DB) INFO: /BEV3/CHVRUECK created #20120608063301

 

(DB) INFO: /BEV3/CHVSALEI created #20120608063302

 

(DB) INFO: /BEV3/CHVSECURE created #20120608063302

 

(DB) INFO: /BEV3/CHVSICH created #20120608063302

 

(DB) INFO: /BEV3/CHVSORT created #20120608063302

 

(DB) INFO: /BEV3/CHVTERMIN created #20120608063302

 

(DB) INFO: /BEV3/CHVTMANFO created #20120608063302

 

(DB) INFO: /BEV3/CHVTMANWE created #20120608063302

 

(DB) INFO: /BEV3/CHVTMBDG created #20120608063302

 

(DB) INFO: /BEV3/CHVTMBEWFI created #20120608063302

 

(DB) INFO: /BEV3/CHVTMBEWSD created #20120608063302

 

(DB) INFO: /BEV3/CHVTMBEWVV created #20120608063302

 

(DB) INFO: /BEV3/CHVTMFOLGE created #20120608063302

 

(DB) INFO: /BEV3/CHVTMSTATU created #20120608063302

 

(DB) INFO: /BEV3/CHVTMVKTG created #20120608063302

 

(DB) INFO: /BEV3/CHVUMSATZ created #20120608063302

 

(DB) INFO: /BEV3/CHVUMSP created #20120608063302

 

(DB) INFO: /BEV3/CHVVERRE created #20120608063302

 

(DB) INFO: /BEV3/CHVVWDNR created #20120608063302

 

(DB) INFO: /BEV3/CHVWAER created #20120608063302

 

(DB) INFO: /BEV3/CHVZUSCH created #20120608063303

 

(DB) INFO: /BEV3/CHWDUSER created #20120608063303

 

(DB) INFO: /BEV3/CHWV created #20120608063303

 

(DB) INFO: /BI0/MHIER_VERS created #20120608063303

 

(DB) INFO: /BI0/MINFOPROV created #20120608063303

 

(DB) INFO: /BI0/MTCAACTVT created #20120608063303

 

(DB) INFO: /BI0/MTCAIFAREA created #20120608063303

 

(DB) INFO: /BI0/MTCTCONTREL created #20120608063303

 

(DB) INFO: /BI0/MTCTOBJVERS created #20120608063303

 

(DB) INFO: /BI0/MTCTSYSID created #20120608063303

 

(DB) ERROR: DDL statement failed

(CREATE VIEW "/BI0/MTCTUSERNM" ( "TCTSYSID" , "TCTUSERNM" , "OBJVERS" , "CHANGED" , "TCTBCTSTMP" , "TCTCONTREL" , "TCTLSTCHG" , "TCTOBJVERS" , "TCTOWNER" , "TCTTSTPNM"  ) AS SELECT T0001."TCTSYSID", T0001."TCTUSERNM", T0001."OBJVERS", T0001."CHANGED", T0001."TCTBCTSTMP",  T0001."TCTCONTREL", T0001."TCTLSTCHG", T0001."TCTOBJVERS", T0001."TCTOWNER", T0001."TCTTSTPNM" FROM "/BI0/PTCTUSERNM" T0001)

DbSlExecute: rc = 103

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

 

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

C:\usr\sap\RP1\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20120608063303

 

Somewhere I read we should start SAP and create this table but i do not get my SID in MMC and by startsap also command get completed but system does not come up.

 

So I expect we can start system in this state.

 

Please suggest me to resolve this problem.

 

Regards,

 

Shivam

  • Re: Error - SQL error 942, table or view does not exist in R3load import in SAPVIEW.log
    Ratnajit Dey
    Currently Being Moderated

    Please check if the table /BI0/PTCTUSERNM exists from the database level and also in the source system.

     

    If not , then in the SAPVIEW.TSK file , change to the following

     

    V /BI0/MTCTUSERNM C ign

     

    Restart the import.

     

    Once the sapinst completes the installation , you will find the SID registered in the MMC.

     

    You can then start the system from MMC

     

    Regards

    Ratnajit

    • Re: Error - SQL error 942, table or view does not exist in R3load import in SAPVIEW.log
      sanjay khatri
      Currently Being Moderated

      I made change to sapview.tsk file but no effect found , after changing I restart procec with continue with old session

       

      found below error

       

      DbSl Trace: ORA-1403 when accessing table SAPUSER

      (DB) INFO: connected to DB
      (DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
      (DB) ERROR: DDL statement failed
      (DROP VIEW "/1SAP1/CNV_A0012")
      DbSlExecute: rc = 103
        (SQL error 942)
        error message returned by DbSl:
      ORA-00942: table or view does not exist
      (IMP) INFO: a failed DROP attempt is not necessarily a problem
      (DB) ERROR: DDL statement failed
      (CREATE VIEW "/1SAP1/CNV_A0012" ( "MANDT" , "CPIDENT" , "TABNAME" , "TABKEY" , "CDOBJCL" , "CDOBJID"  ) AS SELECT T0001."MANDT", T0001."CPIDENT", T0001."TABNAME", T0001."TABKEY", T0001."CDOBJCL",  T0001."CDOBJID" FROM "BDCP" T0001)
      DbSlExecute: rc = 103
        (SQL error 942)
        error message returned by DbSl:
      ORA-00942: table or view does not exist
      (DB) INFO: disconnected from DB

      D:\usr\sap\IDS\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
      D:\usr\sap\IDS\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20120921132734

       

      CAn you help me on this

Actions