Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Reload fails in QMC

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

1 Solution

Accepted Solutions

Re: Reload fails in QMC

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

12 Replies
prma7799
Honored Contributor III

Re: Reload fails in QMC

Hi,

Check OLEDB connection.

Not applicable

Re: Reload fails in QMC

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.

MVP
MVP

Re: Reload fails in QMC

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
Not applicable

Re: Reload fails in QMC

Hi Jonathan,

Can you please suggest how to provide  database access  for Server

sandeepprasad_j
Contributor

Re: Reload fails in QMC

Try to check Force 32 bit in the Scripting Box

Hope it helps

Cheers

Sandeep.

Not applicable

Re: Reload fails in QMC

Hi Sandeep,

Force 32 bit in the Scripting Box  is checked only.

MVP
MVP

Re: Reload fails in QMC

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

Re: Reload fails in QMC

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

Re: Reload fails in QMC

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.