on 09-28-2009 4:23 AM
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
Hi,
Change the field length in Data source to 8,2. This will solve your problem of overflowing error.
Regds,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.