I am facing a weird problem, When ever 2 applications which is connected to database are reloaded the task is failed. But when the same is reloaded manually Its reloading without any error
When the task is failed in the document log I am able to see the below error.
2016-09-29 11:10:46 0032 OLEDB*CONNECT*Provider*OLEDB*XPassword*
2016-09-29 11:10:47 Error: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered
2016-09-29 11:10:47 General Script Error
2016-09-29 11:10:47 Execution Failed
2016-09-29 11:10:47 Execution finished.
If it manually worked and not per task than is the reason probably the user-rights (the task will probably run with a different user) or that the sense-server will be blocked from the database or within the network (quite often is everything blocked unless it's explicitely allowed).
I remember a similar case but not if there was a real solution after all. I think the measures was to include a sleep-statement and to disconnect the connection after the first load and then reconnect again.
Are you closing the connection
I know it's optional but maybe would be worthwhile to do a:
You also mentioned that ODBC connection is not working could you elaborate on this? (Just want to learn as well)