PM51814: CONCURRENT QUERY PROCESSING CAUSING ERROR "RSV-SRV-0040 AN APPLICATION ERROR HAS OCCURRED. CONTACT YOUR ADMINISTRATOR."

APAR status

• Closed as program error.

Error description

• If a report Prompt Page has a page query, the Execution Method
  property cannot be set to Concurrent.  In addition, any prompt
  queries that are shared by 2 or more prompts cannot have an
  Execution Method of Concurrent when there is a Page Query.
  ??ERROR MESSAGE?RSV-SRV-0040 An application error has occurred.
  Contact your Administrator. ?Details ?CCLAssertError:0:Fatal:
  CCL_ASSERT_NAMED(m_bAllRowsOptimization == false, "The master
  dataset cannot be re-used for a second iterator if AllRows
  optimization was applied when the query was executed.");
  

Local fix

• Set Query property - Query Hings > Execution Method = Sequential
  .
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos 10 Business Intelligence 10.1.1 Fix    *
  * Pack 1                                                       *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  COG8 BI REPORT

• Fixed component ID

  5724W12RS

Applicable component levels

• RA11 PSN

     UP