1/9用友股份-LE支持服务业务本部技术方案--《NC56异常设置导致取数问题》建立日期：2013-10-20修改日期：xxxx-xx-xx文档属性：客户文控编号：LE-DY-JS-2013-01182/9文档控制创建记录适用范围审阅人日期审阅签字所属部门发布范围发布人姓名所属部门发布时间内部员工伙伴客户日期作者所属部门邮件地址版本2013-10-20白晓宇技术支持部V1.0版本领域模块备注NC563/9目录NC56异常设置导致取数问题..................................................................................4一、问题描述：........................................................................................................4二、问题处理：........................................................................................................94/9NC56异常设置导致取数问题一、问题描述：客户是nc56，nc中间件，在取数的时候，前台一直在取数，有时候前台取完了，但是没有数据。查看nmc，发现线程一直在运行sql，一直在跑，等待事件是readfromclient.selectmiddledata.pk_order,middledata.pk_produce,middledata.istraned,middledata.scddh,middledata.invcode,middledata.invname,middledata.invspec,middledata.invtype,middledata.measname,middledata.cctcentercode,middledata.cctcentername,middledata.subfacname,sum(middledata.wgnumber),sum(middledata.zcnumber),sum(middledata.fpnumber),middledata.qccost,middledata.bqcost,middledata.ddlxfrom(selectbqqc.pk_order,bqqc.pk_produce,casewhensfjz.pk_produceisnullthen'否'else'是'endistraned,mo.scddh,invbas.invcode,invbas.invname,5/9invbas.invspec,invbas.invtype,meas.measname,ctc.cctcentercode,ctc.cctcentername,nullsubfacname,wg.nnumberwgnumber,zc.nnumberzcnumber,fp.nnumberfpnumber,bqqc.qccost,bqqc.bqcost,mo.ddlxfrom(selectpk_ctcenter,pk_order,pk_invbasdoc,pk_produce,nvl(sum(qccost),0)+nvl(sum(qcsubcost),0)qccost,nvl(sum(ncost),0)+nvl(sum(nsubcost),0)bqcostfrom(selecta.pk_ctcenter,a.pk_order,a.pk_invbasdoc,a.pk_produce,a.pk_subfac,0qccost,0qcsubcost,a.ncost,a.nsubcostfromcm_feea,bd_producepcewherea.pk_corp='1004'anda.pk_calbody='1004C1100000000006UC'anda.caccountyear='2013'anda.caccountmonth='05'anda.cbilltypecode!='MB'anda.idisposeflag=0andpce.sffzfw='N'anda.pk_produce=pce.pk_produceunionallselecta.pk_ctcenter,a.pk_order,a.pk_invbasdoc,a.pk_produce,a.pk_subfac,a.ncostqccost,a.nsubcostqcsubcost,6/90ncost,0nsubcostfromcm_costawherea.pk_corp='1004'anda.pk_calbody='1004C1100000000006UC'anda.caccountyear='2013'anda.caccountmonth='04'anda.ffeetypeflag=0anda.fcosttypeflag=1)xgroupbypk_ctcenter,pk_order,pk_invbasdoc,pk_produce)bqqcleftouterjoin(selectpk_ctcenter,pk_order,pk_produce,sum(nbasicnum)nbasicnum,sum(nnumber)nnumberfromcm_appronumwherepk_corp='1004'andpk_calbody='1004C1100000000006UC'andcaccountyear='2013'andcaccountmonth='05'anddr=0andffeetype=1groupbypk_ctcenter,pk_order,pk_produce)wgonbqqc.pk_ctcenter=wg.pk_ctcenterandbqqc.pk_order=wg.pk_orderandbqqc.pk_produce=wg.pk_produceleftouterjoin(selectdistinctpk_ctcenter,pk_order,pk_produce,nbasicnumnnumberfromcm_appronumwherepk_corp='1004'andpk_calbody='1004C1100000000006UC'7/9andcaccountyear='2013'andcaccountmonth='05'anddr=0and(ffeetype=0anddbilldate='2013-05-31'))zconbqqc.pk_ctcenter=zc.pk_ctcenterandbqqc.pk_order=zc.pk_orderandbqqc.pk_produce=zc.pk_produceleftouterjoin(selectpk_ctcenter,pk_order,pk_produce,sum(nnumber)nnumberfrom(selectdistinctpk_ctcenter,pk_order,pk_produce,nbasicnumnnumberfromcm_appronumwherepk_corp='1004'andpk_calbody='1004C1100000000006UC'andcaccountyear='2013'andcaccountmonth='05'anddr=0andffeetype=2)fpdetailgroupbypk_ctcenter,pk_order,pk_produce)fponbqqc.pk_ctcenter=fp.pk_ctcenterandbqqc.pk_order=fp.pk_orderandbqqc.pk_produce=fp.pk_produce8/9leftouterjoin(selectdistincta.pk_order,a.pk_invbasdoc,a.pk_producefromcm_costawherea.pk_corp='1004'anda.pk_calbody='1004C1100000000006UC'anda.caccountyear='2013'anda.caccountmonth='05')sfjzonbqqc.pk_order=sfjz.pk_orderandbqqc.pk_produce=sfjz.pk_produceleftouterjoinmm_momoonbqqc.pk_order=mo.pk_moid,cm_ctcenterctc,bd_invbasdocinvbas,bd_measdocmeaswherebqqc.pk_ctcenter=ctc.pk_ctcenterandbqqc.pk_invbasdoc=invbas.pk_invbasdocandinvbas.pk_measdoc=meas.pk_measdoc)middledatagroupbymiddledata.pk_order,middledata.pk_produce,middledata.istraned,middledata.scddh,middledata.invcode,middledata.invname,middledata.invspec,middledata.invtype,middledata.measname,middledata.cctcentercode,middledata.cctcentername,middledata.subfacname,middledata.qccost,middledata.bqcost,middledata.ddlxorderbymiddledata.pk_produce,middledata.invcode,middledata.scddh,middledata.cctcentercode9/9二、问题处理：在plsql中直接执行这个sql，9秒就出来了，很快。但是中间件上一直在跑，无法返回给客户数据。线程堆栈中是sockeread.经过检查发现在ncsysconfig.bat上面，server的设置有问题。在红色标注的地方，客户那边环境上设置的服务器名称是ip地址，同时ip地址那边添加了ip。将名称改为ncServer，ip地址那一栏去掉后，在取数就正常了。
