JR54293: Products are not displayed in proper sequence after applying JR5 3438

APAR status

• Closed as program error.

Error description

• After the Feature Pack 8 cumulative interim fix JR53438 is
  applied, the Solr query is missing single quotation marks within
   the category_id portion of the 'sort' function.
  
  For example:
  
  "sort=getSequenceByCatalogAndCategory(sequence,12003,)"
  
  is generated, but the correct syntax should be:
  
  "sort=getSequenceByCatalogAndCategory(sequence,'12003','')"
  
  The function still works without the quotes if a category is
  passed in, for example:
  Working query:
  
  http://hostname:3737/solr/MC_10101_CatalogEntry_en_US/select?q=n
  ame:shirt&fl=sequence&sort=getSequenceByCatalogAndCategory(seque
  nce,10101,"") asc&rows=50
  
  Nonworking query:
  
  http://hostname:3737/solr/MC_10101_CatalogEntry_en_US/select?q=n
  ame:shirt&fl=sequence
  sort=getSequenceByCatalogAndCategory(sequence,10101,)
  asc&rows=50
  
  Without the quotes and without a category, a
  NullPointerException is thrown:
  
  java.lang.NullPointerException
   at
  com.ibm.commerce.foundation.internal.server.services.search.func
  tion.solr.SolrSearchGetSequenceByCatalogAndCategoryFunction$Sequ
  enceFunctionValues.strVal(SolrSearchGetSequenceByCatalogAndCateg
  oryFunction.java:285)
   at
  com.ibm.commerce.foundation.internal.server.services.search.func
  tion.solr.SolrSearchGetSequenceByCatalogAndCategoryFunction$1.st
  rVal(SolrSearchGetSequenceByCatalogAndCategoryFunction.java:177)
   at
  com.ibm.commerce.foundation.internal.server.services.search.func
  tion.solr.SolrSearchGetSequenceByCatalogAndCategoryFunction$1.do
  ubleVal(SolrSearchGetSequenceByCatalogAndCategoryFunction.java:1
  66)...
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce V7 Feature Pack 8
  
  PROBLEM ABSTRACT:
  Products are not displayed in proper sequence after applying
  JR53438
  
  BUSINESS IMPACT:
  Unable to display products in proper sequence by category
  
  RECOMMENDATION:
  

Problem conclusion

• Include a single quotation mark around the 3rd argument in the
  query function.
  

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