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.

[RamanKorrapati]

Hi David,

if you see your PSA data , You may find the difference.

please check your flat file columns and arrange them as it easy of data source fields structure.

later try to see the preview at data source level and later load into psa.

Thanks.

[Former Member]

Hi David,

Please check if the sequence of the fields defined in your Data source and the Flat file are same.

I am assuming there is a disconnect.

Thanks,

Murugnand.K

[Pravender]

- Looks like you have a Numeric filed in your infocube and  you are trying to update non-numeric/text data to it. Please check transformation mapping and map with correct field types.

- Or if you are getting non-numeric data for a numeric field, you need to change it in PSA and then load.

Please check with anyone in your team.

Pravender