银行发报文2615返回报错unique constraint

最新推荐文章于 2023-05-20 01:16:06 发布

cuiwei_saidelike

最新推荐文章于 2023-05-20 01:16:06 发布

阅读量515

点赞数

分类专栏：其他电子化支付文章标签：大数据文档资料

本文链接：https://blog.csdn.net/cuiwei_saidelike/article/details/125683501

版权

在与银行交互过程中遇到Oracle数据库报错：ORA-00001 unique constraint (SPQ_NMG.UK_FPF_NOTICE_NONTAX_LOG) violated，该错误源于触发器SPQ_NMG.ZHH_FPF_CAPITAL_RECEIVE执行时违反了唯一约束。日志显示在尝试更新FPF_CAPITAL_RECEIVE表时，遇到了重复数据问题。解决方案是删除重复数据，允许银行重新发送报文。

摘要由CSDN通过智能技术生成

ORA-0001: unique constraint (spq_nmg.uk_fpf_notice_nontax_log)violated

ORA-06512: at "spq_nmg.zhh_fpf_capital_receive", line 105

ORA-04088: error during execution of trigger ' spq_nmg.zhh_fpf_capital_receive'

与银行沟通，找到最近一次发的报文，未发现有错误，但日志后有大量报错。。。。。

11:01:07.682 E [executor-30] c.b.n.p.d.n.h.ServerHandlerPatch [ServerHandlerPatch.java:71] 处理报文出错
org.springframework.dao.DuplicateKeyException:
### Error querying database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SPQ_NMG.UK_FPF_NOTICE_NONTAX_LOG) violated
ORA-06512: at "SPQ_NMG.ZHH_FPF_CAPITAL_RECEIVE", line 105
ORA-04088: error during execution of trigger 'SPQ_NMG.ZHH_FPF_CAPITAL_RECEIVE'

### The error may exist in URL [jar:file:/opt/bosssoft/ntpay-produce-front/lib/ntpay-domain-all-0.3.0-SNAPSHOT.jar!/mybatis/mappers/capital/CapitalReceive.xml]
##