Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mandilicious
New Contributor III

Reload working Manually but failed in my QMC

Hi All

I have bit of situation my dashboard is working when i reload manually but it keep failing in QMC.

I have checked but am struggling to find an error.

Thanks

1 Solution

Accepted Solutions

Re: Reload working Manually but failed in my QMC

There you have it.

The main difference - account-wise - between reloading a document in QV Desktop and doing the same from a task defined in the QMC, is that the server doesn't use your credentials. It uses the account that runs the QlikView services to authenticate. Your services run as ROMANS\QVService and apparently, this user has nog login in your SQL server DB. Meaning no access.

There are basically two quick solutions:

  • either let your dba create a login in your SQL server DB for ROMANS\QVService with ReadOnly access to whatever you need to extract,
  • or use Section Access fields to temporarily run the reload as another user. You for example. In the QMC, see the Section Acces fields on the Reload tab of the document (if you don't use a Publisher) or in the task attached to the Source document. Enter your domain\accountname and password in the two fields, click Apply and try reloading again.

Best,

Peter

14 Replies
kennethmash
New Contributor III

Re: Reload working Manually but failed in my QMC

Hi

I can't tell what the error is but have you tried to recreate the task? Might be a way around the problem. There also seems to be an issue with your alert emails. Are the email addresses separated correctly i.e are the semi colons in the right place between the email addresses.

shiveshsingh
Honored Contributor

Re: Reload working Manually but failed in my QMC

An invalid character was found in the mail header: ';'.

Can you re-verify it in QMC task where you put user ids for alert mail?

Re: Reload working Manually but failed in my QMC

Please post this file from your QlikView server:

C:\ProgramData\QlikTech\DistributionService\1\Log\20180213\100000 - Deploy_Neo_Final Neo Qlikview Dashboard.qvw\DocumentLog.txt

If you don't feel like posting your entire script in a public forum, open the file in a text editor and scroll down to the end. Do you see any error messages?

MVP
MVP

Re: Reload working Manually but failed in my QMC

If you are using section access, is the service account added with ADMIN access? (you can check the account in the server > Windows button > Run > services.msc)

Was the document open already while the DSC was running the distribution?

mandilicious
New Contributor III

Re: Reload working Manually but failed in my QMC

Hi Peter

Attached please help can the problem be ODBC SQL Server Driver even everything connect successfully and it can run manually but fail in QMC?

Thank

MVP
MVP

Re: Reload working Manually but failed in my QMC

As I mentioned below, the credentials for the user ROMANS\QVSERVICE are not valid or lack permissions to connect to the specified DSN. You need to add the service account to the users allowed to read from the database.

stabben23
Honored Contributor

Re: Reload working Manually but failed in my QMC

Hi,

is ROMANS\QVService a valid Reader in Your SQL Database?

Re: Reload working Manually but failed in my QMC

There you have it.

The main difference - account-wise - between reloading a document in QV Desktop and doing the same from a task defined in the QMC, is that the server doesn't use your credentials. It uses the account that runs the QlikView services to authenticate. Your services run as ROMANS\QVService and apparently, this user has nog login in your SQL server DB. Meaning no access.

There are basically two quick solutions:

  • either let your dba create a login in your SQL server DB for ROMANS\QVService with ReadOnly access to whatever you need to extract,
  • or use Section Access fields to temporarily run the reload as another user. You for example. In the QMC, see the Section Acces fields on the Reload tab of the document (if you don't use a Publisher) or in the task attached to the Source document. Enter your domain\accountname and password in the two fields, click Apply and try reloading again.

Best,

Peter

ali_hijazi
Honored Contributor

Re: Reload working Manually but failed in my QMC

When you create an ODBC connection, use the System DSN tab instead of User DSN