Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Help resolving a Crystal report/Data link viewer crash on refresh of certain reports.

Posted on 2014-09-26
6
Medium Priority
?
1,792 Views
Last Modified: 2014-12-14
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.

Additional info:  
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)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:  
Description:
Faulting application name: DataLink_Viewer_2011.exe, version: 6.14.3.2060, 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
Level:         Error
Keywords:      Classic
User:          N/A
Computer:
Description:
Application: DataLink_Viewer_2011.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
Stack:
   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)
   at System.Windows.Forms.Application.Run(System.Windows.Forms.ApplicationContext)
   at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
   at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
   at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(System.String[])
   at ..(System.String[])



I can add more detail if someone is willing to help.  

Any ideas?
Thanks!
0
Comment
Question by:techitch2
  • 3
  • 3
6 Comments
 
LVL 18

Assisted Solution

by:vasto
vasto earned 2000 total points
ID: 40346489
I guess this has nothing to do with DataLink viewer. iframe.dll is a dll used by Interent Explorer. You probably installed an update, which somehow messed the dll. Can you check when was the last update installed on the machines with problems. You can also download and try another viewer , for example SAP Crystal Viewer :
http://www.businessobjects.com/forms/crystalreports/viewer/

SAP viewer cannot refresh reports , so it might not be the best option to try, but still the installation might fix the components. Another viewer that you can use ( just to check if the report is crashing in Crystal or in DataLink) is R-Tag:
http://www.r-tag.com It will take about 30 minutes to install it and run the report . If it crashes then the problem is in Crystal, otherwise contact DataLink support.
0
 

Author Comment

by:techitch2
ID: 40346622
One security update on the 24th and then about 6 updates on the 12th.  I am now getting reports of multiple reports failing outside of what I initially saw.  Again, they are saying just recently this has been happening and nothing from the XP/windows xp users.  

I worked with the Datalink viewer people yesterday and we installed the latest version of datalink with the same results.  Datalink installs crystal runtime.  It is also happening in crystal.  Wouldn't this point towards a windows update?

I will attempt r-tag and see if i still get crashes but i am betting i will.
0
 
LVL 18

Expert Comment

by:vasto
ID: 40346649
Yes, my guess is that if it is Crystal related you will get the same issue with R-Tag. However, it worth to try because R-Tag is pure .NET and  may be using different viewer control ( I don't know what DataLink is using). R-Tag also provides an internal viewer for PDF , Excel and Word, so even if the Crystal screen preview fails you can preview the report directly in one of the supported file formats and use the reports until you resolve the issues with ieframe.dll. If DataLink supports direct export to PDF you can try to use this too, as a temporary solution

Do you have any Windows 7 computer without updates installed ?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Accepted Solution

by:
techitch2 earned 0 total points
ID: 40346686
No but i just found this on an IBM message board and am testing:  Removed KB2977629.....I will keep you posted.

Flash (Alert)

Abstract
Users who installed MS Internet Explorer 11 security update kb2977629 may experience QMF for Workstation product crashes when building dashboards, visual reports and other documents that use embedded HTML browser to display their content (charts, drill-down paths etc).
Content
Users who installed MS Internet Explorer 11 security update kb2977629 will experience QMF for Workstation product crashes when building dashboards, visual reports and other documents that use embedded HTML browser to display their content (charts, drill-down paths etc).
This is not a problem in QMF. This is a problem in the update itself.
At this time the only way to resolve this problem is to uninstall kb2977629 security update.
0
 
LVL 18

Expert Comment

by:vasto
ID: 40346689
Yeah, it looked like an update issue from the beginning
0
 

Author Closing Comment

by:techitch2
ID: 40389800
Because that the specific windows update was found by myself and noted in the post.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question