ConnectALL automation is not running

Products

• ConnectAll On-Prem
• ConnectALL

Issue/Introduction

ConnectALL automation is not running and no lock icon is showing on the dashboard for the automation.

Automation log show no activity

If the Core service has been restarted, the automation log may show the following entry:

INFO  YYYY-MM-dd mm:hh:ss,zzz [AutomationName |  |  | {}][(connectall-flows) thread #2 - JmsConsumer[pollQ]] com.go2group.connectall.model.transformer.model.api.GenericConfigPoller: Waiting for camel to start up...

 

Cause

This can be caused when the database's user interface lock indicator is not in synch with the automation's lock status.

Resolution

Log into the ConnectALL database and access a SQL query window

Run the following query:

SELECT application_link_id, application_link_name, application_lock_status, source_app_lock_status, dest_app_lock_status FROM application_link WHERE application_lock_status='N' AND (source_app_lock_status='Y' OR dest_app_lock_status='Y');

 

Sample result:

+---------------------+-----------------------+-------------------------+------------------------+----------------------+
| application_link_id | application_link_name | application_lock_status | source_app_lock_status | dest_app_lock_status |
+---------------------+-----------------------+-------------------------+------------------------+----------------------+
|                   4 | AutomationName        | N                       | Y                      | N                    |
+---------------------+-----------------------+-------------------------+------------------------+----------------------+

 

In the above example, application_link_id 4 is locked, but will not represent a locked icon on the dashboard because the application_lock_status value is "N".

 

To resolve this, run the following query, substituting your own application_link_id value in the example query below:

UPDATE application_link SET application_lock_status='Y' WHERE application_link_id=4;

 

Once the database has been updated, navigate back to the Dashboard page in the user interface and refresh it.  

You should now see a lock icon next to the automation.

Click the lock icon and if prompted, accept the lock to be removed.