SQL*Loader-522: lfiopn failed for file (//DD:<DD-name>) and SQL*Loader-509: System error: lrecl too small, following upgrade to 10gR2 (Doc ID 1451549.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.5 [Release 10.2]
IBM z/OS on System z

Symptoms

10.2.0.3/10.2.0.5 SQL*Loader fails with the following errors:

SQL*Loader-522: lfiopn failed for file (//DD:<dd-name>)
SQL*Loader-554: error opening file
SQL*Loader-509: System error: (NO DATA)
SQL*Loader-509: System error: lrecl too small
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

The DD name referred to in message SQL*Loader-522 is the DD name used for either the BAD or DISCARD dataset.

Changes

 An upgrade from 9.2 to 10gR2 has taken place

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms