topic SharePoint reload fails in QlikView

SharePoint reload fails

Thu, 02 Apr 2015 10:26:49 GMT

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

Re: SharePoint reload fails

buzzy996 — Thu, 02 Apr 2015 14:56:07 GMT

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

Re: SharePoint reload fails

Thu, 02 Apr 2015 15:01:33 GMT

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

Re: SharePoint reload fails

prieper — Thu, 02 Apr 2015 15:31:24 GMT

Have you tried to transmit username and password with the URL

think it is something like

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

Peter

Re: SharePoint reload fails

Thu, 02 Apr 2015 15:49:03 GMT

Hi Peter,

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

Thanks!

Regards,
Marcel

Re: SharePoint reload fails

Tue, 07 Apr 2015 09:42:53 GMT

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

Re: SharePoint reload fails

quwok — Tue, 07 Apr 2015 10:21:07 GMT

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)

Re: SharePoint reload fails

Tue, 07 Apr 2015 10:28:45 GMT

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?

Re: SharePoint reload fails

Mon, 02 Nov 2015 09:35:35 GMT

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?

Re: SharePoint reload fails

hansdevr — Tue, 12 Apr 2016 13:21:50 GMT

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%2D4EA8%2DAE6E%2DD04AD7D83285%7D] (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.

Re: SharePoint reload fails

hansdevr — Thu, 14 Apr 2016 05:59:05 GMT

Looks like I finally found the answer.

Log into the QlikView server as the Service Account admin. Startup Internet options and alter security settings with regard to XML. Add the link to the owssvr.dll (http://xxxxxxxxxxxxxxxxxxxx/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List=%7B202E65E4%2DCED6%2D4EA8%2DAE6E%2DD04AD7D83285%7D] (XmlSimple, Table is [xml/data/row]) to the trusted sites. Worked like a charm for me!

Re: SharePoint reload fails

christophebrault — Tue, 12 Jul 2016 10:26:45 GMT

Hi,

Can you share sample script code please ?

Re: SharePoint reload fails

hansdevr — Wed, 13 Jul 2016 06:55:16 GMT

Hi Christophe,

Well, what I showed in my post is in fact what you use in the load script. In stead of loading from a QVD table, or from a xls sheet, you choose to load from a web link. The web link invokes the loading of a table file through xml.

Hope this makes it a little more clear..

Re: SharePoint reload fails

christophebrault — Wed, 13 Jul 2016 07:49:42 GMT

ok thanks.

Not working for me for the moment ...

Re: SharePoint reload fails

Wed, 13 Jul 2016 08:02:38 GMT

Hi Christophe,

My code is also simple:

SourcingIssueOverview:
LOAD
ows_Supplier_x0020_number as SupplierNumber,
ows_Supplier_x0020_name,
ows_Contract_x0020_number,
ows_Ship_x0020_to,
ows_OP_x0020_number,
ows_Item_x0020_Number,
ows_Line_x0020_description,
ows_Qty_x0020_ordered,
ows_Price_x0020_per_x0020_UoM,
ows_OP_x0020_request_x0020_date,
ows_Cancel_x0020_Date,
ows_Entrance_x0020_Control,
ows_Attachments,
ows_Status,
ows_Department,
ows_Type_x0020_of_x0020_issue,
ows_Description_x0020_of_x0020_the_x,
ows_Cause_x0020_of_x0020_the_x0020_i,
ows_Actions_x0020_taken,
ows_Who_x0020_has_x0020_been_x0020_c,
ows_Which_x0020_soluation_x0020_do_x,
ows_Hand_x0020_over_x0020_to,
ows_Final_x0020_solution,
ows_Actions_x0020_taken_x0020_to_x00,
ows_Date_x0020_issue_x0020_solved,
ows_Start_x0020_date_x0020_issue,
ows_Created,
ows_OP_x0020_Promised_x0020_Delivery,
ows_OP_x0020_Actual_x0020_Delivery_x
FROM [https://sp.XXXXX.com/SupplyChain/Sourcing/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={78147072-92e6-4d55-9580-cde967d90e5c}] (XmlSimple, Table is [xml/data/row]);

HOWEVER, automatic reload still doesn't work. The URL https://sp.XXXXX.com/ is added to trusted sites but didn't work.

I'm still interested in possibilities, QV consultants were also not able to solve the issue...

Best regards,

Marcel

Re: SharePoint reload fails

Fri, 23 Sep 2016 03:29:45 GMT

Hi there, we also tried Qlikview consultants and were not able to resolve