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

    How to get VAT_TYPE and UNFIED_CATALOGING data loaded into ARC via ETL

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    In our p_arc_01.log files, we are noticing that three components are "successfully loaded" with "0 of 0" records, indicating that they are not getting included in the ARC ETL load. The three relevant lines from our p_arc_01.log file are:
    Table mrr_opac Successfully Loaded 0 of 0
    ...
    Table mrr_unfied_cataloging Successfully Loaded 0 of 0
    Table mrr_vat_type Successfully Loaded 0 of 0
    It appears that the OPAC table is empty because we had not created the Z69 table and index in ALEPH. We have now done this, and are hoping that this will solve that issue.
    We are not as clear how to resolve the other two lines. If you have any information on what needs to be done to get these tables populated with data, we would appreciate it.

    Resolution:
    In document “Aleph to MRR Mapping.pdf”, are found:
    [1] source table = tab_vat_percent.lng
    Destination table = MRR_VAT_TYPE
    [2] source table = Z106
    Destination table = MMR_UNFIED_CATALOGING
    Since neither of these options are activated in ALEPH, this explains the lack of data in the ARC tables.

    • Article last edited: 10/8/2013