If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

QE-DEF-0285 - The logon Failed

Started by hrk551, 31 Aug 2011 02:17:42 PM

Previous topic - Next topic

hrk551

 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.

MFGF

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.
Meep!

hrk551

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

MFGF

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.
Meep!

hrk551

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