import error: DbSl Trace: ORA-00922 occurred at SQL stmt:

[Former Member]

Hi experts,

we are doing system copy ABAP system(NW7 EPHP) using parallel export/import and export is generated successfully but facing issue in import phase.

we are manually runs Migmon

export :

-------------------------------------------------------------------------------------------------

Unloading of 'SAPAPPL1' export package: OK

Signal file creation for 'SAPAPPL1' export package: OK

Unloading of 'SAPCLUST' export package: OK

Signal file creation for 'SAPCLUST' export package: OK

Unloading of 'SAPDDIM' export package: OK

Unloading of 'SAPAPPL2' export package: OK

Signal file creation for 'SAPAPPL2' export package: OK

Signal file creation for 'SAPDDIM' export package: OK

Unloading of 'SAPDODS' export package: OK

Unloading of 'SAPDFACT' export package: OK

Unloading of 'SAPAPPL0' export package: OK

------------------------------------------------------------------------------------------------------------------------------------------------------

error in import:

ERROR: 2013-09-22 01:37:25 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL1' import package is interrupted with R3load error.

Process 'R3load -i SAPAPPL1.cmd -dbcodepage 4103 -l SAPAPPL1.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL1.log' file.

Standard error output:

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

SAPAPPL1.log:

(RTF) ########## WARNING ###########

        Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file /c_dir/Export/ABAP/DB/SQLFiles.LST

(SQL) INFO: found /c_dir/Export/ABAP/DB/SQLFiles.LST

(SQL) INFO: Trying to open /c_dir/Export/ABAP/DB/SQLFiles.LST

(SQL) INFO: /c_dir/Export/ABAP/DB/SQLFiles.LST opened

(SQL) INFO: Searching for SQL file APPL1.SQL

(SQL) INFO: APPL1.SQL not found

(SQL) INFO: Searching for SQL file /c_dir/Export/ABAP/DB/ORA/APPL1.SQL

(SQL) INFO: found /c_dir/Export/ABAP/DB/ORA/APPL1.SQL

(SQL) INFO: Trying to open /c_dir/Export/ABAP/DB/ORA/APPL1.SQL

(SQL) INFO: /c_dir/Export/ABAP/DB/ORA/APPL1.SQL opened

DbSl Trace: Error 922 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-00922 occurred at SQL stmt (parse error offset=601)

(DB) ERROR: DDL statement failed

(CREATE TABLE "/GC1/TACTDEL" ( "DELGUID" RAW(16) NOT NULL , "CLIENT" VARCHAR2(9) DEFAULT '000' NOT NULL , "OBJTYPE" VARCHAR2(90) DEFAULT ' ' NOT NULL , "OBJ

NAME" VARCHAR2(360) DEFAULT ' ' NOT NULL , "LOGGUID" RAW(16) , "TIMESTAMP" VARCHAR2(42) DEFAULT ' ' NOT NULL , "DELETION_MODE" VARCHAR2(3) DEFAULT ' ' NOT NU

LL , "GEN_OBJTYPE" VARCHAR2(90) DEFAULT ' ' NOT NULL , "MASTER_OBJTYPE" VARCHAR2(90) DEFAULT ' ' NOT NULL , "MASTER_OBJNAME" VARCHAR2(360) DEFAULT ' ' NOT NU

LL , "STATUS" VARCHAR2(3) DEFAULT ' ' NOT NULL , "METADATA" BLOB , "DELETION_COUNT" NUMBER(10) DEFAULT 0 NOT NULL  ) TABLESPACE PSAP@SCHEMAID@ LOB ("METADATA

") store as securefile (enable storage in row cache ) STORAGE (INITIAL 0000000016K NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0

) )

DbSlExecute: rc = 99

  (SQL error 922)

  error message returned by DbSl:

ORA-00922: missing or invalid option

(DB) INFO: disconnected from DB

R3load: job finished with 1 error(s)

R3load: END OF LOG: 20130922013725

----------------------------------------------------------------------------------------------------------------------------------------

ADD: we using lastet DBSL of 720----->"lib_dbsl_425-10007263.sar"

& MigMon s/w using present in installation directory because as per download version not able to even generate export.

Kindly suggest.

Regards,

[Former Member · Accepted solution]

Dear Vivek,

This error is caused by wrong tablespace name "PSAP@SCHEMAID@", this means that placeholder  @SCHEMAID@ has not been replaced correctly whithin your DDLORA.TPL

Try replacing the files DDLORA.TPL from export directory by DDLORA.TPL from installation directory and launch import process.

Thanks

Asim

[former_member188883]

Hi Vivek,

Based on the information

SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file /c_dir/Export/ABAP/DB/SQLFiles.LST
(SQL) INFO: found /c_dir/Export/ABAP/DB/SQLFiles.LST
(SQL) INFO: Trying to open /c_dir/Export/ABAP/DB/SQLFiles.LST
(SQL) INFO: /c_dir/Export/ABAP/DB/SQLFiles.LST opened
(SQL) INFO: Searching for SQL file APPL1.SQL
(SQL) INFO: APPL1.SQL not found
(SQL) INFO: Searching for SQL file /c_dir/Export/ABAP/DB/ORA/APPL1.SQL
(SQL) INFO: found /c_dir/Export/ABAP/DB/ORA/APPL1.SQL
(SQL) INFO: Trying to open /c_dir/Export/ABAP/DB/ORA/APPL1.SQL
(SQL) INFO: /c_dir/Export/ABAP/DB/ORA/APPL1.SQL opened
DbSl Trace: Error 922 in exec_immediate() from oci_execute_stmt(), orpc=

It looks like some problem with the export directory. Have you executed the report SMIGR_CREATE_DLL before starting the database export.

This step will generate the required SQL files which it shows missing.

Refer System Copy guide on how to execute this report.

Hope this helps.

Regards,

Deepak Kori