Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member
replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question