重现步骤

https://web.internal.zhcxkj.com/amz/#/productPerformance


https://webapi.internal.zhcxkj.com/bi/detail/productPerformance/sum

{
  "1":"B0BG52SJ5N",
  "queryDimension":3,
  "currencyType":1,
  "sourceIdList":[
    5107,
    5050,
    5071,
    5554,
    5270,
    5536,
    5545,
    5588,
    5595,
    5614,
    5756,
    5802,
    6278,
    6161,
    6285,
    6292,
    6303,
    6397,
    19218,
    6518,
    6603,
    6605,
    6626,
    6694,
    6875,
    6983,
    7380,
    7727,
    7887,
    7906,
    8003,
    8603,
    8604,
    9410,
    9793,
    9811,
    11304,
    10937,
    13608,
    11977,
    13287,
    12345,
    12503,
    12517,
    12881,
    12895,
    12909,
    12935,
    12953,
    13369,
    13399,
    13489,
    14711,
    16307,
    16319,
    16344,
    15613,
    15883,
    15729,
    16332,
    16597,
    16549,
    16564
  ],
  "salesmanList":[ ],
  "otherQueryType":1,
  "otherQueryList":[
    "B0BG52SJ5N"
  ],
  "queryChild":2,
  "orderBy":"saleQuantity",
  "orderByType":1,
  "orderDirection":"desc",
  "dateTime":[
    "2023-10-20",
    "2023-11-03"
  ],
  "labelAttributeList":[ ],
  "brandList":[ ],
  "pageIndex":1,
  "pageSize":20,
  "startDate":"2023-10-20",
  "endDate":"2023-11-03",
  "purchaseMinTime":"2023-10-20",
  "purchaseMaxTime":"2023-11-03"
}


{
    "success": false,
    "errCode": "10000500",
    "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-bi/detail/getAmzProductPerformanceInventoryFbm] [IAmzProductPerformanceInventoryFbmOpenApi#queryAmzProductPerformanceInventoryFbmSum(AmzProductPerformanceInventoryFbmSumQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: '`tt`.`asin`' must be an aggregate expression or appear in GROUP BY clause\\... (5682 bytes)]"
}

历史记录  
  1. 2023-11-03 14:53:10, 由 夏秋生 创建。
  2. 2023-11-03 15:29:56, 由 王极平 解决，方案为 配置问题 。
    修改了 解决方案，旧值为 ""，新值为 "deploy"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决日期，旧值为 ""，新值为 "2023-11-03 15:29:28"。
    修改了 指派给 ，旧值为 "wangjiping"，新值为 "xiaqiusheng"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "wangjiping"。
    有代码漏合了
  3. 2023-11-03 15:38:50, 由 夏秋生 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "xiaqiusheng"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "xiaqiusheng"。
    修改了 关闭日期，旧值为 ""，新值为 "2023-11-03 15:38:50"。
  4. 2023-11-23 09:38:44, 由 夏秋生 编辑。
    修改了 重现步骤，旧值为 "

    https://web.internal.zhcxkj.com/amz/#/productPerformance


    https://webapi.internal.zhcxkj.com/bi/detail/productPerformance/sum

    {
      "1":"B0BG52SJ5N",
      "queryDimension":3,
      "currencyType":1,
      "sourceIdList":[
        5107,
        5050,
        5071,
        5554,
        5270,
        5536,
        5545,
        5588,
        5595,
        5614,
        5756,
        5802,
        6278,
        6161,
        6285,
        6292,
        6303,
        6397,
        19218,
        6518,
        6603,
        6605,
        6626,
        6694,
        6875,
        6983,
        7380,
        7727,
        7887,
        7906,
        8003,
        8603,
        8604,
        9410,
        9793,
        9811,
        11304,
        10937,
        13608,
        11977,
        13287,
        12345,
        12503,
        12517,
        12881,
        12895,
        12909,
        12935,
        12953,
        13369,
        13399,
        13489,
        14711,
        16307,
        16319,
        16344,
        15613,
        15883,
        15729,
        16332,
        16597,
        16549,
        16564
      ],
      "salesmanList":[ ],
      "otherQueryType":1,
      "otherQueryList":[
        "B0BG52SJ5N"
      ],
      "queryChild":2,
      "orderBy":"saleQuantity",
      "orderByType":1,
      "orderDirection":"desc",
      "dateTime":[
        "2023-10-20",
        "2023-11-03"
      ],
      "labelAttributeList":[ ],
      "brandList":[ ],
      "pageIndex":1,
      "pageSize":20,
      "startDate":"2023-10-20",
      "endDate":"2023-11-03",
      "purchaseMinTime":"2023-10-20",
      "purchaseMaxTime":"2023-11-03"
    }


    {
        "success": false,
        "errCode": "10000500",
        "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-bi/detail/getAmzProductPerformanceInventoryFbm] [IAmzProductPerformanceInventoryFbmOpenApi#queryAmzProductPerformanceInventoryFbmSum(AmzProductPerformanceInventoryFbmSumQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: '`tt`.`asin`' must be an aggregate expression or appear in GROUP BY clause\\... (5682 bytes)]"
    }

    "，新值为 "

    https://web.internal.zhcxkj.com/amz/#/productPerformance


    https://webapi.internal.zhcxkj.com/bi/detail/productPerformance/sum

    {
      "1":"B0BG52SJ5N",
      "queryDimension":3,
      "currencyType":1,
      "sourceIdList":[
        5107,
        5050,
        5071,
        5554,
        5270,
        5536,
        5545,
        5588,
        5595,
        5614,
        5756,
        5802,
        6278,
        6161,
        6285,
        6292,
        6303,
        6397,
        19218,
        6518,
        6603,
        6605,
        6626,
        6694,
        6875,
        6983,
        7380,
        7727,
        7887,
        7906,
        8003,
        8603,
        8604,
        9410,
        9793,
        9811,
        11304,
        10937,
        13608,
        11977,
        13287,
        12345,
        12503,
        12517,
        12881,
        12895,
        12909,
        12935,
        12953,
        13369,
        13399,
        13489,
        14711,
        16307,
        16319,
        16344,
        15613,
        15883,
        15729,
        16332,
        16597,
        16549,
        16564
      ],
      "salesmanList":[ ],
      "otherQueryType":1,
      "otherQueryList":[
        "B0BG52SJ5N"
      ],
      "queryChild":2,
      "orderBy":"saleQuantity",
      "orderByType":1,
      "orderDirection":"desc",
      "dateTime":[
        "2023-10-20",
        "2023-11-03"
      ],
      "labelAttributeList":[ ],
      "brandList":[ ],
      "pageIndex":1,
      "pageSize":20,
      "startDate":"2023-10-20",
      "endDate":"2023-11-03",
      "purchaseMinTime":"2023-10-20",
      "purchaseMaxTime":"2023-11-03"
    }


    {
        "success": false,
        "errCode": "10000500",
        "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-bi/detail/getAmzProductPerformanceInventoryFbm] [IAmzProductPerformanceInventoryFbmOpenApi#queryAmzProductPerformanceInventoryFbmSum(AmzProductPerformanceInventoryFbmSumQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: '`tt`.`asin`' must be an aggregate expression or appear in GROUP BY clause\\... (5682 bytes)]"
    }

    "。
    修改了 指派给 ，旧值为 "closed"，新值为 "xiaqiusheng"。
    修改了 所属迭代，旧值为 "806"，新值为 "813"。
  5. 2023-11-23 09:40:31, 由 夏秋生 编辑。
    修改了 重现步骤，旧值为 "

    https://web.internal.zhcxkj.com/amz/#/productPerformance


    https://webapi.internal.zhcxkj.com/bi/detail/productPerformance/sum

    {
      "1":"B0BG52SJ5N",
      "queryDimension":3,
      "currencyType":1,
      "sourceIdList":[
        5107,
        5050,
        5071,
        5554,
        5270,
        5536,
        5545,
        5588,
        5595,
        5614,
        5756,
        5802,
        6278,
        6161,
        6285,
        6292,
        6303,
        6397,
        19218,
        6518,
        6603,
        6605,
        6626,
        6694,
        6875,
        6983,
        7380,
        7727,
        7887,
        7906,
        8003,
        8603,
        8604,
        9410,
        9793,
        9811,
        11304,
        10937,
        13608,
        11977,
        13287,
        12345,
        12503,
        12517,
        12881,
        12895,
        12909,
        12935,
        12953,
        13369,
        13399,
        13489,
        14711,
        16307,
        16319,
        16344,
        15613,
        15883,
        15729,
        16332,
        16597,
        16549,
        16564
      ],
      "salesmanList":[ ],
      "otherQueryType":1,
      "otherQueryList":[
        "B0BG52SJ5N"
      ],
      "queryChild":2,
      "orderBy":"saleQuantity",
      "orderByType":1,
      "orderDirection":"desc",
      "dateTime":[
        "2023-10-20",
        "2023-11-03"
      ],
      "labelAttributeList":[ ],
      "brandList":[ ],
      "pageIndex":1,
      "pageSize":20,
      "startDate":"2023-10-20",
      "endDate":"2023-11-03",
      "purchaseMinTime":"2023-10-20",
      "purchaseMaxTime":"2023-11-03"
    }


    {
        "success": false,
        "errCode": "10000500",
        "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-bi/detail/getAmzProductPerformanceInventoryFbm] [IAmzProductPerformanceInventoryFbmOpenApi#queryAmzProductPerformanceInventoryFbmSum(AmzProductPerformanceInventoryFbmSumQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: '`tt`.`asin`' must be an aggregate expression or appear in GROUP BY clause\\... (5682 bytes)]"
    }

    "，新值为 "

    https://web.internal.zhcxkj.com/amz/#/productPerformance


    https://webapi.internal.zhcxkj.com/bi/detail/productPerformance/sum

    {
      "1":"B0BG52SJ5N",
      "queryDimension":3,
      "currencyType":1,
      "sourceIdList":[
        5107,
        5050,
        5071,
        5554,
        5270,
        5536,
        5545,
        5588,
        5595,
        5614,
        5756,
        5802,
        6278,
        6161,
        6285,
        6292,
        6303,
        6397,
        19218,
        6518,
        6603,
        6605,
        6626,
        6694,
        6875,
        6983,
        7380,
        7727,
        7887,
        7906,
        8003,
        8603,
        8604,
        9410,
        9793,
        9811,
        11304,
        10937,
        13608,
        11977,
        13287,
        12345,
        12503,
        12517,
        12881,
        12895,
        12909,
        12935,
        12953,
        13369,
        13399,
        13489,
        14711,
        16307,
        16319,
        16344,
        15613,
        15883,
        15729,
        16332,
        16597,
        16549,
        16564
      ],
      "salesmanList":[ ],
      "otherQueryType":1,
      "otherQueryList":[
        "B0BG52SJ5N"
      ],
      "queryChild":2,
      "orderBy":"saleQuantity",
      "orderByType":1,
      "orderDirection":"desc",
      "dateTime":[
        "2023-10-20",
        "2023-11-03"
      ],
      "labelAttributeList":[ ],
      "brandList":[ ],
      "pageIndex":1,
      "pageSize":20,
      "startDate":"2023-10-20",
      "endDate":"2023-11-03",
      "purchaseMinTime":"2023-10-20",
      "purchaseMaxTime":"2023-11-03"
    }


    {
        "success": false,
        "errCode": "10000500",
        "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-bi/detail/getAmzProductPerformanceInventoryFbm] [IAmzProductPerformanceInventoryFbmOpenApi#queryAmzProductPerformanceInventoryFbmSum(AmzProductPerformanceInventoryFbmSumQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: '`tt`.`asin`' must be an aggregate expression or appear in GROUP BY clause\\... (5682 bytes)]"
    }

    "。
    修改了 指派给 ，旧值为 "xiaqiusheng"，新值为 "closed"。
返回
所属项目 技术中心-需求池
所属模块 /
所属计划
所属迭代 开发项目部 - 虎鲸BI - 迭代25
Bug类型
严重程度 提示
优先级 P2
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2023-11-23 09:40:31
截止日期 0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给
所属迭代 开发项目部 - 虎鲸BI - 迭代25
相关需求
相关任务
由谁创建 夏秋生 于 2023-11-03 14:53:10
影响环境 测试环境-测试反馈
由谁解决 王极平 于 2023-11-03 15:29:28
解决版本 主干
解决方案 配置问题
由谁关闭 夏秋生 于 2023-11-03 15:38:50
最后修改 夏秋生 于 2023-11-23 09:40:31
相关Bug