Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Check OLEDB connection.
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.
HI
Most likely cause is that the service account under which publisher/server is running does not have access to the database.
HTH
Jonathan
Hi Jonathan,
Can you please suggest how to provide database access for Server
Try to check Force 32 bit in the Scripting Box
Hope it helps
Cheers
Sandeep.
Hi Sandeep,
Force 32 bit in the Scripting Box is checked only.
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
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
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.