Skip to Content
0
Former Member
Oct 07, 2009 at 07:25 AM

error during installation CRM 5.0

23 Views

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