PM42367: XQE-PLN-0174 THE COLUMN 435 MUST BE CONTAINED IN AN AGGREGATE FUNCTION OR THE GROUP BY CLAUSE. AT

APAR status

• Closed as program error.

Error description

• Various tests simulating moderately large burst/master-detail
  patterns will run with classic DMR but fail when attempted with
  DQM.???XQE-GEN-0002 An unexpected exception occurred. at
  com.cognos.xqe.cubingservices.V5QueryHandler.logThrowableAndBuil
  dSOAPFault(V5QueryHandler.java:703)
  at
  com.cognos.xqe.cubingservices.V5QueryHandler.execute(V5QueryHand
  ler.java:410)
  at
  com.ibm.cubeservices.mdx.v5.V5ProviderFacade.execute(V5ProviderF
  acade.java:98)
  at
  com.cognos.cubics.providers.cubingservices.CSStatement.execute(C
  SStatement.java:152)
  at
  com.ibm.cubeservices.mdx.v5.V5RequestHandler.handleRequest(V5Req
  uestHandler.java:54)
  at
  com.ibm.cubeservices.mdx.comms.Servlet.processMessage(Servlet.ja
  va:124)
  at
  com.ibm.cubeservices.mdx.comms.ComWorker.processQueryInputMsg(Co
  mWorker.java:361)
  at
  com.ibm.cubeservices.mdx.comms.ComWorker.processInput(ComWorker.
  java:266)
  at
  com.ibm.cubeservices.mdx.comms.ComWorker.call(ComWorker.java:176
  )
  at
  com.ibm.cubeservices.mdx.comms.ComWorker.call(ComWorker.java:78)
  at
  java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:31
  5)
  at java.util.concurrent.FutureTask.run(FutureTask.java:150) at
  java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoo
  lExecutor.java:898)
  at
  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
  cutor.java:920)
  at java.lang.Thread.run(Thread.java:736) Caused by:
  java.lang.NullPointerException at
  com.cognos.xqe.ast.v5Exp.V5BoundParameter.getPromptLevelInfoFrom
  MasterDetailLink(V5BoundParameter.java:656)
  at
  com.cognos.xqe.ast.v5Exp.V5BoundParameter.getLevels(V5BoundParam
  eter.java:465)
  at
  com.cognos.xqe.transformation.v5.BindV5Parameter.bindV5Parameter
  ToBoundParameter(BindV5Parameter.java:221)
  at
  com.cognos.xqe.transformation.v5.BindV5Parameter.apply(BindV5Par
  ameter.java:97)
  at
  com.cognos.xqe.query.engine.QTETransformationEngine.applyTransfo
  rmation(QTETransformationEngine.java:1194)
  at
  com.cognos.xqe.query.engine.QTETransformationEngine.applyApplica
  bleTransformation(QTETransformationEngine.java:1112)
  at
  com.cognos.xqe.query.engine.QTETransformationEngine.applyIndexed
  Transformations(QTETransformationEngine.java:630)
  at
  com.cognos.xqe.query.engine.QTETransformationEngine.transformati
  onIteration(QTETransformationEngine.java:565)
  at
  com.cognos.xqe.query.engine.QTETransformationEngine.applyTransfo
  rmations(QTETransformationEngine.java:368)
  at
  com.cognos.xqe.query.planner.QueryPlanner.plan(QueryPlanner.java
  :304)
  at
  com.cognos.xqe.query.planner.QueryPlanner.planQuery(QueryPlanner
  .java:344)
  at
  com.cognos.xqe.query.engine.QueryEngine.prepareRequest(QueryEngi
  ne.java:594)
  at
  com.cognos.xqe.query.engine.QueryEngine.fetchRSAPIDatasets(Query
  Engine.java:448)
  at
  com.cognos.xqe.query.engine.QueryEngine.executeRequest(QueryEngi
  ne.java:400)
  at
  com.cognos.xqe.bibushandler.ExecuteRequestAdapter.executeRequest
  (ExecuteRequestAdapter.java:96)
  at
  com.cognos.xqe.cubingservices.V5QueryHandler.executeRequestInSeq
  uence(V5QueryHandler.java:555)
  at
  com.cognos.xqe.cubingservices.V5QueryHandler.execute(V5QueryHand
  ler.java:397)
  ... 13 more =
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh     *
  * 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