Defect HC-4440
Oracle staging triggers on table PLPAGE lead to stagingprop error 163
Software
| Customer case | Applies to | Corrected in |
|---|---|---|
| CS0132191 | V9.0.0.0 | 9.0.1.12 |
Observed behavior
Oracle staging triggers for the table PLPAGE cause StagingProp utility to terminate with error 163.
Expected behavior
HCL Commerce uses the STAGLOG table to keep track of changes made in the staging environment so that those changes can be processed periodically by the StagingProp utility. Each table that is to be staged has staging triggers that keep track of changes to the table and update the STAGLOG table. The triggers for Oracle databases requires an update to enable the PLPAGE table to be monitored properly.
Resolution
The staging triggers for PLPAGE have been updated in the wcs.stage.trigger.sql file to correct this error.