Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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