Data Transfer Process Error (flatfile)

[former_member196865]

Hi Gurus,

I am new to BW (mainly work with bpc), but lately I have been exploring the BW side. I have an assignment where in I have to create an infoprovider that can be linked to BPC. In order to do this, I created characteristics, keyfigures and infocubes. The issue I have been getting is when I try to upload data into the cube. I have already created  a data store object, transformation, info package and DTP. When I start the infopackage, it says the data has been loaded with a green status, but when I try to execute the data transfer process, I am getting an error and the data is not showing up in the infocube. The screen grab shows the error.

I am new to this so please excuse me if I am not using the correct terminology. Let me know if you need anything else to analyze it further.

[ccc_ccc · Accepted solution]

Hi David,

Could you please check how data in PSA , all values are placed properly in respective infoobjects

or any error and also check escape char's used ( like , ; ")

And also check data types of infoobjects and data on it.

Please check above all.

Regards

Nanda

[former_member196865 · Accepted solution]

Hi Nanda,

Checked the PSA and there seems to be data which is not in the correct order.

Should I format the flatfile to suit the tables?

[ccc_ccc · Accepted solution]

Hi David,

Yes, you have to format accordingly your table and along with this you have do followings also.

1 Convert all characters to upper case (if your not checked "lower character" in infoobject in maintenance")

2 Use proper escape chars

Regards

Nanda

[shyamala_kalluri · Accepted solution]

Hi David,

Based on above PSA table  screenshot, under calendar day section  we will maintain only numeric but whereas it has non numeric (INR) , try to edit your flat file for that field and try to run the DTP.

Thanks,

shyamala valeti.