Upgraded OC/SRM server install shows error message regarding CABI/BOXI server integration

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

We see after upgrade to CA Spectrm R10.3.++ error messages in OC/SRM webserver logfile (catalina.out / stdout.log) indicating service is trying to connect to a configured CABI/BOXI host. The CABI/BOXI integration is not supported nor configurable under CA Spectrum R10.3++ anymore. 

The error message looks like:

<date> <time> - Error while determining Crystal Only users. com.crystaldecisions.sdk.exception.SDKException$ServiceFailure: 
    There was a problem retrieving the service EnterpriseSession from the server <boxihostname>:6400 (FWM 02002)
    at com.aprisma.spectrum.app.repmgr.re.bo.AdminUserContext.logon(AdminUserContext.java:367)
    at com.aprisma.spectrum.app.repmgr.re.bo.AdminUserContext.getEnterpriseSession(AdminUserContext.java:94)
    at com.aprisma.spectrum.app.repmgr.re.bo.AdminUserContext.getInfoStore(AdminUserContext.java:279)
    at com.aprisma.spectrum.app.repmgr.re.bo.CrystalOnlyUserManager.getCrystalOnlyUsers(CrystalOnlyUserManager.java:97)
    at com.aprisma.spectrum.app.repmgr.re.bo.CrystalOnlyUserManager.execute(CrystalOnlyUserManager.java:45)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269)
    at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:257)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

and/or:
<date> <time> - Unable to obtain Business Objects Session: 
        There was a problem retrieving the service EnterpriseSession from the server <boxihostname>:6400 (FWM 02002). 
        Verify that the Business Objects CMS and related services are running. Will retry connecting in 60 seconds.

 

 

Environment

This applies to all supported CA Spectrum platforms (Linux and Windows) when the CA Spectrum OC-SRM server install was configured with a CABI/BOXI integration prior to upgrade to CA Spectrum Release R10.3 and higher.
 

Cause

The CA Spectrum R10.3 and higher does not support CABI/BOXI integration anymore but upgrade task may not remove the CABI/BOXI integration parameter from internal configuration. 

 

Resolution

NOTE: Starting from DX NetOps Spectrum 21.2.4, the default root password for MySql is "MySqlR00t". For DX NetOps Spectrum versions prior to 21.2.4, the default root password is "root". In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

R10.3.1 installer is missing the BOCI/CABI cleanup - so manual cleanup is required by native mysql command to update reporting.registry entry.

Check for existing configuration per native mysql-command. All native mysql-command are executed per Spectrum install owner logon from directory $SPECROOT/mysql/bin at CA Spectrum OC/SRM server:

- show the current configuration data:
     ./mysql[.exe] --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> -e"select * from registry\G;" reporting
- update single entries out of this record
     ./mysql[.exe] --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> -e"update registry set ='value';" reporting

Sample: ./mysql[.exe] --defaults-file=../my-spectrum.cnf -uroot -proot -e"update registry set BOPort='0';" reporting

Here it is required to overwrite the entries:    BOPort and BOHost
Please set BOXI port-number to "0" - while BOXI hostname / URL set to "nothing". So set BOHost='';   ( which are 2 single_quotes without any space/blank character ).
When the reporting.registry parameters are modified, you are required to restart the OC/SRM tomcat service once. 
 

Additional Information

Using alias like "alias strmy='/app/spectrum/mysql/bin/mysql --defaults-file=/app/spectrum/mysql/my-spectrum.cnf -uroot -p<PASSWD>'

Then checking for configuration shows / here sample for not configured BOXI parameter:
[[email protected] bin]$ strmy reporting -e"select * from registry\G;" | grep BO
                      BOPassword:
                   BOCommonFiles:
                          BOHome:
                   BOInstallRoot:
          ConvertedReportsToBOXI: false
                          BOUser:
                          BOHost: 
                          BOPort: 0
                      BOAuthType:
                    BOTomcatPort: 0
                      BOInfoView:
                           BOCmc:
           BOInfoViewCredentials:
              BOInfoViewAuthType:
         DefaultBOXIUserPassword:
                  BOSharedSecret: