C8 FAQ

Cognos 8.3, when trying to open a project in Framework Manager, it requires authentication. It gives "CAM-AAA-0064 - The function 'CMQueryCognosSecurityJNI' failed." error after entering user/password.

       Server CM-SYS-5192 An error occurred with Content Manager.   error cmStoreNotAvailable  CM-SYS-5003 Content Manager is unable to access the content store. Verify your database connection parameters, and then contact your database administrator for assistance.   1 Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off client connection The Connection descriptor used by the client was: NCSAPMEDCRD1:1525:DWD        

Investigating

Cognos 8.3, After log on to portal and click "Australia" tab, the page gave 5 "CPS-PAG-4801 - Operation failed in the consumer component." error.

com.cognos.cps.services.wsrp.v1.types.OperationFailedFaultPF-BRG-6141 The operation did not run.PF-BRG-6143 The request encountered an error while processing XML content.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6140 Not able to run the request.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6143 The request encountered an error while processing XML content.
 at com.cognos.portal.fragment.wsrp.FragmentWSRPBridge.getMarkup(FragmentWSRPBridge.java:219)
 at com.cognos.portal.fragment.service.WSRPService.handleSOAPRequest(WSRPService.java:436)
 at com.cognos.portal.fragment.service.WSRPService.invokeImpl(WSRPService.java:329)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:648)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:614)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:382)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:116)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:143)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:133)
 at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:249)
 at com.cognos.pogo.transport.PogoServlet.doPost(PogoServlet.java:561)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at com.cognos.pogo.isolation.ServletWrapper.service(ServletWrapper.java:291)
 ...

com.cognos.cps.services.wsrp.v1.types.OperationFailedFaultPF-BRG-6141 The operation did not run.PF-BRG-6143 The request encountered an error while processing XML content.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6140 Not able to run the request.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6143 The request encountered an error while processing XML content.
 at com.cognos.portal.fragment.wsrp.FragmentWSRPBridge.getMarkup(FragmentWSRPBridge.java:219)
 at com.cognos.portal.fragment.service.WSRPService.handleSOAPRequest(WSRPService.java:436)
 at com.cognos.portal.fragment.service.WSRPService.invokeImpl(WSRPService.java:329)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:648)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:614)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:382)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:116)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 ...

com.cognos.cps.services.wsrp.v1.types.OperationFailedFaultPF-BRG-6141 The operation did not run.PF-BRG-6143 The request encountered an error while processing XML content.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6140 Not able to run the request.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6143 The request encountered an error while processing XML content.
 at com.cognos.portal.fragment.wsrp.FragmentWSRPBridge.getMarkup(FragmentWSRPBridge.java:219)
 at com.cognos.portal.fragment.service.WSRPService.handleSOAPRequest(WSRPService.java:436)
 at com.cognos.portal.fragment.service.WSRPService.invokeImpl(WSRPService.java:329)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:648)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:614)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:382)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:116)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:143)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:133)
 at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:249)
 at com.cognos.pogo.transport.PogoServlet.doPost(PogoServlet.java:561)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at com.cognos.pogo.isolation.ServletWrapper.service(ServletWrapper.java:291)
 ...

com.cognos.cps.services.wsrp.v1.types.OperationFailedFaultPF-BRG-6141 The operation did not run.PF-BRG-6143 The request encountered an error while processing XML content.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6140 Not able to run the request.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6143 The request encountered an error while processing XML content.
 at com.cognos.portal.fragment.wsrp.FragmentWSRPBridge.getMarkup(FragmentWSRPBridge.java:219)
 at com.cognos.portal.fragment.service.WSRPService.handleSOAPRequest(WSRPService.java:436)
 ...

com.cognos.cps.services.wsrp.v1.types.OperationFailedFaultPF-BRG-6141 The operation did not run.PF-BRG-6143 The request encountered an error while processing XML content.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6140 Not able to run the request.
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6143 The request encountered an error while processing XML content.
 at com.cognos.portal.fragment.wsrp.FragmentWSRPBridge.getMarkup(FragmentWSRPBridge.java:219)
 at com.cognos.portal.fragment.service.WSRPService.handleSOAPRequest(WSRPService.java:436)
 at com.cognos.portal.fragment.service.WSRPService.invokeImpl(WSRPService.java:329)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:648)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:614)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:382)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:116)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:143)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:133)
 at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:249)
 at com.cognos.pogo.transport.PogoServlet.doPost(PogoServlet.java:561)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at com.cognos.pogo.isolation.ServletWrapper.service(ServletWrapper.java:291)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
 at java.lang.Thread.run(Unknown Source)
com.cognos.portal.fragment.wsrp.BridgeException: PF-BRG-6140 Not able to run the request.
 at com.cognos.portal.fragment.wsrp.Fragment.execute(Fragment.java:169)
 at com.cognos.portal.fragment.wsrp.FragmentWSRPBridge.getMarkup(FragmentWSRPBridge.java:161)
 at com.cognos.portal.fragment.service.WSRPService.handleSOAPRequest(WSRPService.java:436)
 at com.cognos.portal.fragment.service.WSRPService.invokeImpl(WSRPService.java:329)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:648)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:614)
 at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:382)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:116)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:143)
 at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
 at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:133)
 at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:249)
 at com.cognos.pogo.transport.PogoServlet.doPost(PogoServlet.java:561)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at com.cognos.pogo.isolation.ServletWrapper.service(ServletWrapper.java:291)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
 at java.lang.Thread.run(Unknown Source)
com.cognos.portal.fragment.server.DashboardException: PF-SRV-6116 Unable to process the document, target is not valid or the target was not received.
 at com.cognos.portal.fragment.service.ServiceEnvironment.getLocalTargetStream(ServiceEnvironment.java:253)
 at com.cognos.portal.fragment.Environment.getTargetStream(Environment.java:581)
 at com.cognos.portal.fragment.service.ServiceEnvironment.createValidationDocument(ServiceEnvironment.java:658)
 ...

Possibly, the DW server and C8 server were reboot/shutdown in the wrong sequence. It may cause C8 server lose the connection or hold a stall connection to DW. Contact DBA.

Cognos 8.3, in Australia portal, Executive section, a yellow box shows up "PF-VAL-6171 Error retrieving metadata for the target fragment.".

Permission for Executive section has not been set properly.

Cognos 8.3, cube build was failed due to the following error(s).

Thu 10 Dec 2009 12:36:11 AM 2 00416C17 (TR2317) The level 'Regional Material Long Code' is designated as unique.  Source value '2960-B-9565' was used in an attempt to create a category in the path ( Regional Material,M00295,018175,028175,038175,040757,2960-B-9565 ).  '2960-B-9565' already exists in level 'Regional Material Long Code' in the path ( Regional Material,( Blank ),( Blank )~24548,( Blank )~24549,( Blank )~24550,04,2960-B-9565 ). [->OK]
Thu 10 Dec 2009 12:36:35 AM 2 00000000 (TR2318) Transformer has detected 424 attempts to create a category in more than one path. Refer to the online help for a detailed explanation of level uniqueness. [->OK]
Thu 10 Dec 2009 12:36:35 AM 4 00000000 End processing 50611 records from data source 'Material (with transaction)'.
Thu 10 Dec 2009 12:36:35 AM 4 00000000 Timing, READ DATA SOURCE,00:00:25
Thu 10 Dec 2009 12:36:35 AM 4 00000000 End cube update.
Thu 10 Dec 2009 12:36:35 AM 4 00000000 Timing, TOTAL TIME (CREATE CUBE),00:00:38
Thu 10 Dec 2009 12:36:35 AM 2 00000000 (TR0136) A uniqueness violation was detected.  The process has been aborted. [->OK]

Investigating