Defect HC-4439
Oracle staging triggers on PLPAGE lead to stageprop error
Software
Customer case | Applies to | Corrected in |
---|---|---|
CS0132191 | V8.0.4.0 | 8.0.4.25 |
Observed behavior
The Oracle staging triggers are creating staglog entries with incorrect key values, leading to problems in the stagingprop operation.
Expected behavior
The triggers were incorrectly recording the storeent_id value instead of the plpage_id for the records being touched.
Resolution
The Oracle triggers for table PLPAGE,
ISTG_PLPAGE, USTG_PLPAGE, DSTG_PLPAGE
were updated to record the page_id instead of the storeent_id