Error while running SAP installation of IDES 4.7 (SAPVIEW.log)

[Former Member]

Dear Support,

I am installing IDES 4.7 version in Windows 2003 with Oracle 9.2.

Central instance is successfully completed.

At the Database Instance creation, in the step DATABASE LOAD

status is -

R3load jobs: running 2 waiting 0

exceptions occur and message box occurs with RETRY VIEWLOG STOP RESET.

I am trying with RETRY and not succeeded.

Suggest how to proceed.

Thanks,

Choon Keet

Error Observed from at sapinst.log is to look at sapview.log.

Here is the message from SAPVIEW.log

C:\usr\sap\ENS\SYS\exe\run/R3load.exe: START OF LOG: 20100305000926

C:\usr\sap\ENS\SYS\exe\run/R3load.exe: sccsid @(#) $Id:

//bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

C:\usr\sap\ENS\SYS\exe\run/R3load.exe: version R6.40/V1.4

C:\usr\sap\ENS\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program

Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/SAPVIEW.cmd -l

C:\Program

Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/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): WE8DEC

(DB) ERROR: DDL statement failed

(DROP VIEW "/BEV1/EMBWDP_A")

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 "/BEV1/EMBWDP_A" ( "MANDT" , "KTOINH" , "ERDAT" , "VKORG"

,

"VTWEG" , "SPART" , "LFDNR" , "LGGRP" , "MATNR" , "KUNAG" , "KUNWE" ,

"KUNRE" , "KUNRG" , "PARVW" , "RECHNR" , "RECHPOS" , "FKDAT" , "KZAKT" ,"HERK" , "UHRZEIT" , "VRKME" , "MEINS" , "UMVKZ" , "UMVKN" , "FKLMG" ,

"VBELV" , "POSNV" , "VGBEL" , "VGPOS" , "AUBEL" , "AUPOS" , "PFSTOCK" ,

"PFPRS" , "BELW" , "HAUSW" , "KURST" , "NWBELW" , "NWHAUSW" , "URKURS" ,"NWHAUSWALT" , "URKURSAA" , "URDAT" , "ARCHIV" , "Q01" , "V01" , "Q02" ,"V02" , "Q03" , "V03" , "Q04" , "V04" , "Q05" , "V05" , "Q06" , "V06" ,

"Q07" , "V07" , "Q08" , "V08" , "Q09" , "V09" , "Q10" , "V10" , "Q11" ,

"V11" , "Q12" , "V12" , "Q13" , "V13" , "Q14" , "V14" , "Q15" , "V15" ,

"Q16" , "V16" , "Q17" , "V17" , "Q18" , "V18" , "Q19" , "V19" , "Q20" ,

"V20" ) AS SELECT T0001."MANDT", T0001."KTOINH", T0001."ERDAT",

T0001."VKORG", T0001."VTWEG", T0001."SPART", T0001."LFDNR",

T0001."LGGRP", T0001."MATNR", T0001."KUNAG", T0001."KUNWE",

T0001."KUNRE", T0001."KUNRG", T0001."PARVW", T0001."RECHNR",

T0001."RECHPOS", T0001."FKDAT", T0001."KZAKT", T0001."HERK",

T0001."UHRZEIT", T0001."VRKME", T0001."MEINS", T0001."UMVKZ",

T0001."UMVKN", T0001."FKLMG", T0001."VBELV", T0001."POSNV",

T0001."VGBEL", T0001."VGPOS", T0001."AUBEL", T0001."AUPOS",

T0001."PFSTOCK", T0001."PFPRS", T0001."BELW", T0001."HAUSW",

T0001."KURST", T0001."NWBELW", T0001."NWHAUSW", T0001."URKURS",

T0001."NWHAUSWALT", T0001."URKURSAA", T0001."URDAT", T0001."ARCHIV",

T0001."Q01", T0001."V01", T0001."Q02", T0001."V02", T0001."Q03",

T0001."V03", T0001."Q04", T0001."V04", T0001."Q05", T0001."V05",

T0001."Q06", T0001."V06", T0001."Q07", T0001."V07", T0001."Q08",

T0001."V08", T0001."Q09", T0001."V09", T0001."Q10", T0001."V10",

T0001."Q11", T0001."V11", T0001."Q12", T0001."V12", T0001."Q13",

T0001."V13", T0001."Q14", T0001."V14", T0001."Q15", T0001."V15",

T0001."Q16", T0001."V16", T0001."Q17", T0001."V17", T0001."Q18",

T0001."V18", T0001."Q19", T0001."V19", T0001."Q20", T0001."V20" FROM

"/BEV1/EMLGBWDP" T0001 WHERE T0001."KZAKT" = 'A' AND T0001."HERK" = 'F') DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

C:\usr\sap\ENS\SYS\exe\run/R3load.exe: job finished with 1 error(s)

C:\usr\sap\ENS\SYS\exe\run/R3load.exe: END OF LOG: 20100305000927

1. I have tried to look for any solution on internet. There are people

who have encountered this before. But the just rerun the installation and

the error goes away.

1. I have also tried to create the view manually but I got the same error. Anyway does anyone know where is the view created? what table it used?

Thanks.

Choon Keet

[Former Member · Accepted solution]

Hi Choon,

First of all do you have the installation guide on you, if not please get one from the marketplace. The one I have suggests the following at the end of installation -

Since we are installing IDES, I am told just click retry once more (you will get the error again), and

then click OK to end the installation. This is valid for SAP R/3 4.7 ext.1.

See if this removes the error you are getting, please awards points if you succeed, and let me know.

Thanks,

kind regards,

M. Nizam