I have installed C10.1 on windows 2008 R2 64 bit, Oracle client 11gR2 64 bit.
Initially i tried Content Store with Oracle but I got errors so i tried Oracle Advanced and I am successful in testing the content store. Now all the reports are upgraded and when i tried to open cognos connection this throws me an error:
QE-DEF-0285 The Log on Failed. I tried to test my data source in data source connection but that also give me same error. I have provided correct credentials. Any Idea.
My cube based reports are working fine.
Thank you.
Cognos 10's classic query mode does not work with the Oracle 64 bit client libraries. You will need to install and use the Oracle 32 bit client libraries to get your data source connection to work. The content store connection to Oracle works differently - using JDBC.
Regards,
MF.
Hello MFGF,
I have installed 32 bit client and DNS tested success, data source in cognos administration tested sucess, cognos connection is giving me following error
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
Details | Retry | Hide this message.
I am getting this for all the reports, so this got to be soem kind of connectionor driver issue. Any idea?
Thnak you,
HRK
What are the details of the message? There is normally a more detailed response you can get to. Can you click on "Details" and give us the next part of the message? If I had to guess, I would imagine your package is out of step with the tables/columns in the database and your report is looking for an object that does not exist.
Regards,
MF.
It is not allowing to attach, I am copying some part
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
com.cognos.portal.fragment.server.SOAPFaultException: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
at com.cognos.portal.fragment.service.ServiceEnvironment.getBiBusTargetStream(ServiceEnvironment.java:508)
at com.cognos.portal.fragment.service.ServiceEnvironment.getLocalTargetStream(ServiceEnvironment.java:295)
at com.cognos.portal.fragment.Environment.getTargetStream(Environment.java:594)
at com.cognos.portal.fragment.server.document.DocumentFactoryImpl.createDocument(DocumentFactoryImpl.java:132)
at com.cognos.portal.fragment.wsrp.DocumentFactoryImpl.createDocument(DocumentFactoryImpl.java:36)
at com.cognos.portal.fragment.server.DashboardProcessor.process(DashboardProcessor.java:280)
at com.cognos.portal.fragment.wsrp.Fragment.executeAjaxRequest(Fragment.java:205)
at com.cognos.portal.fragment.wsrp.FragmentWSRPBridge.getFragmentXML(FragmentWSRPBridge.java:600)
at com.cognos.portal.fragment.service.WSRPService.handleHttpRequest(WSRPService.java:399)
at com.cognos.portal.fragment.service.WSRPService.invokeImpl(WSRPService.java:366)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:194)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:52)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:194)
at com.cognos.p2plb.clerver.balancer.RequestForwarder.rawForwardToSelf(RequestForwarder.java:181)
at com.cognos.p2plb.clerver.balancer.RequestForwarder.forwardToSelf(RequestForwarder.java:154)
at com.cognos.p2plb.clerver.balancer.LoadBalanceRequest.processRequest(LoadBalanceRequest.java:88)
at com.cognos.p2plb.clerver.balancer.LoadBalanceRequest.processRequest(LoadBalanceRequest.java:45)
at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:243)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:194)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:52)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:194)
at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:120)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:194)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:52)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:194)
at