DB6 Installation - error on phase VIEW (CREATE VIEW "/BEV1/LAVMVA1_V)

[Former Member]

Dear all,

I install LNX X86_64, DB6 - ERP 6.0 EHP4, during phase IMPORT ABAP I've got error in SAPVIEW.log:

_____________________________________________________________________________

usr/sap/SID/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

/usr/sap/SID/SYS/exe/run/R3load: version R7.01/V1.4 [UNICODE]

Compiled Dec 25 2009 23:46:01

/usr/sap/SID/SYS/exe/run/R3load -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP VIEW "/BEV1/LAVMVA1_V" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE VIEW "/BEV1/LAVMVA1_V" ( "MANDT", "BSTNK", "VKORG", "VTWEG", "SPART", "VKBUR", "VKGRP", "KUNNR", "ERNAM", "BSTDK", "AUART", "VBELN" ) AS SELECT T0001."MANDT", T0001."BSTNK", T0001."VKORG", T0001."VTWEG", T0001."SPART", T0001."VKBUR", T0001."VKGRP", T0001."KUNNR", T0001."ERNAM", T0001."BSTDK", T0001."AUART", T0002."VBELN" FROM "VBAK" T0001, "VBUK" T0002 WHERE T0002."MANDT" = T0001."MANDT" AND T0002."VBELN" = T0001."VBELN" AND ( T0002."VBOBJ" = 'A' OR T0002."VBOBJ" = 'L' ) )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

/usr/sap/SID/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/SID/SYS/exe/run/R3load: END OF LOG: 20100119153412

__________________________________________________________________________________

I have changed R3load, sapinst to newest version, space is enough, tablespaces are not full.

Do you have any idea what is cause of error and how to solve it?

Any help is appreciated.

Regards,

Roman

[Frank-Martin · Accepted solution]

Hi Roman,

please check if the target table VBAK and VBUK exist.

Regards

Frank

[Former Member · Accepted solution]

Hi Frank,

thanks for reply, how can I check it?

Another point: SAP ERP is installed as new system, therefore I dont know how it could happened that same tables are missing.

Regards,

Roman

[Frank-Martin · Accepted solution]

Hi Roman,

if "sapxxx" is your connect user, you can the following commands on your database server.

db2 describe table sapxxx.VBUK

db2 describe table sapxxx.VBAK

If one of the tables is missing, you need to check the R3load log files corresponding to those tables.

Regards

Frank

[Former Member · Accepted solution]

Hi Roman,

for example you can use the command

db2 "select tabschema from syscat.tables where tabname = 'VBAK'" (same with the other table) and if you get a solution row with you tabschema the tables exists.

Regards

Olaf

[Former Member · Accepted solution]

Hi Frank,

thanks for your very fast hints.

I have checked .log files SAPxxxx.log (SAP0000, SAPAPPL0, SAPAPPL1, ...) but there isnt any entry with VBAK.

When I entered under <sid>adm command: db2 describe table sap<sid>.VBAK it takes a long time wihtout any result.

Thanks a lot for your help.

Roman

Edited by: Roman Mikolas on Jan 19, 2010 4:27 PM

Edited by: Roman Mikolas on Jan 19, 2010 4:27 PM

[Former Member · Accepted solution]

Hi Olaf,

I entered your command and result is 0 record selected.

It seems that tables doesnt exist but what now? Create tables manually? What parameters, commands, ...

Regards,

Roman