Root Cause:
The problem and error message can be caused by any customization or coding changes made to any or all of the SQL views used in the functionality of this export event. If a client has made a change to the code, such as include code to restrict the output to a specific reporting year, then records may not be successfully selected, and the functionality of the event will be broken.
Environment:
IRS 1098/1099 Export Event - Selecting to Include 1099-INTWorkaround:
The client should review all of the SQL views delivered and used in this export, to see if any custom code has been added. The custom code should be removed and the event can then be re-run.
The SQL views accessed by the 1099-INT portion of the IRS 1098/1099 export are the following :
Q_IRS_1099INT_Export
Q_IRS_1099INT_Export_With_StateCode
Q_IRS_1099INT_Export_ReportAllAmts
Q_IRS_1099INT_Export_ReportAllAmts_With_StateCode
ArticleNumber:
000044235