After deploying the CABI probe to a robot we are getting the following: (command = <startup java>) returns no-restart code (42)
search cancel

After deploying the CABI probe to a robot we are getting the following: (command = <startup java>) returns no-restart code (42)

book

Article ID: 47286

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

 
After installing the cabi probe it would not start.
 
We see the following in the log files on loglevel 5:
 
Oct 04 11:23:46:296 [Thread-1, cabi]      [exec] do-install-upgrade-test:
Oct 04 11:23:46:296 [Thread-1, cabi]      [exec]      [echo] Checking DBMS host and port:
Oct 04 11:23:46:296 [Thread-1, cabi]      [exec]      [echo] About to validate port: CBDSQLSERVR1:1433
Oct 04 11:23:46:327 [Thread-1, cabi]      [exec]      [echo]   Port 1433 is OK
Oct 04 11:23:46:342 [Thread-1, cabi]      [exec]      [echo] Done validating port: CBDSQLSERVR1:1433
Oct 04 11:23:46:342 [Thread-1, cabi]      [exec]      [echo] Validating administrative database connection at jdbc:tibcosoftware:sqlserver://sqlservername:1433;SelectMethod=cursor;sendTimestampEscapeAsString=false. Phase: [test]
Oct 04 11:23:46:342 [Thread-1, cabi]      [exec]      [echo] About to validate JDBC jar existence
Oct 04 11:23:46:342 [Thread-1, cabi]      [exec]      [echo]   Look in: C:/Program Files/Nimsoft/cabi/buildomatic/conf_source/db/sqlserver/jdbc
Oct 04 11:23:46:342 [Thread-1, cabi]      [exec]      [echo]   Found jar file: assuming OK
Oct 04 11:23:46:342 [Thread-1, cabi]      [exec]      [echo]   Jar or Jars found: TIsqlserver-5.14.jar;jasperreports-pro-6.0.0.jar
Oct 04 11:23:46:514 [Thread-1, cabi]      [exec] [advanced-sql] Failed to connect: [Tibcosoftware][SQLServer JDBC Driver][SQLServer]Cannot open user default database. Login failed.
Oct 04 11:23:46:514 [Thread-1, cabi]      [exec]      [echo] Connection failed:
Oct 04 11:23:46:514 [Thread-1, cabi]      [exec]      [echo]   SQLState: HY000
Oct 04 11:23:46:514 [Thread-1, cabi]      [exec]      [echo]   Vendor specific error code: 4064
Oct 04 11:23:46:514 [Thread-1, cabi]      [exec]      [echo]   Message: [[Tibcosoftware][SQLServer JDBC Driver][SQLServer]Cannot open user default database. Login failed.]
Oct 04 11:23:46:514 [Thread-1, cabi]      [exec]
Oct 04 11:23:46:514 [Thread-1, cabi]      [exec] BUILD FAILED
 

 

Environment

UIM 8.x
cabi 3.x

Resolution

The following actions should solve this error:

1) Run the following command on the database using SQL Management Studio or any similar SQL Management tool.

ALTER LOGIN <SQL Username> WITH DEFAULT_DATABASE = CA_UIM
GO
 
2) deactivate the cabi probe.
3) Activate the cabi probe
 

 

Additional Information

NOTE: The data_engine and wasp may still connect and working properly before applying these steps.

Related KB's:
cabi_external probe will not start
Cabi probe v3.0 deployment problems

Cannot install Cabi on Linux: Controller: Probe 'cabi' (command = <startup java>) returns no-restart code (42)
Wasp probe used with CABI won't start. Controller: Max. restarts reached for probe 'wasp' (command = <startup java>)
Unable to use UIM CA Business Intelligence Dashboards

Cabi Documentation:
Installing and Upgrading CA Business Intelligence JasperReports Server with CA UIM