After further testing it appears that this is a problem with the ODBC connection and its interaction with the SQL server.
Either the ODBC connection or the SQL server or the SQL job is going to sleep in some way part the way through the load. Once the task has frozen if we Test the ODBC...
We have a sequence of calls to a SQL server via ODBC that we use to poulate an OLAP server.
This generally works very well, however we occasionaly get part the way through the sequence and the OLAP server freezes. It is not the same part of the sequence each time.
There are many areas for us...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.