Hello!
I have a customer that is experiencing a crash in both GP and MR. Restarting the SQL server (nightly) temporarily resolves the issue but it comes back.
Below are the logs of the errors. The customer tried installing the patch in KB article: https://support.microsoft.com/en-us/kb/2640103 but when installing it errors out saying it does not apply:
Log Name: Application
Source: Application Error
Date: 9/16/2016 1:30:48 PM
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: xa-acct-01.mfm.lan
Description:
Faulting application name: ReportViewer.exe, version: 2.12.14001.45, time stamp: 0x564f9120
Faulting module name: clr.dll, version: 4.0.30319.34209, time stamp: 0x5348a1ef
Exception code: 0xc0000005
Fault offset: 0x00000000002071b4
Faulting process id: 0x3294
Faulting application start time: 0x01d210486fc03d01
Faulting application path: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Client\ReportViewer.exe
Faulting module path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
Report Id: afd08a43-7c3b-11e6-ad34-005056b049f3
Event Xml:
schemas.microsoft.com/.../event">
1000
2
100
0x80000000000000
29515
Application
xa-acct-01.mfm.lan
ReportViewer.exe
2.12.14001.45
564f9120
clr.dll
4.0.30319.34209
5348a1ef
c0000005
00000000002071b4
3294
01d210486fc03d01
C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Client\ReportViewer.exe
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
afd08a43-7c3b-11e6-ad34-005056b049f3
Log Name: Application
Source: .NET Runtime
Date: 9/16/2016 1:30:48 PM
Event ID: 1023
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: xa-acct-01.mfm.lan
Description:
Application: ReportViewer.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an internal error in the .NET Runtime at IP 000007FEEFC871B4 (000007FEEFA80000) with exit code 80131506.
Event Xml:
schemas.microsoft.com/.../event">
1023
2
0
0x80000000000000
29514
Application
xa-acct-01.mfm.lan
Application: ReportViewer.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an internal error in the .NET Runtime at IP 000007FEEFC871B4 (000007FEEFA80000) with exit code 80131506.
Any ideas?
Thanks!
------------------------------
Dan Moore
GP Support Specialist
Boyer & Associates
Plymouth MN
763-412-4300
------------------------------
*This post is locked for comments
We recommended they spin up another server to run MR instead of running both on one server. Also gave them some specs/system requirements so hopefully they will beef them up a bit!
Thanks everyone!
Hey Dan,
I know this probably is not what you want to hear, but you should use caution with trying to run a trace for a long period of time. The process is quite a hog which could cause perf problems. Also if you are not on top of clearing it out the process will eat up a lot of disc space.
Thank you,
Ken Hubbard
Dan,
How many users do you have? Even for a pretty small installation that looks way underprovisoned to run both SQL and MR. I suspect if you watch the resource consumption on the VM you will notice it maxing out on memory just before the crash.
Kirk
Next step we are going to run a trace more than likely for the entire day until it happens again since it is random each day.
They are 100% virtual on vmware. The server has 4GB ram and 2vcpu and is running windows 2008R2 fully patched.
This looks like the .Net framework issue, I'm not sure if you find good help on this topic here.
I would make sure all the latest updates and fixes are installed for Windows in regards to the .Net, may be even reinstalled.
Dan,
Ken's suggestions are good ones. Could you also give us some information about the servers hardware (or virtual hardware) configuration?
Regards,
Kirk
Hey Dan,
This is a pretty tough issue to troubleshoot. It might be handy to capture a DEXSQL.log and SQL trace to see what the last item called is and what does that call look like in the trace.
What are they doing in GP when it crashes?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156