CA Businness Intelligence (CABI) 6.4.3 installation failed

book

Article ID: 140825

calendar_today

Updated On:

Products

CA Spectrum CA eHealth

Issue/Introduction

Customer is installing Jasper Server 6.4.3 (Ca Businness Intelligence 6.4.3) on Linux platform but it fails with error:

19033 Error while installing CA Business Intelligence

 

The CABusinessIntelligence install log file shows the following exception:

2019-11-08 13:06:54 INFO  JasperInstaller:178 - do-install-upgrade-test:
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo] Checking DBMS host and port:
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo] About to validate port: localhost:5432
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   Port 5432 is OK
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo] Done validating port: localhost:5432
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo] Validating administrative database connection at jdbc:postgresql://localhost:5432/postgres. Phase: [test]
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo] For JDBC driver the artifactId and version properties are set:
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   maven.jdbc.artifactId=postgresql
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   maven.jdbc.version=9.4-1210.jdbc41
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   Specified JDBC driver jar exists
2019-11-08 13:06:54 INFO  JasperInstaller:178 - [advanced-sql] Failed to connect: FATALE: il ruolo "JASPERRFI" non esiste
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo] Connection failed:
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   SQLState: 28000
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   Vendor specific error code: 0
2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   Message: [FATALE: il ruolo "JASPERRFI" non esiste]
2019-11-08 13:06:54 INFO  JasperInstaller:178 - 
2019-11-08 13:06:54 INFO  JasperInstaller:182 - BUILD FAILED
2019-11-08 13:06:54 DEBUG ProgressThread:88 - Error code from component install is: 1
2019-11-08 13:06:54 ERROR CABIUtil:106 - ErrorCode : 19033   ErrorMessage : 
2019-11-08 13:06:54 DEBUG ProgressThread:90 - Getting the error codes list from CABIInstallException object
2019-11-08 13:06:54 ERROR CABIUtil:106 - ErrorCode : 19033   ErrorMessage : 
2019-11-08 13:06:54 ERROR CABIUtil:106 - ErrorCode : 19033   ErrorMessage : 
2019-11-08 13:06:54 INFO  ProgressThread:93 - Error code is: 19033
2019-11-08 13:06:54 ERROR CABIUtil:110 - com.ca.bicoe.cajasperserver.install.preinstall.utils.CABIException
 at com.ca.bicoe.cajasperserver.install.api.install.JasperInstaller.exceptionCheck(JasperInstaller.java:183)
 at com.ca.bicoe.cajasperserver.install.api.install.JasperInstaller.conditionCheck(JasperInstaller.java:169)
 at com.ca.bicoe.cajasperserver.install.api.install.JasperInstaller.process(JasperInstaller.java:145)
 at com.ca.bicoe.cajasperserver.install.api.install.JasperInstaller.newInstall(JasperInstaller.java:222)
 at com.ca.bicoe.cajasperserver.install.api.CAJaspersoftInstallerAPI.installFresh(CAJaspersoftInstallerAPI.java:192)
 at com.ca.bicoe.cajasperserver.guiinstall.ComponentInstall.newJasperInstall(ComponentInstall.java:559)
 at com.ca.bicoe.cajasperserver.guiinstall.ComponentInstall.componentInstall(ComponentInstall.java:216)
 at com.ca.bicoe.cajasperserver.install.guiinstaller.customcode.ShowInstallProgress.showProgress(ShowInstallProgress.java:189)
 at com.ca.bicoe.cajasperserver.install.guiinstaller.customcode.ShowInstallProgress.install(ShowInstallProgress.java:119)
 at com.zerog.ia.installer.actions.CustomAction.installSelf(Unknown Source)
 at com.zerog.ia.installer.InstallablePiece.install(Unknown Source)
 at com.zerog.ia.installer.InstallablePiece.install(Unknown Source)
 at com.zerog.ia.installer.GhostDirectory.install(Unknown Source)
 at com.zerog.ia.installer.InstallablePiece.install(Unknown Source)
 at com.zerog.ia.installer.Installer.install(Unknown Source)
 at com.zerog.ia.installer.actions.InstallProgressAction.ae(Unknown Source)
 at com.zerog.ia.installer.actions.ProgressPanelAction$1.run(Unknown Source)

2019-11-08 13:06:54 DEBUG ProgressThread:95 - Error key is: ERROR_JASPERSERVER_INSTALL
2019-11-08 13:06:54 DEBUG ProgressThread:97 - Error message is: Error while installing CA Business Intelligence
2019-11-08 13:06:54 INFO  ProgressThread:103 - 1
2019-11-08 13:07:09 DEBUG RollBackInstallation:98 - Getting the error codes list from CABIInstallException object
2019-11-08 13:07:09 DEBUG RollBackInstallation:104 - Error code occured during the installation is: 19033
2019-11-08 13:07:09 INFO  RollBackInstallation:141 - Starting rollback operation
2019-11-08 13:07:09 INFO  RollBackInstallation:143 - error code is: 19033

 

 

 

Cause

The following input parameters were being used:

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo] Checking properties:

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   dbType=postgresql

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   dbHost=localhost

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   dbUsername=JASPERXXX

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   dbPassword=**********

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   dbPort=5432

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   js.dbName=jasperserver

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   sugarcrm.dbName=sugarcrm

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   foodmart.dbName=foodmart

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   webAppNamePro=jasperserver-pro

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   appServerType=tomcat

2019-11-08 13:06:54 INFO  JasperInstaller:178 -      [echo]   appServerDir=C:\Program Files\CA\SC\CA Business Intelligence/apache-tomcat

with the dbUsername=JASPERXXX in Upper Case. 

PostgreSQL converts the username introduced during the installation to one which only uses lowercase letters and then using the JASPERRFI (in capital letters to connect) failed to connect.

 

Environment

Release : 10.4

Component : Jaspersoft for CA Spectrum  / SpectroSERVER

Resolution

Do not use dbUsername in Upper Case for PostgreSQL installation on Linux platform, but supply it all in lower case.

Attachments