Aug 28, 2010 at 10:19 AM

SAPVIEW error during Database Load phase

35 Views

Hello All,

I am in the process of migrating my SAP system from HP Unix to AIX.

I have finished exporting the database but I am getting the below error in SAPVIEW.log during the import due to which my work is held up.

-

(DB) ERROR: DDL statement failed

(CREATE VIEW "ROVERCUBE3V" ( "KUNNR" , "TYPE" , "FIELD" , "AUFNR" , "DMBTR" , "

WAERS" , "EZDAT" , "MGMAX" , "ERFME" , "MGMIN" , "ANZHL" , "PERIV" , "PERIO" , "

GJAHR" , "COUNTRY" , "REGION" ) AS SELECT T0001."KUNNR", T0001."TYPE", T0001."F

IELD", T0001."AUFNR", T0001."DMBTR", T0001."WAERS", T0001."EZDAT", T0001."MGMAX

", T0001."ERFME", T0001."MGMIN", T0001."ANZHL", T0001."PERIV", T0001."PERIO", T0

001."GJAHR", T0001."COUNTRY", T0001."REGION" FROM "ROVERCUBE3" T0001 WHERE T0001

."OBJVERS" = 'A')

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

-

Any help would be highly appreciated.

Regards,

Nirmal.K