A dictionary entry change introduced for added support for attachments on MID Server Script Files causes a multiple update being performed on the database when an attachment is deleted, in order to null out references. Even though no actual change is made, this triggers the database listener MidScriptListener to incorrectly notify all MID Servers of a potential change.
Steps to Reproduce
Initiate a grab log files from an existing MID Server record.
Upon an input response with an attachment, remove the attachment.
Note that an ecc_queue record is created per MID Server with the following:
This issue is fixed in all currently supported versions. Please review the Fixed In section to determine the latest available patch your instance can be upgraded to.
On earlier releases, the workaround consisted in update the dictionary entry below by setting Reference cascade rule = None, not the default -- None --. This was also part of the official patch, and should not be reverted:
Navigate to /sys_dictionary_list.do.
Find the Dictionary Entry for Table = ecc_agent_script_file, Column name = script_attachment.
Under Related Links, click Advanced View.
Under Reference Specification - Additional Customization look for Reference cascade rule and select None from the drop-down, not the default -- None --.
See the screenshot below:
- Clear the MID Server ECC queue if required, to avoid unprocessed messages to be sent.
Restart the MID Server node.
Related Problem: PRB1204637