Scribd
Upload
6 views3 pages

Oracle Data Loader Import Process

The document outlines the execution log of a BulkOpsClient process, detailing the steps taken to log in, validate, and submit an import request using Oracle Data Loader On Demand. It includes configuration settings, SOAP request submissions, and responses, as well as error handling for a SOAP Request Rate Limit issue. The process concludes with a successful import submission and user logout.

Uploaded by

madhan299911
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
6 views3 pages

Oracle Data Loader Import Process

The document outlines the execution log of a BulkOpsClient process, detailing the steps taken to log in, validate, and submit an import request using Oracle Data Loader On Demand. It includes configuration settings, SOAP request submissions, and responses, as well as error handling for a SOAP Request Rate Limit issue. The process concludes with a successful import submission and user logout.

Uploaded by

madhan299911
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

[2010-04-24 07:51:54,393] DEBUG - [main] [Link](): Execution begin.

[2010-04-24 07:51:54,393] DEBUG - [main] [Link](): List of all


configurations loaded: {numofthreads=1, impstatchkinterval=30, maxloginattempts=1,
manifestfiledir=.\Manifest\, sessionkeepchkinterval=300, routingurl=https://
[Link], hosturl=[Link] testmode=debug,
maxthreadfailure=1, logintimeoutms=180000, csvblocksize=1000, maxsoapsize=10240}

[2010-04-24 07:51:54,393] DEBUG - [main] [Link](): List of all options


loaded: {password=*********, clientloglevel=detailed, waitforcompletion=False,
datetimeformat=usa, importloglevel=errors, datafilepath=.\\data\\[Link],
operation=insert, help=False, mapfilepath=.\\data\\[Link],
clientlogfiledir=., recordtype=account, duplicatecheckoption=externalid,
username=oracle/oracle, csvdelimiter=,}

[2010-04-24 07:51:54,393] INFO - [main] Attempting to log in...

[2010-04-24 07:51:55,081] INFO - [main] Successfully logged in as: wchung/eric

[2010-04-24 07:51:55,081] DEBUG - [main] [Link](): Execution begin.

[2010-04-24 07:51:55,081] INFO - [main] Validating Oracle Data Loader On Demand


Import request...

[2010-04-24 07:51:55,081] DEBUG - [main] [Link]():


Execution begin.

[2010-04-24 07:51:55,097] DEBUG - [main] [Link]():


Execution complete.

[2010-04-24 07:51:55,331] DEBUG - [Thread-1] [Link]():


Submitting BulkOpImportGetRequestDetail WS call

[2010-04-24 07:51:55,331] INFO - [main] A SOAP request was sent to the server to
create the import request.

[2010-04-24 07:51:55,862] DEBUG - [Thread-1]


[Link](): SOAP request sent successfully
and a response was received

[2010-04-24 07:51:55,862] DEBUG - [Thread-1] [Link]():


BulkOpImportGetRequestDetail WS call finished

[2010-04-24 07:51:55,862] DEBUG - [Thread-1] [Link](): SOAP


response status code=OK

[2010-04-24 07:51:55,862] DEBUG - [Thread-1] [Link](): Going


to sleep for 300 seconds.

[2010-04-24 07:51:55,862] DEBUG - [main]


[Link](): Handling SoapFaultException.

[2010-04-24 07:51:55,862] DEBUG - [main] There was an error sending the SOAP
request
to web service: SBL-ODU-01005

[2010-04-24 07:51:55,862] DEBUG - [main] [Link]():


Experienced SOAP Request Rate Limit error while sending the validation request.
Will
try to send again in 1 sec.

[2010-04-24 07:51:56,862] INFO - [main] A SOAP request was sent to the server to
create the import request.

[2010-04-24 07:52:01,268] INFO - [main] A response to the SOAP request sent to


create the import request on the server has been received.

[2010-04-24 07:52:01,268] DEBUG - [main]


[Link](): SOAP request sent successfully and

a response was received

[2010-04-24 07:52:01,268] INFO - [main] Oracle Data Loader On Demand Import


validation PASSED.

[2010-04-24 07:52:01,268] DEBUG - [main] [Link]():


Execution complete.

[2010-04-24 07:52:01,268] DEBUG - [main] [Link]():


Execution begin.

[2010-04-24 07:52:01,268] DEBUG - [main] [Link]():


Sending CSV Data Segments.

[2010-04-24 07:52:01,268] DEBUG - [main] [Link]():


CSVDataSender will use 1 threads.

[2010-04-24 07:52:01,268] INFO - [main] Submitting Oracle Data Loader On Demand


Import request with the following Request Id: 1QA2-Q5NU1...

[2010-04-24 07:52:01,268] DEBUG - [main] [Link](): Creating


thread 0

[2010-04-24 07:52:01,284] INFO - [main] Import Request Submission Status: Started

[2010-04-24 07:52:01,284] DEBUG - [main] [Link](): Starting


thread 0

[2010-04-24 07:52:01,284] DEBUG - [main] [Link](): There are


pending requests. Going to sleep.

[2010-04-24 07:52:01,284] DEBUG - [Thread-3] [Link](): Thread 0


submitting CSV Data Segment: 1 of 1

[2010-04-24 07:52:02,487] INFO - [Thread-3] A response to the import data SOAP


request sent to the server has been received.

[2010-04-24 07:52:02,487] DEBUG - [Thread-3]


[Link](): SOAP request sent successfully and a

response was received

[2010-04-24 07:52:02,487] INFO - [Thread-3] A SOAP request containing import data


was sent to the server: 1 of 1

[2010-04-24 07:52:02,487] DEBUG - [Thread-3] [Link](): There is no

more pending request to be picked up by Thread 0.


[2010-04-24 07:52:02,487] DEBUG - [Thread-3] [Link](): Thread 0
terminating now.

[2010-04-24 07:52:06,284] INFO - [main] Import Request Submission Status: 100.00%

[2010-04-24 07:52:07,284] INFO - [main] Oracle Data Loader On Demand Import


submission completed succesfully.

[2010-04-24 07:52:07,284] DEBUG - [main] [Link]():


Execution complete.

[2010-04-24 07:52:07,300] DEBUG - [main] [Link](): Execution


complete.

[2010-04-24 07:52:07,300] INFO - [main] Attempting to log out...

[2010-04-24 07:52:09,487] INFO - [main] oracle/oracle is now logged out.

[2010-04-24 07:52:09,487] DEBUG - [Thread-1] [Link]():


Interrupted.

[2010-04-24 07:52:09,487] DEBUG - [main] [Link](): Execution complete.

You might also like