MAP_ACQUISITION_CSV_STAGING
 Description : Runtime User : ASHOK Started : 2009-05-26 14:29:17.0 
Name
Status
Log
MAP_ACQUISITION_CSV_STAGING
Error
RPE-01013: SQL Loader reported error condition, number 1.

SQL*Loader: Release 11.1.0.6.0 - Production on Tue May 26 14:29:25 2009

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

Control File:   F:\Oracle11g\product\11.1.0\db_1\owb\temp\MAP_ACQUISITION_CSV_STAGING.ctl
Character Set WE8MSWIN1252 specified for all input.

Data File:      D:\MY CURRENT PROJECTS\GEIP-IHSS-Santa Clara\CDI-OWB\Source_Systems\Acquisition.csv
  Bad File:     F:\Oracle11g\product\11.1.0\db_1\owb\temp\Acquisition.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     200 rows, maximum of 50000 bytes
Continuation:   Concatenate every 1 physical records
Path used:      Conventional

Table "ASHOK"."SOURCESTAGE", loaded from every logical record.
Insert option in effect for this table: APPEND

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
"SOURCE_ID"                             1     1   ,  O(") CHARACTER            
"CUSTOMER_NUMBER"                    NEXT    20   ,  O(") CHARACTER            
"CUSTOMER_TYPE"                      NEXT     4   ,  O(") CHARACTER            
"NAME_PREFIX"                        NEXT     4   ,  O(") CHARACTER            
"FIRST_NAME"                         NEXT    20   ,  O(") CHARACTER            
"MIDDLE_NAME"                        NEXT    20   ,  O(") CHARACTER            
"LAST_NAME"                          NEXT    20   ,  O(") CHARACTER            
"NAME_SUFFIX"                        NEXT     5   ,  O(") CHARACTER            
"EMAIL"                              NEXT    50   ,  O(") CHARACTER            
"DATE_OF_BIRTH"                      NEXT    20   ,  O(") CHARACTER            
"DATE_OF_DEATH"                      NEXT    20   ,  O(") CHARACTER            
"GENDER"                             NEXT     1   ,  O(") CHARACTER            
"ADDRESS_LINE_1"                     NEXT   100   ,  O(") CHARACTER            
"ADDRESS_LINE_2"                     NEXT   100   ,  O(") CHARACTER            
"CITY_CODE"                          NEXT    10   ,  O(") CHARACTER            
"STATE_CODE"                         NEXT     4   ,  O(") CHARACTER            
"COUNTRY_CODE"                       NEXT     4   ,  O(") CHARACTER            
"ZIP_CODE"                           NEXT     6   ,  O(") CHARACTER            
"AREA_CODE"                          NEXT     6   ,  O(") CHARACTER            
"PHONE_HOME"                         NEXT    20   ,  O(") CHARACTER            
"PHONE_WORK"                         NEXT    20   ,  O(") CHARACTER            
"PHONE_MOBILE"                       NEXT    20   ,  O(") CHARACTER            
"SOCIAL_SECURITY_NUMBER"             NEXT    50   ,  O(") CHARACTER            
"EDUCATION"                          NEXT    20   ,  O(") CHARACTER            
"INCOME"                             NEXT    10   ,  O(") CHARACTER            
"TAX_IDENTIFICATION_NUMBER"          NEXT    20   ,  O(") CHARACTER            
"FAMILY_ID"                          NEXT    10   ,  O(") CHARACTER            
"FAMILY_RELATIONSHIP"                NEXT    20   ,  O(") CHARACTER            
"PREFERENCE_NAME"                    NEXT    20   ,  O(") CHARACTER            
"PREFERENCE_TIME"                    NEXT    20   ,  O(") CHARACTER            
"PREFERENCE_PHONE"                   NEXT    10   ,  O(") CHARACTER            
"PREFERENCE_LANGUAGE"                NEXT    20   ,  O(") CHARACTER            

value used for ROWS parameter changed from 200 to 67
SQL*Loader-500: Unable to open file (D:\MY CURRENT PROJECTS\GEIP-IHSS-Santa Clara\CDI-OWB\Source_Systems\Acquisition.csv)
SQL*Loader-552: insufficient privilege to open file
SQL*Loader-509: System error: The data is invalid.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Table "ASHOK"."SOURCESTAGE":
  0 Rows successfully loaded.
  0 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:                  49714 bytes(67 rows)
Read   buffer bytes:   65536

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

Run began on Tue May 26 14:29:25 2009
Run ended on Tue May 26 14:29:26 2009

Elapsed time was:     00:00:00.31
CPU time was:         00:00:00.06
:
SQL*Loader: Release 11.1.0.6.0 - Production on Tue May 26 14:29:25 2009

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

SQL*Loader-500: Unable to open file (D:\MY CURRENT PROJECTS\GEIP-IHSS-Santa Clara\CDI-OWB\Source_Systems\Acquisition.csv)
SQL*Loader-552: insufficient privilege to open file
SQL*Loader-509: System error: The data is invalid.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
 
Job Summary
 Updated : 2009-05-26 14:29:29.0 Job Final Status : Completed with errors Job Processed Count : 1 Job Error Count : 1 Job Warning Count : 0