领料申请单 拉式生成 领料出库单保存时报错
金蝶云社区-768386603
768386603
0人赞赏了该文章 1,239次浏览 未经作者许可,禁止转载编辑于2015年09月07日 23:42:30

领料申请单拉式生成领料出库单时,提示如下错误--------------------------------

错误信息:update data error.ORA-00001: unique constraint (EASTEST.PK_MATELREQENTRY) violated
Caused exception message is: ORA-00001: unique constraint (EASTEST.PK_MATELREQENTRY) violated
错误详细堆栈信息:com.kingdee.bos.dao.ormapping.SQLAccessException: update data error.ORA-00001: unique constraint (EASTEST.PK_MATELREQENTRY) violated
Caused exception message is: ORA-00001: unique constraint (EASTEST.PK_MATELREQENTRY) violated
at com.kingdee.bos.dao.ormapping.ORMappingDAO.updateBigObject(ORMappingDAO.java:789)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.update(ORMappingDAO.java:749)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerUpdate(AbstractEntityControllerBean.java:322)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean._update(AbstractCoreBaseControllerBean.java:178)
at com.kingdee.eas.framework.app.CoreBaseControllerBean._update(CoreBaseControllerBean.java:106)
at com.kingdee.eas.framework.app.ObjectBaseControllerBean._update(ObjectBaseControllerBean.java:160)
at com.kingdee.eas.scm.im.inv.app.InvBillBaseControllerBean._update(InvBillBaseControllerBean.java:5186)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.update(AbstractCoreBaseControllerBean.java:164)
at com.kingdee.eas.framework.app.CoreBaseControllerBean._save(CoreBaseControllerBean.java:230)
at com.kingdee.eas.framework.app.CoreBillBaseControllerBean._save(CoreBillBaseControllerBean.java:104)
at com.kingdee.eas.scm.common.app.SCMBillBaseControllerBean._save(SCMBillBaseControllerBean.java:726)
at com.kingdee.eas.scm.im.inv.app.InvBillBaseControllerBean._save(InvBillBaseControllerBean.java:921)
at com.kingdee.eas.scm.im.inv.app.MaterialReqBillControllerBean._save(MaterialReqBillControllerBean.java:348)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.save(AbstractCoreBaseControllerBean.java:450)
at sun.reflect.GeneratedMethodAccessor381.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:57)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy157.save(Unknown Source)
at com.kingdee.eas.framework.CoreBase.save(CoreBase.java:315)
at sun.reflect.GeneratedMethodAccessor380.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:193)
at $Proxy156.save(Unknown Source)
at com.kingdee.eas.base.btp.app.BTPManagerControllerBean.innerSaveModelAndRelations(BTPManagerControllerBean.java:759)
at com.kingdee.eas.base.btp.app.BTPManagerControllerBean._saveRelations(BTPManagerControllerBean.java:711)
at com.kingdee.eas.base.btp.app.AbstractBTPManagerControllerBean.saveRelations(AbstractBTPManagerControllerBean.java:528)
at sun.reflect.GeneratedMethodAccessor436.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:57)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy206.saveRelations(Unknown Source)
at com.kingdee.eas.base.btp.BTPManager.saveRelations(BTPManager.java:409)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_btp_1_IBTPManager.pi18(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_base_1_btp_1_IBTPManager.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:629)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:125)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:24)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:103)
Caused by: java.sql.SQLException: ORA-00001: unique constraint (EASTEST.PK_MATELREQENTRY) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10643)
at com.kingdee.bos.sql.shell.KDStatement.executeBatch(KDStatement.java:415)
at com.apusic.jdbc.adapter.StatementHandle.executeBatch(Unknown Source)
at com.kingdee.bos.dao.ormapping.impl.BatchPreparedStatement.closeInternal(BatchPreparedStatement.java:70)
at com.kingdee.bos.dao.ormapping.impl.BatchConnection.closeStatements(BatchConnection.java:171)
at com.kingdee.bos.dao.ormapping.impl.AbstractObjectHandler.close(AbstractObjectHandler.java:197)
at com.kingdee.bos.dao.ormapping.impl.ObjectCUDFactory.close(ObjectCUDFactory.java:37)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.updateBigObject(ORMappingDAO.java:783)
... 49 more
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-00001: unique constraint (EASTEST.PK_MATELREQENTRY) violated

------------------
查了提示的约束是 领料出库单分录fid的唯一索引。分录表中没有重复的fid,领料出库单的fid也没有重复。
而且单独新增领料出库单均正常;虽然领料申请单拉式生成领料出库单保存提交时提示错误,但其实已经生成领料出库单,重新修改此领料出库单,保存提交正常。也能证明领料出库单及分录表数据是正常的。
领料申请单新增、保存提交、审核均正常。
是转换关系中的数据问题?错误日志也提示保存转换关系错误的部分。
该如何确定此问题的原因呢?如何解决呢?请达人指教!