UPDATE ! PF-SRV-6110 Run failed

Hi There all, :’( (anyone knows what POGO means)

UPDATE:
When I make a Tab from a folder (for example testnico within public folders) and I create a cognos viewer within teh testnico TAB then I can do anything with it. I can insert a Item etc with no errors.
But NOT in the folder testnico under public folders.

Is this a matter of rights (we have a OTAP enviroment and we checked all the rights and capabilities and everything looks the same)
From a Tab I can work, from a folder I can’t.

What’s interesting is that from a folder Cognos Viewer is started and from a Tab not. Is there a difference ??

:frowning: >:(


I have a strange error (one that is not very known on the internet). When I want to add an entry inside Cognos Viewer I’ll get the following error.
PF-SRV-6110 Run failed with a lot of Java details.

In advanced my excuses for the long list of Java.

For what I can understand is that for some reasons he can’t write the XML. By root cause (at the end of the Java) and something about “updateCustom(CMBaseProvider.java:200)”

I don’t really know what all that Java means but my first guess is that Cognos is not able to write something in the Content Store ??? (don’t smile if I am wrong) this is all new to me. ???

Well thank you in advance and I hope someone can respond because I have been trying several thing last week.

With regards,

Nico

Details errors

com.cognos.portal.fragment.server.DashboardException: PF-SRV-6110 Uitvoeren mislukt.
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:221)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:102)
at com.cognos.portal.fragment.server.DashboardProcessor.writeXML(DashboardProcessor.java:288)
at com.cognos.portal.fragment.server.DashboardProcessor.process(DashboardProcessor.java:244)
at com.cognos.portal.fragment.service.DashboardService.invokeImpl(DashboardService.java:326)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:673)
at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:639)
at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:388)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:126)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:149)

    at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263) 
    at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:146) 
    at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:264) 
    at com.cognos.pogo.transport.PogoServlet.doPost(PogoServlet.java:595) 
    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:324) 
    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:579) 
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) 
    at java.lang.Thread.run(Thread.java:810) 

com.cognos.portal.xml.pipeline.PipelineException: PF-SRV-6110 Uitvoeren mislukt.
at com.cognos.portal.fragment.server.pipeline.CMBaseProvider.updateCustom(CMBaseProvider.java:200)
at com.cognos.portal.fragment.server.pipeline.CMBaseProvider.execute(CMBaseProvider.java:118)
at com.cognos.portal.xml.pipeline.ProcessInstance.process(ProcessInstance.java:238)
at com.cognos.portal.xml.pipeline.PipelineDefinition.executePipeline(PipelineDefinition.java:378)
at com.cognos.portal.xml.pipeline.Pipeline.execute(Pipeline.java:118)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:218)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:102)
at com.cognos.portal.fragment.server.DashboardProcessor.writeXML(DashboardProcessor.java:288)
at com.cognos.portal.fragment.server.DashboardProcessor.process(DashboardProcessor.java:244)
at com.cognos.portal.fragment.service.DashboardService.invokeImpl(DashboardService.java:326)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:673)
at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:639)
at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:388)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:126)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:149)

    at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263) 
    at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:146) 
    at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:264) 
    at com.cognos.pogo.transport.PogoServlet.doPost(PogoServlet.java:595) 
    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:324) 
    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:579) 
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) 
    at java.lang.Thread.run(Thread.java:810)

Root Cause:
com.cognos.portal.xml.pipeline.PipelineException: PF-SRV-6110 Uitvoeren mislukt.
at com.cognos.portal.fragment.server.pipeline.CMBaseProvider.updateCustom(CMBaseProvider.java:200)
at com.cognos.portal.fragment.server.pipeline.CMBaseProvider.execute(CMBaseProvider.java:118)
at com.cognos.portal.xml.pipeline.ProcessInstance.process(ProcessInstance.java:238)
at com.cognos.portal.xml.pipeline.PipelineDefinition.executePipeline(PipelineDefinition.java:378)
at com.cognos.portal.xml.pipeline.Pipeline.execute(Pipeline.java:118)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:218)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:102)
at com.cognos.portal.fragment.server.DashboardProcessor.writeXML(DashboardProcessor.java:288)
at com.cognos.portal.fragment.server.DashboardProcessor.process(DashboardProcessor.java:244)
at com.cognos.portal.fragment.service.DashboardService.invokeImpl(DashboardService.java:326)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:673)
at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:639)
at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:388)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:126)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:149)

    at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263) 
    at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:146) 
    at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:264) 
    at com.cognos.pogo.transport.PogoServlet.doPost(PogoServlet.java:595) 
    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:324) 
    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:579) 
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) 
    at java.lang.Thread.run(Thread.java:810)

Pogo = performance-oriented grammar optimizer 8)

You can enable the following pogo logging will assist in narrowing down your cause.
NOTE: Make backups of all the files you want to change. And the performance of these logging may cause your Cognos environment to slow down…

Steps:

  1.    Backup the PogoLogkitConfig.xml file located within cognos\c8\webapps\p2pd\WEB-INF.
    
  2.    Open the PogoLogkitConfig.xml file in a text editor.
    
  3.    Add the following lines to the file.  
    

Ensure that the lines above are added below the following lines otherwise you will not get the desired results:

  1. Uncomment the line containing ReportServerInProgressRequests (remove the surrounding the line) as follows: *** This is only available in Cognos 8.1.209.83 and higher. It will not work in earlier releases. ***

Once again, ensure that the lines above are added below the following lines:

  1. Save the file. 
    
  2. The file named pogo_YYYY-MM-DD.log within the c8/logs directory will contain the additional pogo log information.   
    

Notes: -Restarting Cognos 8 is not required; the changes will take affect right away.

  • The pogo logs in the c8/logs directory that were currently being written to will be overwritten. This includes pogo_YYYY-MM-DD.log, pogoPerf_YYYY-MM-DD.log and pogoWarpFault_YYYY-MM-DD.log.

Hi Martijn,

Thank you for your effort. Its highly appreciated.
I have now these log files. But I cant’t make anything of it. It looks like no errors.
But there is also a file called: ipfInternal_java.log (create at the time I get the error in Cognos viewer (PF-SRV-6110)
In this file there is a section with the following:

JSQLStatement.f(Unknown Source)

The rest of the result is below.

Is there something that causing this. A corrupt Content database (SQL)

Thanks in advanced and with kindly regards,

Nico

277089663 WARN [Thread-10] - LogJDBCAppender::getLogStatement() - SQLException:
com.jnetdirect.jsql.JSQLException: String or binary data would be truncated.
at com.jnetdirect.jsql.JSQLException.makeFromDatabaseError(Unknown Source)
at com.jnetdirect.jsql.IOBuffer.processPackets(Unknown Source)
at com.jnetdirect.jsql.JSQLStatement.f(Unknown Source)
at com.jnetdirect.jsql.JSQLStatement.for(Unknown Source)
at com.jnetdirect.jsql.JSQLStatement.doExecute(Unknown Source)
at com.jnetdirect.jsql.JSQLPreparedStatement.execute(Unknown Source)
at com.cognos.indications.LogJDBCAppender.getLogStatement(LogJDBCAppender.java:1374)
at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:234)
at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:131)
at com.cognos.indications.LogJDBCAppender.append(LogJDBCAppender.java:189)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:221)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:57)
at org.apache.log4j.Category.callAppenders(Category.java:187)
at org.apache.log4j.Category.forcedLog(Category.java:372)
at org.apache.log4j.Category.log(Category.java:846)
at com.cognos.logserver.LogServerIndicationProcessor.run(LogServerIndicationProcessor.java:82)
at java.lang.Thread.run(Thread.java:810)