Hello Gurus,
I have read the following topic http://www.cognoise.com/index.php/topic,31241.0.html (http://www.cognoise.com/index.php/topic,31241.0.html)and I am facing somewhat a similar issue. I have installed CA 11.0.4, tested the connection successfully but I am unable to see the schemas, it shows "Results are empty". I have followed all the technotes but none of them helped me. http://www-01.ibm.com/support/docview.wss?uid=swg21973943 (http://www-01.ibm.com/support/docview.wss?uid=swg21973943)
I have tried connecting it through FM where I am getting the following error
I am using Oracle Oracle 10gR2. I have just read on the following topic http://www.cognoise.com/index.php/topic,31241.0.html (http://www.cognoise.com/index.php/topic,31241.0.html) that CA only supports 12cR1 & 11gR2. Does it mean any other versions of Oracle are not supported?
I opned a PMR with IBM which took a lot of time and was not able to solve the issue.
Tried using FM but still no luck
I will really appreciate your feedback.
Thanks
Quote from: superman99 on 13 Nov 2016 02:02:26 PM
Hello Gurus,
I have read the following topic http://www.cognoise.com/index.php/topic,31241.0.html (http://www.cognoise.com/index.php/topic,31241.0.html)and I am facing somewhat a similar issue. I have installed CA 11.0.4, tested the connection successfully but I am unable to see the schemas, it shows "Results are empty". I have followed all the technotes but none of them helped me. http://www-01.ibm.com/support/docview.wss?uid=swg21973943 (http://www-01.ibm.com/support/docview.wss?uid=swg21973943)
I have tried connecting it through FM where I am getting the following error
I am using Oracle Oracle 10gR2. I have just read on the following topic http://www.cognoise.com/index.php/topic,31241.0.html (http://www.cognoise.com/index.php/topic,31241.0.html) that CA only supports 12cR1 & 11gR2. Does it mean any other versions of Oracle are not supported?
I opned a PMR with IBM which took a lot of time and was not able to solve the issue.
Tried using FM but still no luck
I will really appreciate your feedback.
Thanks
Hi,
I don't think Oracle 10 has a JDBC driver that is compliant with JRE8 (Cognos Analytics uses JRE8). Assuming I'm correct, your only option is to upgrade to Oracle 11 or Oracle 12.
Cheers!
MF.
Thanks MFGF for your prompted response.
I was able to connect to Oracle 10gR2 using ojdbc7.jar but it is not recommended because the risk here is that Cognos query generation is based on the functionality of the Oracle 11 product, there's an outside chance that some of the SQL we generate may not work correctly.