错误 #254: WEB1011617005166561订单重复 - Digi-Key Issue Tracking List - Digi-Key Service

错误 #254

WEB1011617005166561订单重复

由 Katherine Ma 在超过 3 年之前添加.

状态:

新建

优先级:

普通

指派给:

陆燕龙陆

开始日期:

2021-03-31

计划完成日期:

% 完成:

预期时间:

DK-Feedback:

KDSH

描述

Order 'WEB1011617005166561' failed with same error, we sent request only twice not sure why those many duplicate orders created in kingdee , could you please look into this, any code changes promoted to PROD recently ?

C:\Users\raj_kaukoti\AppData\Local\Temp\scp07589\opt\mule\mule-enterprise-3.8.3\logs\sales-order.log (4 hits)

Line 84498:   "number": "WEB1011617005166561",

Line 84722: <?xml version="1.0" encoding="UTF-8"?>&lt;soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:xsd="http://www.w3.org/2001/XMLSchema"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;&lt;soapenv:Body&gt;&lt;soapenv:Fault&gt;&lt;faultcode&gt;soapenv:Server.userException&lt;/faultcode&gt;&lt;faultstring&gt;com.kingdee.bos.webservice.WSInvokeException:Sql1 execute exception : update T_SD_saleorderentry set cforiginalqty = fqty where fparentid = (select fid from T_SD_saleorder where fnumber = 'WEB1011617005166561')

Line 84760: Message               : com.kingdee.bos.webservice.WSInvokeException: Sql1 execute exception : update T_SD_saleorderentry set cforiginalqty = fqty where fparentid = (select fid from T_SD_saleorder where fnumber = 'WEB1011617005166561')

Line 84789: com.kingdee.bos.webservice.WSInvokeException: Sql1 execute exception : update T_SD_saleorderentry set cforiginalqty = fqty where fparentid = (select fid from T_SD_saleorder where fnumber = 'WEB1011617005166561')

From:Flora Liu
Sent:Monday, March 29, 2021 8:56 PM
To:Raj Kaukoti <Raj.Kaukoti@digikey.com>; dl_IT_China_RMB_Support <dl_IT_China_RMB_Support@digikey.com>; shjie_fan <shjie_fan@kingdee.com>; 'muzi_zhang' <muzi_zhang@kingdee.com>
Cc:Draco Lu <Draco.Lu@digikey.com>
Subject:回复: duplicated order in RMB

Flora Liu

Operations Manager - PRC Sales

DIGI-KEY ELECTRONICS (SHANGHAI) CO., LTD

+86 18621711290 (Cellphone)

+86 21 3279 6240 (Direct)

+86 400 920 1199 (RMB hotline)

发件人:Raj Kaukoti <Raj.Kaukoti@digikey.com>
发送时间:2021年3月30日9:47
收件人:Flora Liu <Flora.Liu@digikey.com>; dl_IT_China_RMB_Support <dl_IT_China_RMB_Support@digikey.com>; shjie_fan <shjie_fan@kingdee.com>; 'muzi_zhang' <muzi_zhang@kingdee.com>
抄送:Draco Lu <Draco.Lu@digikey.com>
主题:RE: duplicated order in RMB

Robert,

Due to  below error, our retry logic sent same request second time , could you please look into this ? kingdee should not accept duplicate orders.

Request :

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><importBill>

&lt;billType&gt;003&lt;/billType&gt;

&lt;billDataJSON&gt;[ {

"CUSTNUM": 1011617064907473,

"CUSTOMERORDERNUMBER": "JAE-2103001726",

"ShipCarrier": 0,

"OrderName": null,

"CUSTREQUEST": "",

"DECSoID": 68846479,

"DELIVERYADDRESS": "江苏省江阴市江苏省江阴市经济开发区澄江中路288号",

"DESTINATION": {

"number": "CN"

},

"DKORDERSOURCE": 10,

"EXADDRESS1": "江苏省江阴市经济开发区澄江中路288号",

"EXADDRESS2": "",

"EXCITY": "江阴市",

"EXCOMPANYBUSINESS": "江阴信邦电子有限公司",

"EXCOUNTRY": {

"number": "CN"

},

"EXPOSAL": "214400",

"EXPROVINCE": "江苏省",

"FINANCECOM": "江阴信邦电子有限公司",

"FINANCEEMAIL": null,

"FINANCENUMBER": "0510-86404098",

"FINANCEPERSON": "1",

"FINANCEZIPCODE": "214400",

"GUDINGDIANHUA": "0510-86404098",

"INDUSTRY": {

"number": 23

},

"INDUSTRYDESC": "",

"INDUSTRYNEW": {

"number": 23

},

"INVOICEADDRESS": "江苏省江阴市江苏省江阴市经济开发区澄江中路288号",

"INVOICEHEADLINE2": "江阴信邦电子有限公司",

"INVOICETYPE": 1,

"JUTIYONGTU2": {

"number": 4

},

"JUTIYONGTU2NEW": {

"number": 4

},

"KAIHUYINHANG": "中国农业银行江阴经济开发区支行",

"LOGISTICCODE": "214400",

"LOGISTICCOM": "江阴信邦电子有限公司",

"companyEnglishName": null,

"LOGISTICEMAIL": "1@sinbon.com",

"LOGISTICFAX": null,

"LOGISTICMOBILE": "0510-86404098",

"LOGISTICNUMBER": "0510-86404098",

"LOGISTICPERSON": "1",

"MINGXIYONGTUZHONGWEN": "",

"MINGXIYONGTU_NEW": "",

"NCNRdes": "",

"ORDERPASSWORD": null,

"ProductResale": 0,

"PurchaseOrgUnit": {

"number": "010101"

},

"RETENTIONDAYS": "0",

"SHIPMENTTYPE": 0,

"SHUIHAO": "91320281724196491P",

"SOTYPE": 1,

"SURVEYURL": null,

"YINHANGZHANGHAO": "642901040003595",

"YONGTU2": {

"number": 6

},

"YONGTU2NEW": {

"number": 6

},

"ZHUCEDIZHI": "江苏省江阴经济开发区澄江中路288号",

"bizDate": "2021-03-29 19:43:36",

"bizType": {

"number": "210"

},

"currency": {

"number": "BB01"

},

"deliveryType": {

"number": "SEND"

},

"entries": [

"CANDELIVERYQTY": 2,

"CUSTPARTNUM": "A61701098001SD",

"DEFDELIVERYQTY1": 0,

"DELIVERYDATE": "2021-03-29 19:43:36",

"DESCRIPTION": "IC GATE DRVR HI/LOW SIDE MODULE",

"MANUFACTUREMNO": "1810-1028-ND",

"NCNR": "F",

"actualtaxprice": 650.91,

"amount": 1301.82,

"bizDate": "2021-03-29 19:43:36",

"discount": null,

"isPresent": false,

"leadTime": "2021-03-29 19:43:36",

"storageOrgUnit": {

"number": "010101"

},

"material": {

"number": 7347492

},

"overweight": false,

"paymentCustomer": {

"number": 277394

},

"qty": 2,

"quantityUnCtrl": 1,

"taxAmount": 1301.82,

"taxPrice": 650.91,

"taxRate": 0,

"unit": {

"number": "PCS"

],

"exEntries": [

"DescribeApplicatnUse": "",

"EXCOUNTRY": {

"number": "CN"

},

"EndUserDL": null,

"JUTIYONGTU2": {

"number": 4

},

"YONGTU2": {

"number": 6

],

"exchangeRate": "1.0",

"isCentralBalance": false,

"isInTax": true,

"isInnerSale": false,

"number": "WEB1011617064907473",

"orderCustomer": {

"number": 277394

},

"ordertimeus": "2021-03-29 19:43:36",

"paymentType": {

"number": "001"

},

"saleOrgUnit": {

"number": "010101"

},

"settlementType": {

"number": "33"

},

"sobizType": "10",

"storageOrgUnit": {

"number": "010101"

},

"complianceProfile": 0

} ]</billDataJSON>

&lt;billStatus&gt;1&lt;/billStatus&gt;

</importBill></soap:Body></soap:Envelope>

2021-03-29 19:43:37,077 [[sales-order].http.requester.KDCustomer_HTTP_Request_Configuration(1) SelectorRunner] DEBUG org.mule.module.http.internal.HttpMessageLogger - REQUESTER

POST /ormrpc/services/WSWSBDWebServiceFacade HTTP/1.1

SOAPAction: ""

Connection: close

Host: rh-kd-app-prd-a.sh.nx.digikey.com:7888

User-Agent: AHC/1.0

Accept: */*

Content-Type: text/xml; charset=UTF-8

Content-Length: 2265

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><importBill>

&lt;billType&gt;001&lt;/billType&gt;

&lt;billDataJSON&gt;[ {

"address": "深圳市光明区马田街道薯田埔社区薯田埔第三工业区蓝海帆科创园C栋102、202、302",

"bank": {

"bankaccount": "000171179203",

"bankname": "深圳农村商业银行马田支行"

},

"city": "深圳",

"csperson": {

"number": "Undefined"

},

"fi.paymenttype": {

"number": "001"

},

"fi.phone": "0755-29940373",

"fi.settlementtype": {

"number": "02"

},

"invoiceheadline": "深圳新控半导体技术有限公司",

"invoicetype": 1,

"iscredited": false,

"ShipCarrier": 0,

"linkman": [

"address": "深圳市光明区马田街道薯田埔社区薯田埔第三工业区蓝海帆科创园C栋102、202、3",

"address2": "深圳市光明区马田街道薯田埔社区薯田埔第三工业区蓝海帆科创园C栋102、202、3",

"city": "深圳",

"company": "深圳新控半导体技术有限公司",

"contactperson": "龙莉芳",

"contactpersonpost": "",

"email": "3319944341@qq.com",

"isbusiness": false,

"isfin": false,

"islog": true,

"mobile": "18822860337",

"phone": "18822860337",

"province": "广东省",

"provincecode": "GD",

"postalcode": "518000",

"website": ""

},

"address": "深圳市光明区马田街道薯田埔社区薯田埔第三工业区蓝海帆科创园C栋102、202、3",

"address2": "深圳市光明区马田街道薯田埔社区薯田埔第三工业区蓝海帆科创园C栋102、202、3",

"city": "深圳",

"company": "深圳新控半导体技术有限公司",

"contactperson": "龙莉芳",

"contactpersonpost": "",

"isbusiness": false,

"isfin": true,

"islog": false,

"mobile": "18822860337",

"province": "广东省",

"provincecode": "GD",

"phone": "18822860337",

"postalcode": "518000"

],

"province": "广东省",

"taxregisterno": "914403003118666372",

"webid": 2497127,

"name": "深圳新控半导体技术有限公司"

} ]</billDataJSON>

&lt;billStatus&gt;1&lt;/billStatus&gt;

ERROR

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Server.userException</faultcode><faultstring>com.kingdee.bos.webservice.WSInvokeException: Sql1 execute exception : update T_SD_saleorderentry set cforiginalqty = fqty where fparentid = (select fid from T_SD_saleorder where fnumber = 'WEB1011617064907473')

Caused exception message is: ORA-01427: single-row subquery returns more than one row

at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)

at com.kingdee.eas.scm.ws.app.SCMWebServiceFacadeControllerBean._importBill(SCMWebServiceFacadeControllerBean.java:119)

at com.kingdee.eas.scm.ws.app.AbstractSCMWebServiceFacadeControllerBean.importBill(AbstractSCMWebServiceFacadeControllerBean.java:45)

at sun.reflect.GeneratedMethodAccessor449.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav

2021-03-29 19:43:37,754 [[sales-order].http.requester.KDOrder_HTTP_Request_Configuration.worker(1)] DEBUG org.mule.module.http.internal.HttpMessageLogger - REQUESTER

a:25)

at java.lang.reflect.Method.invoke(Method.java:592)

at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)

at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRES_NEW(TxInvokerBean.java:69)

at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRES_NEW(Unknown Source)

at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:195)

at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)

at $Proxy228.importBill(Unknown Source)

at com.kingdee.eas.scm.ws.SCMWebServiceFacade.importBill(SCMWebServiceFacade.java:47)

at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_ws_1_ISCMWebServiceFacade.pi4(Unknown Source)

at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_ws_1_ISCMWebServiceFacade.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)

null</faultstring><detail><com.kingdee.bos.webservice.WSInvokeException xsi:type="ns1:WSInvokeException" xmlns:ns1="urn:client.scmwebservicefacade"/><ns2:hostname xmlns:ns2="http://xml.apache.org/axis/">rh-kd-app-prd-a.sh.nx.digikey.com</ns2:hostname></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>

2021-03-29 19:43:37,754 [[sales-order].http.requester.KDOrder_HTTP_Request_Configuration.worker(1)] DEBUG org.mule.module.http.internal.HttpMessageLogger - REQUESTER

2021-03-29 19:43:37,758 [[sales-order].submitorder-web2kd.stage1.1392] ERROR org.mule.exception.CatchMessagingExceptionStrategy -

Message : com.kingdee.bos.webservice.WSInvokeException: Sql1 execute exception : update T_SD_saleorderentry set cforiginalqty = fqty where fparentid = (select fid from T_SD_saleorder where fnumber = 'WEB1011617064907473')

Caused exception message is: ORA-01427: single-row subquery returns more than one row

at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)

at com.kingdee.eas.scm.ws.app.SCMWebServiceFacadeControllerBean._importBill(SCMWebServiceFacadeControllerBean.java:119)

at com.kingdee.eas.scm.ws.app.AbstractSCMWebServiceFacadeControllerBean.importBill(AbstractSCMWebServiceFacadeControllerBean.java:45)

at sun.reflect.GeneratedMethodAccessor449.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)