ORA-00942 during export

[ganimede_dignan]

Hi,

On a BW system, a NW04S Oracle 10.2.0.4 with Win 03 R3 SP2 X86 in MSCS, 2 export jobs ends due ORA-00942, an example...

(EXP) ERROR: DbSlExeRead failed

rc = 103, table "/BI0/0100000001"

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

All objs are:

D /BIC/E100414 E err

D /BIC/E100942 E xeq

D /BIC/E100963 E xeq

D /BI0/0100000001 E err

D /BI0/0100000002 E xeq

D /BI0/0100000003 E xeq

D /BI0/0100000004 E xeq

D /BI0/0100000005 E xeq

D /BI0/0100000006 E xeq

D /BI0/0100000007 E xeq

D /BI0/0100000008 E xeq

D /BI0/0100000009 E xeq

D /BI0/0100000010 E xeq

D /BI0/0100000011 E xeq

D /BI0/0100000012 E xeq

D /BI0/0100000013 E xeq

D /BI0/0100000014 E xeq

D /BI0/0100000015 E xeq

D /BI0/0100000016 E xeq

D /BI0/0100000017 E xeq

D /BI0/0100000018 E xeq

D /BI0/0100000019 E xeq

D /BI0/0100000020 E xeq

D /BI0/0100000021 E xeq

D /BI0/0100000022 E xeq

D /BI0/0100000023 E xeq

D /BI0/0100000024 E xeq

D /BI0/0100000025 E xeq

D /BI0/0100000026 E xeq

D /BI0/0100000027 E xeq

D /BI0/0100000028 E xeq

D /BI0/0100000029 E xeq

D /BI0/0100000030 E xeq

D /BI0/0100000031 E xeq

D /BI0/0100000033 E xeq

D /BI0/0100000034 E xeq

D /BI0/0100000035 E xeq

D /BI0/0100000036 E xeq

D /BI0/0100000037 E xeq

D /BI0/0100000038 E xeq

D /BI0/0100000039 E xeq

D /BI0/0100000041 E xeq

D /BI0/0100000042 E xeq

D /BI0/0100000043 E xeq

D /BI0/0100000044 E xeq

D /BI0/0100000045 E xeq

D /BI0/0100000047 E xeq

D /BI0/0100000049 E xeq

D /BI0/0100000051 E xeq

D /BI0/0100000052 E xeq

D /BI0/0100000053 E xeq

All objs are missed in database level but DB02 transaction is ok, no missing table or index.

Regards.

[stefan_koehler · Accepted solution]

Hello Ganimede,

i have seen a similiar behavior on our BW system during the unicode conversion.

Please perform the following steps to identify / check the ABAP DDIC inconsistency:

1) Run transaction SE11 -> Enter the names of the tables "/BIC/E*"

2) Run transaction SE14 -> Enter the names of the tables "/BIC/E*"

or you can use the following report to check the inconsistency:

http://rapidshare.com/files/347140030/ZCHK_NTDDDB.txt.html

You can cleanup this inconsistency with the FM DD_NAMETAB_DELETE.

Regards

Stefan

[ganimede_dignan]

Hi,

for D /BI0/01* you are right (note Note 449891 - Temporary database objects in BW 3.x) but for D /BIC/E100* it's so strange.

Regards.

[markus_doehr2]

This can happen if the BW system was not stopped during the export. At the time R3ldctl run was making a list of all tables those tables existed. Later those tables were deleted (load jobs, cube compressions...) and now the export doesn't find them.

The only way of avoiding such problems is to shutdown the system during the export time.

Markus

Edited by: Markus Doehr on Feb 7, 2010 12:53 AM