2683 Numeric Overflow occurred during computation-MultiLoad

General
Enthusiast

2683 Numeric Overflow occurred during computation-MultiLoad

Hi Gurus
Iam trying to update a small table using multiload...
I got an error 2683 numeric overflow occurred during computation.

the column data type is decimal (8,2) and the data in the file is 130000.00

any help please

Thanks
3 REPLIES
Enthusiast

Re: 2683 Numeric Overflow occurred during computation-MultiLoad

999999.99 is the maximum number held by decimal (8,2).

Please check if the result of your comptation is exceeding.

Re: 2683 Numeric Overflow occurred during computation-MultiLoad

Possibilites:
1,
Is there any aggregation / calculation happening while inserting / updating the data which can cause the numeric overflow

Need more information:
2, How many rows/colums/records are there in the table?
Enthusiast

Re: 2683 Numeric Overflow occurred during computation-MultiLoad

suma..

its not exceeding 999999.99 the data value is less than this...

madrockster...

there is no aggregation/caliculation and I am trying to update 1 column and 21 rows in 12 column 21 rows table

Thanks