Skip to Content
avatar image
Former Member

Error at Import ABAP phase

Loading of 'SAPVIEW' import package: ERROR

Import Monitor jobs: running 0, waiting 0, completed 17, failed 1, total 18.

Below is the error log of SAPVIEW..log

E:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20130521092855

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

E:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

E:\usr\sap\PRD\SYS\exe\uc\NTAMD64\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) ERROR: DDL statement failed

(DROP VIEW "APPL_DEVC")

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 "APPL_DEVC" ( "DEVCLASS" , "OBJ_NAME"  ) AS SELECT T0001."DEVCLASS", T0001."DEVCLASS" FROM "TDEVC" 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

E:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

E:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130521092856

I checked oracle instance, it is working fine. Please help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 21, 2013 at 04:44 PM

    Hi Sandeep,

    Might not seem relevant.

    1. The system you exported from is it a non-unicode to unicode conversion system?

    2. If above not applicable did you pre export job SMIGR_CREATE_DDL create any files and if so did you copy these to your sapinst directory before starting your import? i.e. noting to check files on same server where job is execute. If so it might have skipped files and tables in previous import job causing the sapview job not to run.

    3. If also not this scenario do as Juan Reyes suggested update R3load and retry if still failing giving us some more log information to assist in troubleshooting this.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • May 21, 2013 at 02:55 PM

    I would update R3load to the latest version and try again.

    Regards, Juan

    Add comment
    10|10000 characters needed characters exceeded