Skip to Content
author's profile photo Former Member
Former Member

Datasource Extraction error

hello experts,

in trying to extract data from a datasource, the following error message was displayed

++++++

Field DATAPAKID in table /BIC/B0007838000 is specified twice. Please check

Message no. DT963

Diagnosis

Two fields of the table have identical names, but field names must be unique within a table.

Procedure

Check the names of the table fields and correct them.

+++

checked table in SE16 but got response - table not active in the dictionary.

any ideas as to how this can be resolved

many thanks

Tee

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 06:54 AM

    I request you to check the DS table once again in SE11.

    Than try to once again generate the data source in RS02 if it is custome defined.

    Hope this will help you.

    Regards

    Saravanan.ar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2007 at 03:52 PM

    Is it standard DS or custom Data source? Go to rsa3 and extract the data and see if you can get any data, if not then you need to make sure nobody actually make some changes to the extract structure of the datasource. If it is export data source, then may be you need to regenerate the export data source again.

    Let's know when you are getting the error.

    thanks.

    Wond

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      many thanks for your reply.

      yes it is a standard DataSource and checks showed that no changes had been made to the extract structure as suggested.

      however, after further checks, it came to light that the DataSource table had a number of repeated columns which the BW extraction process didn't like in the comm structure.

      when all the non-required columns were removed, the data load was successful.

      by the way, i got the error when i tried to activate the transfer rules.

      once again many thanks for your time and effort.

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.