David Lai's Business Intelligence Blog

Recently I had a client who switched from http to https; and although it seemed like a simple transition in some places, it was tricky in others such as WEBI Richclient.

With WEBI Richclient, we noticed that we could no longer publish or view our BI Web Services as the BI Web Services area was just hanging.

One workaround would be to just give up and work through WEBI in BI Launchpad, however if the organization is still in Business Objects 3.1, this will not be possible as BI Web Service publishing is not available through InfoView.

Well the other way is to make sure that the correct https certificate has been imported to the Business Objects client.

Here are the steps on how to import the https certificate to the Business Objects client.

Step 1

Obtain the https certificate from your server administrator.  Let’s assume the https certificate is called “root.cer”.

Step 2

Put “root.cer” in the directory of your choice.  In our example I’ll just put it in “C:\Temp”

Step 3

Now we will need to import the certificate to cacerts file in Business Objects.  You’ll notice that there are 2 java directories in the Business Objects client folder.  To be safe I import the certificate to both cacerts files

Step 4

In the command prompt, use the following command to import the cacerts file to Business Objects

cd <Business Objects Installation Directory>\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jre\bin

keytool -importcert -file C:\Temp\root.cer -keystore “<Business Objects Installation Directory>\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jre\lib\security\cacerts” -storepass changeit -alias root

Now repeat with the other java directory in Business Objects

cd <Business Objects Installation Directory>\SAP BusinessObjects Enterprise XI 4.0\win32_x86\sapjvm\jre\bin

keytool -importcert -file C:\Temp\root.cer -keystore “<Business Objects Installation Directory>\SAP BusinessObjects Enterprise XI 4.0\win32_x86\sapjvm\jre\lib\security\cacerts” -storepass changeit -alias root

 Step 5

Open up WEBI Rich Client and test to make sure the BI Web Services now populate when you go to tools -> Manage BI Services