PI85000: STORED PROCEDURE REPORT PERFORMANCE IS DEGRADED AFTER UPGRADE TOFIX PACK 8

APAR status

• Closed as program error.

Error description

• A report based on a stored procedure contains several items on
  the page based on the same stored procedure query.  In a
  previous version of 10.2.2, when the report was run the stored
  procedure would only be executed once.  After upgrading to Fix
  Pack 8, the stored procedure is run once for each object on the
  page, which makes the report take longer to complete.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.2 Fix Pack  *
  * 9                                                            *
  ****************************************************************
  Configuration Instructions:
  Requires the following setting in the <general> tab in
  xqe.config.xml file
  
        <queryReuse enabled="true" size="10">
             <allowReuseOfParameterizedQueries value="true"/>
         </queryReuse>
  

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:

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

  PI85261 PI86244

Fix information

• Fixed component name

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels

• RA22 PSN

     UP