JR43559: CMVC 218643 - ADDRESS ISSUES USING SOLR WITH ORACLE

APAR status

• Closed as program error.

Error description

• When navigating the catalog after setting up Solr search and
  building the index, the following error is displayed:
  
  The store has encountered a problem processing the last request.
  Try again later. If the problem persists, contact your site
  administrator.
  
  The Commerce trace shows the following:
  
  Commerce trace shows:
  
  CWXFS2005E: Cannot connect to the search server: Internal Server
  Error
  
  Solr trace shows:
  
  SolrCore E org.apache.solr.common.SolrException log
  java.lang.NumberFormatException: empty String
      at java.lang.Throwable.<init>(Throwable.java:67)
      at
  sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.ja
  va:1040)
      at java.lang.Float.valueOf(Float.java:399)
      at java.lang.Float.<init>(Float.java:500)
      at
  com.ibm.commerce.foundation.internal.server.services.search.func
  tion.solr.SolrSearchGetSequenceByCatalogAndCategoryFunction$1.fl
  oatVal(SolrSearchGetSequenceByCatalogAndCategoryFunction.java:13
  8)
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce v7 users who use Solr search where sequence
  is empty
  
  PROBLEM ABSTRACT:
  'NumberFormatException: empty String' error occurs when trying
  to navigate the catalog after successfully building Solr index
  
  BUSINESS IMPACT:
  High Impact - store cannot be navigated
  
  RECOMMENDATION:
  

Problem conclusion

• The empty string is forced to a null value so that it will skip
  further parsing
  
  -------------------------------------------------------------
  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