Direct links to fixes
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 number
JR47901
Reported component name
WC BUS DEV ED W
Reported component ID
5724I3900
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-09-26
Closed date
2014-03-17
Last modified date
2014-03-17
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
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
07 December 2021