内网穿透工具不显示内容，支付完成后点击我已支付没反应，日志显示调用支付宝订单查询接口失败

Question

------------- 环绕通知开始 -------------
06:58.945 INFO com.shangu.nls.business.aspect.LogAspect 47 1842884249804595200 请求地址: http://localhost:18000/nls/web/order-info/query-order-status/20241006190628898887 GET
06:58.945 INFO com.shangu.nls.business.aspect.LogAspect 48 1842884249804595200 类名方法: com.shangu.nls.business.controller.web.WebOrderInfoController.sendForRegister
06:58.945 INFO com.shangu.nls.business.aspect.LogAspect 49 1842884249804595200 远程地址: 0:0:0:0:0:0:0:1
06:58.945 INFO com.shangu.nls.business.aspect.LogAspect 70 1842884249804595200 请求参数: [“20241006190628898887”]
06:58.957 DEBUG c.s.n.b.mapper.OrderInfoMapper.selectByExample 135 1842884249804595200 > Preparing: select id, order_no, order_at, order_type, info, member_id, amount, pay_at, channel, channel_at, status, desc, created_at, updated_at from order_info WHERE ( order_no = ? )
06:58.957 DEBUG c.s.n.b.mapper.OrderInfoMapper.selectByExample 135 1842884249804595200 > Parameters: 20241006190628898887(String)
06:58.969 TRACE c.s.n.b.mapper.OrderInfoMapper.selectByExample 141 1842884249804595200 < Columns: id, order_no, order_at, order_type, info, member_id, amount, pay_at, channel, channel_at, status, desc, created_at, updated_at
06:58.969 TRACE c.s.n.b.mapper.OrderInfoMapper.selectByExample 141 1842884249804595200 < Row: 1842884123782537216, 20241006190628898887, 2024-10-06 19:06:28.898, 1, 1842884122373251072, 1811609621182435328, 0.02, 2024-10-06 19:06:29, A, null, I, 语音识别付费, 2024-10-06 19:06:28.898, 2024-10-06 19:06:28.898
06:58.969 DEBUG c.s.n.b.mapper.OrderInfoMapper.selectByExample 135 1842884249804595200 <== Total: 1
06:59.223 WARN com.shangu.nls.business.alipay.AliPayService 53 1842884249804595200 调用支付宝订单查询接口失败，原因：{“buyerPayAmount”:“0.00”,“code”:“40004”,“httpBody”:"{“alipay_trade_query_response”:{“msg”:“Business Failed”,“code”:“40004”,“out_trade_no”:“20241006190628898887”,“sub_msg”:“交易不存在”,“sub_code”:“ACQ.TRADE_NOT_EXIST”,“receipt_amount”:“0.00”,“point_amount”:“0.00”,“buyer_pay_amount”:“0.00”,“invoice_amount”:“0.00”},“sign”:“igCIe4owpBcVRhokFg79w51POgahnBcap4+D2ZDs23lAHjioYUkBvNNeEX17AqqlAT3zlBj558hpw6pYb5u0ZgfgH+uQldZfSLLHr8hKH1oL5oQsLDK2ZKWMT2Xge5T4FJY0DjO+7W/pORYgUKPR43EZUvuCV/Y+9+4hXfZDwivpK8CcBMZSRdHivTpQX/RjOTNlfxOgMZmaEzijo9rTNHAl3n/v6a0/M87YUntzZ1RzXAiqAgfC7yMpsEZ5pOO2Q4ngUvsv3E42x8fNIxlEuqHlzewezzWZGzTxBfiOE5QjEKBD2taMdKoW04UIoyc8JbcVxDIRgBPUqxHw1CDrrQ==”}",“invoiceAmount”:“0.00”,“msg”:“Business Failed”,“outTradeNo”:“20241006190628898887”,“pointAmount”:“0.00”,“receiptAmount”:“0.00”,“subCode”:“ACQ.TRADE_NOT_EXIST”,“subMsg”:“交易不存在”}
06:59.223 INFO com.shangu.nls.business.aspect.LogAspect 73 1842884249804595200 返回结果: {“content”:“I”,“success”:true}
06:59.223 INFO com.shangu.nls.business.aspect.LogAspect 74 1842884249804595200 ------------- 环绕通知结束 耗时：278 ms -------------
**问题：**返回ACQ.TRADE_NOT_EXIST 交易不存在；支付成功后，在支付宝显示交易成功，但是查询支付宝订单接口失败，无法正确获取到消息

附：配置

Answer 1

甲蛙 2024-10-07 13:43:05

我在测试的时候，也遇到过沙箱环境没有异步通知的情况，所以靠主动查询，查不到得检查你传递的参数，订单号不要传错，我课程里是可以的。不过至少说明查询已经能调到支付宝了，逻辑、配置没有错

• 提问者 AKIRA_KARASAWA #1

  老师，这个搞不定，后面会有影响吗？实在搞不定了

• 甲蛙 回复 提问者 AKIRA_KARASAWA #2

  如果是沙箱环境问题，换个时间测试，实在不成功也没影响，可以在支付成功后，自己把数据库的记录改成S即可