datasource 3.x issue

[Former Member]

Hello Gurus

I am having the following issue please help..

I am executing an infopackage for 0bparter_attr  from CRM i get this issue

Record 566 :Contents 10101000000 99 from field VALID_FROM cannot be converted in type DEC

[former_member182470 · Accepted solution]

HI,

Please edit the record No:566 in PSA and save it.

Come back to monitor and right click on the red status of the datapackage-->Manual Processing

Then your load will continue from the struck stage..

[Former Member · Accepted solution]

Thanks for replying.

Actually the error package is not getting loaded to PSA to manually edit the record.

[RamanKorrapati · Accepted solution]

Hi,

At ecc side go to RSA3, enter the valid from value as 10101000000 at selection, execute it. you may find respective record details.thru that you will know 0BPARTNER, once you know 0bpartner, seek crm team help and ask them edit valid from value. once the correction was done, delete request at PSA and reload data from source team.

Thanks

[Former Member · Accepted solution]

Thank you for replying.

Actually we are pulling directly from CRM to BW.

In CRM at rsa3 tcode

i dont have any option to enter valid from value.

I am new to SAP,Correct me if i am missing something.

[RamanKorrapati · Accepted solution]

Hi venmani,

To find out the wrong record, at RSA3, execute and down load whole load data into Excel sheet(seems like you may medium size data), in that you may see Valid from and Valid date too. there you can find valid form - 10101000000, thru that you will find respective bpartner value. once you know partner value, take crm team help and do the correction. after the correct recheck at RSA3, if values are coming as expected way, then reload to bw too.

On excel use filters on column "valid from" you will find easily.

or ask CRM team check wrong "valid date from" was lied in base tables of 0BPARTNER_ATTR data source.

Thanks

[Former Member]

see this link:

http://scn.sap.com/thread/1814956

[Former Member]

Venmani,

Work with ECC team to correct the records so that it comes into BW in the correct format.

For a more immediate solution, filter out records that have the wrong format in the infopackage selection. This should allow your data to move into the data targets.

[Former Member]

hello

the field valid from is of date type and you are loading decimal value 1110000 in to it hence it is throwing error .please check the data in source replace number with date.That will solve your problem.

Thanks

Jacko

[Former Member]

Can you please explain briefly..

Regards

Venmani