CMP not playing nicely with tU_table on MS SQL Server

[wcydaip]

I have a Customer table with a relationship to an EyeColorCode table. The eyeColorCode is maintained on inserts and updates through Sql Server triggers. Both triggers do basically the same check.

Inserts behave as expected but updates aren't working.

However, if I remove the tU_Customer, the update executes successfully? This is, unfortunately, not an option.

I was wondering if there is a setting that I need to flip in order for this to complete successfully?

The error states:

org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[
...
Update failed. Expected one affected row: rowsAffected=0, id=tableid

[wcydaip]

Looks to be the fault of the trigger. Had some wild variation of sql. Sorry for the claim.