Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

SharePoint reload fails

Dear all,

I have a strange issue with reload of sharepoint on QV server (desktop works fine):

- I link to an xml file >>> https://sp.XXX.com/KAM/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={c7ee32ec-3c7d-4d2b-b7b8-62ff5b5655e2}

- The sharepoint site is part of the intranet (also in the IE settings) and logon method "automatic logon with current username and password" is used.

- The link works fine in IE when I'm logged in on the QV server with the same QV User that is running the QV services !

- However, reloading the QV app itself is NOT working >>> Access Denied (download failed). There are no other specifications of the error.

Any thoughts on what the difference is between QV app & using the same link directly in IE (with the same user on the QV Server)??

Regards,
Marcel

Tags (1)
15 Replies
buzzy996
Honored Contributor II

Re: SharePoint reload fails

may be operating system vs qlikview server issue 32bit/64bit issue.

Not applicable

Re: SharePoint reload fails

Hi Shiva,

Thank you for your reply.

The link works fine in IE on the QlikView Server. So therefore 32/64 bit cannot be the issue. I'm thinking more about user authentication or some setting...

Regards,
Marcel

prieper
Honored Contributor II

Re: SharePoint reload fails

Have you tried to transmit username and password with the URL

think it is something like

http://userSmiley Tongueassword@sp.XXX......

Peter

Not applicable

Re: SharePoint reload fails

Hi Peter,

No, I was not aware of this "trick". I'll try and let you know if it worked.

Thanks!

Regards,
Marcel

Not applicable

Re: SharePoint reload fails

Hi Peter,

Nope, no luck on this solution either. I'm out of options... can there be a more technical issue? E.g. with too strict policy or...

Regards,
Marcel

quwok
Contributor III

Re: SharePoint reload fails

The QlikView Server would be using the service account to access SharePoint, does the service account has permissions to access the files?

(the account we are referring to is the account the QlikView services are running at, usually it is the account you supplied when installing the QlikView Server application)


Not applicable

Re: SharePoint reload fails

Yes, we double checked that the user running QV services also has access to SharePoint list. I can log in on the server with that user name, use the URL from QV and copy/paste this into IE (on the server) and it works. The reload also works with all other users. That's why I think it's so strange... any other thoughts what can be the cause?

Not applicable

Re: SharePoint reload fails

Getting the same issue here Tried all the workarounds on the forum but seems the QV server when running the reload as a service has an issue.

Any suggestions?

hansdevr
Contributor II

Re: SharePoint reload fails

I have exactly the same issue:

This is the log of my qvw:

 

12-4-2016 11:26:41: 0033 row:

 

12-4-2016 11:26:41: 0034 LOAD

 

12-4-2016 11:26:41: 0035 ows_Body,

 

12-4-2016 11:26:41: 0036 ows_DueDate,

 

12-4-2016 11:26:41: 0037 ows_TemplateName,

 

12-4-2016 11:26:41: 0038 ows_Title,

 

12-4-2016 11:26:41: 0039 ows_Editor,

 

12-4-2016 11:26:41: 0040 ows_AssignedTo,

 

12-4-2016 11:26:41: 0041 ows_BusinessObjectRootKey,

 

12-4-2016 11:26:41: 0042 %Key_xml_98C49F546A18E856

 

12-4-2016 11:26:41: 0043 FROM [http://xxxxxxxxxxxxxxxxxxxx/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List=%7B202E65E4%2DCED6%2D4E...] (XmlSimple, Table is [xml/data/row])

 

12-4-2016 11:26:41: Error: Access is denied.

 

 

12-4-2016 11:26:41:       General Script Error

 

12-4-2016 11:26:41:       Execution Failed

 

12-4-2016 11:26:41:      Execution finished.

 

Community Browser