January 26, 2018 at 2:57 pm
I am running Visual Studio 2015 with SSDT 17.2 and SQL Server 2016.
Downloading data from Oracle to SQL Server using OLEDB drivers 32-bit provided by Oracle. I run the package from Visual Studio (use 64 bit run-time set to false) and data flow should download 750k rows but around 130k rows the packages stops and says execution completed but there are no errors. And the source and destination components inside the data flow task are still yellow and spinning as if they are still running. When I comment out large columns from the source query like varchar(2000) more rows download say 300k rows before the package stops again with the data flow components staying yellow and still spinning. I tried a different package also downloading from Oracle with a different source table and the same thing happens.
I checked the Windows event logs and under the application log the DtsDebugHost is crashing.
Faulting application name: DtsDebugHost.exe, version: 2015.130.1601.5, time stamp: 0x57244eb5
Faulting module name: KERNELBASE.dll, version: 10.0.14393.1770, time stamp: 0x59bf2bcf
Exception code: 0xc0000005
Fault offset: 0x000daa12
Faulting process id: 0x4750
Faulting application start time: 0x01d396e6a3035f33
Faulting application path: C:\Users\saad\AppData\Local\Microsoft\Microsoft SQL Server\140\SSIS\130\x86\DtsDebugHost.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
So I am assuming the reason I am not getting any errors returned during execution in Visual Studio is because the DTS debugger is just crashing during the data flow execution.
When I run the package from the SQL Server agent there are also no errors in the job log but again an error in the Windows application log. The error is the same except it says dtexec.exe instead of DtsDebugHost.exe for the faulting application path. Same faulting module path KERNELBASE.dll.
How do I go about figuring out the cause of this crash?
Thanks,
David
January 30, 2018 at 10:12 am
My sys admin informed me that he installed ODAC 12.2c release 1 (12.2.0.1.0) causing a driver version mismatch between dev and prod.
The Oracle source server is 12c Enterprise Edition Release 12.1.0.2.0 - 64bit so I would guess that trying to use 12.2 drivers on a 12.1 server would be the reason those drivers failed because they are newer than the server version.
After we uninstalled 12.2c and reinstalled 11.2 drivers the problem went away and all is working fine again.
May 31, 2018 at 12:51 am
Dude! You are my hero!
Thank you so much for posting back your solution. I had the exact same problem:
490K rows transferred to SQL (out of millions) and yellow spinning disks in my SSIS project, and then the Data Flow Task just hung there.
I was also using ODAC 12.2 drivers against an Oracle 12.1 source:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Changed the ODAC drivers and now it works 100%.
Faulting application name: DtsDebugHost.exe, version: 2015.131.5026.0, time stamp: 0x5aae90ff
Faulting module name: KERNELBASE.dll, version: 10.0.16299.309, time stamp: 0xd3aa915c
Exception code: 0xc0000005
Fault offset: 0x001008f2
Faulting process ID: 0x3fb0
Faulting application start time: 0x01d3f817237f7a77
Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll
Report ID: 3129483e-fda0-4655-a047-40381bbfd8a9
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply