on 10-07-2009 8:25 AM
Hi ,
We are installaling SAP CRM 5.0 SR2 on windows server .During import ABAP phase its giving below error.I am attaching SAPVIEW.log for more details::
(DB) ERROR: DDL statement failed
(CREATE VIEW "/SAPCND/D04V681F" ( "ROLLNAME" , "AS4LOCAL" , "AS4VERS" , "DDLANGUAGE" , "DATATYPE" , "LENG" , "OUTPUTLEN" , "CONVEXIT" , "SCRTEXT_S" , "SCRTEXT_M" , "SCRTEXT_L" , "DDTEXT" , "LOWERCASE" , "VALEXI" , "ENTITYTAB" , "DOMNAME" ) AS SELECT T0002."ROLLNAME", T0002."AS4LOCAL", T0002."AS4VERS", T0003."DDLANGUAGE", T0002."DATATYPE", T0002."LENG", T0002."OUTPUTLEN", T0002."CONVEXIT", T0003."SCRTEXT_S", T0003."SCRTEXT_M", T0003."SCRTEXT_L", T0003."DDTEXT", T0002."LOWERCASE", T0002."VALEXI", T0002."ENTITYTAB", T0002."DOMNAME" FROM "/SAPCND/T681F" T0001, "DD04L" T0002, "DD04T" T0003 WHERE T0001."ROLLNAME" = T0002."ROLLNAME" AND T0002."ROLLNAME" = T0003."ROLLNAME" AND T0002."AS4LOCAL" = T0003."AS4LOCAL" AND T0002."AS4VERS" = T0003."AS4VERS" AND T0002."AS4LOCAL" = 'A' AND T0002."AS4VERS" = '0000')
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\CRT\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
E:\usr\sap\CRT\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20091007115311
E:\usr\sap\CRT\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20091007115343
E:\usr\sap\CRT\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\CRT\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Jun 11 2007 00:33:22
E:\usr\sap\CRT\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 "/SAPCND/D04V681F")
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 "/SAPCND/D04V681F" ( "ROLLNAME" , "AS4LOCAL" , "AS4VERS" , "DDLANGUAGE" , "DATATYPE" , "LENG" , "OUTPUTLEN" , "CONVEXIT" , "SCRTEXT_S" , "SCRTEXT_M" , "SCRTEXT_L" , "DDTEXT" , "LOWERCASE" , "VALEXI" , "ENTITYTAB" , "DOMNAME" ) AS SELECT T0002."ROLLNAME", T0002."AS4LOCAL", T0002."AS4VERS", T0003."DDLANGUAGE", T0002."DATATYPE", T0002."LENG", T0002."OUTPUTLEN", T0002."CONVEXIT", T0003."SCRTEXT_S", T0003."SCRTEXT_M", T0003."SCRTEXT_L", T0003."DDTEXT", T0002."LOWERCASE", T0002."VALEXI", T0002."ENTITYTAB", T0002."DOMNAME" FROM "/SAPCND/T681F" T0001, "DD04L" T0002, "DD04T" T0003 WHERE T0001."ROLLNAME" = T0002."ROLLNAME" AND T0002."ROLLNAME" = T0003."ROLLNAME" AND T0002."AS4LOCAL" = T0003."AS4LOCAL" AND T0002."AS4VERS" = T0003."AS4VERS" AND T0002."AS4LOCAL" = 'A' AND T0002."AS4VERS" = '0000')
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\CRT\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
E:\usr\sap\CRT\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20091007115344
E:\usr\sap\CRT\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20091007124236
E:\usr\sap\CRT\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\CRT\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Jun 11 2007 00:33:22
E:\usr\sap\CRT\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 "/SAPCND/D04V681F")
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 "/SAPCND/D04V681F" ( "ROLLNAME" , "AS4LOCAL" , "AS4VERS" , "DDLANGUAGE" , "DATATYPE" , "LENG" , "OUTPUTLEN" , "CONVEXIT" , "SCRTEXT_S" , "SCRTEXT_M" , "SCRTEXT_L" , "DDTEXT" , "LOWERCASE" , "VALEXI" , "ENTITYTAB" , "DOMNAME" ) AS SELECT T0002."ROLLNAME", T0002."AS4LOCAL", T0002."AS4VERS", T0003."DDLANGUAGE", T0002."DATATYPE", T0002."LENG", T0002."OUTPUTLEN", T0002."CONVEXIT", T0003."SCRTEXT_S", T0003."SCRTEXT_M", T0003."SCRTEXT_L", T0003."DDTEXT", T0002."LOWERCASE", T0002."VALEXI", T0002."ENTITYTAB", T0002."DOMNAME" FROM "/SAPCND/T681F" T0001, "DD04L" T0002, "DD04T" T0003 WHERE T0001."ROLLNAME" = T0002."ROLLNAME" AND T0002."ROLLNAME" = T0003."ROLLNAME" AND T0002."AS4LOCAL" = T0003."AS4LOCAL" AND T0002."AS4VERS" = T0003."AS4VERS" AND T0002."AS4LOCAL" = 'A' AND T0002."AS4VERS" = '0000')
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\CRT\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
E:\usr\sap\CRT\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20091007124237
Please help how to proceed.
Thanks..
Mohit
Hi Mohit,
First thing to try would be to replace the kernel directory for the latest one for your system, in particular r3trans and r3load.
You might also have a problem with your media, in particular the export DVD(s). If it was me I would download the DVDs (all) again from service.sap.com and re-start from scratch. I add this twice before and both times doing this resolved it for me.
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Mohit ,
Go to the temp SAP installation directory and check for more information .
Check log files there to see more specific information.
Regards
Ajay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
13 | |
12 | |
11 | |
11 | |
11 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.