uniqueness

The Interaction Concentrator Application template includes a preconfigured error reaction set to ignore unique constraint violations:

• Option Name: uniqueness
• Option Value: error=unique;reaction=ignore

The default option name, uniqueness, is correct for Oracle RDBMSs, but not for Microsoft SQL Server, PostgreSQL, or DB2 databases. If you are using a Microsoft SQL Server, PostgreSQL, or DB2 database, consult the documentation for your RDBMS to determine the correct error value, and then configure this option accordingly. For example, if the error returned by your Microsoft SQL Server database in reaction to violation of the uniqueness constraint is duplicate, configure the option as follows: error=duplicate; reaction=ignore.