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

[ragosu66]

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?

[#2]

Hii Rafael;

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

[rajeshvaswani77]

Hi Rafael,

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

Thanks,

Rajesh Vaswani

[jagan]

Hi,

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

Regards,

jagan.

[ragosu66]

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 · Accepted solution]

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]

Dear Rajesh,

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

Regards,

DJ

[dhananjay_capge]

Dear Jagan,

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

Regards,

DJ

[kenji_khoo]

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]

did you find solution to this.