应收单审核报ORA-01407错误,请帮忙分析解决,多谢!
金蝶云社区-华正科技_张华义
华正科技_张华义
0人赞赏了该文章 1,927次浏览 未经作者许可,禁止转载编辑于2015年12月09日 11:12:17

EAS7.5版本,应收单审核时报中断错误,错误信息如下:
错误信息:null
Caused exception message is: ORA-01407: cannot update ("SCM75"."T_SD_SALEORDERENTRY"."FTOTALINVOICEDQTY") to NULL
错误详细堆栈信息:com.kingdee.bos.BOSException: null
Caused exception message is: ORA-01407: cannot update ("SCM75"."T_SD_SALEORDERENTRY"."FTOTALINVOICEDQTY") to NULL
at com.kingdee.eas.scm.common.AbstractWriteBackHandler.handle(AbstractWriteBackHandler.java:180)
at com.kingdee.eas.fi.ar.app.OtherBillControllerBean._audit(OtherBillControllerBean.java:2721)
at com.kingdee.eas.fi.ar.app.AbstractOtherBillControllerBean.audit(AbstractOtherBillControllerBean.java:247)
at sun.reflect.GeneratedMethodAccessor3218.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:60)
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 $Proxy714.audit(Unknown Source)
at com.kingdee.eas.fi.ar.OtherBill.audit(OtherBill.java:163)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_ar_1_IOtherBill.pi95(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_ar_1_IOtherBill.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
Caused by: java.sql.SQLException: ORA-01407: cannot update ("SCM75"."T_SD_SALEORDERENTRY"."FTOTALINVOICEDQTY") to NULL
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.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at com.kingdee.bos.sql.shell.KDPreparedStatement.execute(KDPreparedStatement.java:264)
at com.apusic.jdbc.adapter.PreparedStatementHandle.execute(Unknown Source)
at com.kingdee.eas.scm.common.AbstractWriteBackHandler.executeUpdate(AbstractWriteBackHandler.java:161)
at com.kingdee.eas.scm.common.AR2SIWriteBackHandler.batchWriteBackOrder(AR2SIWriteBackHandler.java:329)
at com.kingdee.eas.scm.common.AR2SIWriteBackHandler.doHandle(AR2SIWriteBackHandler.java:447)
at com.kingdee.eas.scm.common.AbstractWriteBackHandler.handle(AbstractWriteBackHandler.java:177)
... 20 more
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-01407: cannot update ("SCM75"."T_SD_SALEORDERENTRY"."FTOTALINVOICEDQTY") to NULL
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.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at com.kingdee.bos.sql.shell.KDPreparedStatement.execute(KDPreparedStatement.java:264)
at com.apusic.jdbc.adapter.PreparedStatementHandle.execute(Unknown Source)
at com.kingdee.eas.scm.common.AbstractWriteBackHandler.executeUpdate(AbstractWriteBackHandler.java:161)
at com.kingdee.eas.scm.common.AR2SIWriteBackHandler.batchWriteBackOrder(AR2SIWriteBackHandler.java:329)
at com.kingdee.eas.scm.common.AR2SIWriteBackHandler.doHandle(AR2SIWriteBackHandler.java:447)
at com.kingdee.eas.scm.common.AbstractWriteBackHandler.handle(AbstractWriteBackHandler.java:177)
at com.kingdee.eas.fi.ar.app.OtherBillControllerBean._audit(OtherBillControllerBean.java:2721)
at com.kingdee.eas.fi.ar.app.AbstractOtherBillControllerBean.audit(AbstractOtherBillControllerBean.java:247)
at sun.reflect.GeneratedMethodAccessor3218.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:60)
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 $Proxy714.audit(Unknown Source)
at com.kingdee.eas.fi.ar.OtherBill.audit(OtherBill.java:163)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_ar_1_IOtherBill.pi95(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_ar_1_IOtherBill.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)