OS-DB Migration [ Import Error ]

[Former Member]

Hello,

We are doing the OS-DB Migration and on the last stage of the import...

We had 38 processes,out of which 37 are completed successfully... SAPAPPL0 is giving error...

Kindly please suggest...

1. trying to restart import ###

(RIM) WARNING: unable to drop table "/BDL/LOCK"

DbSlExecute: rc = 107

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

1. restart finished ###

#START: 20080616221834

TAB: [HEADER]

FIL: /sapexport/DATA/SAPAPPL0.001 #20080616221834

EOT: [HEADER]

(GSI) INFO: dbname = "P4520080614110639 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "SAPTR10 "

(GSI) INFO: sysname = "SunOS"

(GSI) INFO: nodename = "SAPTR10"

(GSI) INFO: release = "5.9"

(GSI) INFO: version = "Generic_122300-15"

(GSI) INFO: machine = "sun4u"

(CS) ERROR: cannot build CREATE statement for "/BDL/LOCK"

not enough parameters for all items of the template

#STOP: 20080616221834

Thanks,

RaHuL...

[stefan_koehler · Accepted solution]

Hello Rahul,

> (CS) ERROR: cannot build CREATE statement for "/BDL/LOCK"

> not enough parameters for all items of the template

> #STOP: 20080616221834

Please post the following content:

• CREATE TABLE template from the DDLORA.TPL file

• Corresponding table definition for /BDL/LOCK out of the SAPAPPL0.STR file

Regards

Stefan

[Former Member · Accepted solution]

Hello,

Thanks for the Reply...

• CREATE TABLE template from the DDLINF.TPL [ as we are migrating from Informix] file

cretab: CREATE TABLE &tab_name

( /{ &fld_name &fld_desc /-, /} )

IN &location

EXTENT SIZE &init

NEXT SIZE &next

LOCK MODE ROW ;

REVOKE ALL ON &tab_name FROM PUBLIC ;

GRANT SELECT ON &tab_name TO PUBLIC

• Corresponding table definition for /BDL/LOCK out of the SAPAPPL0.STR file

tab: /BDL/LOCK

att: APPL0 0 PA T all /BDL/LOCK~0 APPL0 0

fld: CATEGORY CHAR 12 0 0 not_null 1

fld: TASKNAME CHAR 40 0 0 not_null 2

fld: ID CHAR 10 0 0 not_null 3

###############################

Latest Error is :

1. restart finished ###

#START: 20080617122529

TAB: [HEADER]

FIL: /sapexport/DATA/SAPAPPL0.001 #20080617122529

EOT: [HEADER]

(GSI) INFO: dbname = "P4520080614110639 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "SAPTR10 "

(GSI) INFO: sysname = "SunOS"

(GSI) INFO: nodename = "SAPTR10"

(GSI) INFO: release = "5.9"

(GSI) INFO: version = "Generic_122300-15"

(GSI) INFO: machine = "sun4u"

(IMP) TABLE: "/SAPDMC/LSCRULET"

TAB: /SAPDMC/LSCRULET

FIL: /sapexport/DATA/SAPAPPL0.001 #20080617122529

EOT: /SAPDMC/LSCRULET

(IMP) DATA: 34 rows in table "/SAPDMC/LSCRULET" #20080617122529

#Trying to create primary key "/SAPDMC/LSCRULET~0"

(IMP) PRKEY: "/SAPDMC/LSCRULET~0"

(IMP) ERROR: CREATE statement failed for object "/SAPDMC/LSCSTEPS"

(CREATE TABLE "/SAPDMC/LSCSTEPS" ( "STEPNR" VARCHAR2(3) DEFAULT '000' NOT NULL ,

"STEPTYPE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "FUNCNAME" VARCHAR2(30) DEFAULT ' ' NOT NULL ,

"X_MAINSTEP" VARCHAR2(1) DEFAULT ' ' NOT NULL , "X_VISIBLE" VARCHAR2(1) DEFAULT ' ' NOT NULL ,

"X_INACTIVE" VARCHAR2(1) DEFAULT ' ' NOT NULL , "X_READGENRLV" VARCHAR2(1) DEFAULT ' ' NOT NULL ,

"X_CONVGENRLV" VARCHAR2(1) DEFAULT ' ' NOT NULL , "DESCRPTN" VARCHAR2(50) DEFAULT ' ' NOT NULL

) TABLESPACE PSAPSTABD STORAGE (INITIAL 16384 NEXT

0000000040K MINEXTENTS 0000000001 MAXEXTENTS 0000000300

PCTINCREASE 0000 ))

DbSlExecute: rc = 106

(SQL error 955)

error message returned by DbSl:

ORA-00955: name is already used by an existing object

Regards,

RaHuL...

[Former Member · Accepted solution]

Hi

Please check the Oracle configuration files.

[Former Member · Accepted solution]

Hello,

Ignore the first part.. Please find DDLORA.TPL

root@SAPTR10 # cat DDLORA.TPL

prikey: AFTER_LOAD ORDER_BY_PKEY

seckey: AFTER_LOAD

cretab: CREATE TABLE &tab_name

( /{ &fld_name &fld_desc /-, /} )

TABLESPACE &location

STORAGE (INITIAL &init

NEXT &next

MINEXTENTS &minext

MAXEXTENTS &maxext

PCTINCREASE &pctinc )

crepky: CREATE UNIQUE INDEX &pri_key

ON &tab_name

( &key_fld /-, )

TABLESPACE &location

STORAGE (INITIAL &init

NEXT &next

MINEXTENTS &minext

MAXEXTENTS &maxext

PCTINCREASE &pctinc )

creind: CREATE &unique INDEX &ind_name

ON &tab_name

( /{ &fld_name /-, /} )

TABLESPACE &location

STORAGE (INITIAL &init

NEXT &next

MINEXTENTS &minext

MAXEXTENTS &maxext

PCTINCREASE &pctinc )

Thanks,

RaHuL...

[Former Member · Accepted solution]

Thanks for the reply Deepak,

But that is not the issue... We have completed 37 of the 38 processes in import...

For this also this error comes only for few tables...

Thanks,

Rahul...

[stefan_koehler · Accepted solution]

Hello Rahul,

what is your exactly error now:

The first one with "/BDL/LOCK" or the second one with "/SAPDMC/LSCSTEPS" ?

These are two different errors with 2 different types.

Regards

Stefan

[Former Member · Accepted solution]

Last Error is:

restart finished ###

#START: 20080617122529

TAB: HEADER

FIL: /sapexport/DATA/SAPAPPL0.001 #20080617122529

EOT: HEADER

(GSI) INFO: dbname = "P4520080614110639 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "SAPTR10 "

(GSI) INFO: sysname = "SunOS"

(GSI) INFO: nodename = "SAPTR10"

(GSI) INFO: release = "5.9"

(GSI) INFO: version = "Generic_122300-15"

(GSI) INFO: machine = "sun4u"

(IMP) TABLE: "/SAPDMC/LSCRULET"

TAB: /SAPDMC/LSCRULET

FIL: /sapexport/DATA/SAPAPPL0.001 #20080617122529

EOT: /SAPDMC/LSCRULET

(IMP) DATA: 34 rows in table "/SAPDMC/LSCRULET" #20080617122529

#Trying to create primary key "/SAPDMC/LSCRULET~0"

(IMP) PRKEY: "/SAPDMC/LSCRULET~0"

(IMP) ERROR: CREATE statement failed for object "/SAPDMC/LSCSTEPS"

(CREATE TABLE "/SAPDMC/LSCSTEPS" ( "STEPNR" VARCHAR2(3) DEFAULT '000' NOT NULL ,

"STEPTYPE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "FUNCNAME" VARCHAR2(30) DEFAULT ' ' NOT NULL ,

"X_MAINSTEP" VARCHAR2(1) DEFAULT ' ' NOT NULL , "X_VISIBLE" VARCHAR2(1) DEFAULT ' ' NOT NULL ,

"X_INACTIVE" VARCHAR2(1) DEFAULT ' ' NOT NULL , "X_READGENRLV" VARCHAR2(1) DEFAULT ' ' NOT NULL ,

"X_CONVGENRLV" VARCHAR2(1) DEFAULT ' ' NOT NULL , "DESCRPTN" VARCHAR2(50) DEFAULT ' ' NOT NULL

) TABLESPACE PSAPSTABD STORAGE (INITIAL 16384 NEXT

0000000040K MINEXTENTS 0000000001 MAXEXTENTS 0000000300

PCTINCREASE 0000 ))

DbSlExecute: rc = 106

(SQL error 955)

error message returned by DbSl:

ORA-00955: name is already used by an existing object

Thanks,

RaHuL...

[stefan_koehler · Accepted solution]

Hello Rahul,

so you solved the first problem? (your table / template defintion looks fine.. maybe the storage parameter settings in the *TPL files is wrong)

For the error with "/SAPDMC/LSCSTEPS":

Check your definition / task files, if this table is defined more than once.

If not take a look at the content of the table - if it is empty drop it and restart the load process.

Regards

Stefan