SharePoint reload fails

[#1]

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

[buzzy996]

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

[#3]

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]

Have you tried to transmit username and password with the URL

think it is something like

http://user:password@sp.XXX......

Peter

[#5]

Hi Peter,

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

Thanks!

Regards,
Marcel

[#6]

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]

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)

[#8]

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?

[#9]

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]

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.