1/7用友股份-LE支持服务业务本部技术方案--《NC57销售订单流水号问题》建立日期：2013-10-20修改日期：xxxx-xx-xx文档属性：客户文控编号：LE-DY-JS-2013-01192/7文档控制创建记录适用范围审阅人日期审阅签字所属部门发布范围发布人姓名所属部门发布时间内部员工伙伴客户日期作者所属部门邮件地址版本2013-10-20白晓宇技术支持部V1.0版本领域模块备注NC573/7目录NC57销售订单流水号问题......................................................................................4一、问题描述：........................................................................................................4二、问题处理：........................................................................................................44/7NC57销售订单流水号问题一、问题描述：Nc5.7版本销售订单、销售收款单保存时提示【由于网络不稳定，可能已经生成此单据致，请检查后，进行确认！您提供的单据编码不唯一，系统无法保存】。导致销售订单无法保存。二、问题处理：通过nmc获取日志，后台没有具体的错误，只有前台有提示：AWT-EventQueue-2]ERROR-您提供的单据编码不唯一，系统无法保存nc.vo.uap.pf.PFBusinessException:您提供的单据编码不唯一，系统无法保存atnc.bs.pub.pf.PfUtilTools.runClass(PfUtilTools.java:1308)atnc.bs.pub.compiler.AbstractCompiler.runClass(AbstractCompiler.java:417)atnc.bs.pub.action.N_30_PreKeep.runComClass(N_30_PreKeep.java:150)atnc.bs.pub.pf.pfframe.PFRunClass.runComBusi(PFRunClass.java:119)atnc.bs.pub.pf.pfframe.PFBusiAction.actionOnStep(PFBusiAction.java:255)atnc.bs.pub.pf.pfframe.PFBusiAction.processAction(PFBusiAction.java:678)atnc.itf.uap.pf.PlatformEJBEjbBean.processAction(PlatformEJBEjbBean.java:673)atnc.itf.uap.pf.EJSLocalStatelessnc_itf_uap_pf_PlatformEJB_7d0a933a.processAction(UnknownSource)atsun.reflect.GeneratedMethodAccessor668.invoke(UnknownSource)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method.invoke(Method.java:618)atnc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:56)atnc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:34)5/7at$Proxy107.processAction(UnknownSource)atnc.bs.pub.pf.pfframe.PlatFormEntryImpl.processAction(PlatFormEntryImpl.java:74)atsun.reflect.GeneratedMethodAccessor3773.invoke(UnknownSource)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method.invoke(Method.java:618)atnc.bs.framework.comn.serv.ServiceDispatcher.invokeBeanMethod(ServiceDispatcher.java:351)atnc.bs.framework.comn.serv.ServiceDispatcher.execCall(ServiceDispatcher.java:160)atnc.bs.framework.comn.serv.CommonServletDispatcher.doGet(CommonServletDispatcher.java:75)atnc.bs.framework.comn.serv.CommonServletDispatcher.doPost(CommonServletDispatcher.java:95)Causedby:java.sql.SQLException:您提供的单据编码不唯一，系统无法保存提示编码不唯一，到nclogs中查看后台日志发下了下面的提示：$debuglevel=ERROR$$msg=没有多余的单据号可供分配，获得单据号失败nc.vo.pub.ValidationException:没有多余的单据号可供分配，获得单据号失败atnc.impl.uap.sfapp.BillCode.getSequenceBillCode(BillCode.java:341)atnc.impl.uap.sfapp.BillCode.getBillCode(BillCode.java:197)atnc.impl.uap.sfapp.BillCodeMemoryManager.getNewBillCode(BillCodeMemoryManager.java:191)atnc.impl.uap.sfapp.BillcodeRuleImpl.getBillCodeByRule0(BillcodeRuleImpl.java:503)atnc.impl.uap.sfapp.BillcodeRuleImpl.getBillCodeByRule_RequiresNew(BillcodeRuleImpl.java:474)6/7atnc.impl.uap.sfapp.BillcodeRuleImpl.getBillCode_RequiresNew(BillcodeRuleImpl.java:435)atnc.itf.uap.sfapp.SFAppEJBEjbBean.getBillCode_RequiresNew(SFAppEJBEjbBean.java:969)atnc.itf.uap.sfapp.EJSLocalStatelessnc_itf_uap_sfapp_SFAppEJB_6294585a.getBillCode_RequiresNew(UnknownSource)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method.invoke(Method.java:618)atnc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:56)atnc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:34)at$Proxy59.getBillCode_RequiresNew(UnknownSource)atnc.bs.pub.billcodemanage.BillcodeGenerater.getBillCode(BillcodeGenerater.java:135)atnc.impl.scm.so.pub.CheckValueValidityImpl.getSysBillNO(CheckValueValidityImpl.java:311)atnc.impl.scm.so.so001.SaleOrderDMO.insert(SaleOrderDMO.java:1959)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method.invoke(Method.java:618)7/7通过上面的提示看到，是无法分配单据号了，经过查证，发现流水号已经到了最大值，无法继续分配了，也没有返回从头继续。顾问将流水号设置按日清零，重启环境就好了。
