Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

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

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

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

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
Contributor II

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

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

jdvermeire
Contributor

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

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

Community Browser