JR50438: DSL two-step queries fail when the 'usePrimaryKeyValues' flag is set to false.

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• When configuring query generation to form a single query by
  injecting the XPath to SQL statement into the association SQL
  statement as a sub-select, the generated query contains an
  invalid comment. This issue occurs when tracing for the
  com.ibm.commerce.foundation component is enabled.
  

Local fix

• To resolve this issue, use one of the following workarounds:
  
   1) Set the 'usePrimaryKeyValues' flag to 'true'.
   2) Disable tracing for the com.ibm.commerce.foundation
  component.
   3) Set the value of the DSLQueryNameTracing property to 'false'
  in the foundation wc-component.xml file.
  

Problem summary

• USERS AFFECTED:
   Customers who defined custom access profiles with the
  'usePrimaryKeyValues' flag set to 'false' .
  
   PROBLEM ABSTRACT:
   DSL two-step queries fail when the 'usePrimaryKeyValues' flag
  is set to false.
  
   BUSINESS IMPACT:
   Two-step queries can fail, causing hindering DSL product
  functionality.
  
   RECOMMENDATION:
  

Problem conclusion

• Use a different SQL comment syntax on DB2 and Oracle. On Derby,
  users must still disable query name tracing by setting the
  DSLQueryNameTracing property to 'false' when the
  'usePrimaryKeyValues' flag is set to 'false'.
  
  
   -------------------------------------------------------------
   The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
   http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

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

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP