Delete a connection

Note: Use the following procedure if data issues are suspected.

1. Right-click the entry in the list and select Delete Connection.

   You are prompted to confirm the deletion.

   Note: In an error-free operational environment, any connection (active or inactive) can be deleted.

2. Select Yes to continue with deleting the connection.

   The connection entry is removed from the list.

3. Make a note of the Unique Environment Name (UEN) for the MES repository connection.

4. Close the Work Tasks Connector Configuration utility

5. In SQL Server Management Studio, run queries to check the information in the Work Tasks repository database and the MES databases. For example:

   --MESDB (MES Database)

   select * from MESDB.dbo.AWC_Workflowconnection

   select * from MESDB.dbo.AWC_Workflowconnection_Status

   --Work Tasks repository DB

   select * from SkeltaDB.dbo.SKExternalConnectionDetails

   select * from SkeltaDB.dbo.MESConnectionDetails

   select * from SkeltaDB.dbo.SKExternalConnections

6. Delete the details pertaining to a specific UEN in the MES database and the Work Tasks repository database for the respective repository, as described below:

   --delete all the details related to the unique environment name which was configured in the Work Tasks - MES Connector

   delete from MESdb.dbo.AWC_WorkflowConnection where UEN = 'MESDB_MES'

   delete from MESdb.dbo.AWC_Workflowconnection_Status where UEN='MESDB_MES'

   delete from SkeltaDB.dbo.SKExternalConnectionDetails where Title='MESDB_MES'

   Alternatively, you can delete all connection details in the MES database, as described below:

   delete from AWC_WorkflowConnection

   delete from AWC_WorkflowConnection_Status