ARC incremental mode, order deletions not propagated
- Article Type: General
- Product: Aleph
- Product Version: 21
Problem Symptoms:
Deletion of orders in Complete Incremental ETL are not propagated
Cause:
Missing Triggers
Resolution:
Deletions of records are only propagated if the relevant triggers are set and z900 records created.
Follow instructions of 'Appendix C. Aleph Z900 Oracle Table, Index and Related Triggers' of document 'ALEPH Configuration for ARC' to implement the relevant triggers.
Additional Information
Use util 17/6/4. Show Trigger Status to check the Status of the active triggers.
For ARC Complete Incremental the following trigger will show in XXX50 library:
Z16_TRIGGER_1 Z16 ENABLED
Z20_TRIGGER_1 Z20 ENABLED
Z30H_TRIGGER_1 Z30H ENABLED
Z30_TRIGGER_1 Z30 ENABLED
Z313_TRIGGER Z30 ENABLED
Z313_TRIGGER_1 Z30 ENABLED
Z31_TRIGGER_1 Z31 ENABLED
Z36H_TRIGGER_1 Z36H ENABLED
Z36_TRIGGER_1 Z36 ENABLED
Z37_TRIGGER_1 Z37 ENABLED
Z38_TRIGGER_1 Z38 ENABLED
Z501_TRIGGER_1 Z501 ENABLED
Z601_TRIGGER_1 Z601 ENABLED
Z68_TRIGGER_1 Z68 ENABLED
Z70_TRIGGER_1 Z70 ENABLED
Z76_TRIGGER_1 Z76 ENABLED
Z77_TRIGGER_1 Z77 ENABLED
Z78_TRIGGER_1 Z78 ENABLED
Additional trigger for usr_library:
Z303_TRIGGER_1 Z303 ENABLED
Z304_TRIGGER_1 Z304 ENABLED
Z305_TRIGGER_1 Z305 ENABLED
Z308_TRIGGER_1 Z308 ENABLED
Category: ETL (ARC)/ARC
Subject: Extract - ARC