on 05-21-2013 3:34 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sandeep,
Follow below notes these will be helpful to you.
Note 709389 - Problems during load of SAPVIEW
Note 1238351 - Hom./Het.System Copy SAP NW 7.0 incl. Enhancement Package 1
Thanks,
Venkat
I would update R3load to the latest version and try again.
Regards, Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.