topic Re: Loading data from sharepoint file through QMC, failed with error: access is denied in QlikView

Loading data from sharepoint file through QMC, failed with error: access is denied

ragosu66 — Fri, 11 Oct 2013 22:31:36 GMT

Hi guys. We have installed Publisher Qvw11 SR2 in 64 bit edition.

I'm reading data from an excel file in sharepoint. Using information from other discussions, I connected and loaded the data in qvd files through qvw files without problem. But when I tried to load them in QMC reload calendar, them failed with error messages of "Access is denied" .

I verified the IE security configuration in Internet section and modified the trusted sites, but the problem did not was corrected. My UserID and QMC UserID have propietary profiles, then I supposed that they have complete security access.

Can somebody help me with this issue?

Re: Loading data from sharepoint file through QMC, failed with error: access is denied

Sat, 12 Oct 2013 00:46:40 GMT

Hii Rafael;

You should check if the User Qlikview running the service have access rights to the sharepoint.

Re: Loading data from sharepoint file through QMC, failed with error: access is denied

rajeshvaswani77 — Sat, 12 Oct 2013 03:05:21 GMT

Hi Rafael,

In SharePoint you need to grant permission to the QlikView Account.

Thanks,

Rajesh Vaswani

Re: Loading data from sharepoint file through QMC, failed with error: access is denied

jagan — Sat, 12 Oct 2013 10:49:07 GMT

Hi,

In Sharepoint give access to the qlikview user, and check. The user which you has no access in sharepoint.

Regards,

jagan.

Re: Loading data from sharepoint file through QMC, failed with error: access is denied

ragosu66 — Sun, 13 Oct 2013 15:44:45 GMT

First, I like to thank you for your fast answer.

When was designing the report, I verified the User IDs with Access the data in SharePoint, then the qvw report read SharePoint data without trouble.
I requested assign this security profile to User ID of QMC.

But when I reload this report through QMC, it abort. Reading the log, I only can detect the error "Access is Denied". I checked the security profile configuration used by QMC and have the same items than User Id of report designer.

Somebody know what other item verify to correct this issue?

Re: Loading data from sharepoint file through QMC, failed with error: access is denied

ragosu66 — Tue, 15 Oct 2013 23:39:55 GMT

Hi,

Joe Longoria provided the correct answer through discussion "Issue reloading documents via Publisher which reads data from sharepoint list" with the next lines:

"I had a similar issue. Created a document on my computer that referenced a file via URL from sharepoint. Worked fine on my computer, but would not load on QV server via scheduled load.

I logged on to the QV server as the login used to run the QV services. I opened up IE and added the sharepoint site as a local intranet site in the "Sites" setting under IE-->Tools-->Security-->Local Intranet-->Sites.

There may be an easier way to resolve this, but the above worked for me."

It works fine in reload through QMC.

Re: Loading data from sharepoint file through QMC, failed with error: access is denied

dhananjay_capge — Tue, 24 Mar 2015 05:37:55 GMT

Dear Rajesh,

Can you give me steps to follow to grant this access ?

Regards,

Re: Loading data from sharepoint file through QMC, failed with error: access is denied

dhananjay_capge — Tue, 24 Mar 2015 05:38:52 GMT

Dear Jagan,

Can you give me steps to follow to grant this access ?

Regards,

Re: Loading data from sharepoint file through QMC, failed with error: access is denied

kenji_khoo — Thu, 29 Mar 2018 02:20:26 GMT

Hi,

I still get failed in QMC although i insert sites in Local Intranet.

The script as below. Kindly advice.

let vPath = '\\xxxxxxxxxx.sharepoint.com@SSL\DavWWWRoot\BIData\Shared Documents';

DO while vCheck=0

LET vFileSize=filesize('$(vPath)/Country/*.txt');

trace $(vFileSize);

IF vFileSize>0 then

trace 'success';

exit script;

ELSE

//**Explaination throw an error, qlik task will stop

LOAD B;

LOAD * Inline [

Col1

];

ENDIF

LOOP;

let vCheck=0;

Re: Loading data from sharepoint file through QMC, failed with error: access is denied

manojciti — Mon, 30 May 2022 08:44:05 GMT

did you find solution to this.