End Of Year Rollover Displays Error Running Stored Procedure MailingAddress

End Of Year Rollover Displays Error Running Stored Procedure MailingAddress

The event failed and reported this error:

Error Running Stored Procedure: Cannot add or change record. Referential integrity rules require a related record in table MailingAddress.  
The transaction ended in the trigger. The batch has been aborted.

Workaround:

  1. Go to System Administration > End Of Day Updates > Mailing Address - Seasonal Address upd
  2. Run the event Mailing Address - Seasonal Address upd at the beginning of the rollover event.
    Note: This update must be scheduled to run nightly. We strongly recommend that you run this update prior to running letters. 

ArticleNumber:

000043746