Feb-27-2020, 05:49 PM
Hi everyone,
I am running a forecasting code and am having a very weird issue.
My code is stored on a server and we have created a service account which takes the code and executes it.
This allows us to have the code launched automatically based on a scheduler.
My issue is now the following.
My code is failing when I am executing it using the service account and job scheduler.
I get an arithmetic overflow:
pyodbc.DataError: ('22003', '[22003] [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting float to data type numeric. (8115) (SQLExecDirectW); [22003] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (3621)')
Now this is normal given that apparently the number I am trying to upload is: 1.0753157419192108e+264
The thing is, if I take this exact code and run it but with my user account (throught the command terminal). I get no error message and this number:2.812633513
Does anyone know what could be the source of these two behaviors?
Again, the code is EXACTLY the same. I literally copy and pasted the same version of it.
I have no clue what is wrong :(
Would anyone be able to help?
Thanks!
Cheers
I am running a forecasting code and am having a very weird issue.
My code is stored on a server and we have created a service account which takes the code and executes it.
This allows us to have the code launched automatically based on a scheduler.
My issue is now the following.
My code is failing when I am executing it using the service account and job scheduler.
I get an arithmetic overflow:
pyodbc.DataError: ('22003', '[22003] [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting float to data type numeric. (8115) (SQLExecDirectW); [22003] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (3621)')
Now this is normal given that apparently the number I am trying to upload is: 1.0753157419192108e+264
The thing is, if I take this exact code and run it but with my user account (throught the command terminal). I get no error message and this number:2.812633513
Does anyone know what could be the source of these two behaviors?
Again, the code is EXACTLY the same. I literally copy and pasted the same version of it.
I have no clue what is wrong :(
Would anyone be able to help?
Thanks!
Cheers