ConnectALL - Records are not getting Orphaned during its scheduled orphan run

Products

• ConnectAll SaaS
• ConnectALL
• ConnectAll On-Prem

Issue/Introduction

Steps to Reproduce: 

1. Create a unidirectional automation between two Rally projects to sync Initiatives
2. Setup Orphan management.
3. Run the automation to sync records.
4. Orphan a record and trigger Orphan run.

 

Actual Results: 
Qualifying records below does not get Orphaned.

 

Expected Results: 
Qualifying records should have got Orphaned.

Environment

3.5.x

Cause

Orphan logs has below database connection error causing Orphan service not to run.

JmsConsumer[findOrphanQ]] com.go2group.connectall.config.DBConfig: Error connecting to Database.
java.sql.SQLTransientConnectionException: hikariCP - Connection is not available, request timed out after 30000ms.

Resolution

Restart Orphan service to reconnect database.