Skip to Content
author's profile photo Eirikur Ingibergsson
0
Eirikur Ingibergsson

r3load export error ORA-00942 for table QCMBTXBLOK

Posted on Dec 02, 2007 at 07:04 PM 238 Views

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2007 at 07:15 PM
    2

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Stefan Koehler
    Stefan Koehler
    Posted on Dec 02, 2007 at 08:19 PM
    1

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.