SQL Task System.OverflowException errors - VisualCron - Forum

Community forum

ubuser
2020-10-13T18:26:40Z
VisualCron v9.4, Oracle OBDC system DSN connection. If I try to run a simple query with standard output in it always results in this error:

Exception in Task: System.OverflowException: Arithmetic operation resulted in an overflow.
at VisualCronService.SQLAPI.RunODBCQuery(TaskProcessClass tpc, Boolean& Active, ConnectionClass cc, Boolean bolSplitCommands, String strConnectionString, Int32 intCommandTimeout, CommandType ct, Boolean IsStoredProcedureJob, String strCommand, List`1 lstParameters, StringBuilder& sbSTDOutput, StringBuilder& stdError, VariableReplacerClass VR, Boolean bolDebugging, JobClass Job, TaskClass Task, TriggerClass Trigger, OdbcCommand& Cmd, TaskSQLOutputSettingsClass output) in C:\git\code\VisualCronService\Jobs\TaskProcesses\Database\SQL\apiSQL.vb:line 2813
at VisualCronService.ProcessTaskSQLClass.Run() in C:\git\code\VisualCronService\Jobs\TaskProcesses\Database\clsProcessTaskSQL.vb:line 99

I've tried two different Oracle databases with a simple select query and I get the same error. Is there some guidance on how to resolve.

Thanks.
Support
2020-10-14T20:54:54Z
Please export the Job and send to support@visualcron.com.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top