PM92304: UNABLE TO VALIDATE/TEST QUERY SUBJECT IN FM WHEN USING PROMPT MACRO.

APAR status

• Closed as program error.

Error description

• When prompt macro like below is included in a query subject,
  modelers are unable to validate/test it in Framework Manager.
  ?Even though prompt value is set, prompt screen appears again
  and again. Finally, it results in error and unable to publish.
  ??Select * from  [great_outdoors_sales].BRANCH where
  BRANCH_CODE=#prompt('brcd')#??(Environment)?Cognos BI 10.2.1 --
  reproduced.?Cognos BI 10.2.0 -- not reproduced.?
  

Local fix

Problem summary

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

  COG FRAMEWRK MG

• Fixed component ID

  5724W12FM

Applicable component levels

• RA21 PSN

     UP