r3load export error ORA-00942 for table QCMBTXBLOK

[esi]

Dear all,

I am attempting to export our newly upgraded (from 46c to erp2005) development system. (for importing later on new hardware).

In log file SAPAPPL1_43 I get the following error:

(EXP) ERROR: DbSlExeRead failed

rc = 103, table "QCMBTXBLOK"

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

I found references to note 9385 which does not apply, since there are no qcm* tables, neither in ddic, not in DB.

Can anyone suggest how to proceed ?

I have already reported the problem formally but am hoping to save time by posting here also.

Rgds, Eirikur.

[Former Member · Accepted solution]

Hi Eirikur,

no problem, you have an extra entry in your active nametab. You could delete the entry if the table does not exists in DDIC and DB. You may also set the table in the Task file (SAPAPPL1_43.TSK) from <i>err</i> to <i>ign</i> (ignore). This will export this package without this table.

You may check for other inconsistencies with the statement:

select tabname from <sapschema>.ddntt
where tabform = 'T' and tabtype in ('T','P','C')
minus
select table_name from dba_tables;

Set all found tables to ignore.

Best regards

Ralph

[esi · Accepted solution]

Thanks for the reply.

I found 5 qcm* entries which match your select command.

In total I have 28 qcm* entries which are causing problems, since they exist in ntab but not db, so I am ingoring them all in the export.

I hope this is OK.

Best thanks for the suggestion.

Rgds, Eirikur.

[stefan_koehler]

Hello Eirikur,

the QCM tables are temporary tables, that are created, if you change the DDIC structure (for example make a CHAR(40) field to a CHAR(20) field).

This is described in the sapnote #9385 ... you should check the data dictionary transformations.

Regards

Stefan