Servicing Director Analysis Error Trial Calculation Error: "Failed to Disable PaymentChange Triggers..."
Failed to Disable PaymentChange Triggers.
Error: SELECT failed because the following SET options have incorrect settings: 'CONCAT__YIELDS_', verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
Root Cause:
The Analysis Trial Calculation changes the database tables in unique ways, and if your database administrator has added database monitoring of table changes, this added database monitoring can have the error above.
Workaround:
This information is for your local IT or database administrator.
- The Trial Calculation will temporarily disable certain Payment Change related database Triggers and then re-enable them.
- These changes are done using database ALTER commands.
- If the database administrator has added SQL Data Definition Language (DDL) trigger events to the server, monitoring TableChangeTracking on DATABASE FOR ALTER_TABLE, then the DDL trigger may have the SQL error above if the DDL trigger added does not have the correct SQL SET options. Change your DDL triggers so that they do not cause the error for the Servicing Director product.
ArticleNumber:
000043377