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

[hansdevr]

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%2D4E...] (XmlSimple, Table is [xml/data/row]) to the trusted sites. Worked like a charm for me!

[christophebrault]

Hi,

Can you share sample script code please ?

[hansdevr]

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..

[christophebrault]

ok thanks.

Not working for me for the moment ...

[#6]

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

[#7]

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