Discussions

A client has thousands of messages in the CommunicationLog with values of 0 in the Sent, Delivered, and Not Delivered columns. They were added here over time from a runaway Process Automation task, which I need to investigate and modify to prevent it from writing these ghost records in the future. As for the historical records already written, I was thinking of writing a SQL query to delete them from the table. Before taking that step, I was hoping someone could provide some guidance. Will deleting from this table pose a problem? Two related tables give me pause for concern – CommunicationLogEvent and CommunicationLogRecipient. These two seem to be related to CommunicationLog through the CommunicationLogKey column. ASI tech support said this type of support goes beyond the scope of their responsibilities. I was also unable to find any documentation on this topic. Any advice would be greatly appreciated.

I'm posting cross-posting this question from the iMIS Gurus list at the request of Jake Bound. He said that Paul Bradshaw would be on the lookout for it.