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

    Meaning of "p_arc_01_transform.log" Messages ?

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

    Description:
    After running ETL for the CASH table, we got the following message in the "p_arc_01_transform.log". We wonder how we could interpret the message:
    "NO_PROCESS_DETAILS_LINES
    154
    1 row selected.
    PROCESS_CODE TASK_CODE START_DATE END_DATE ERROR_DESC
    no rows selected
    NO_PROCESS_DETAILS_LINES
    212
    1 row selected."

    Resolution:
    The excerpt that you sent indicates that the process finished with no errors.
    Even if the Extract was run on one table, (like cash), the Transform and load are done on all tables.
    The log shows you how many processes were done (in your example =154) up till 'p-arc-01-transform' file was updated.
    It is updated every 5 minutes. So, every 5 minutes a new line is written indicating how many processes were done till then.
    If there were errors in the transform and load processes that were already made, the errors would have been written in that log file.

    • Article last edited: 10/8/2013