PI85029: PROJECTED QUERY THAT INCLUDES AN ORACLE CLOB WILL RESULT IN A REPORT SERVER RRROR IN 10.2.2 FP6 AND LATER

APAR status

• Closed as program error.

Error description

• If a CLOB is included in a projected query in a report it will
  fail and a dump file will be generated in 10.2.2 FP6 and later
  when run in CQM.  This works in 10.2.2 FP5 and earlier.
  
  DPR-ERR-2056 The Report Server is not responding.
  Handler trace back:
  [the_dispatcher]
  com.cognos.pogo.handlers.performance.PerformanceIndicationHandle
  r
  [the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
  [service_lookup]
  com.cognos.pogo.handlers.engine.ServiceLookupHandler
  [load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
  [lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
  [reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler
  [warp_with_authenticate]
  com.cognos.pogo.handlers.logic.ChainHandler
  [do_warp] com.cognos.pogo.handlers.logic.ChainHandler
  [warpmta] com.cognos.pogo.reportservice.ReportServerHandler
  

Local fix

• Run the query using Dynamic Query Mode
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.2 Fix Pack  *
  * 9                                                            *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

• A fix for this APAR is targeted for IBM COGNOS 10.2.2 BI Fix
  Pack 9.
  The Fix Pack Release Schedule can be found at
  http://www.ibm.com/software/analytics/support/fixes/pbi_schedule
  .html.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI80821

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels

• RA22 PSN

     UP