cancel
Showing results for 
Search instead for 
Did you mean: 

overflow error while loading from flat file to PSA

Former Member
0 Kudos

Hello,

i have created one generic data source to upload the data from flat file. In the data source, i have defined the following field

Tquantity of data type : QUAN ,length = 7 and decimals = 2, external length = 9 and format = Internal.

However, when i am loading record with quantity = '261450' , the system is throwing up the error " overflow converting from '261450' when assigning application structure'.

Any idea why the system is throwing up this record, even the length of the value passed is only 6 digits.

Regds,

BW small

Accepted Solutions (1)

Accepted Solutions (1)

ravindra_tumuluri
Contributor
0 Kudos

Hi,

Change the field length in Data source to 8,2. This will solve your problem of overflowing error.

Regds,

Ravi

Former Member
0 Kudos

Thanks a lot Ravi. I have changed the datasource field length as suggested. It solved my problem.

Former Member
0 Kudos

Hi,

Even I am facing the similar problem, what is the logic behind calculating the Field length and precision ?

Answers (2)

Answers (2)

Former Member
0 Kudos

I faced a similar problem in BW 7.31. I traced the problem to "data type" settings in the datasource. I was able to resolve the issue by changing the value from "INT2" to "INT4" for the problem field.

former_member312442
Discoverer
0 Kudos

I got the same problem. After Change the value from "INT2" to "INT4", it works! Thanks Mohammad!

Former Member
0 Kudos

Hi,

Change the format of quantity in the flatfile as number.

it might be in text format.

open the file in ewcel, right click on the value and change the format to number.

If the format is number, try changing it to text and preceed this with 000.

Hope this helps,

Sri...

Former Member
0 Kudos

Hi Sri,

The source file is a csv file qith 16 million records. i can not open in excel.

but any idea, why the system is not accpeting only this reocrd, when all other records went through successfully ?

BW small

Former Member
0 Kudos

Hi,

I guess this mightr be the first record.

But for debugging, we need to struggle a bit.

split this file in to two so that you wlll be able to open with excel2007.

You can select the entire row of quantity and change the format atonce.

Hope this helps,

Srinath.