none
Problem with two jobs affiliated with a sql script

    Question

  • Hello --

    I am testing a script called dbWarden on our 2008R2 standard server. The URL for the script in question is the following:

    http://sourceforge.net/projects/dbwarden/

    I have executed the script, and it appears to have successfully completed its installation. There is a database as well as several created the jobs. The problem that I am having is that two of the jobs: dba_CheckFiles and dba_HealthReport fail when they are run. The error message that I am getting in both cases is the following:

    Executed as user: NT AUTHORITY\NETWORK SERVICE. 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.

    Has anyone seen this message, know what it means, and what can be done to correct it?

    Thanks.

    Thursday, April 18, 2013 12:40 PM

Answers

  • Check what the jobs are doing in the job steps. If they are executing any sql statements or stored procedures then analyse them. Check the tables involved uin the sql statements and Check the target column size for each column for the table where the value is computed by a formula. Consider either expanding the size of the target column or reducing the allowable values in the formula's source columns.

    msdn.microsoft.com/en-us/library/ms1633a63(v=sql.105).aspx


    Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.

    Thursday, April 18, 2013 1:02 PM
  • Executed as user: NT AUTHORITY\NETWORK SERVICE. 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.

    Hi Kaplan,

    An arithmetic overflow is caused by a calculated column value that exceeds the column's specified size. When this error occurs, the calculation stops and the remainder of the results pane is not filled.

    To correct this error: Check the target column size for each column where the value is computed by a formula. Consider either expanding the size of the target column or reducing the allowable values in the formula's source columns.

    For more information, please refer to http://msdn.microsoft.com/en-us/library/ms163363(v=SQL.105).aspx.

    Thanks.

    If you have any feedback on our support, please click here.


    Maggie Luo
    TechNet Community Support

    Friday, April 19, 2013 9:05 AM
    Moderator
  • Hello --

    I contacted the developer of the script, and he with a colleague added an additional proc value to the script. That along with reconfiguring the public profile allowed the scripts in question to work.

    Thanks to everyone for the help.

    Tuesday, April 23, 2013 4:52 PM

All replies

  • Check what the jobs are doing in the job steps. If they are executing any sql statements or stored procedures then analyse them. Check the tables involved uin the sql statements and Check the target column size for each column for the table where the value is computed by a formula. Consider either expanding the size of the target column or reducing the allowable values in the formula's source columns.

    msdn.microsoft.com/en-us/library/ms1633a63(v=sql.105).aspx


    Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.

    Thursday, April 18, 2013 1:02 PM
  • On the website, under tickets, you can log a ticket to ask for the developers to fix the issue.

    Thursday, April 18, 2013 8:48 PM
    Moderator
  • Executed as user: NT AUTHORITY\NETWORK SERVICE. 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.

    Hi Kaplan,

    An arithmetic overflow is caused by a calculated column value that exceeds the column's specified size. When this error occurs, the calculation stops and the remainder of the results pane is not filled.

    To correct this error: Check the target column size for each column where the value is computed by a formula. Consider either expanding the size of the target column or reducing the allowable values in the formula's source columns.

    For more information, please refer to http://msdn.microsoft.com/en-us/library/ms163363(v=SQL.105).aspx.

    Thanks.

    If you have any feedback on our support, please click here.


    Maggie Luo
    TechNet Community Support

    Friday, April 19, 2013 9:05 AM
    Moderator
  • Hello --

    I contacted the developer of the script, and he with a colleague added an additional proc value to the script. That along with reconfiguring the public profile allowed the scripts in question to work.

    Thanks to everyone for the help.

    Tuesday, April 23, 2013 4:52 PM