Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
ragosu66
Contributor III
Contributor III

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

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?

1 Solution

Accepted Solutions
ragosu66
Contributor III
Contributor III
Author

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.

View solution in original post

9 Replies
Not applicable

Hii Rafael;

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

rajeshvaswani77
Specialist III
Specialist III

Hi Rafael,

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

Thanks,

Rajesh Vaswani

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

jagan.

ragosu66
Contributor III
Contributor III
Author

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?

ragosu66
Contributor III
Contributor III
Author

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.

dhananjay_capge
Partner - Contributor III
Partner - Contributor III

Dear Rajesh,

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

Regards,

DJ

dhananjay_capge
Partner - Contributor III
Partner - Contributor III

Dear Jagan,

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

Regards,

DJ

kenji_khoo
Partner - Contributor
Partner - Contributor

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

A

B

];

ENDIF

LOOP;

let vCheck=0;

manojciti
Contributor III
Contributor III

did you find solution to this.