cancel
Showing results for 
Search instead for 
Did you mean: 

error during installation CRM 5.0

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

0 Kudos

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