Solved: Re: Reload fails in QMC - Qlik Community

Report Inappropriate Content · ‎2015-02-02

Hi,

When I am executing .qvw from desktop working fine. But, when it is running on QMC throwing error as reload failed.

Log file showing

02-02-2015 10:20:14 AM:	Error: OLEDB connection failed
02-02-2015 10:20:14 AM:	General Script Error
02-02-2015 10:20:14 AM:	Execution Failed
02-02-2015 10:20:14 AM:	Execution finished.

Here by I have attached logfile

Any one please help me on this

avinashelite · ‎2015-02-02

Hi Saranya,

you can do it 2 ways:

1.In QMC go to the Task which you have created and go to reload tab >here you will see the section access option ,please select this check box and provide the service account user name and passwords if any.

2.In the QV script add a inline table with your other access table in the section access as below:

section access:

load * inline

[

ACCESS,NTNAME

ADMIN,SERVICEACCOUNT

];

since its giving error with OLEDB please check with the connection string also once , try to create a fresh connection

hope this helps you

View solution in original post

prma7799 · ‎2015-02-02

Hi,

Check OLEDB connection.

Report Inappropriate Content · ‎2015-02-02

Hi,

thanks for your reply

OLEDB path is correct, it is working fine when I am reloading it on desktop. Same thing when I am trying to reload it on QMC reload fails.

jonathandienst · ‎2015-02-02

HI

Most likely cause is that the service account under which publisher/server is running does not have access to the database.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Report Inappropriate Content · ‎2015-02-02

Hi Jonathan,

Can you please suggest how to provide database access for Server

sandeepprasad_j · ‎2015-02-02

Try to check Force 32 bit in the Scripting Box

Hope it helps

Cheers

Sandeep.

Report Inappropriate Content · ‎2015-02-02

Hi Sandeep,

Force 32 bit in the Scripting Box is checked only.

jonathandienst · ‎2015-02-02

Saranya Arumugam wrote:

Hi Jonathan,

Can you please suggest how to provide database access for Server

I can't really help you with that. I suggest that you contact your system administrator or database administrator for access.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

avinashelite · ‎2015-02-02

Hi

Are you using section access?? if so contact your QV admin and get the service account details.

And then add this service account as admin in the section access

Peter_Cammaert · ‎2015-02-02

In QMC, use the Section Access username and password fields to change the account under which the reload is being performed to the one that has access to the Database.

Or - as was suggested before - grant the service account access to the DB.