Feb 23 at 10:31 AM

BO 4.3 Too many tables; MySQL can only use 61 tables in a join

132 Views

Hello,

I got this error in BO 4.3 after changing the DB connection to ODBC :

|25ff7b27-9971-1624-6a1b-76dc58851bd9|2023 02 23 06:23:28:089|+0100|Error| |>=|E|X|webiserver_BOBI43.WebIntelligenceProcessingServer| 9380|8784|| |14|2|2|0|

Webi SDK.CorbaServerImpl.doProcess()|bobi43:8:76.127:6|webiserver_BOBI43.WebIntelligenceProcessingServer.processDPCommandsEx|localhost:9380:4220.6246:1|IE.C3_DPManager|localhost:9380:8784.6247:1|CtZbEFB8WUSkgxk2cF4BAcU258|||||bonnin||||||Uncaught Exception in SilentScope: CS::OpenJob_Describe: 0.024

Error=[MySQL][ODBC 8.0(w) Driver][mysqld-5.6.49]Too many tables; MySQL can only use 61 tables in a join

why i didn't have the error before changing to ODBC connection. For information the DB is Oracle 19c.

Thank you.

Best regards.

Riadh