Help resolving a Crystal report/Data link viewer crash on refresh of certain reports.
Posted on 2014-09-26
It was reported to me yesterday that since Tuesday this week (9/23) that a group of invoicing crystal reports (that up until now have worked fine) have started randomly crashing when a refresh of the date is requested. So you can open the report and change the parameters once and the reports runs, but then if you refresh the report with a new date then sometimes the reports crashes Crystal reports or Data link viewer. I've only been able to recreate this on Windows 7/ Server 2008 machines. It does not seem to happen on xp/server 2003 (yes we are still running some of those machines :)).
Our Reports are connected to a sql server 2008 and pull through a OLE DB (ADO) connection using integrated security.
These invoicing reports have been built for three divisions of the company that are connected to three different databases and are all having the same random crashes.
Initially i thought it was this was limited to Data Link viewer so I was in touch with the support and we made some changes to the settings....only to later see the same crashes in crystal reports.
I attempted to rebuild the report for scratch with the same crashes happening.
I have also done some rollbacks of some windows updates due to the fact we are not seeing this on windows xp. I rolled back two .net updates from the 18th and a security update. Same results.
I am seeing two errors in a row an Event 1000 app hang followed by .Net 1026 error when the crash happens.
Log Name: Application
Source: Application Error
Date: 9/25/2014 3:19:26 PM
Event ID: 1000
Task Category: (100)
Faulting application name: DataLink_Viewer_2011.exe, version: 220.127.116.110, time stamp: 0x5419b2de
Faulting module name: ieframe.dll, version: 11.0.9600.17280, time stamp: 0x53f26cda
Exception code: 0xc0000005
Fault offset: 0x00064778
Faulting process id: 0x440
Faulting application start time: 0x01cfd8f589e3ee1b
Faulting application path: C:\Program Files\Millet Software\DataLink Viewer 2011\DataLink_Viewer_2011.exe
Faulting module path: C:\Windows\System32\ieframe.dll
Log Name: Application
Source: .NET Runtime
Date: 9/25/2014 3:19:23 PM
Event ID: 1026
Task Category: None
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG ByRef)
at System.Windows.Forms.Application+ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr, Int32, Int32)
at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Int32, System.Windows.Forms.ApplicationContext)
at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Int32, System.Windows.Forms.ApplicationContext)
I can add more detail if someone is willing to help.