JR47901: CMVC 230802 - INVCNFREL and INVCNF tables are not staged for DOM Inventory system

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

• INVCNFREL and INVCNF tables are not staged for DOM Inventory
  system
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce users on V7.0 who use the DOM inventory
  system and expect the INVCNFREL and INVCNF tables to be staged.
  
   PROBLEM ABSTRACT:
   INVCNFREL and INVCNF tables are not staged for DOM Inventory
  system
  
   BUSINESS IMPACT:
   Unable to look up inventory count from storefront
  
   RECOMMENDATION:
  

Problem conclusion

• The fix requires the user to perform the following additional
  steps:
  
   1. Create staging triggers, this needs to be applied only on
  staging server:
  
   For DB2 or OS400, connect to WC database first, then run the
  SQL file like this:
   db2 -td# -vf
  WCS_install_dirschemadb2aparwcs.create.stage.trigger.invcnf.sql
  >>createTriggers.log
  
   For Oracle, run the SQL file like this:
   sqlplus -s %user%/%password%@%database% <
  WCS_install_dirschemaoracleaparwcs.create.stage.trigger.invcnf.s
  ql >>createTriggers.log
         where %user% is the Oracle user name, e.g. wcs
         %password% is the Oracle user password, e.g. wcs1
         %database% is the database name, e.g. ORCL
  
   Check the log to ensure the SQLs execute successfully.
  
   2. Create the staging table record, this needs to be done on
  both staging and production server:
  
   For DB2 or OS400, connect to WC database first, then run the
  SQL file like this:
   db2 -tvf
  WCS_install_dirschemadb2aparwcs.insert.stgmertab.invcnf.sql
  >>insertStgmertab.log
  
   For Oracle, run the SQL file like this:
   sqlplus -s %user%/%password%@%database% <
  WCS_install_dirschemaoracleaparwcs.insert.stgmertab.invcnf.sql
  >>insertStgmertab.log
         where %user% is the Oracle user name, e.g. wcs
         %password% is the Oracle user password, e.g. wcs1
         %database% is the database name, e.g. ORCL
  
   Check the log to ensure the SQLs execute successfully.
  
  
  
   -------------------------------------------------------------
   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 DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R700 PSY

     UP