APPCRASH NAV 2009 R2

g.remirez@saltosystems.com

Hi,

we a navision database with many classic clients and 5 nas-es, and sometimes we get a crash error. We also have ExpandIT Launcher to do scheduling calls to navision.

We are having this issue many times earlier so we have to get a fast solution.

I am going to explain the environment.

The server machine is:

Windows server 2012 Standard (x64)

Intel Xeon CPU X5675, 3,07GHz (2 processors)

12 GB of RAM

The database server machine is:

Windows server 2012 Standard (x64)

Intel Xeon CPU ES-2640, 2,50GHz (4 processors)

24 GB of RAM

The event log is:

Faulting application name: finsql.exe, version: 6.0.32012.0, time stamp: 0x4d030bb8
Faulting module name: finsql.exe, version: 6.0.32012.0, time stamp: 0x4d030bb8
Exception code: 0xc00000fd
Fault offset: 0x001629e4
Faulting process id: 0x%9
Faulting application start time: 0x%10
Faulting application path: %11
Faulting module path: %12
Report Id: %13
Faulting package full name: %14
Faulting package-relative application ID: %15

---

Fault bucket , type 0
Event Name: APPCRASH
Response: Not available
Cab Id: 0

Problem signature:
P1: finsql.exe
P2: 6.0.32012.0
P3: 4d030bb8
P4: finsql.exe
P5: 6.0.32012.0
P6: 4d030bb8
P7: c00000fd
P8: 001629e4
P9:
P10:

Attached files:

These files may be available here:
C:\ProgramData\Microsoft\Windows\WER\ReportQueue\AppCrash_finsql.exe_208be638e02e5bff31c213fe22b15423931113a_24d5f575

Analysis symbol:
Rechecking for solution: 0
Report Id: 18022740-effd-11e5-941f-005056a509d0
Report Status: 4
Hashed bucket:

And the Report.wer is:

Version=1
EventType=APPCRASH
EventTime=131031036039117586
ReportType=2
Consent=1
ReportIdentifier=b351836c-effb-11e5-941f-005056a509d0
WOW64=1
Response.type=4
Sig[0].Name=Application Name
Sig[0].Value=finsql.exe
Sig[1].Name=Application Version
Sig[1].Value=6.0.32012.0
Sig[2].Name=Application Timestamp
Sig[2].Value=4d030bb8
Sig[3].Name=Fault Module Name
Sig[3].Value=finsql.exe
Sig[4].Name=Fault Module Version
Sig[4].Value=6.0.32012.0
Sig[5].Name=Fault Module Timestamp
Sig[5].Value=4d030bb8
Sig[6].Name=Exception Code
Sig[6].Value=c00000fd
Sig[7].Name=Exception Offset
Sig[7].Value=001629e4
DynamicSig[1].Name=OS Version
DynamicSig[1].Value=6.2.9200.2.0.0.272.7
DynamicSig[2].Name=Locale ID
DynamicSig[2].Value=2057
UI[2]=C:\Program Files (x86)\Microsoft Dynamics NAV\CSIDE Client\finsql.exe
LoadedModule[0]=C:\Program Files (x86)\Microsoft Dynamics NAV\CSIDE Client\finsql.exe
LoadedModule[1]=C:\Windows\SYSTEM32\ntdll.dll
LoadedModule[2]=C:\Windows\SYSTEM32\MSCOREE.DLL
LoadedModule[3]=C:\Windows\SYSTEM32\KERNEL32.dll
LoadedModule[4]=C:\Windows\SYSTEM32\KERNELBASE.dll
LoadedModule[5]=C:\Windows\system32\apphelp.dll
LoadedModule[6]=C:\Windows\AppPatch\AcLayers.DLL
LoadedModule[7]=C:\Windows\SYSTEM32\msvcrt.dll
LoadedModule[8]=C:\Windows\SYSTEM32\USER32.dll
LoadedModule[9]=C:\Windows\SYSTEM32\GDI32.dll
LoadedModule[10]=C:\Windows\SYSTEM32\SHELL32.dll
LoadedModule[11]=C:\Windows\SYSTEM32\SHLWAPI.dll
LoadedModule[12]=C:\Windows\SYSTEM32\OLEAUT32.dll
LoadedModule[13]=C:\Windows\SYSTEM32\MPR.dll
LoadedModule[14]=C:\Windows\SYSTEM32\SETUPAPI.dll
LoadedModule[15]=C:\Windows\SYSTEM32\sfc.dll
LoadedModule[16]=C:\Windows\SYSTEM32\WINSPOOL.DRV
LoadedModule[17]=C:\Windows\SYSTEM32\RPCRT4.dll
LoadedModule[18]=C:\Windows\SYSTEM32\combase.dll
LoadedModule[19]=C:\Windows\SYSTEM32\CFGMGR32.dll
LoadedModule[20]=C:\Windows\SYSTEM32\DEVOBJ.dll
LoadedModule[21]=C:\Windows\SYSTEM32\SspiCli.dll
LoadedModule[22]=C:\Windows\SYSTEM32\sfc_os.DLL
LoadedModule[23]=C:\Windows\SYSTEM32\CRYPTBASE.dll
LoadedModule[24]=C:\Windows\SYSTEM32\sechost.dll
LoadedModule[25]=C:\Windows\SYSTEM32\bcryptPrimitives.dll
LoadedModule[26]=C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.9200.17359_none_8935f06086091acc\COMCTL32.dll
LoadedModule[27]=C:\Windows\SYSTEM32\PSAPI.DLL
LoadedModule[28]=C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6871_none_50944e7cbcb706e5\MSVCP90.dll
LoadedModule[29]=C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6871_none_50944e7cbcb706e5\MSVCR90.dll
LoadedModule[30]=C:\Windows\SYSTEM32\WINTRUST.dll
LoadedModule[31]=C:\Windows\SYSTEM32\CRYPT32.dll
LoadedModule[32]=C:\Windows\SYSTEM32\WTSAPI32.dll
LoadedModule[33]=C:\Windows\SYSTEM32\WININET.dll
LoadedModule[34]=C:\Windows\SYSTEM32\SHFOLDER.dll
LoadedModule[35]=C:\Windows\SYSTEM32\hlink.dll
LoadedModule[36]=C:\Windows\SYSTEM32\WS2_32.dll
LoadedModule[37]=C:\Windows\SYSTEM32\MSIMG32.dll
LoadedModule[38]=C:\Windows\SYSTEM32\Secur32.dll
LoadedModule[39]=C:\Windows\SYSTEM32\COMDLG32.dll
LoadedModule[40]=C:\Windows\SYSTEM32\ADVAPI32.dll
LoadedModule[41]=C:\Windows\SYSTEM32\ole32.dll
LoadedModule[42]=C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6871_none_50944e7cbcb706e5\msvcm90.dll
LoadedModule[43]=C:\Windows\SYSTEM32\MSASN1.dll
LoadedModule[44]=C:\Windows\SYSTEM32\iertutil.dll
LoadedModule[45]=C:\Windows\SYSTEM32\USERENV.dll
LoadedModule[46]=C:\Windows\SYSTEM32\NSI.dll
LoadedModule[47]=C:\Windows\SYSTEM32\SHCORE.DLL
LoadedModule[48]=C:\Windows\SYSTEM32\profapi.dll
LoadedModule[49]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscoreei.dll
LoadedModule[50]=C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll
LoadedModule[51]=C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.6910_none_d089c358442de345\MSVCR80.dll
LoadedModule[52]=C:\Windows\assembly\NativeImages_v2.0.50727_32\mscorlib\b9d3e6f3fe8936deb2f1defb3a205f9a\mscorlib.ni.dll
LoadedModule[53]=C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorsec.dll
LoadedModule[54]=C:\Windows\SYSTEM32\CRYPTSP.dll
LoadedModule[55]=C:\Windows\system32\rsaenh.dll
LoadedModule[56]=C:\Windows\SYSTEM32\imagehlp.dll
LoadedModule[57]=C:\Windows\SYSTEM32\ncrypt.dll
LoadedModule[58]=C:\Windows\SYSTEM32\bcrypt.dll
LoadedModule[59]=C:\Windows\SYSTEM32\NTASN1.dll
LoadedModule[60]=C:\Windows\SYSTEM32\gpapi.dll
LoadedModule[61]=C:\Windows\SYSTEM32\cryptnet.dll
LoadedModule[62]=C:\Windows\SYSTEM32\WLDAP32.dll
LoadedModule[63]=C:\Windows\SYSTEM32\IPHLPAPI.DLL
LoadedModule[64]=C:\Windows\SYSTEM32\WINNSI.DLL
LoadedModule[65]=C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorjit.dll
LoadedModule[66]=C:\Windows\SYSTEM32\ACTIVEDS.DLL
LoadedModule[67]=C:\Windows\SYSTEM32\adsldpc.dll
LoadedModule[68]=C:\Windows\SYSTEM32\VERSION.dll
FriendlyEventName=APPCRASH
ConsentKey=APPCRASH
AppName=Microsoft Dynamics NAV Classic Client executable for SQ
AppPath=C:\Program Files (x86)\Microsoft Dynamics NAV\CSIDE Client\finsql.exe
ReportDescription=Stopped working

kylehardin

According to the event log entries, you are using build 6.0.32012.0, which is the base version of NAV 2009 R2. One thing you can try - and this isn't trivial, but it means you don't have to do anything to NAV code - is to upgrade your clients, NASes, and possibly ExpandIT (I don't know a lot about ExpandIT and its versions) to the latest hotfix release for 2009 R2. Back up your SQL database first. But the latest build of 2009 R2 contains a ton of hotfixes that you can read about on CustomerSource. Looks like the latest build is 38655.

https://mbs.microsoft.com/customersource/Global/NAV/downloads/hot-fixes/NAV2009SP1PlatformHotfixOverview

All of this is a way of saying that I can't tell anything about why this is crashing from the event log entries. There isn't any useful information there, other than it is finsql.exe that dies.

The only alternative I can think of would be looking for some manner of pattern. Do users get an error message before it dies? Certain times of day? Only when ExpandIT does something?