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:
- Go to System Administration > End Of Day Updates > Mailing Address - Seasonal Address upd
- 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