ORA-14400: inserted partition key does not map

[Former Member]

We are doing Unicode conversion of SCM 7.0 Sr1 with LC. We have

followed the approach of Combined upgrade and unicode conversion.

We have completed the upgrade and now proceeeding with unicode

conversion. We are done with the export and now we are import the data

into target system. During the import many of our packages are getting

into some ora errors.

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

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "/BIC/B0000141000"

(SQL error 904)

error message returned by DbSl:

ORA-00904: "RECORDMODE": invalid identifier

(DB) INFO: /BIC/B0000142000 deleted/truncated #20091114154819

DbSl Trace: Error 904 in stmt_execute() from oci_execute_stmt(), orpc=0

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

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "/BIC/B0000142000"

(SQL error 904)

error message returned by DbSl:

ORA-00904: "RECORDMODE": invalid identifier

(DB) INFO: /BIC/B0000149000 deleted/truncated #20091114154819

DbSl Trace: Error 904 in stmt_execute() from oci_execute_stmt(), orpc=0

Please Help.

[Former Member]

Hi,

you are missing partition objects of some non-standard SAP tables , you would have to execute the script Markus mentioned to CREATE the tables with ALL partitions according in your source system.

Then you can load the data so partition keys can find the table partition to be stored in.

bye

yk

[markus_doehr2]

Did you execute the report "SMIGR_CREATE_DDL" before you started the export?

Markus

[Former Member]

We ran the report, SMIGR_CREATE_DDL and performed export/import process therafter. However, the issue we are facing was due to some program bug.

We reinstated the import and got the issue resolved. Thanks for all your inputs though!!

[Former Member]

Hi,

Now I am no expert on the combined upgrade/unicode conversion always done them separate.

But, the

ORA-00904: "RECORDMODE": invalid identifier

I think means it is trying to insert data into column RECORDMODE where the data is not alphanumeric.....Fror example a date.....

It defo looks like a BI table so it could be possibe...

Regards

Mark