问题详情

    • 项目环境:
      SIT

      描述

      转发请求报文: {"businessBody":{"requestImageUpload":{"lossLst":["3c90d94d064311e8918c5cb90189188c","3c92901c064311e8918c5cb90189188c"],"mobile":"13586898127","registNo":"07633008082018000444","reportNo":"590a61a04235459fbc20941294df1d29","surveyType":"1","uploadFilesLst":[

      {"fileName":"07633008082018000444.jpg","fileType":"0","fileUrl":"MP/DX/prd/P0101/jpg/07633008082018000444.jpg","imgType":"","latitude":"","longitude":"","shotPlace":"","shotTime":"2018-01-31 14:39:31"}

      ],"uploadType":"2"}},"requestHead":{"companyCode":"TIANANCORE","interfaceCode":"LR05","interfaceName":"上传影像资料","seqNo":"1517380771223","serviceCode":"coreService","serviceName":"朗泰服务平台","signatureCode":"4ffaffeae52cfd9274e275a8788351f0"}}
      转发响应报文: {"responseHead":

      {"errorMessage":"\n### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \u0027\u0027 at line 9\n### The error may exist in file [/usr/local/softinstall/tasurvey/tomcat7-tasurvey-interface/webapps/msadapter/WEB-INF/classes/com/liveneo/adapter/base/sqlmap/PrpmLossItemMapper.xml]\n### The error may involve com.liveneo.adapter.base.mapper.PrpmLossItemMapper.selectLossItemByLossUuids-Inline\n### The error occurred while setting parameters\n### SQL: select loss_item_id, case_info_id, case_no, loss_id, loss_name, loss_type, loss_status, lossitem_status, surveyor_code, surveyor_name, mobile, contact, contact_phone, end_case_time, finish_case_time, remark, user_type, check_loss_usercode, check_loss_username, org_code, org_name, loss_deal_type, create_by, create_time, modify_by, modify_time from prpm_loss_item where loss_item_id in\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \u0027\u0027 at line 9\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \u0027\u0027 at line 9","resultCode":"999","serviceCode":"msplatform","serviceName":"查勘平台","interfaceCode":"LR05","interfaceName":"影像资料上传","seqNo":"1517380771223"}

      }

        活动

        周攀 创建问题 -
        刘志鹏 进行了改变 -
        字段 原值 新值
        状态 Open [ 1 ] In Progress [ 3 ]
        刘志鹏 进行了改变 -
        issue.field.resolutiondate 2018-01-31 16:25:17.0 2018-01-31 16:25:17.442
        预估剩余时间 0 minutes [ 0 ]
        已耗费时间 2 hours [ 7200 ]
        工作日志 Id 11342 [ 11342 ]
        刘志鹏 进行了改变 -
        状态 In Progress [ 3 ] Resolved [ 5 ]
        解决结果 Fixed [ 1 ]
        周攀 进行了改变 -
        解决版本 3.3.180131_release [ 10276 ]
        解决版本 3.3.180208_release [ 10275 ]
        周攀 进行了改变 -
        报告人 周攀 [ zhoupan ] 包珍 [ baozhen ]

          用户

          • 经办人:
            刘志鹏
            报告人:
            包珍
          • 投票:
            0 为这个问题投票
            关注人:
            1 关注这个问题

            日期

            • 创建:
              更新:
              解决:

              时间追踪

              预估时间:
              原预估时间 - 尚未登记
              尚未登记
              剩余时间:
              剩余时间 - 0 分
              0m
              实际工作时间:
              耗费时间 - 2 小时
              2h