Home » RDBMS Server » Server Utilities » Error while loading table ( Using OWB ) (Oracle 11g, OWB,Win XP)
Error while loading table ( Using OWB ) [message #405064] Tue, 26 May 2009 04:06 Go to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Hi All,

First of all i apologyze for posting in SQL and PL/SQL Forum instead of Warehouse Builder, i haven't got any replies there.


I have a flat file which i am loading into a Target Table in Oracle Warehouse Builder. It uses SQL Loader Internally to load the data from flat file, I am facing an issue. Please find the following error.


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  


I believe that this is related to SQL * Loader error.

ACtually the flat file resides in my system ( D:\MY CURRENT PROJECTS\GEIP-IHSS-Santa Clara\CDI-OWB\Source_Systems\Acquisition.csv). I am connecting to a oracle server.

Please suggest

Is it required that i need to place the flat file in Oracle Server System ??
Re: Error while loading table ( Using OWB ) [message #405067 is a reply to message #405064] Tue, 26 May 2009 04:14 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, if you insist, SQL*Loader question fits into Server Utilities forum, not SQL & PL/SQL one. So I'll
a) delete the one opened in the Warehouse Builder forum
b) move this one into the Server Utilities forum
Re: Error while loading table ( Using OWB ) [message #405068 is a reply to message #405064] Tue, 26 May 2009 04:15 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Please don't delete in "Warehouse Builder" section,but you can move it to server Utilities
Re: Error while loading table ( Using OWB ) [message #405081 is a reply to message #405068] Tue, 26 May 2009 04:48 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In that case, we'd have cross-posting (two topics in different forums talking about the same problem). Discussion would go on in both of them, some (many / most) of the forum members visit all forums and what would you have? A mess.

Therefore, it has been deleted from the OWB forum. Continue discussion (if any) here. If necessary, it can later be moved somewhere else.
Re: Error while loading table ( Using OWB ) [message #405199 is a reply to message #405081] Tue, 26 May 2009 23:39 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
I see that this problem was replied to on the OTN forums (see link below), indicating that the source file needs to be on the server. The documentation indicates that the source file can be on any drive that the client can access. However, since you seem to have a privilege problem, moving it to the server might be the simplest way to solve that problem.

http://forums.oracle.com/forums/thread.jspa?messageID=3494586&tstart=0
Re: Error while loading table ( Using OWB ) [message #405200 is a reply to message #405064] Tue, 26 May 2009 23:43 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

@Barbara Boehmer,

thank you very much for the reply, I only posted in OTN hoping to get the reply,

I believe we need to put the file in the Server. I shall do it and post the solution if it is succesful.

Regards,
Ashoka BL
Re: Error while loading table ( Using OWB ) [message #405214 is a reply to message #405064] Wed, 27 May 2009 00:58 Go to previous message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

I am able to load the files from .csv to a target table.

I have placed the files in Oracle server.

Regards,
Ashoka BL
Previous Topic: sqlloader continueif problem
Next Topic: import data
Goto Forum:
  


Current Time: Fri Dec 09 19:30:22 CST 2016

Total time taken to generate the page: 0.11328 seconds