topic Re: Reload working Manually but failed in my QMC in QlikView

Reload working Manually but failed in my QMC

mandilicious — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Reload working Manually but failed in my QMC

kennethmash — Tue, 13 Feb 2018 09:06:17 GMT

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.

Re: Reload working Manually but failed in my QMC

shiveshsingh — Tue, 13 Feb 2018 10:13:15 GMT

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

Peter_Cammaert — Tue, 13 Feb 2018 10:26:32 GMT

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?

Re: Reload working Manually but failed in my QMC

Miguel_Angel_Baeyens — Tue, 13 Feb 2018 10:32:20 GMT

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?

Re: Reload working Manually but failed in my QMC

mandilicious — Tue, 13 Feb 2018 11:00:09 GMT

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

Re: Reload working Manually but failed in my QMC

Miguel_Angel_Baeyens — Tue, 13 Feb 2018 11:04:05 GMT

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.

Re: Reload working Manually but failed in my QMC

stabben23 — Tue, 13 Feb 2018 11:04:54 GMT

Hi,

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

Re: Reload working Manually but failed in my QMC

Peter_Cammaert — Tue, 13 Feb 2018 11:08:05 GMT

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

Re: Reload working Manually but failed in my QMC

ali_hijazi — Tue, 13 Feb 2018 11:12:24 GMT

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

Re: Reload working Manually but failed in my QMC

mandilicious — Wed, 14 Feb 2018 09:07:47 GMT

Hi Peter

Quick one with your two quick solutions

1) Dba created BPS-REPORTS\QVService as a login detail instate of THE-ROMANS\QVService. if may ask is it a way i can change this manually in my QMC or they need to create THE-ROMANS\QVService as it is?

2)As for me to use Section Access fields to temporarily run the reload as another user, i tried to reload but it keeps failing

I tried below login details and tried Username: .\QVService with password they gave me.

Re: Reload working Manually but failed in my QMC

mandilicious — Wed, 14 Feb 2018 09:43:03 GMT

Hi Angel

I am not using section access,i thought it was open but even after closing everything it still not working?

Thanks

Re: Reload working Manually but failed in my QMC

mandilicious — Wed, 14 Feb 2018 09:47:40 GMT

Hi Ali

I have tested both System and User DSN they connect successfully

Thanks

Re: Reload working Manually but failed in my QMC

mandilicious — Wed, 14 Feb 2018 09:51:30 GMT

Hi Staffan

Actually it was not but they gave me new username:BPS-REPORTS\QVService instate of ROMANS\QVService?

which I am little bit confused cause my dashboard complain about ROMANS\QVService not that one?

Re: Reload working Manually but failed in my QMC

stabben23 — Wed, 14 Feb 2018 10:35:10 GMT

Hi,

If you have create a New OBDC Connection With correct New user (BPS-REPORTS\QVService) . Then Create a New Connection string in Your qvw-Application script.