geedge-jira/md/OMPUB-1246.md

# 【M22项目-Reports】Dimensions选择Session ID，生成预览图时查询OLAP的metric接口超时

| ID | Creation Date | Assignee | Status |
|----|----------------|----------|--------|
| OMPUB-1246 | 2024-04-20T14:54:29.000+0800 | 窦凤虎 | 已关闭 |


---

描述：预览数据查询时间超过30秒，导致查询超时

复现步骤：
 * 创建的Report的chart相关信息如下：
 * !image-2024-04-20-13-22-52-169.png|thumbnail!

当前问题：
[https://10.160.11.206/v1/metric/query]
接口报500错误：
 * !image-2024-04-20-13-23-53-920.png|thumbnail!**doufenghu** commented on *2024-04-22T16:18:15.278+0800*:

由查询数据库更改为基于Data Mock生成样例数据，QGW由24.03 Backport 至TSG OLAP 24.02.01.



---

**hebingning** commented on *2024-04-23T13:50:34.341+0800*:

修改后mock的数据session id 为五位数，当前session records中的session 为19位

mock 的数据应该与实际的session id最少位数相同：

!image-2024-04-23-12-20-25-833.png|thumbnail!

[~doufenghu] 



---

**doufenghu** commented on *2024-04-23T14:17:38.636+0800*:

现Session ID 预览结果，通过数据类型生成 mock data。



---

**hebingning** commented on *2024-04-25T19:11:19.674+0800*:

client ip 的 mock 数据不恰当，数据非IP类型：

!image-2024-04-25-17-41-15-436.png|thumbnail!



---

**doufenghu** commented on *2024-04-30T14:43:40.560+0800*:

通过逻辑类型输出IP类型Mockdata，已更新至24.02.



---

**hebingning** commented on *2024-04-30T18:40:35.519+0800*:

复测通过，关闭次bug：

!image-2024-04-30-17-10-29-760.png|thumbnail!



---



# Attachments

Attachment: image-2024-04-20-13-22-52-169.png

![image-2024-04-20-13-22-52-169.png](https://gfwleak.exec.li/admin/geedge-jira/raw/branch/master/attachment/55813/image-2024-04-20-13-22-52-169.png)



Attachment: image-2024-04-20-13-23-53-920.png

![image-2024-04-20-13-23-53-920.png](https://gfwleak.exec.li/admin/geedge-jira/raw/branch/master/attachment/55812/image-2024-04-20-13-23-53-920.png)



Attachment: image-2024-04-23-12-20-25-833.png

![image-2024-04-23-12-20-25-833.png](https://gfwleak.exec.li/admin/geedge-jira/raw/branch/master/attachment/56014/image-2024-04-23-12-20-25-833.png)



Attachment: image-2024-04-25-17-41-15-436.png

![image-2024-04-25-17-41-15-436.png](https://gfwleak.exec.li/admin/geedge-jira/raw/branch/master/attachment/56288/image-2024-04-25-17-41-15-436.png)



Attachment: image-2024-04-30-17-10-29-760.png

![image-2024-04-30-17-10-29-760.png](https://gfwleak.exec.li/admin/geedge-jira/raw/branch/master/attachment/56581/image-2024-04-30-17-10-29-760.png)