JR55876: Scheduler jobs fail when trying to run the PopulateExpressionForCatalogFilters command

APAR status

• Closed as program error.

Error description

• Scheduler jobs that populate expressions for contracts might
  encounter ObjectNotFoundException errors when inactive contracts
   exist.[Not always caused ONF, but it will populate solr query
  in Expersson table not correctly.]
  
  This issue occurs because the inactive contracts are not
  filtered out.
  
  You might notice an error similar to the following sample:
  
  com.ibm.commerce.contract.objects.ContractKey incompatible with
  com.ibm.commerce.contract.objects.ContractKey".
  java.lang.ClassCastException:
  com.ibm.commerce.contract.objects.ContractKey incompatible with
  com.ibm.commerce.contract.objects.ContractKey
      at
  com.ibm.commerce.contract.beansrc.CachedContractAccessBean.getKe
  yForCache(CachedContractAccessBean.java:100)
      at
  com.ibm.commerce.contract.beansrc.CachedContractAccessBean.refre
  shCopyHelper(CachedContractAccessBean.java:191)
      at
  com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean.__getCache(Abst
  ractEntityAccessBean.java:101)
      at
  com.ibm.commerce.contract.objects.ContractAccessBean.getReferenc
  eNumber(ContractAccessBean.java:790)
      at
  com.ibm.commerce.registry.TradingAgreementCopy.<init>(TradingAgr
  eementCopy.java:220)
      at
  com.ibm.commerce.registry.TradingAgreementRegistry.retrieve(Trad
  ingAgreementRegistry.java:291)
      at
  com.ibm.commerce.registry.AbstractManagedDynamicCacheRegistry.fi
  ndObject(AbstractManagedDynamicCacheRegistry.java:137)
      at
  com.ibm.commerce.registry.TradingAgreementRegistry.find(TradingA
  greementRegistry.java:96)
      at
  com.ibm.commerce.contract.catalogfilter.command.ResolveProductSe
  tSolrExpressionCmdImpl.performExecute(ResolveProductSetSolrExpre
  ssio
  CmdImpl.java:98)
      at
  com.ibm.commerce.command.ECCommandTarget.executeCommand(ECComman
  dTarget.java:157)
      at
  com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCach
  e.java:332)
      at
  com.ibm.websphere.command.CacheableCommandImpl.execute(Cacheable
  CommandImpl.java:166)
      at
  com.ibm.commerce.command.MeasuredCacheableCommandImpl.execute(Me
  asuredCacheableCommandImpl.java:63)
      at
  com.ibm.commerce.command.AbstractECTargetableCommand.execute(Abs
  tractECTargetableCommand.java:199)
      at
  com.ibm.commerce.contract.catalogfilter.ProductSetSearchExpressi
  onBuilder.getExpression(ProductSetSearchExpressionBuilder.java:1
  10)
      at
  com.ibm.commerce.catalog.commands.PopulateExpressionsForCatalogF
  iltersCmdImpl.generateProductSetExpression(PopulateExpressionsFo
  rCat
  logFiltersCmdImpl.java:495)
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7 Feature Pack 7 or later, and
  Version 8.
  
  PROBLEM ABSTRACT:
  Scheduler jobs fail when trying to run the
  PopulateExpressionForCatalogFilters command
  
  BUSINESS IMPACT:
  Scheduler job creates unnecessary Solr queries that might cause
  a data error.
  
  RECOMMENDATION:
  

Problem conclusion

• Added a SQL query to filter the invalid contracts for
  PopulateExpressionForCatalogFilters.
  

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