cancel
Showing results for 
Search instead for 
Did you mean: 

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

saaidia
Explorer
0 Kudos

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

raymond_giuseppi
Active Contributor

Check your connection, you reached a MySQL and not an Oracle database?

Accepted Solutions (0)

Answers (2)

Answers (2)

denis_konovalov
Active Contributor
0 Kudos

Either you're using wrong ODBC driver (MySQL instead of Oracle) or you're connecting to the wrong DB.

saaidia
Explorer
0 Kudos

Thank you very much for your answer, as it seems we are using a wrong ODBC driver, do you have an idea please how to configure an ODBC connection to Oracle 19c Database in 4.3 ? Thank You.

Best Regards.

former_member184995
Active Contributor
0 Kudos

I think Ayman showed you up above.

Jason

ayman_salem
Active Contributor
0 Kudos

Are you trying to change the connection from Oracle DB to MySQL?

saaidia
Explorer
0 Kudos

Hello Ayman,

Thank you very much for your answers.

We wanted to set an ODBC connection to Oracle DB 19c.

We found a difference between 4.3 and 4.2 with the connection popup parameters, do you have an idea please how to set an ODBC connection to an Oracle 19c Database.

Thank you.

Best regards.

Riadh

ayman_salem
Active Contributor
0 Kudos

in UDT (Universe Designer) select Tools --> Connections ---> select desired connection ---> edit --> press "back" ---> select "ODBC driver" under Oracle 19c --> continue and complete your definitions