JR53045: stagingprop utility fails during post-propagation

APAR status

• Closed as new function.

Error description

• The post-propagation stage of the stagingprop utility fails on a
  query against the DMEMSPOTCOLLDEF table:
  SELECT DMEMSPOTCOLLDEF.EMSPOT_ID FROM DMEMSPOTCOLLDEF WHERE
  DMEMSPOTCOLLDEF.COLLATERAL_ID IN (?)
  
  The parameter marker is bound with the value that's retrieved
  from the BIGINTOBJECT_ID column of the ATCHREL table using the
  query:
  SELECT ATCHREL.BIGINTOBJECT_ID FROM ATCHREL WHERE
  ATCHREL.ATCHREL_ID IN (?)
  
  This occurs because DMEMSPOTCOLLDEF.COLLATERAL_ID is of type
  INTEGER and ATCHREL.BIGINTOBJECT_ID is of type BIGINT. So
  there's the potential for the BIGINT value to be truncated when
  converted to type INTEGER.
  

Local fix

• The post-propagation process involving cache invalidation can be
   disabled for the ATCHAST, ATCHREL, COLLATERAL and COLLDESC
  tables:
  
  Edit the resource:
  com.ibm.commerce.staging.StagingPostRowPropagateConfig.propertie
  s
  
  inside this JAR file:
  <WC_UserInstallDir>/lib/Utilities.jar:
  
  
  by commenting out these lines:
  atchast=com.ibm.commerce.staging.postprop.StagingPostRowAtchast
  atchrel=com.ibm.commerce.staging.postprop.StagingPostRowAtchrel
  collateral=com.ibm.commerce.staging.postprop.StagingPostRowColla
  teral
  colldesc=com.ibm.commerce.staging.postprop.StagingPostRowColldes
  c
  
  i.e.,
  #atchast=com.ibm.commerce.staging.postprop.StagingPostRowAtchast
  #atchrel=com.ibm.commerce.staging.postprop.StagingPostRowAtchrel
  #collateral=com.ibm.commerce.staging.postprop.StagingPostRowColl
  ateral
  #colldesc=com.ibm.commerce.staging.postprop.StagingPostRowCollde
  sc
  
  Subsequent invocations of the stagingprop utility will skip
  post-propagation for these tables.
  

Problem summary

• USERS AFFECTED:
  IT users who run the stagingprop utility
  
  PROBLEM ABSTRACT:
  stagingprop utility fails during post-propagation
  
  BUSINESS IMPACT:
  stagingprop utility will fail to propagate data associated with
  the ATCHREL table
  
  RECOMMENDATION:
  

Problem conclusion

• Adjusted the query used to retrieve the ATCHREL.BIGINTOBJECT_ID
  column values from:
  SELECT ATCHREL.BIGINTOBJECT_ID FROM ATCHREL ATCHREL WHERE ...
  
  to:
  SELECT ATCHREL.BIGINTOBJECT_ID FROM ATCHREL ATCHREL WHERE
  ATCHREL.ATCHOBJTYP_ID = 4 AND ...
  
  
  By only selecting attachments associated with collateral objects
   (ATCHOBJTYP_ID == 4) the returned BIGINTOBJECT_ID column values
   will always have a max INTEGER value or less.
  

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