Skip to Content
avatar image
Former Member

SAPVIEW error during Database Load phase

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 31, 2010 at 06:01 AM

    Hi

    Please check if the table ROVERCUBE3 exists in the system.

    If not check in SAPAPPL0.STR the table structure is present and in the log file SAPAPPL0.log the table was created .

    If not , please perform the export again.

    regards

    Ratnajit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Check the SAP Note 709389 ( Problems during load of SAPVIEW) , it should help you to troubleshoot.

      Regards,

      Neel

  • avatar image
    Former Member
    Sep 10, 2010 at 04:04 PM

    Hello,

    The error is not with view: ROVERCUBE3V

    The table that you should be looking out for is: T0001

    Check your logs for table T0001, check if it has been created properly or not.

    Regards,

    Siddhesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The issue has been resolved by solving the inconsistencies in the tables.

      ROVERCUBE3 was not exported as the nametab was corrupted. I later on cleared the inconsistency and then exported once again.

      Nirmal.K