IBM Support

PM75121: XQE-PLN-0248 THE COLUMN '<COLUMN>' OF '<TABLE>' COULD NOT BE FOU ND IN THE MODEL. POSSIBLY CAUSED BY OUT-OF-DATE QUERY SUBJECT...

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Running Cognos 10.1.1 report with Dynamic Query Mode enabled
    intermittently fails with error: ??XQE-PLN-0248 The column
    '<Column>' of '<Table>' could not be found in the model.
    Possibly caused by out-of-date query subject definition:
    '<Table>'??=== JAVA STACK TRACE === XQE-PLN-0248 The column
    '<Column>' of '<Table>' could not be found in the model.
    Possibly caused by out-of-date query subject definition:
    '<Table>' at
    com.cognos.xqe.transformation.relational.binding.SQLBinder.bindQ
    ualifiedColumn(SQLBinder.java:331)
    at
    com.cognos.xqe.transformation.relational.binding.SQLBinder.bindC
    olumns(SQLBinder.java:234)
    at
    com.cognos.xqe.transformation.relational.binding.BindSQLProject.
    apply(BindSQLProject.java:84)
    at
    com.cognos.xqe.query.engine.QTETransformationEngine.applyTransfo
    rmation(QTETransformationEngine.java:1225)
    at
    com.cognos.xqe.query.engine.QTETransformationEngine.applyApplica
    bleTransformation(QTETransformationEngine.java:1143)
    at
    com.cognos.xqe.query.engine.QTETransformationEngine.applyBottomU
    pTransformations(QTETransformationEngine.java:846)
    at
    com.cognos.xqe.query.engine.QTETransformationEngine.applyBottomU
    pTransformations(QTETransformationEngine.java:778)
    at
    com.cognos.xqe.query.engine.QTETransformationEngine.transformati
    onIteration(QTETransformationEngine.java:563)
    at
    com.cognos.xqe.query.engine.QTETransformationEngine.applyTransfo
    rmations(QTETransformationEngine.java:370)
    at
    com.cognos.xqe.query.planner.QueryPlanner.plan(QueryPlanner.java
    :328)
    at
    com.cognos.xqe.query.planner.QueryPlanner.planQuery(QueryPlanner
    .java:389)
    at
    

Local fix

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM75121

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    A11

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-16

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

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

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

Fix information

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013