Due to a dictionary entry change related to support being added for attachments on MID Server Script Files, a multiple update database execution is performed when an attachment is deleted 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:
Topic: SystemCommand, Source: FileChange, Name: ecc_agent_script_file, Queue: output
Update the following dictionary entry and set Reference cascade rule = None, not the default -- None --. This is 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