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

    SQL*Loader-510: Physical record in data file is longer than the maximum

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

    Problem Symptoms:
    * SQL*Loader-510: Physical record in data file (/exlibris/aleph/u20_n/xxx50/scratch/mirror_details.dat) is longer than the maximum (1048576)
    * SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

    Cause:


    Resolution:
    1) Check in the interface: ETL > ETL status, give a range date and choose the latest ETL
    2) Check report "Mirror?€? at the ?€œMirror Error Count?€? column:
    When you click on the red numbers in this column you can see the erroneous text from Aleph data including some spaces created by using the TAB key instead of blanks on the keyboard
    3) After the data was corrected, please run a new ETL and check if the error messages disappeared

    Category: ETL (ARC)

    Subject: Transform and Load

    • Article last edited: 10/8/2013