Skip to Content
author's profile photo Former Member
Former Member

"DDL statement failed" in Database load faze

Hello,

I have an problem when installing DB2 on Solaris platform.

During the installation, in Database load Faze, i get the error:

MSC-01015 Process finished with error(s), check log file /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.log

I check the log & it has a whole bunch on tables that are created & at the end of it i get this message:

DB) ERROR: DDL statement failed

(CREATE VIEW "D010TINF" ( "PROG", "R3STATE", "LANGUAGE", "UNAM", "UDAT", "UTIME", "DATALG" ) AS SELECT T0001."PROGNAME"

, T0001."R3STATE", T0001."LANGUAGE", T0001."UNAM", T0001."UDAT", T0001."UTIME", T0001."DATALG" FROM "REPOTEXT" T0001)

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.REPOTEXT"; is an undefined name. SQLSTATE=42704

(DB) INFO: disconnected from DB

/sapmnt/S47/exe/R3load: job finished with 1 error(s)

/sapmnt/S47/exe/R3load: END OF LOG: 20080810125355

/sapmnt/S47/exe/R3load: START OF LOG: 20080810130455

/sapmnt/S47/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/S47/exe/R3load: version R6.40/V1.4

/sapmnt/S47/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.cmd -l /tmp/sapin

st_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.log -c 300 -merge_bck -stop_on_error

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

(DROP VIEW "D010TINF")

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.D010TINF"; is an undefined name. SQLSTATE=42704

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

(DB) ERROR: DDL statement failed

(CREATE VIEW "D010TINF" ( "PROG", "R3STATE", "LANGUAGE", "UNAM", "UDAT", "UTIME", "DATALG" ) AS SELECT T0001."PROGNAME"

, T0001."R3STATE", T0001."LANGUAGE", T0001."UNAM", T0001."UDAT", T0001."UTIME", T0001."DATALG" FROM "REPOTEXT" T0001)

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.REPOTEXT"; is an undefined name. SQLSTATE=42704

(DB) INFO: disconnected from DB

/sapmnt/S47/exe/R3load: job finished with 1 error(s)

/sapmnt/S47/exe/R3load: END OF LOG: 20080810130457

/sapmnt/S47/exe/R3load: START OF LOG: 20080810140953

/sapmnt/S47/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/S47/exe/R3load: version R6.40/V1.4

/sapmnt/S47/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.cmd -l /tmp/sapin

st_instdir/R3E47X2/SYSTEM/ABAP/DB6/NUC/DB/SAPVIEW.log -c 300 -merge_bck -stop_on_error

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

(DROP VIEW "D010TINF")

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.D010TINF"; is an undefined name. SQLSTATE=42704

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

(DB) ERROR: DDL statement failed

(CREATE VIEW "D010TINF" ( "PROG", "R3STATE", "LANGUAGE", "UNAM", "UDAT", "UTIME", "DATALG" ) AS SELECT T0001."PROGNAME"

, T0001."R3STATE", T0001."LANGUAGE", T0001."UNAM", T0001."UDAT", T0001."UTIME", T0001."DATALG" FROM "REPOTEXT" T0001)

DbSlExecute: rc = 103

(SQL error -204)

error message returned by DbSl:

SQL0204N "SAPS47.REPOTEXT"; is an undefined name. SQLSTATE=42704

(DB) INFO: disconnected from DB

/sapmnt/S47/exe/R3load: job finished with 1 error(s)

/sapmnt/S47/exe/R3load: END OF LOG: 20080810140954

Please lend me some of your wisdom 😊

Regards,

Yoav Zilberman

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 10, 2008 at 07:18 PM

    Hi Yoav,

    your import failed already before the SAPVIEW package was processed. You should check the other packages too for errors or for packages which are not imported. But the errors show that at lease the tables REPOTEXT and D010TINF are missing. I'm not sure, but I think they are in SAPDDIC package. You should run the package again before running SAPVIEW. For a functioning system you need both, tables and views.

    Regards

    Ralph

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.