Error in SQL Query - VisualCron - Forum

Community forum

LEikelman
2016-02-10T02:01:00Z
We have a SQL task in VisualCron that has been running for a while with no issues. We are suddenly starting to see the following errors in the SQL task(s):

Error in SQL query:

Exception in Task: System.Exception: System.Data.Odbc.OdbcException (0x80131937)
at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.NFMCAMDOGBCBCKKAEOJICMPGMOLBJPKAAHOI.HJFIADPLOHNMCEFCBBMALDJFPNMAJJBMIBPA(TaskProcessClass , ConnectionClass , Boolean , String , Int32 , CommandType , Boolean , String , List`1 lstParameters, StringBuilder& , StringBuilder& , VariableReplacerClass , JobClass , TaskClass , TriggerClass , OdbcCommand& , TaskSQLOutputSettingsClass )
at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.GKHJKBDAJKKLOCDAGMDEFBPILHJMKGOIPBBJ.Run()

We are on version 7.2.1 build 15243.

I've verified that the SQL connection is connecting successfully (via the "test connection" in VisualCron). I've verified that we are getting the same error in numerous other SQL task(s). Can someone please assist with identifying why we are suddenly seeing this error?
Support
2016-02-10T08:22:08Z
If you search on the error code it seems like a timeout problem (query running for too long):

https://social.msdn.micr...out?forum=databasedesign 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top