BI自助数据集-跨库-链接出错

楼主
我是社区第281920位番薯,欢迎点我头像关注我哦~

1、MySQL,业务不同,分库
    jdbc:mysql://192.168.32.92:3308/经营

jdbc:mysql://192.168.32.92:3308/财务          

2、按分库设置finebi数据链接

3、按库设置业务包,实时数据

4、跨业务包创建自助数据链接——报错

错误代码:62400001The SQL : { select t2.`__fcol_6` as `__fcol_10`, t2.`__fcol_7` as `__fcol_11`, t2.`__fcol_8` as `__fcol_12`, t2.`__fcol_9` as `__fcol_13` from ( ( select t0.`__fcol_0` as `__fcol_6`, t0.`__fcol_1` as `__fcol_7`, t0.`__fcol_2` as `__fcol_8`, null as `__fcol_9` from (select T_36F378.`项目简称` as `__fcol_0`, T_36F378.`支付金额` as `__fcol_1`, T_36F378.`分包商名称` as `__fcol_2` from (SELECT * from `f2分包付款` ) as `T_36F378`) as `t0` ) union all ( select t1.`__fcol_3` as `__fcol_6`, null as `__fcol_7`, t1.`__fcol_4` as `__fcol_8`, t1.`__fcol_5` as `__fcol_9` from (select T_3654A5.`项目简称` as `__fcol_3`, T_3654A5.`供应商名称` as `__fcol_4`, T_3654A5.`合同额(元)` as `__fcol_5` from (SELECT * FROM `b3分包合同` WHERE 1=1 ) as `T_3654A5`) as `t1` ) ) as `t2` limit 5000 } is wrong, please check!Table '财务.b3分包合同' doesn't exist
------是什么原因?实时数据不能正确找到数据链接?

分享扩散:

沙发
发表于 2021-9-26 16:19:41
修改为统一的链接,就可以解决。是不是有点小bug?
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

返回顶部 返回列表