I have successfully installed BO 4.1 sp3 to linux and I have worked my way towards integrating it with Spectrum. Are there any post install instructions to follow after you have installed CABI 4.1?  I have worked my way through the first set of errors I had when I tried to integrate OneClick with Business Objects: "

Error importing SRM content when attempting to enable Spectrum Report Manager and CABI integration, Document ID:  TEC1314934 but now when I try to enable integration I get

Error importing SRM content: CE SDK Exception occurred : 'Unable to find servers in CMS ***.com:6400 and cluster @***.com:6400 with kind fileserver and service FileStoreV2. All such servers could be down or disabled by the administrator. (FWM 01014)' (FWM 04002)

Hi,

Can you check name resolution to ***.com is resolved properly to a correct IP address?

Can you also check if CMS process is listening to TCP/6400 on CABI machine?

On Windows, run the following on the DOS prompt

      netstat -aon | findstr /R 6400

On Linux, run the following on a bash shell (using root user)

      netstat -apn | grep 6400

James,

We do have post install actions which needs to be performed after installing Cabi. Have a look here

https://wiki.ca.com/display/CASP10/Post+Installation+Configuration+for+CABI+1

Also make sure we are able to login to CMC before integrating with Oneclick. Also check if the other servers are running in the Central management console

I finally have a working installation of Business Objects 4.1 sp3 on linux but when I run the SpectrumUpdate.sh command I get

Java path /opt/CA/SharedComponents/CommonReporting4/sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java

Getting new files from cor-rm-1

Exception in thread "main" java.net.ConnectException: Connection refused

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:382)

        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:241)

        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:365)

        at java.net.Socket.connect(Socket.java:529)

        at java.net.Socket.connect(Socket.java:476)

        at sun.net.NetworkClient.doConnect(NetworkClient.java:163)

        at sun.net.www.http.HttpClient.openServer(HttpClient.java:426)

        at sun.net.www.http.HttpClient.openServer(HttpClient.java:540)

        at sun.net.www.http.HttpClient.<init>(HttpClient.java:216)

        at sun.net.www.http.HttpClient.New(HttpClient.java:302)

        at sun.net.www.http.HttpClient.New(HttpClient.java:321)

        at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:987)

        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:923)

        at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:841)

        at com.ca.spectrum.repmgr.wkp.update.WwwGet.get(WwwGet.java:67)

        at com.ca.spectrum.repmgr.wkp.update.Retriever.main(Retriever.java:71)

Failed to download Spectrum update. Exiting...

Now when I run the same command I get

Java path /sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java

./SpectrumUpdate.sh: line 43: /sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java: No such file or directory

Failed to download Spectrum update. Exiting...

Hey David,

You will have to make sure the BO_INST_PATH is set properly.

Generally on Linux this would be /opt/CA/SharedComponents/CommonReporting4/

So export BO_INST_PATH=/opt/CA/SharedComponents/CommonReporting4

Then try running it again.

Thanks!

Matt

I did the export again.  I can access the Business Objects CMC page as well as the Infoview aka BI pages so I know that the full install went fine.  From my understanding of the documentation I need to run the SpectrumUpdate.sh but now I get this error:

./SpectrumUpdate.sh: line 43: /sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java: No such file or directory

Are the JAVA_HOME and PATH supposed to point to this directory??

From the SpectrumUpdate.sh

if [ "${OS_TYPE}" = "linux" ]; then

    JAVA=${BO_INST_PATH}/sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java

    JAR_CMD=${BO_INST_PATH}/sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/jar

So what' missing that's causing the spectrumupdate to fail?

${BO_INST_PATH} is missing. So you got the error

  ./SpectrumUpdate.sh: line 43: /sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java: No such file or directory

The directory path to java directory should be something like /opt/CA/SharedComponents/CommonReporting4/sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java. The error message shows incomplete directory. The script defines JAVA variable as ${BO_INST_PATH}/sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java. So ${BO_INST_PATH} is empty in this case.

As Matt has mentioned above have you set BO_INST_PATH variable to the path where CABI installed before running the SpectrumUpdate.sh script? On a bash shell you should run something like below

          export BO_INST_PATH= /opt/CA/SharedComponents/CommonReporting4

If you want to check BO_INST_PATH has been defined properly, run the following and make sure it is showing correct directory before running the SpectrumUpdate.sh script.

          echo $BO_INST_PATH

[root@d1-cabi-01 ~]# export BO_INST_PATH=/opt/CA/SharedComponents/CommonReporting4/

[root@d1-cabi-01 ~]# echo $BO_INST_PATH

/opt/CA/SharedComponents/CommonReporting4/

[root@d1-cabi-01 ~]# cd /opt/CA/SharedComponents/CommonReporting4/utilities/

[root@d1-cabi-01 utilities]# ls

biconfig                                         DynamicConnections.sh

CABI resource usage estimator v1.2 from SAP.swf  logger.properties

CA_NVM_EXE                                       PostInstall

configFile.xml                                   Spectrum.jar

DynamicConnections.bat                           SpectrumUpdate

[root@d1-cabi-01 utilities]# cd SpectrumUpdate/

[root@d1-cabi-01 SpectrumUpdate]# ./SpectrumUpdate.sh -host http://xxxx:80 -username  -password

Java path /opt/CA/SharedComponents/CommonReporting4//sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java

Getting new files from cor-rm-1

Exception in thread "main" java.net.ConnectException: Connection refused

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:382)

        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:241)

        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:365)

        at java.net.Socket.connect(Socket.java:529)

        at java.net.Socket.connect(Socket.java:476)

        at sun.net.NetworkClient.doConnect(NetworkClient.java:163)

        at sun.net.www.http.HttpClient.openServer(HttpClient.java:426)

        at sun.net.www.http.HttpClient.openServer(HttpClient.java:540)

        at sun.net.www.http.HttpClient.<init>(HttpClient.java:216)

        at sun.net.www.http.HttpClient.New(HttpClient.java:302)

        at sun.net.www.http.HttpClient.New(HttpClient.java:321)

        at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:987)

        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:923)

        at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:841)

        at com.ca.spectrum.repmgr.wkp.update.WwwGet.get(WwwGet.java:67)

        at com.ca.spectrum.repmgr.wkp.update.Retriever.main(Retriever.java:71)

Failed to download Spectrum update. Exiting...

What username and password am I supposed to use?  The username and password that has admin access to OneClick or the user that has admin access to the server that the SpectrumUpdate.sh is trying to connect to????

You need to set OneClick (Spectrum) user and password. The script will access your OneClick Server with the user credential to download the some jar files to be deployed on CABI Tomcat installation. So when you run run the script it will be with something like this (I assume I have 'spectrum' user which password is 'specpass'

          ./SpectrumUpdate.sh -host <OneClick Server URL> -username spectrum -password specpass

Please remove the last forward slash character ("/") in BO_INST_PATH when you exported the value. This creates double slashes in the directory path to Java directory and will cause problem.

Why can't CA have a program with documentation that simply just works???  I fix one error and now I have another.

Java path /opt/CA/SharedComponents/CommonReporting4/sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java

Getting new files from 10.125.2.14

Exception in thread "main" java.net.ConnectException: Connection refused

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:382)

        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:241)

        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:365)

        at java.net.Socket.connect(Socket.java:529)

        at java.net.Socket.connect(Socket.java:476)

        at sun.net.NetworkClient.doConnect(NetworkClient.java:163)

        at sun.net.www.http.HttpClient.openServer(HttpClient.java:426)

        at sun.net.www.http.HttpClient.openServer(HttpClient.java:540)

        at sun.net.www.http.HttpClient.<init>(HttpClient.java:216)

        at sun.net.www.http.HttpClient.New(HttpClient.java:302)

        at sun.net.www.http.HttpClient.New(HttpClient.java:321)

        at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:987)

        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:923)

        at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:841)

        at com.ca.spectrum.repmgr.wkp.update.WwwGet.get(WwwGet.java:67)

        at com.ca.spectrum.repmgr.wkp.update.Retriever.main(Retriever.java:71)

Failed to download Spectrum update. Exiting...

[boadmin@d1-cabi-01 SpectrumUpdate]$

Can you try using Internet Browser from the CABI machine (the machine you run SpectrumUpdate.sh script) to access the OneClick Server URL you have specified as '-host' argument value of SpectrumUpdate.sh script? The java exception seems to be a connection failure to the OneClick Server. Is the Spectrum Tomcat listening to port 80 as you have specified? Or 8080? Do you have a firewall blocking access to TCP/80?

From the Linux machine that is running CABI I can access the URL for oneCLick in the browser (http://oneclick:8080/spectrum) from there I can sign in with the spectrum admin account. When I try the SpectrumUpdate.sh script I have tried using the same URL on the same port and I get the same error.  This is very frustrating to have a CA product that you want to use but can't because of the installation issues

We are getting connection refused error back from the -host you are connecting to (10.125.2.14).

Perhaps try the hostname instead of IP?

This does work, and is documented properly - you just need to make sure the options are correct.

I have tried IP address and hostname of the OneClick server in the SpectrumUpdate.sh script and the results are the same.  The OneClick and CABI are both linux and neither are running iptables and selinux is disabled. Yet, from Firefox running on the CABI server I can access http://oneclick:8080/spectrum with my Spectrum admin account.  I am using the same URL in the SpectrumUpdate.sh script with the same username and password with no success.

[root@d1-cabi-01 ~]# cd /opt/CA/SharedComponents/CommonReporting4/utilities/SpectrumUpdate/

[root@d1-cabi-01 SpectrumUpdate]# ls

SpectrumUpdate.sh  spectrum-wkp-update.jar

[root@d1-cabi-01 SpectrumUpdate]# ./SpectrumUpdate.sh -host http://cor-rm-1:8080/spectrum -username someuser -password password

Java path /sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java

./SpectrumUpdate.sh: line 43: /sap_bobj/enterprise_xi40/linux_x64/sapjvm/bin/java: No such file or directory

This what I get every time whether I use a hostname or IP address, no matter what I account I use the results are the same. I know there is not a lot of love for CABI in the community but I'd really like to be able to use it

I ran the Spectrumupdate.sh again after fixing a permission issue in the SpectrumUpdate Folder but while I am progressing I did get some errors in the attached log

Hi Kalyan,

we have face boxi integration problem and get below error, have you any solution.

SRM has not finished starting.

regards,

Amit rai

Getting closer but now this:

Error importing SRM content: Input/output exception occurred : '/usr/Spectrum/Install-Tools/SRM-Tools/BIAR/virtualization.biar (Permission denied)' (FWM 04013). This occurs when I try to save the Business Objects Integration after I have removed the necessary biar files as required in the tech doc.  I tested it and it was successful.  I copied the remaining biar files back to the SRM-Tools folder and saved again

While CABI will install on Centos 6.x/7.x and I did successfully integrate OneClick with Business Objects and was able to run all the required post installation commands you will find the Crystal Reporting Server does not start. So I have given up my quest to use CABI on Centos and have given up and surrendered to the Microsoft gods. But even CABI on Microsoft is not cut and dry.  After successfully installing BO and verifying both CMC and InfoView ( BI ).Running the SpectrumUpdate.bat file is another story. Even after setting the BO_INST_PATH the SpectrumUpdate.bat file fails because it cannot find the sapjvm file in the CABI path

Just a note that D08a for 10.0 will resolve most of these issue.

D08a is in 10.1, therefore CA Support suggests installing 10.1 to resolve these types of issues.

Will Spectrum 10.0 work with CABI 10.1 until I get Spectrum 10 upgraded to 10.1?  Basically I want to upgrade CABI first to the newest version.

Let me take a stab at what you meant.

No, Spectrum 10.0 will not work with CABI 3.3.

Spectrum 10.0 will only work with CABI 4.1 SP3.

Spectrum 10.1 also only supports CABI 4.1 SP3.

So there was no CABI upgrade with 10.1, if that is what you meant.

Hi Matthew,

I have upgraded spectrum to 10.1 from 9.4.2.1 and installed CABI 4.1 SP3. However I am getting the 404 Missing page while right click any report. Do we need to install patch D08a? If yes could you please share the same for Windows as Oneclick and CABI hosted on same machine, Windows box 2008.

The issue with the 404 page should be resolved with this -

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1756383.aspx?intcmp=searchresul…

Bon Courage,

     Don