DATA LOAD ERROR

[Former Member]

Hi

I am loading data from Application Server to DSO.

I am getting the below error

+Error 'Overflow converting from '32771'' on assignment field ID record 280 value 32771+

I checked the data in application server and also checked the field ID.everything looks ok

Can anyone help me on this?

Thanks

[Former Member]

Hi Meenakshi,

are you able to load this data into PSA without error?

Is the PSA value same as that of one that is shown in application server?

Thanks.

[Former Member]

Hi,

The Particular value in the field ID is not even visible in PSA.

Thanks

[Former Member]

Please find out the data type and length of this field at the source.

I suggest you download the file into .csv file and keeping only this erroneous record, try to load the file.

with some trial and error, you might be able to identify what is wrong with this field.

Thanks.

[Former Member]

Hi Meenakshi,

It might be that your KeyFigure Exceed the limit.

Change the data type to Float probably it will helps.

Regards

Ranganath

Edited by: Ranganath on Jul 4, 2011 1:11 PM

[Former Member]

Hi,

Thanks for your reply

The Field is actually a datafield in the ODS and the data type is CHAR 5. Since this is an ODS there is no Key figures.

Any thing other than this needs to be checked.

Thanks

[Former Member]

Hi Meenakshi,

ODS contains keyFields and DatafIelds.

Here DataFiels could be either Charecteristic or Keyfigure.

KeyFields could be only Charecteritics.

Coming to the point You just make sure the field id values is not exceeding the limit Char 5 in your case.

Defenitely its Length and Data Type issue.Bcoz I came across this error long time ago.

Either increase it length /Changing data type will solve the issue.

Regards

Ranganath

Edited by: Ranganath on Jul 4, 2011 3:01 PM

[Former Member]

Hi,

I tried loading two datas(one erraneous) as CSV file. First time the erraneous record got failled. I tried removing the ID value of the erraneous record. Then it was succesfully loaded in the PSA.

The length is 5 and data type is NUMC. The value is 32771.

Thanks

[Former Member]

Hi Meenakshi,

Please find out whether there is any conversion routine set for this field, while loading the DSO.

By removing the conversion, you would be able to load the value as it is.

Thanks.