Event Manager IRS 1098/1099 Export Error: Invalid Column Name AcquisitionDate

Event Manager IRS 1098/1099 Export Error: Invalid Column Name AcquisitionDate

The event failed and reported this error:

Database Error

Invalid column name 'AcquisitionDate'.
Statement(s) could not be prepared.

Root Cause:

This error is caused by applying only one of two parts of the Fusion Servicing Director 19.4.1 or 19.4.2 service packs, leaving one part not installed. 
The error indicates the Servicing Director 19.4.1 or 19.4.2 Database Update part was not installed.

Workaround:

If you receive this error, the Servicing Director desktop applications running the export event have already been updated to either 19.4.1 or 19.4.2. 
Note: If you have 19.4.1 only installed on the applications, then you should install the 19.4.2 service pack on the applications because it is a replacement for the 19.4.1 service pack. 

To resolve the error, install the Database Update which matches the version of the service pack installed on the desktop applications. Install the Database Update on the Servicing Director SQL server by installing the service pack file named "SD Database Update.msi".

ArticleNumber:

000041851