Home > IT Answers > Microsoft Windows > SQL Error
Jimdab
0 pts.
 SQL Error
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
When attempting to upload a file to SQL Server, we receive this error:Arthimetic overflow error converting expression to data type int OnProject is the colaboration tool that is running on SQL. This error appears no matter what size file we try to upload.

Software/Hardware used:
ASKED: March 30, 2007  10:40 AM
UPDATED: March 30, 2007  11:48 AM
RELATED QUESTIONS
Answer Wiki:
It has nothing to do with the file size. Look at the data being imported - there is a field being converted to an integer data type which causing the problem. Since an integer is defined as whole number data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647), it's likely that character data is being inserted.
Last Wiki Answer Submitted:  March 30, 2007  10:59 am  by  PurpleLady   0 pts.
All Answer Wiki Contributors:  PurpleLady   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

That’s the cause. Here are the solutions:

If the data is in error, fix the data.

If the data is correct, redefine the field. In DB2, your best bet is DECIMAL, somewhere between DECIMAL(10) and DECIMAL(31), depending on the size of your data. In other DBMS dialects, use NUMBER(10) or larger.
—
Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
800-315-1174 (+1-949-552-1904)

SheldonLinker
 15 pts.