Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Automatic reload issue

Good afternoon,
we are working on a reorganization of some previously created Qlik documents. Until now, the loading was done via a batch running the reload via command line on a virtual machine.
Now we want to transfer everything on the server to manage uploads directly from there. Here is the problem.
In fact, for these documents Qlik load data from some Acces database with multiple links to other access database.
If you run the reload manually by classic Qlik desktop client installed on the server, everything works great.
The moment you try to execute the automatic reload by the server, it faults. The log says it can not open one of the db linked to the db that is directly opened by Qlik. The permissions of all files are correct for the user of the Distribution Service (in fact I even tried to do a reload manually using just the same user of the service and everything works). The addresses are all written in UNC format, and there are no mapped drives. We used ODBC 32 bit connection because the server is 64 bit against 32 bit of access db.
So I ask myself if it is a problem of distribution service that fails to open db connected to other db (although loading another query that takes data from another connected db, it works fine).

Can anyone help me?

Thank you

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Automatic reload issue

Then,

we found the problem. It was a server problem so the linked to active directory. The distribution service doesn't recognize autorizathion for the service account. We had to reboot the server to solve the issue.

7 Replies
agni_gold
Valued Contributor II

Re: Automatic reload issue

Is service account has access to access DB ?

hirishv7
Honored Contributor

Re: Automatic reload issue

Hi,

Check this way,

Is your QMC Distribution service installed on same machine where the QVW's are hosted?

How to Distribute Reports after Successful .qvw Reload on a QlikView Server with Publisher

The Versions of client and server also should be same.

HTH,

Hirish

Not applicable

Re: Automatic reload issue

‌yes, the service account has access to the ms access db infact when the reload runs it open some queryes with succes but when it arrives to a query that works on a connected query it crashes.

Not applicable

Re: Automatic reload issue

‌Hi,

we don't have the publisher server. The QMC is on the same machine where are QVW files.

Not applicable

Re: Automatic reload issue

another problem is that if we use the MS access database in a network path the reload task goes in error tring to open it with this message in the log file: "Impossible to open the 'unknokn' file".

THe path us accessible for the distributin service account.

For us both these issues are a very big problem. First I'm trying to understand the issue with connected tables and then I would like to understand the why of network error

Not applicable

Re: Automatic reload issue

Then,

we found the problem. It was a server problem so the linked to active directory. The distribution service doesn't recognize autorizathion for the service account. We had to reboot the server to solve the issue.

swiftfahad
New Contributor

Re: Automatic reload issue

sir I want to know how you have configured your server I want to do the same plz help . can you provide me ur email so I can contact you .. your cal also see my post Auto Reload from qvd's

so you can understand what I want

Community Browser