ROW-00060 Oracle OLEDB provider
-
Hello,
I am using an SSIS package with the natvie ole db\oracle provider for ole db to copy data across to
my oracle db. I a test-sub set of 700 000 rows and the process failes at 97000 with the error:
0xC0202009 at Data Flow Task Table mytestTable, ORALCE Table mytestTable [650]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ROW-00060: Erreur interne : [dainsert,16]".
Error: 0xC0209029 at Data Flow Task Table mytestTable, ORALCE Table mytestTable [650]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (663)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (663)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Data Flow Task Table mytestTable: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ORALCE Table mytestTable" (650) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task Table mytestTable: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC02090F5 at Data Flow Task Table mytestTable, DataReader Table mytestTable [1]: The component "DataReader Table mytestTable" (1) was unable to process the data.
Error: 0xC0047038 at Data Flow Task Table mytestTable: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "DataReader Table mytestTable" (1) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task Table mytestTable: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.
I read in this forum that someone suggested using a loop container to "only" load lets say 10 000 records at a time -
since my real data set is over 3 million rows with 200+ columns I thought it would be a good idea.
If so, how do I tell the loop container to load only 10 000 rows at a time ?
Do you have any other suggestions regarding this error?
thanks
-
I tired increasing the buffer size which made the transfer run to up to 99670 rows out of 700 000. (before buffer doubling 96560). but it still does not make the full 700 000.
-
Looking since a few hours into the issue now and discovered a statement made on infoqu.com that
this might be with incorrect table definition of the oracle destination table (i.e. field with limited length). But I have no idea how to identify a particular column from that error.
-
metalray (5/14/2009)
Hello,I am using an SSIS package with the natvie ole db\oracle provider for ole db to copy data across to
my oracle db. I a test-sub set of 700 000 rows and the process failes at 97000 with the error:
0xC0202009 at Data Flow Task Table mytestTable, ORALCE Table mytestTable [650]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ROW-00060: Erreur interne : [dainsert,16]".
Error: 0xC0209029 at Data Flow Task Table mytestTable, ORALCE Table mytestTable [650]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (663)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (663)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Data Flow Task Table mytestTable: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ORALCE Table mytestTable" (650) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task Table mytestTable: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC02090F5 at Data Flow Task Table mytestTable, DataReader Table mytestTable [1]: The component "DataReader Table mytestTable" (1) was unable to process the data.
Error: 0xC0047038 at Data Flow Task Table mytestTable: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "DataReader Table mytestTable" (1) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task Table mytestTable: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.
I read in this forum that someone suggested using a loop container to "only" load lets say 10 000 records at a time -
since my real data set is over 3 million rows with 200+ columns I thought it would be a good idea.
If so, how do I tell the loop container to load only 10 000 rows at a time ?
Do you have any other suggestions regarding this error?
thanks
From the error you receive I'm guessing this is caused when inserting the data in your destination Oracle database (dainsert). A couple of suggestions:
1. Install and use the latest Oracle client software. I would recommend the Oracle 11g client software, which is backward compatible with 9g, 10g and 11g on the server side . DO NOT use Microsoft OLE DB provider for Oracle because it is known to cause problems and it is not up-to-date with the latest features supported by Oracle.
2. Install the latest patches for your Oracle server.
3. Check third-party CozyRoc Oracle Destination component. It loads the data in bulk and is between 10x - 30x faster compared to OLE DB destination.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Hi Old Hand,
Unfortunately I cant install the 11g client or any third party tools (it department and licensing is an issue).
I have to stick with to my ssis standard components and the 100g oracle client.
I am looking at a commit loop that commits every 10 000 rows since I suspect the oracle buffer is running out.
Is there a tutorial out there that explains ssis commit loops?
-
You have to convince them you are loosing so much time already that they are now loosing money by sticking to their rules. Also I don't see a reason not to use 11g client? It doesn't require additional licensing I think.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply