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

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

book

Article ID: 130164

calendar_today

Updated On:

Products

Spectrum Network Observability

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

Run the following syntax to connect to the MySQL command prompt:

 ./mysql[.exe] --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> reporting

Run the following syntaxes to delete/remove the old entries from the registry table:

  • update registry set CrystalReportsUser='';
  • update registry set CrystalReportsPassword='';
  • update registry set CrystalReportsHost='';
  • update registry set DBHost='';
  • update registry set BOInfoView='';
  • update registry set BOCmc='';
  • update registry set BOInfoViewCredentials='';
  • update registry set UniverseUser='';
  • update registry set UniversePassword='';
  • update registry set BOPassword='';
  • update registry set BOSharedSecret='';
  • update registry set BOUser='';
  • update registry set BOHost='';
  • update registry set BOPort='0';
  • update registry set BOAuthType='';
  • update registry set BOTomcatPort='0';
  • update registry set BOInfoViewAuthType='';



- 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:
[spectro@liejooc 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:

 

Powered by Wolken Software