topic Re: Reload fails in QMC in QlikView

Reload fails in QMC

Mon, 02 Feb 2015 05:04:05 GMT

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

Re: Reload fails in QMC

prma7799 — Mon, 02 Feb 2015 05:05:29 GMT

Hi,

Check OLEDB connection.

Re: Reload fails in QMC

Mon, 02 Feb 2015 05:08:35 GMT

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.

Re: Reload fails in QMC

jonathandienst — Mon, 02 Feb 2015 05:26:33 GMT

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

HTH

Jonathan

Re: Reload fails in QMC

Mon, 02 Feb 2015 05:31:04 GMT

Hi Jonathan,

Can you please suggest how to provide database access for Server

Re: Reload fails in QMC

sandeepprasad_j — Mon, 02 Feb 2015 05:37:22 GMT

Try to check Force 32 bit in the Scripting Box

Hope it helps

Cheers

Sandeep.

Re: Reload fails in QMC

Mon, 02 Feb 2015 05:40:25 GMT

Hi Sandeep,

Force 32 bit in the Scripting Box is checked only.

Re: Reload fails in QMC

jonathandienst — Mon, 02 Feb 2015 06:02:06 GMT

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

Re: Reload fails in QMC

avinashelite — Mon, 02 Feb 2015 07:58:30 GMT

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

Peter_Cammaert — Mon, 02 Feb 2015 08:33:42 GMT

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.

Re: Reload fails in QMC

Mon, 02 Feb 2015 09:43:11 GMT

Hi Avinash,

Thanks for your reply..

Yeah, we are using Section access in .qvw

Could you please brief the steps where to add service account as admin.

Re: Reload fails in QMC

avinashelite — Mon, 02 Feb 2015 09:51:57 GMT

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

Re: Reload fails in QMC

Peter_Cammaert — Mon, 02 Feb 2015 09:51:57 GMT

The batch reload process is able to open your document and start script execution. So it's not Section Access that is causing an error.

See my post below.