这是我查询到的操作删行时的debug后台代码:
[AWT-EventQueue-2] DEBUG - executeBatch sql: select distinct areaclcode,areaclname,pk_areacl,pk_fatherarea,mnecode from bd_areaclwhere 11=11and (pk_areacl in (select distinct power.resource_data_id from sm_power_areaclass power,sm_user u,sm_user_role urole where u.cuserid='0001X110000000000XZ7' and u.cuserid=urole.cuseridand urole.pk_corp='0001' and urole.pk_role=power.pk_role and power.orgtypecode=1 and (power.pk_org='0001' or iscommon_power in('y','Y')))) and (pk_areacl='0001X110000000000ZLK' )order by areaclcode
[AWT-EventQueue-2] DEBUG - executeBatch sql: select distinct doccode,docname,pk_defdoc,pk_defdoc1 from bd_defdocwhere 11=11and (sealflag is null or sealflag 'Y')and (pk_defdoc='ORGCORP00000000A0132' )order by doccode
[AWT-EventQueue-2] DEBUG - enter method: nc.itf.uap.busibean.IRef.queryMainBatch([Ljava.lang.String
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.busibean.IRef.queryMainBatch write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.busibean.IRef.queryMainBatch read result from server spend time: 16
[AWT-EventQueue-2] DEBUG - leave method: nc.itf.uap.busibean.IRef.queryMainBatch([Ljava.lang.String
, spend time: 16
[AWT-EventQueue-2] INFO - ExecBatchRefSetPk taken time:16ms.
[AWT-EventQueue-2] INFO - 单据模板加载业务数据所用时间:16 ms
[AWT-EventQueue-2] DEBUG - 开始解析公式:[copycode->custcode, copycode1->custcode, copyname->custname, copyname1->custname, tradename->getColValue(bd_defdoc,docname,pk_defdoc,trade), custbas_code->getColValue(bd_cubasdoc,custcode,pk_cubasdoc,pk_cubasdoc1), corp_code->getColValue(bd_corp,unitcode,pk_corp,pk_corp1), unitname-> getColValue(bd_settleunit,settleunitname,pk_settleunit,correspondunit), areacl_name->getColValue(bd_areacl,areaclname,pk_areacl,pk_areacl), ecotype_name->getColValue(bd_defdoc,docname,pk_defdoc,ecotypesincevfive), pricegroupname->getColValue(bd_defdoc,docname,pk_defdoc,pk_pricegroup)]
[AWT-EventQueue-2] DEBUG - 开始拆分解析公式....
[AWT-EventQueue-2] DEBUG - 解析公式结束!
[AWT-EventQueue-2] DEBUG - 开始从公式中取得变量...
[AWT-EventQueue-2] DEBUG - 返回公式中的变量!
[AWT-EventQueue-2] DEBUG - 开始从公式中取得变量...
[AWT-EventQueue-2] DEBUG - 返回公式中的变量!
[AWT-EventQueue-2] DEBUG - 开始取公式的值...
[AWT-EventQueue-2] DEBUG - 公式[custcode]执行结果为:[02002101009]
[AWT-EventQueue-2] DEBUG - 公式[custcode]执行结果为:[02002101009]
[AWT-EventQueue-2] DEBUG - 公式[custname]执行结果为:[上海歆瑞装饰材料有限公司]
[AWT-EventQueue-2] DEBUG - 公式[custname]执行结果为:[上海歆瑞装饰材料有限公司]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[null]
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_defdoc,docname,pk_defdoc,trade)]执行结果为:[null]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[null]
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_cubasdoc,custcode,pk_cubasdoc,pk_cubasdoc1)]执行结果为:[null]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[null]
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_corp,unitcode,pk_corp,pk_corp1)]执行结果为:[null]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[null]
[AWT-EventQueue-2] DEBUG - 公式[ getColValue(bd_settleunit,settleunitname,pk_settleunit,correspondunit)]执行结果为:[null]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[0001X110000000000ZLK]
调试: 公司数据没下载,开始从后台查询公式SELECT
bd_areacl.areaclname
FROM
bd_areacl
WHERE
bd_areacl.pk_areacl = ?
[AWT-EventQueue-2] DEBUG - enter method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues read result from server spend time: 0
[AWT-EventQueue-2] DEBUG - leave method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object
, spend time: 0
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_areacl,areaclname,pk_areacl,pk_areacl)]执行结果为:[上海地材类供应商名录]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[ORGCORP00000000A0132]
调试: 公司数据没下载,开始从后台查询公式SELECT
bd_defdoc.docname
FROM
bd_defdoc
WHERE
bd_defdoc.pk_defdoc = ?
[AWT-EventQueue-2] DEBUG - enter method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues read result from server spend time: 16
[AWT-EventQueue-2] DEBUG - leave method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object
, spend time: 16
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_defdoc,docname,pk_defdoc,ecotypesincevfive)]执行结果为:[有限责任(公司)]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[null]
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_defdoc,docname,pk_defdoc,pk_pricegroup)]执行结果为:[null]
[AWT-EventQueue-2] DEBUG - 还原公式信息...
[AWT-EventQueue-2] DEBUG - 开始解析公式:[account->getColValue(bd_accbank ,bankacc,pk_accbank,pk_accbank), accname->getColValue(bd_accbank ,bankname,pk_accbank,pk_accbank), accaddr->getColValue(bd_accbank ,address,pk_accbank,pk_accbank), memo->getColValue(bd_accbank ,memo,pk_accbank,pk_accbank), pk_currtype->getColValue(bd_accbank ,pk_currtype,pk_accbank,pk_accbank), currtypecode->getColValue(bd_currtype ,currtypecode ,pk_currtype ,pk_currtype ), currtypename->getColValue(bd_currtype ,currtypename ,pk_currtype ,pk_currtype )]
[AWT-EventQueue-2] DEBUG - 开始拆分解析公式....
[AWT-EventQueue-2] DEBUG - 解析公式结束!
[AWT-EventQueue-2] DEBUG - 开始从公式中取得变量...
[AWT-EventQueue-2] DEBUG - 返回公式中的变量!
[AWT-EventQueue-2] DEBUG - 开始从公式中取得变量...
[AWT-EventQueue-2] DEBUG - 返回公式中的变量!
[AWT-EventQueue-2] DEBUG - 开始取公式的值...
[AWT-EventQueue-2] DEBUG - getColValue参数值=[0001X1100000000037BN]
调试: 公司数据没下载,开始从后台查询公式SELECT
bd_accbank.bankacc
FROM
bd_accbank
WHERE
bd_accbank.pk_accbank = ?
[AWT-EventQueue-2] DEBUG - enter method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues read result from server spend time: 0
[AWT-EventQueue-2] DEBUG - leave method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object
, spend time: 0
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_accbank ,bankacc,pk_accbank,pk_accbank)]执行结果为:[32779508010106493]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[0001X1100000000037BN]
调试: 公司数据没下载,开始从后台查询公式SELECT
bd_accbank.bankname
FROM
bd_accbank
WHERE
bd_accbank.pk_accbank = ?
[AWT-EventQueue-2] DEBUG - enter method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues read result from server spend time: 15
[AWT-EventQueue-2] DEBUG - leave method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object
, spend time: 15
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_accbank ,bankname,pk_accbank,pk_accbank)]执行结果为:[上海农村商业银行九亭支行]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[0001X1100000000037BN]
调试: 公司数据没下载,开始从后台查询公式SELECT
bd_accbank.address
FROM
bd_accbank
WHERE
bd_accbank.pk_accbank = ?
[AWT-EventQueue-2] DEBUG - enter method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;)
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues read result from server spend time: 0
[AWT-EventQueue-2] DEBUG - leave method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;), spend time: 0
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_accbank ,address,pk_accbank,pk_accbank)]执行结果为:[null]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[0001X1100000000037BN]
调试: 公司数据没下载,开始从后台查询公式SELECT
bd_accbank.memo
FROM
bd_accbank
WHERE
bd_accbank.pk_accbank = ?
[AWT-EventQueue-2] DEBUG - enter method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;)
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues read result from server spend time: 16
[AWT-EventQueue-2] DEBUG - leave method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;), spend time: 16
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_accbank ,memo,pk_accbank,pk_accbank)]执行结果为:[null]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[0001X1100000000037BN]
调试: 公司数据没下载,开始从后台查询公式SELECT
bd_accbank.pk_currtype
FROM
bd_accbank
WHERE
bd_accbank.pk_accbank = ?
[AWT-EventQueue-2] DEBUG - enter method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;)
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues read result from server spend time: 0
[AWT-EventQueue-2] DEBUG - leave method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;), spend time: 0
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_accbank ,pk_currtype,pk_accbank,pk_accbank)]执行结果为:[00010000000000000001]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[00010000000000000001]
调试: 公司数据没下载,开始从后台查询公式SELECT
bd_currtype.currtypecode
FROM
bd_currtype
WHERE
bd_currtype.pk_currtype = ?
[AWT-EventQueue-2] DEBUG - enter method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;)
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues read result from server spend time: 0
[AWT-EventQueue-2] DEBUG - leave method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;), spend time: 0
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_currtype ,currtypecode ,pk_currtype ,pk_currtype )]执行结果为:[CNY]
[AWT-EventQueue-2] DEBUG - getColValue参数值=[00010000000000000001]
调试: 公司数据没下载,开始从后台查询公式SELECT
bd_currtype.currtypename
FROM
bd_currtype
WHERE
bd_currtype.pk_currtype = ?
[AWT-EventQueue-2] DEBUG - enter method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;)
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.mw.MwBizEJB.findColumnValues read result from server spend time: 16
[AWT-EventQueue-2] DEBUG - leave method: nc.bs.dbcache.intf.IDBCacheBS.findColumnValues(nc.vo.dbcache.query.QueryClause,[Ljava.lang.Object;), spend time: 16
[AWT-EventQueue-2] DEBUG - 公式[getColValue(bd_currtype ,currtypename ,pk_currtype ,pk_currtype )]执行结果为:[人民币]
[AWT-EventQueue-2] DEBUG - 还原公式信息...
[AWT-EventQueue-2] DEBUG - enter method: nc.itf.uap.bd.cust.ICuBasDocTmp.update(nc.vo.bd.b08.CubasdocVO)
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.bd.BusiScmEJB.update write info to server spend time: 0
[AWT-EventQueue-2] DEBUG - Invoke nc.itf.uap.bd.BusiScmEJB.update read result from server spend time: 31
[AWT-EventQueue-2] DEBUG - leave method: nc.itf.uap.bd.cust.ICuBasDocTmp.update(nc.vo.bd.b08.CubasdocVO), spend time: 31
[AWT-EventQueue-2] ERROR - ORA-20001: 已从网银付款,不能修改名称,请取消!
ORA-06512: 在 "XMV502.DELBD_CUSTBANKNET", line 26
ORA-04088: 触发器 'XMV502.DELBD_CUSTBANKNET' 执行过程中出错
java.lang.RuntimeException: ORA-20001: 已从网银付款,不能修改名称,请取消!
ORA-06512: 在 "XMV502.DELBD_CUSTBANKNET", line 26
ORA-04088: 触发器 'XMV502.DELBD_CUSTBANKNET' 执行过程中出错
at nc.impl.uap.bd.cust.CustBasDocDAO.update(CustBasDocDAO.java:1375)
at nc.impl.uap.bd.cust.CubasdocImpl.update(CubasdocImpl.java:104)
at nc.impl.uap.bd.BusiScmEJB.update(BusiScmEJB.java:595)
at nc.itf.uap.bd.BusiScmEJBEjbBean.update(BusiScmEJBEjbBean.java:348)
at nc.itf.uap.bd.BusiScmEJB_Local.update(BusiScmEJB_Local.java:2332)
at sun.reflect.GeneratedMethodAccessor4848.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at nc.bs.framework.server.AbstractEJBToBServiceHandler.invoke(AbstractEJBToBServiceHandler.java:79)
at nc.bs.framework.server.AbstractEJBToBServiceHandler.invoke(AbstractEJBToBServiceHandler.java:54)
at $Proxy26.update(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at nc.bs.framework.comn.serv.ServiceDispatcher.invokeBeanMethod(ServiceDispatcher.java:320)
at nc.bs.framework.comn.serv.ServiceDispatcher.execCall(ServiceDispatcher.java:129)
at nc.bs.framework.comn.serv.CommonServletDispatcher.doGet(CommonServletDispatcher.java:76)
at nc.bs.framework.comn.serv.CommonServletDispatcher.doPost(CommonServletDispatcher.java:95)
可以看出已经生效了,只是不明白为什么不弹出错误框 |