JR49600: CMVC 234687 - Sorting gift registry results by EVENTDATE DESC fails

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

• Setting the value of sortByFieldName to EVENTDATE DESC results
  in invalid SQL causing an error like the following:
  
   [2/14/14 4:34:21:969 CST] 00000049 WC_GIFTREGIST 2
  com.ibm.commerce.giftregistry.beans.GiftRegistrySearchDataBeanBa
  se executeSimilarMatchesSearchOnDB2() An exception was caught
  while running the similar matches query. Returning null.
   [2/14/14 4:34:21:970 CST] 00000049 WC_GIFTREGIST 2
  com.ibm.commerce.giftregistry.beans.GiftRegistrySearchDataBeanBa
  se executeSimilarMatchesSearchOnDB2()
  com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
  SQLCODE=-206, SQLSTATE=42703, SQLERRMC=EVENTDATE, DRIVER=4.12.55
  

Local fix

• Set the sortByFieldName value to EVENTDESC which will return the
   results in ascending order
  

Problem summary

• USERS AFFECTED:
   WebSphere Commerce v7 users who are using the sortByFieldName
  parameter with a DESC value
  
   PROBLEM ABSTRACT:
   Sorting gift registry results by EVENTDATE DESC fails
  
   BUSINESS IMPACT:
   Low - cannot control the order in which the results are sorted
  
   RECOMMENDATION:
  

Problem conclusion

• The code has been updated to allow the SQL to be formed
  correctly
   -------------------------------------------------------------
   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