Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

load from https source with self-signed certificate - Unknown error in MSXML

Hello

For debugging purposes we load xml data from our tomcat web application working on https, using self-signed certificate.

A browser warns users that it can be dangerous to open such pages, but we can add an exception for such page and force open it, but QlikView script just stops working with "Unknown error in MSXML".

Is there a way to add an exception or force QlikView to enable loading data from https source with self-signed certificate?

This problem happens in both QV Server and Developer.

In QV Developer, if you try to load data from Web File with such https url, it shows Internet error: 12038.

I installed our certificate as trusted in all possible Windows 7 storages (publisher, personal and so on) but this did not help.

Please advice.

4 Replies
Bjorn_Wedbratt
Former Employee
Former Employee

Hi Consona,
You're saying that you get a warning about the self-signed certificate? Is this even after adding it into the correct certificate store? The certificate should be added into trusted root certificates as described here:

http://blogs.technet.com/b/sbs/archive/2008/05/08/installing-a-self-signed-certificate-as-a-trusted-...

Also the certificate must match the host used in the URL when accessing the site (so if the certificate is generated for mysite.company.com you must access the site using http://mysite.company.com). Finally make sure the certificate hasn't expired.

Make sure you get rid of the warning in the browser before trying to load into QV again, or if possible try to load using HTTP (just to make sure there's nothing wrong in the xml stream) as a test.

Regards,
Bjorn

Not applicable
Author

thank you Bjorn,

your advice has really helped!

I performed all steps as you described, except that I did not guess that "local computer" should be the correct place to store our self-signed certificate. Now it works great!

qlikviewforum
Creator II
Creator II

Hi All

The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.

Created the new thread for the same below.

http://community.qlik.com/message/249859#249859

Thanks,

qlikview forum

Anonymous
Not applicable
Author

I found the solution to this issue.  It comes from Windows internet options handling of mixed content.  To fix it, open up "Internet Options" (from either the control panel or IE).  Click on the "Security" tab.  With the internet zone selected, click on the "Custom level..." button.  Scroll down in the list for "Display Mixed Content" and select "Enable".

If you are running Win 2008, you'll need to disable IE Enhanced Security Configuration:

http://technet.microsoft.com/en-us/library/dd883248(v=ws.10).aspx#manage