JR50628: TradingAgreementAccessBean.findEntitledTradingAgreementByTypeFor BuyerUnderStore isn't cached

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

• The following SQL executes frequently:
  
   SELECT
  T1.ACCOUNT_ID,T1.REFERENCECOUNT,T1.TRADING_ID,T1.TRDTYPE_ID,T1.E
  NDTIME,T1.STARTTIME,T1.STATE,T1.MARKFORDELETE,T1.CREDITALLOWED,T
  1.REFTRADING_ID,T1.OPTCOUNTER
   FROMTRADINGT1
   WHEREstate=1andmarkfordelete=0andtrdtype_id=:1and(starttime<:2o
  rstarttimeisnull)and(endtime>:3orendtimeisnull)andtrading_idin
   (selecttrading_id
   fromparticipnt
   wherepartrole_id=2andtrading_idisnotnullandtermcond_idisnulland
  (member_idisnullormember_id=:4ormember_id=:5ormember_idin
   (selectancestor_id
   frommbrrel
   wheredescendant_id=:6)ormember_idin
   (selectmbrgrp_id
   frommbrgrpmbr
   wheremember_id=:7andexclude='0')))andtrading_idin
   (selectcontract_id
   fromstorecntr
   wherestore_id=:8)orderbytrading_id
  
   The SQL is triggered by the method
  TradingAgreementAccessBean.findEntitledTradingAgreementByTypeFor
  BuyerUnderStore() as seen in this sample stack:
  
   at
  com/ibm/commerce/contract/objects/TradingAgreementAccessBean.fin
  dEntitledTradingAgreementByTypeForBuyerUnderStore(TradingAgreeme
  ntAccessBean.java:184(Compiled Code))
   at
  com/ibm/commerce/contract/facade/server/commands/FetchContractBy
  IdentifierCmdImpl.fetchContracts(FetchContractByIdentifierCmdImp
  l.java:99(Compiled Code))
   at
  com/ibm/commerce/contract/facade/server/commands/AbstractFetchCo
  ntractCmdImpl.execute(AbstractFetchContractCmdImpl.java:83(Compi
  led Code))
   at
  com/ibm/commerce/contract/facade/server/commands/GetContractCmdI
  mpl.performExpression(GetContractCmdImpl.java:70(Compiled Code))
   at
  com/ibm/commerce/contract/facade/server/ContractFacadeImpl.getCo
  ntract(ContractFacadeImpl.java:46(Compiled Code))
   at
  com/ibm/commerce/foundation/internal/client/services/invocation/
  InvocationService.invoke(InvocationService.java:113(Compiled
  Code))
   at
  com/ibm/commerce/foundation/client/facade/bod/AbstractBusinessOb
  jectDocumentFacadeClient.sendBusinessObjectDocument(AbstractBusi
  nessObjectDocumentFacadeClient.java:451(Compiled Code))
   at
  com/ibm/commerce/contract/facade/client/ContractFacadeClient.get
  Contract(ContractFacadeClient.java:104(Compiled Code))
   at
  com/ibm/commerce/catalog/facade/server/services/search/metadata/
  SearchCatalogEntryViewPriceResultFilter.createContractPrices(Sea
  rchCatalogEntryViewPriceResultFilter.java:609(Compiled Code))
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce v7.0 users, in particular B2B stores
  
   PROBLEM ABSTRACT:
   TradingAgreementAccessBean.findEntitledTradingAgreementByTypeFo
  rBuyerUnderStore isn't cached
  
   BUSINESS IMPACT:
   Possible performance degradation
  
   RECOMMENDATION:
  

Problem conclusion

• FetchContractByIdentifierCmdImpl.fetchContracts() has been
  updated and instead of using
  TradingAgreementAccessBean.findEntitledTradingAgreementByTypeFor
  BuyerUnderStore(), it will now use:
  ContractCmdUtil.getEligibleTradingAgreements()
   The new code uses an equivalent SQL that allows for caching.
  
   -------------------------------------------------------------
   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