0Cust_sales Data Load Error in DTP

[Former Member]

Hi all,

Till PSA data is loaded, but when executing DTP to load a data in master 0Cust_sales get Following error...

Category ABAP Programming Error

Runtime Errors MESSAGE_TYPE_X

ABAP Program CL_RSDMD_UPDATE_MASTER_DATA===CP

Application Component BW-WHM-DBA

Error while writing master record "10" of characteristic 0DIVISION

Long text of error message:

Diagnosis

Value 10 for characteristic 0DIVISION is to be written to master

data table /BI0/PDIVISION. An error occurred while doing this.

System Response

Procedure

Check the master data table. Note that, in addition to the primary

index, there can be another unique index in one of the master data

tables.

Procedure for System Administration

Technical information about the message:

Message class....... "BRAIN"

Number.............. 290

Variable 1.......... 10

Variable 2.......... "0DIVISION"

Variable 3.......... "/BI0/PDIVISION"

Variable 4.......... " "

Please Help I am trying sing last 4 daya I search on SDN and other SAP Forum but not solved.

[Former Member · Accepted solution]

Hi,

From the posts that you have made I understand that there is an issue writing value 10 for the info-object 0DIVISION to the table /BI0/P.... and also that you already have a record with value 10 present in the table.

/BI0/P - is a time independent table.

On this basis,I tried to do some research and have found the following :

1)When updating data to the master data table :

Refer the following link:http ://help.sap.com/saphelp_nw70/helpdata/en/42/fbd598481e1a61e10000000a422035/frameset.htm

When data is updated to the master data table or text table following errors can occur:

Invalid characters in keys or navigation attributes

If no SID exists for the value of the navigation attribute

If no language field is defined for texts

Invalid "from" and "to" dates

Duplicate data records with relation to keys

Overlapping and invalid time intervals

2)Handling the duplicate record :

Refer the following link : http://help.sap.com/saphelp_nw04/helpdata/en/d0/538f3b294a7f2de10000000a11402f/frameset.htm

You may have to make the necessary changes as mentioned in this above link.

[Former Member · Accepted solution]

Hi,

I checked 0Division under MasterData/Text, SID table is not generated...

View of MstrDtaTbls /BI0/MDIVISION

Master data tab /BI0/PDIVISION

SID table attr.

If the issue with SID table, than please guide me how can i generate SID Table.

[Former Member · Accepted solution]

Hi,

The SID tables are generated by the system on its own.What I felt was the error "duplicate error record as the record with value 10 already existed in the table" , or the issue can be the missing language for the text.

[KamalMehta · Accepted solution]

Hi ,

You can try creating the Error DTP first .This can be done by following the instructions as mentioned below :

1. Open the Normal DTP .Goto to the Update tab in the DTP.

2. In the Update tab you will get the option of creating the error DTP .This will take you to the Error DTP screen .

3. Use the Option as 'Valid records update reporting possible Requestgreeen '. Increase the number of errorenous records to be ignored if required .

4. Keep the above option (Valid records updates Reporting possible(Request Green) ) in both the Normal and Error DTP .

Once the Error DTP is created run the Normal DTP .Now your Normal DTP should not failed and all the errorneous records should get collected in an Error stack .Later you can check all the errorneous records .

Kindly try the same and update accordingly .

Thanks

Kamal

[Former Member · Accepted solution]

Hi,

I have tried with error DTP also, in 0cust_sales division, ales org, Dist Channel, cust sales are key. If i try with error DTP all records will come in error dtp.

If it is issue with error DTP than how same record will update in dso. All records will sucessfully updated in DSO, and if i try to load data from dso to master 0Cust_sales same error again occured.

Please suggest....

[Former Member · Accepted solution]

Gurus

We are in similiar situation where it is complaining about ...

Diagnosis

value 1500110005/2013/003 for Chatracteristic ZXXX_XXX is to be written to Master data table /BIC/PZXXX .An error occured while doing this.

System response

Procedure

Check master data table . Note that , in addition to the primary Index , there can be another unique index in one of the master data table

I checked the P table and the value is there in P table. but when I try to load from DSO to cube we have this error coming again. We are on B 7.3

Please help

Thanks

KR

[Former Member · Accepted solution]

Hi,

     Delete complete data of p table and SID table and load data again...

Regards,

Vimal

[Former Member]

try to check and fix error in RSRV for your masterdata.

run test to Compare Char. Value in SID/P&Q table, if there is any error, fix it.

[Former Member]

Hi Vimal,

Check below things.

1) Check job for DTP, try to analyse error in it.

2) Check st22 short dumps if there are any.

3) Check sm21 for any OS level errors.

Parallel you can check values in Master data table which is already loaded and Division 10 value anything different in it like key values are blank.

Please reply and post whatever you see, this will help to understand the issue.

Regards,

[Former Member]

Hi Thanks for your reply..

I have checked all these thing but not getting any help from it.

I tried to load in ODS here it is successfully loaded, but when I got for master 0Cust_sales get error while executing DTP.

Till PSA no any issue occued.

In DTP Get

Updating attributes for InfoObject 0CUST_SALES : 258 -> 0 Data Records

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

From ST22..

Diagnosis

Value 10 for characteristic 0DIVISION is to be written to master

data table /BI0/PDIVISION. An error occurred while doing this.

System Response

Procedure

Check the master data table. Note that, in addition to the primary

index, there can be another unique index in one of the master data

tables.

Procedure for System Administration

Technical information about the message:

Message class....... "BRAIN"

Number.............. 290

Variable 1.......... 10

Variable 2.......... "0DIVISION"

Variable 3.......... "/BI0/PDIVISION"

Variable 4.......... " "

[Former Member]

Can you check in table /BI0/PDIVISION if there is already Division exists with Value 10.

Also check if there is any lock present for this table in sm12.

[Former Member]

Hi,

Yes for /BI0/PDIVISION value is present,

So Please suggest how to solve it.