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 ------是什么原因?实时数据不能正确找到数据链接? |