troubleshooting Question

Oracle SQLLOADER:Error 566

Avatar of hobbssh49
hobbssh49 asked on
Oracle Database
9 Comments1 Solution4568 ViewsLast Modified:
Hello,

Have any one gotten this error loading data utilizing SQLLOADER on a UNIX machine: SQL*Loader-566: partial record found at end of datafile
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.  I have verified that the last record is not a partial records.  Any help would be greatly appreciated.

Here is the example of the control file:
load data
infile '/edi/gssls/867in/867IN.dat' "fix 427"
discardmax 7000
append into table indir_sales_edi_raw
fields terminated by "whitespaces"
(
 record_id                 sequence(MAX,1),
 ec_filerow_id             position(1:3),
 cv_dist_cust_id           position(4:18),
 cv_indir_cust_id          position(19:35),
 name1                     position(36:75),
 address1                  position(76:110),
 address2                  position(111:145),
 city                      position(146:175),
 state                     position(176:181),
 postal                    position(182:193),
 phone                     position(194:217),
 contact_name              position(218:267),
 ship_date                 position(268:275),
 invoice                   position(276:297),
 qty_shipped               position(298:308),
 qty_returned              position(313:323),
 upc_id                    position(328:345),
 invoice_amount            position(346:360),
 ec_ext_tp_id              position(361:376),
 cv_isa_cntrl              position(377:385),
 cv_gs_cntrl               position(386:394),
 cv_st_cntrl               position(395:403),
 process_date              position(404:411),
 process_state             CONSTANT "A")
~
ASKER CERTIFIED SOLUTION
RCorfman

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros