Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Toad Sql Loader

Highlighted
dasfweg
Super Collector

Toad Sql Loader

Good morning,

I am attempting to run the Import Users report. I am using Toad Sql Loader to load the data into the knta_users_int table. When i execute the Sql Loader im getting the following error:

SQL*Loader: Release 11.1.0.6.0 - Production on Wed Sep 19 10:27:19 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Control File:   knta_users.ctl
Data File:      C:\Users\gehamilton\Desktop\PPM Users Import.csv
  Bad File:     C:\Users\gehamilton\Desktop\PPM Users Import.bad
  Discard File: C:\Users\gehamilton\Desktop\PPM Users Import.dsc
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

Table "ITG"."KNTA_USERS_INT", loaded from every logical record.
Insert option in effect for this table: INSERT

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
USERNAME                            FIRST     *  WHT      CHARACTER           
FIRST_NAME                           NEXT     *  WHT      CHARACTER           
LAST_NAME                            NEXT     *  WHT      CHARACTER           
USER_DATA1                           NEXT     *  WHT      CHARACTER           
USER_DATA2                           NEXT     *  WHT      CHARACTER           

Record 1: Rejected - Error on table "ITG"."KNTA_USERS_INT", column FIRST_NAME.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 2: Rejected - Error on table "ITG"."KNTA_USERS_INT", column FIRST_NAME.

MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table "ITG"."KNTA_USERS_INT":
  0 Rows successfully loaded.
  51 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                  82560 bytes(64 rows)
Read   buffer bytes: 1048576

Total logical records skipped:          0
Total logical records read:            51
Total logical records rejected:        51
Total logical records discarded:        0

Run began on Wed Sep 19 10:27:19 2012
Run ended on Wed Sep 19 10:27:19 2012

 

This is my parameter file:

LOAD DATA
INFILE 'C:\Users\gehamilton\Desktop\PPM Users Import.csv'
BADFILE 'C:\Users\gehamilton\Desktop\PPM Users Import.bad'
DISCARDFILE 'C:\Users\gehamilton\Desktop\PPM Users Import.dsc'

INTO TABLE "ITG"."KNTA_USERS_INT"
FIELDS TERMINATED BY X'9'
(USERNAME,
FIRST_NAME,
LAST_NAME,
USER_DATA1,
USER_DATA2)

 

I know it's something simple im missing........

3 REPLIES
Oscar_Pereira
Frequent Visitor

Re: Toad Sql Loader

 

Just to make sure that the issue is not related to the values .  Does it work if you run the query from SQL plus directly instead of Toad ?

 

Regards

Oscar p

d4y4n4
Frequent Visitor

Re: Toad Sql Loader

Hi,

Based on the error MAXIMUM ERROR COUNT EXCEEDED, this is a Oracle issue.

Check this link for details about how to change the ERRORS parameter

http://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_params.htm#sthref573

Regards,
Dayana
d4y4n4
Frequent Visitor

Re: Toad Sql Loader

Also check this link for the other error " Column not found before end of logical record (use TRAILING NULLCOLS)"

http://www.dbforums.com/oracle/983068-sql-loader-problem.html

Regards,
Dayana Campos
//Add this to "OnDomLoad" event