积木BI保存无效

[zonhar]

1.因jimubi-1.9.4 项目内的 jsqlparser 4.6 与我当前项目mybatis-plus 项目中 jsqlparser 4.8冲突，排除掉 jsqlparser 4.6 依赖后 项目中正常启动

2.创建仪表盘报表成功后，拉动图标保存成功后，能看到/drag/page/edit 接口正常保存成 template 参数

3.关闭报表后， 再次进入 报表设计详情， /drag/page/queryById 无 template参数

[jeecgDeveloper]

1.排查一下保存时，template 的值是否存储，截图看一下
2.看一下数据库onl_drag_page对应的表中template 字段是否正确存储数据

3.排查一下是有redis缓存，清除一下对应的缓存

[zhangdaiscott]

试试这个版本

        <dependency>
            <groupId>org.jeecgframework.jimureport</groupId>
            <artifactId>jimubi-spring-boot-starter</artifactId>
            <version>1.9.5</version>
        </dependency>

[zonhar]

好的，我先试试

[zonhar]

jimubi-1.9.5 版本并不能解决这个问题

[zonhar]

### 试了/drag/page/edit接口，并没有正确保存，template 参数，

入参：{"id":"1074296188045398016","name":"中晟昊-门店资金报表","backgroundColor":null,"theme":"default","style":"default","coverUrl":null,"designType":100,"backgroundImage":"","template":"[{"config":{"w":24,"h":14,"dataType":1,"url":"http://api.jeecg.com/mock/42/nav","timeOut":0,"turnConfig":{"url":""},"linkageConfig":[],"dataMapping":[{"filed":"标题","mapping":""},{"filed":"图标","mapping":""},{"filed":"数值","mapping":""},{"filed":"后缀","mapping":""},{"filed":"颜色","mapping":""}],"chartData":[{"title":"访问数","icon":"icon-jeecg-qianbao","value":2000,"color":"green","suffix":"月"},{"title":"成交额","icon":"icon-jeecg-youhuiquan","value":20000,"color":"blue","suffix":"月"},{"title":"下载数","icon":"icon-jeecg-tupian","value":8000,"color":"orange","suffix":"周"},{"title":"成交数","icon":"icon-jeecg-jifen","value":5000,"color":"purple","suffix":"年"}],"option":{"icon":{"fontSize":50},"card":{"title":"卡片","extra":"更多","rightHref":"","size":"default"},"body":{"horizontal":8,"vertical":8,"span":6}},"size":{"height":140}},"component":"JSimpleCard","i":"759ab8a9-f98b-43ca-93fe-d52318c8cc11","x":0,"y":0,"w":24,"h":14,"orderNum":0,"moved":false}]","sign":"396D6399E6EBF28BC410FBBED10C95ED"}

出参： {
"success": true,
"message": "修改成功!",
"code": 200,
"result": {
"id": "1074296188045398016",
"name": "中晟昊-门店资金报表",
"path": "/drag/page/view/1074296188045398016",
"desJson": null,
"template": "[{"component":"JSimpleCard","w":24,"moved":false,"x":0,"h":14,"i":"759ab8a9-f98b-43ca-93fe-d52318c8cc11","y":0,"orderNum":0,"pageCompId":"1074607960279257088"}]",
"coverUrl": null,
"backgroundColor": null,
"backgroundImage": "",
"theme": "default",
"style": "default",
"designType": 100,
"protectionCode": null,
"type": null,
"izTemplate": null,
"createBy": null,
"lowAppId": null,
"tenantId": 1,
"appMenuGroupId": null,
"createTime": null,
"updateBy": "1",
"updateTime": "2025-04-22 18:35:13",
"updateCount": null,
"visitsNum": null,
"delFlag": null
},
"timestamp": 1745318113108
}

数据库：

[zonhar]

redis 缓存也清理了

[zhangdaiscott]

那报什么错，原因是什么

[zonhar]

没报错呀

[zonhar]

要不你远程看下？

[zonhar]

有偿

[zonhar]

最开始因为，积木bi 的jsqlparser 与我项目内jsqlparser 冲出，我排除依赖后，项目启动就出现这个问题了，其他功能正常

[zonhar]

保存日志.txt

[zonhar]

已发现问题，/drag/page/edit 未自动更新redis 缓存数据， /drag/page/queryById还是获取redis 缓存数据
请检查是否是以下代码导致未更新redis 缓存

[zhangdaiscott]

没修改成功？

[zonhar]

数据库修改成功了，redis里面的缓存没更新

[zonhar]

检测一下/drag/page/edit接口，更新了数据库，但redis缓存还是旧的数据，数据库更新成功后，应该要把缓存模版数据应该也要更新一下，因为/drag/page/queryById接口是先读redis缓存的数据

[zhangdaiscott]

<!-- 积木BI大屏和仪表盘 -->
            <dependency>
                <groupId>org.jeecgframework.jimureport</groupId>
                <artifactId>jimubi-spring-boot3-starter</artifactId>
                <version>1.9.5</version>
            </dependency>