iDash Subscription Disconnected

book

Article ID: 142239

calendar_today

Updated On:

Products

CA Workload Automation iDash for CA 7

Issue/Introduction

Reviewed $IDASH_HOME/log/info.log and found these entries:


2019-12-21 01:13:36 [ INFO] idash-SLA-processing: Failed to get latest SLA run for DADS_OPEN_AUTOSCORE_SM_FILES^YELLOW:Sun Dec 22 05:00:00 GMT 2019SHUTDOWN is in progress.
2019-12-21 01:13:36 [ERROR] idash-SLA-processing: Failed to get latest SLA run for DADS_OPEN_AUTOSCORE_SM_FILES^YELLOW:Sun Dec 22 05:00:00 GMT 2019SHUTDOWN is in progress.
com.microsoft.sqlserver.jdbc.SQLServerException: SHUTDOWN is in progress.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:232)

and then:


2019-12-21 01:14:02 [ERROR] YELLOW: iDashDB
2019-12-21 01:14:02 [ERROR] YELLOW: java.sql.SQLException:com.microsoft.sqlserver.jdbc.SQLServerException:SHUTDOWN is in progress. ClientConnectionId:6a4c6fc1-d12b-4f4f-82f4-1d1b3d16db6b
2019-12-21 01:14:18 [ERROR] idashdb-config-thread-1: com.microsoft.sqlserver.jdbc.SQLServerException:SHUTDOWN is in progress. ClientConnectionId:7fd54d61-b7da-4c4b-b60c-3a464a2c107d
2019-12-21 01:14:18 [ERROR] idashdb-config-thread-1: com.ca.idash.core.exception.IdashException:Unable to create a new JDBC connection for: jdbc:sqlserver://GTS-CON-SQLVS:1433;databaseName=iDash
2019-12-21 01:14:54 [ERROR] site: updateSLARunRecords failed : Both the primary and secondary connections are not available

Resolution

As per above messages, it seems DB was not available due to a shutdown.