VERIFIED SOLUTION i

"Delivery channel is referenced.” message in EngageOne Server

Issue

Error - "Delivery channel is referenced.” is being observed on deleting Delivery Channel from EngageOne Admin.

Cause

EngageOne Admin does not allow to delete delivery channel which is currently in-use by any pending requests.

Resolution

UPDATED: August 4, 2018
EngageOne is associated with EngageOne repository or database. Execute following query, on database in question, to check Delivery Channel is associated with any pending requests 

select * from TDS_RequestChannels where DeliveryChannelId = (select DELIVERY_CHANNEL_ID from OCM_DELIVERY_CHANNEL
where DELIVERY_CHANNEL_NAME = 'Delivery-Channel_Name')

If above query returns any rows, deletion of the selected delivery channel will not be allowed. This also helps to determine number of delivery items associated with the channel and current status.