Getting BI Web Services to work in WEBI Richclient through https
April 29, 2014 by: David LaiRecently 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
I was struggling with this issue for a while, this totally saved the day!
Thanks Dave!
Darren
Thanks David, this really helped me.
George