ClaimCenter涉事方页面无法更新ContactManager联系人报错问题

问题表现 #

• 在ClaimCenter涉事方页面尝试更新ContactManager中存储的联系人数据时，未按照预期修改已有联系人记录，反而触发了contact表新记录插入逻辑，最终操作失败报错

完整错误栈（中文翻译） #

com.guidewire.pl.system.exception.DBException: 批量更新执行失败
at com.guidewire.pl.system.transaction.ConnectionHandler.newDbException(ConnectionHandler.java:1422) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.transaction.ConnectionHandler.executeBatchUpdate(ConnectionHandler.java:871) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.entitywriter.TableWriterImpl.insert(TableWriterImpl.java:94) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.entitywriter.DatabaseEntityWriterImpl.insert(DatabaseEntityWriterImpl.java:68) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.DatabaseChangedBeanWriter.writeBeanInserts(DatabaseChangedBeanWriter.java:296) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.DatabaseChangedBeanWriter.writeBeanChanges(DatabaseChangedBeanWriter.java:234) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.DatabaseChangedBeanWriter.writeChangedBeans(DatabaseChangedBeanWriter.java:81) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.bundle.BundleWriter.commitBundle(BundleWriter.java:146) ~[pl-10.101.0.jar:?]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [jetty-util-9.4.30.v20200611.jar:9.4.30.v20200611]
at java.lang.Thread.run(Thread.java:834) [?:?]
Suppressed: java.lang.IllegalArgumentException: 键值非法，bean类 = entity.CompanyVendor, id = -489001
at com.guidewire.pl.system.database.impl.DBRestriction.compare(DBRestriction.java:164) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.impl.DBRestriction.compareEquals(DBRestriction.java:153) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.entitywriter.TableWriterImpl.checkForDuplicateKeyInDatabase(TableWriterImpl.java:694) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.entitywriter.TableWriterImpl.checkForDuplicateKeyExceptionForMostDBs(TableWriterImpl.java:638) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.entitywriter.TableWriterImpl.checkForDuplicateKeyException(TableWriterImpl.java:357) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.entitywriter.TableWriterImpl.insert(TableWriterImpl.java:96) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.entitywriter.DatabaseEntityWriterImpl.insert(DatabaseEntityWriterImpl.java:68) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.DatabaseChangedBeanWriter.writeBeanInserts(DatabaseChangedBeanWriter.java:296) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.DatabaseChangedBeanWriter.writeBeanChanges(DatabaseChangedBeanWriter.java:234) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.database.DatabaseChangedBeanWriter.writeChangedBeans(DatabaseChangedBeanWriter.java:81) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.bundle.BundleWriter.commitBundle(BundleWriter.java:146) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.transaction.SessionImpl.flush(SessionImpl.java:111) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.transaction.SessionImpl.commit(SessionImpl.java:169) ~[pl-10.101.0.jar:?]
at com.guidewire.pl.system.transaction.TransactionManagerImpl.execute(TransactionManagerImpl.java:94) ~[pl-10.101.0.jar:?]
at java.lang.Thread.run(Thread.java:834) [?:?]
Caused by: java.sql.BatchUpdateException: INSERT语句与FOREIGN KEY约束"FK__cc_contac__Conta__6231487C"冲突。冲突发生在数据库"cc_v8backup"，表"dbo.cc_contact"的'ID'列
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2075) ~[mssql-jdbc-8.2.2.jre11.jar:?]
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at com.guidewire.pl.system.database.jdbcwrappers.PreparedStatementDebugHandler.executeBatch(PreparedStatementDebugHandler.java:371) ~[pl-10.101.0.jar:?]
at jdk.internal.reflect.GeneratedMethodAccessor193.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at com.guidewire.pl.system.database.jdbcwrappers.StatementDebugHandler.invoke(StatementDebugHandler.java:66) ~[pl-10.101.0.jar:?]
at com.sun.proxy.$Proxy67.executeBatch(Unknown Source) ~[?:?]
at com.guidewire.pl.system.transaction.ConnectionHandler.executeBatchUpdate(ConnectionHandler.java:857) ~[pl-10.101.0.jar:?]
... 78 more

根因定位 #

从错误信息可得到两个核心判断依据：

1. 被抑制的参数异常：系统尝试插入的CompanyVendor实体ID为负数（-489001），这是Guidewire平台中未持久化临时实体的典型标识，说明系统未正确关联到ContactManager中已有的持久化联系人实体，反而将其识别为全新实体执行插入逻辑
2. 底层SQL约束异常：插入关联表时引用的cc_contact.ID不存在，完全符合系统尝试插入关联记录、但未先创建对应contact主记录的逻辑特征

修复方案 #

• 检查涉事方页面的联系人绑定逻辑，确认修改联系人时是否正确从ContactManager拉取已持久化的实体（带正ID），而非新构造空的临时实体
• 验证ClaimCenter与ContactManager的集成配置，确认联系人同步映射规则是否正确，是否存在实体关联字段丢失的问题
• 排查自定义代码中是否存在修改联系人时误将持久化实体转为临时实体、或者未正确赋值实体关联ID的逻辑

内容的提问来源于stack exchange，提问作者CodeForLife