PK85514: SQL0302N IN MENU COMPONENTS WHEN MENU.INCLUDECONTENTLINKS=FALSE

APAR status

• Closed as program error.

Error description

• When rendering a menu item an SQL0302N error is encounterd when
  menu.includeContentLinks=false is set in the
  WCMConfigService.properties file.
  

Local fix

• N/A
  

Problem summary

• JCR L3 analysis finds that the "exclude current content" query
  generates xpath which incorrectly performs a comparison on the
  "ibmcontentwcm:referenceUuid" attribute for nodes of type
  "ibmcontentwcm:webcontent"; however nodes of that type do not
  have that attribute. Don't understand why this issue hasn't been
  seen before, but it could be something specific to how the
  customer's SQL optimizer is handling this query. In any case,
  the query appears to be incorrect.
  
  Also, the particular code that generates this query should only
  be required if "include content links" is selected on the menu
  component; however, the code incorrectly generates this query
  regardless of whether "include content links" is selected. For
  this customer, "include content links" is not selected, so by
  correcting the code to only generate the faulty query, the
  problem is solved for this case.
  
  This leaves open the question of whether the query itself needs
  to be fixed; could conceivably come back if a customer sees this
  issue with both "exclude current content" and "include content
  links" selected. Exchanged email with Kenny Sabir about this and
  he thinks the query should be ok as is.
  
  Customer gets sql error when rendering menu components that have
  "exclude current content" flag set.
  The code that is causing the error should only execute when both
  "exclude current content" and "include content links" are
  selected; however it currently ignores the state of "include
  content links" and executes whenever "exclude current content"
  flag is set.
  This  customer has "include content links" deselected (for
  another PMR).
  So fixing the code to test for "include content links" fixes the
  problem for this customer.
  

Problem conclusion

• add a test for "include content links" around the subject code.
  

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

  LOTUS WEB CONT

• Fixed component ID

  5724I2900

Applicable component levels

• R61A PSY

     UP