MS SQL Server - SQLSTATE 2203 Error 8115

Author

SQLSTATE 2203 Error 8115

D''Animal

2005-08-25, 1:23 pm

Hi,

I have this job that runs sometimes it completes successfully, sometimes it
fails.
When it fails it gives this error message -->
-----
Executed as user: sqlagent. Arithmetic overflow error converting expression
to data type int.
[SQLSTATE 22003] (Error 8115) The statement has been terminated. [SQLSTATE
01000] (Error 3621).
The step failed.
-------
When I did the research on all the codes in the error looks like one of the
statements such as -->
SELECT ABS(convert(int, -2147483648))
is causing the problem. The problem I am having is that stored procedure
that runs has many 'converts' and I do not know which one is causing the
problem. Can I setup some kind of monitor that will catch exact cause or
declared 'int' that it is unable to convert to "int"?
How should I go about it?
Thanks

-D

D''Animal

2005-08-25, 8:23 pm

How do I setup job monitor?
-D

"D''Animal" wrote:

> Hi,
>
> I have this job that runs sometimes it completes successfully, sometimes it
> fails.
> When it fails it gives this error message -->
> -----
> Executed as user: sqlagent. Arithmetic overflow error converting expression
> to data type int.
> [SQLSTATE 22003] (Error 8115) The statement has been terminated. [SQLSTATE
> 01000] (Error 3621).
> The step failed.
> -------
> When I did the research on all the codes in the error looks like one of the
> statements such as -->
> SELECT ABS(convert(int, -2147483648))
> is causing the problem. The problem I am having is that stored procedure
> that runs has many 'converts' and I do not know which one is causing the
> problem. Can I setup some kind of monitor that will catch exact cause or
> declared 'int' that it is unable to convert to "int"?
> How should I go about it?
> Thanks
>
> -D

Sponsored Links