Devart Forums

We are using ODAC 4.70.37.0 (Core Lab) and just upgraded from Oracle 10.2.0.4 to Oracle 10.2.0.5. We are now experiencing difficulties (jobs failing) during bulk data inserts from a SQL Server package. Does anyone know if ODAC version 4.70.37.0 is compatible with Oracle 10.2.0.5. (We realize this is an old version of ODAC.) Thank you!

mfw1 wrote:ODAC version 4.70.37.0

Did you mean OraDirect .NET (it was renamed to dotConnect for Oracle) http://www.devart.com/dotconnect/oracle/? Only OraDirect .NET (dotConnect for Oracle) has version 4.70.37.0 http://www.devart.com/dotconnect/oracle ... story.html. You wrote that you were using ODAC http://www.devart.com/odac/, but ODAC doesn't have version 4.70.37.0 http://www.devart.com/odac/revision_history.html

mfw1 wrote:We are using ODAC 4.70.37.0 (Core Lab) and just upgraded from Oracle 10.2.0.4 to Oracle 10.2.0.5. We are now experiencing difficulties (jobs failing) during bulk data inserts from a SQL Server package.

OraDirect .NET 4.70.37.0 supports Oracle 10.2.0.5. Please specify the exact exception text and call stack.

Thank you! We have a MS SQL Server DTS package that is now failing in the connection and/or bulk inserts to the newly upgraded Oracle 10.2.0.5 database (worked for 10.2.0.4 version). Following are the messages we are getting:

PackageStart,LTC1CSIPR04,LTC1CSIPR04\sqlserver,HSCLIENT_EXTRACT,{0CF56D49-D3C0-4EF7-B707-C09A956881BB},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:04 PM,3/20/2013 4:00:04 PM,0,0x,Beginning of package execution.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Data Flow Task,{B1EFCE31-8823-43B3-B73B-47ACF3D65A6A},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450910,0x,CoreLab.Oracle.OracleException: ORA-00600: internal error code, arguments: [16622], [], [], [], [], [], [], []
at CoreLab.Oracle.i.b(Int32 A_0)
at CoreLab.Oracle.OracleLoader.Open()
at OraDirectBulkLoadDest.OraDirectBulkDest.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)
OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Sequence Container,{5C854440-F515-40C9-BF76-2E6A84D70006},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450910,0x,CoreLab.Oracle.OracleException: ORA-00600: internal error code, arguments: [16622], [], [], [], [], [], [], []
at CoreLab.Oracle.i.b(Int32 A_0)
at CoreLab.Oracle.OracleLoader.Open()
at OraDirectBulkLoadDest.OraDirectBulkDest.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)
OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,HSCLIENT_EXTRACT,{0CF56D49-D3C0-4EF7-B707-C09A956881BB},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450910,0x,CoreLab.Oracle.OracleException: ORA-00600: internal error code, arguments: [16622], [], [], [], [], [], [], []
at CoreLab.Oracle.i.b(Int32 A_0)
at CoreLab.Oracle.OracleLoader.Open()
at OraDirectBulkLoadDest.OraDirectBulkDest.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)
OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Data Flow Task,{B1EFCE31-8823-43B3-B73B-47ACF3D65A6A},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "INSERT DATA IN CLIENT HOSTED SERVICES" (3371) failed with error code 0x80004005. 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.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Sequence Container,{5C854440-F515-40C9-BF76-2E6A84D70006},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "INSERT DATA IN CLIENT HOSTED SERVICES" (3371) failed with error code 0x80004005. 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.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,HSCLIENT_EXTRACT,{0CF56D49-D3C0-4EF7-B707-C09A956881BB},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "INSERT DATA IN CLIENT HOSTED SERVICES" (3371) failed with error code 0x80004005. 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.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Data Flow Task,{B1EFCE31-8823-43B3-B73B-47ACF3D65A6A},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread4" has exited with error code 0x80004005. There may be error messages posted before this with more information on why the thread has exited.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Sequence Container,{5C854440-F515-40C9-BF76-2E6A84D70006},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread4" has exited with error code 0x80004005. There may be error messages posted before this with more information on why the thread has exited.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,HSCLIENT_EXTRACT,{0CF56D49-D3C0-4EF7-B707-C09A956881BB},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread4" has exited with error code 0x80004005. There may be error messages posted before this with more information on why the thread has exited.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Data Flow Task,{B1EFCE31-8823-43B3-B73B-47ACF3D65A6A},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450951,0x,SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Sequence Container,{5C854440-F515-40C9-BF76-2E6A84D70006},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450951,0x,SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,HSCLIENT_EXTRACT,{0CF56D49-D3C0-4EF7-B707-C09A956881BB},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450951,0x,SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Data Flow Task,{B1EFCE31-8823-43B3-B73B-47ACF3D65A6A},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Sequence Container,{5C854440-F515-40C9-BF76-2E6A84D70006},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

OnError,LTC1CSIPR04,LTC1CSIPR04\sqlserver,HSCLIENT_EXTRACT,{0CF56D49-D3C0-4EF7-B707-C09A956881BB},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

OnTaskFailed,LTC1CSIPR04,LTC1CSIPR04\sqlserver,Data Flow Task,{B1EFCE31-8823-43B3-B73B-47ACF3D65A6A},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,0,0x,(null)
PackageEnd,LTC1CSIPR04,LTC1CSIPR04\sqlserver,HSCLIENT_EXTRACT,{0CF56D49-D3C0-4EF7-B707-C09A956881BB},{FA211BA4-579D-4F16-9763-7AC26CD5C036},3/20/2013 4:00:44 PM,3/20/2013 4:00:44 PM,1,0x,End of package execution.

Thanks for any help you can provide.

mfw1 wrote:ORA-00600: internal error code, arguments: [16622]

It seems that this isn't a dotConnect for Oracle issue. Contact the Oracle support team regarding this issue https://support.oracle.com/