Export with R3load aborts with ORA-00942

[Former Member]

Hello Gurus,

I want to migrate a CRM system (4.0, Basis 6.20, Kernel 6.40) from SOLARIS to LINUX. The Database version is ORACLE 10.2.0.2.0.

The export aborts with an ORA-00942 error.

In log file SAPUSER.log I found the following entry:

(EXP) ERROR: DbSlExeRead failed

rc = 103, table "ZCT_TEST"

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

How can I solve that problem? Where can R3load find this table?

The table doesn't exist on the system.

Thank you in advance for your help!

Best Regards

Ines

[stefan_koehler · Accepted solution]

Hello Ines,

it seems like that customer table ZCT_TEST still exists in the SAP (ABAP) DDIC.

Please check this via SE11/SE14 and recreate the table on the database or delete the DDIC entry.

How the nametab works is described in sapnote #932779 (it is also describes the tables in the unicode conversion process, but in your case this part of the note is not necessary)

If you have some inconsistency in the SAP DDIC (table is not valid in SE11/SE14, but visible in table DDNTT), then you can use the function DD_NAMETAB_DELETE to delete these entries.

Regards

Stefan

[Former Member · Accepted solution]

Hello Stefan,

I can't find the table with se11. In se14 the table is active but does not exist on the database.

Shall I use DD_NAMETAB_DELETE and delete the entry for the table?

Or is it maybe better to create the table with se14?

I checked the nametab for the table with DD_SHOW_NAMETAB and found an active nametab for the table.

Thank you.

Best Regards

Ines

[stefan_koehler · Accepted solution]

Hello Ines,

i have seen the same situation in one of our BW-systems (SE11 -> not visible, SE14 -> visible and active).

I used the function DD_NAMETAB_DELETE and deleted the corresponding entry for the table.

After that please restart the whole export procedure again, and it should work.

Regards

Stefan

[Former Member]

Hi,

Please check if 973882 note helps

Rohit