PH00312: PROMPT MACROS CAUSE QUERY SERVICE INTERNAL ERRORS BECAUSE NOT PROPERLY HANDLED

APAR status

• Closed as suggestion for future release.

Error description

• Seen for Dashboards while reports work.
  
  The following error is shown in the user interface:
  User interface shows:
  Query Service internal error has occurred.
  
  XQE log documents:
  Caught error in the Query Service: XQE-QTE-0008 The query
  contains an unresolved parameter(s)
  
  Background:
  The Framework Manager package used contains queries with prompt
  macros to dynamically define the source, for example which view
  or table to select (having same metadata).
  Sample select:
  SELECT * FROM
  [my_database].PRODUCT_#prompt('mySelection','token','EN')#
  
  Another sample use the macro to select the language relevant
  column by replacing the language suffix (here EN, DE etc.) by a
  macro expression.
  Sample SQL:
  SELECT
   ORDER_METHOD.ORDER_METHOD_CODE,
   ORDER_METHOD.ORDER_METHOD_#prompt('myLanguage','token','EN')#
  FROM ...
  

Local fix

• Where possible, do not use macros for the time being.
  Or include the prompt subject in the deployment/ package to
  allow access to metadata information.
  
  Or (working in 11.0.8, but no more in 11.0.9), do not use macros
  on database objects (import layer),
  implement them on model query subjects (next modelling
  layer(s)) or use a Parameter Map and/or a prompt macro to select
  one of the Parameter Map Keys.
  

Problem summary

Problem conclusion

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

Applicable component levels