topic Re: Reload Failed in QlikView

Reload Failed

Muthu — Fri, 07 Oct 2016 04:07:20 GMT

Hi,

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.

Re: Reload Failed

sushil353 — Fri, 07 Oct 2016 04:21:26 GMT

Hi,

Try connecting with ODBC driver..

HTH

Re: Reload Failed

Muthu — Fri, 07 Oct 2016 05:10:02 GMT

ODBC Connection is not working

Re: Reload Failed

marcus_sommer — Fri, 07 Oct 2016 05:20:01 GMT

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).

- Marcus

Re: Reload Failed

stabben23 — Fri, 07 Oct 2016 05:21:45 GMT

Hi,

Do you mean when you reload it from Publisher/server it fails? if so, have a look if you have install OLEDB Connection on the server where you have Your qmc.

Re: Reload Failed

Muthu — Fri, 07 Oct 2016 05:23:46 GMT

In the qmc also when I am reloading one task it works, Issue happens only when 2 apps are reloaded

Re: Reload Failed

marcus_sommer — Fri, 07 Oct 2016 05:27:27 GMT

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.

- Marcus

Re: Reload Failed

Anonymous — Fri, 07 Oct 2016 05:33:15 GMT

Are you closing the connection

I know it's optional but maybe would be worthwhile to do a:

Disconnect;

You also mentioned that ODBC connection is not working could you elaborate on this? (Just want to learn as well)

Thanks

David