• 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