on 02-23-2023 10:31 AM
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
Either you're using wrong ODBC driver (MySQL instead of Oracle) or you're connecting to the wrong DB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you trying to change the connection from Oracle DB to MySQL?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.