Skip to Content
avatar image
Former Member

DTP data load failed

Hi Everbody,

I added 2 fields UMREN (Denominator), UMREZ(Numerator) into my Data Source (2LIS_04_P_ARBPL),  Info Source (2LIS_04_P_ARBPL) and also into Standard Cube (0PP_C03)

Later I activated all the transformations, DTP, Data source, info source, info cube..

Ran the Info Package data loaded successfully till PSA.. When I am executing DTP, the load is failing by giving short dump.

Short Dump:

Short text

                     SQL error "-206" while accessing table "/BI0/F0PP_C03".

What happened?

                Database error text: "Column NUMERATOR not in specified tables. MSGID=

                Job=021133/BDAADM/WP13"

For Your Information (FYI):

In the “Details” tab, as shown in the below 5th line, it is giving dump.

Success: Updating to InfoCube 0PP_C03 : 90 -> 0 Data Records

Success: Overlapping check with archived data areas for InfoProvider 0PP_C03

Success: Conversion of Characteristic Values to SIDs

Success: Write to Fact Table

Failed: Dump: The internal session was terminated with the runtime error DBIF_RSQL_SQL_ERROR (see ST22)

    Please help to resolve this issue.

regards

Ajay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Jun 20, 2012 at 08:15 AM

    in the transformation maintenance, display the generated program. do a search for the missing field. if you don't find the field, something went wrong when activating the transformation. try activating it again. reload.

    M.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2012 at 08:04 AM

    Hi

    Seems to be issue with info obejcts that you are connected so please check with soucre and target types and use same length and type of obejcts and check with data load.

    Jagadeesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 20, 2012 at 08:04 AM

    HI,

    DBIF_RSQL_SQL_ERROR is the most irritating error. Sometimes, it may get resolved by repeating the DTP. Try this.....

    Make sure you delete the red request from Cube and then run DTP again.

    There are some SAP Notes available for this error. Please search..........

    Regards,

    Suman

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 20, 2012 at 08:10 AM

    Hi Ajay,

    Delete the indexes in the cube and reschedule the DTP it will get executed successfully

    Prathish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 20, 2012 at 09:01 AM

    Hi all

          this issue is resolved, I reactivated all the bw objects in an order such as data source, transformations, infocube.. by doing this, the issue is resolved..

    regards

    ajay

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2012 at 09:12 AM

    Hi Ajay,

    If you are facing same short dump for all activation and loading then don't forget to check "Tablespace size" , sometimes this dump comes due to Tablespace is full. T code: DB02 -> Tablespace overview ->active tablespace size. If not authorized then ask BASIS team to check it.

    Else,Try data loading with new DTP and check for SAP Notes related to this dump.

    Regards,

    Avinash

    Add comment
    10|10000 characters needed characters exceeded