Error during Import

[Former Member]

Hi Gurus,

We are in the process of Migration Solution Manager (ABAP+JAVA) from

Source: AIX/ORACLE 10.2

Target : Linux / Oracle 11.2

We have successfully done the export.

During the Import we are facing problem.

Below is the log of "SAPDFACT.log"

*************************

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "SM120110512020527 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "onnism1db "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "onnism1db"

(GSI) INFO: release = "2.6.18-238.9.1.el5"

(GSI) INFO: version = "#1 SMP Fri Mar 18 12:42:39 EDT 2011"

(GSI) INFO: machine = "x86_64"

(DB) INFO: /BI0/F0SMD_EA2D deleted/truncated #20110514164707

DbSl Trace: Error 14400 in stmt_execute() from oci_execute_stmt(), orpc=258

DbSl Trace: ORA-14400 occurred when executing SQL stmt (parse error offset=0)

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "/BI0/F0SMD_EA2D"

(SQL error 14400)

error message returned by DbSl:

ORA-14400: inserted partition key does not map to any partition

(DB) INFO: disconnected from DB

/usr/sap/SM1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/SM1/SYS/exe/run/R3load: END OF LOG: 20110514164708

**********************************************

Please suggest

Br

Anthony

[Former Member · Accepted solution]

Just to give you more information:

Since the object mentioned in the error message is relevant to BW non-standard database objects, you are getting the above error message. Basically R3LDCTL does not read the BW meta data, it reads only the ABAP dictionary information.

To overcome such limitation of R3LDCTL and R3LOAD, SAP has given a report called SMIGR_CREATE_DDL, which writes database specific DDL statements into *.SQL files.

As suggested by others, please run SMIGR_CREATE_DDL as the first step during the export to overcome this issue.

Thanks

PrakashP

[former_member433581 · Accepted solution]

Hello,

I'm having today the same error "ORA-14400: inserted partition key does not map to any partition" during the import process of a system copy (export-import procedure) of a BW system (SAP Enhance Package 1 for SAP Netwaver 7.3) and before the export I ran the SMIGR_CREATE_DDL report on the source system.

The system copy is just to change system's SID.

I'm stuck in this, any advices?

[markus_doehr2]

> (DB) INFO: /BI0/F0SMD_EA2D deleted/truncated #20110514164707

Did you execute the report "SMIGR_CREATE_DDL" on the source system and put the resulting SQL files to the target import directory?

Markus

[Former Member]

Make sure to run report "SMIGR_CREATE_DDL" in the source system and copy the files to the appropriate directory of the target system.

SAP note 771209 contains details on the usage of the report.

Joe Wilson