Data Backup and Recovery

SnapManager for SQL crashes with .NET Runtime Error System.AccessViolationException

Mastaghandi
2,462 Views

Hi bros!

 

I have a big problem and try to solve it now for about 3 days now im at the end.

My System:

 

Server 2008R2 (latest Updates)

Snapmanager for SQL 7.2.3

SnapDrive 7.1.5

Ontap 8.2.3P6 and 8.2.4P6 (all 7-Mode)

 

When i would Backup the SQL with Snapmanager SnapMgrService.exe craches with an .NET Runtime 1026 Error. The Exception Info is: System.AccessViolationException.

 

In the snapmanager log i see the following:

Version=1
EventType=CLR20r3
EventTime=131843195259257586
ReportType=2
Consent=1
ReportIdentifier=40dd4e03-d2a3-11e8-8737-0050569c429f
IntegratorReportIdentifier=40dd4e02-d2a3-11e8-8737-0050569c429f
Response.type=4
Sig[0].Name=Problemsignatur 01
Sig[0].Value=SnapMgrService.exe
Sig[1].Name=Problemsignatur 02
Sig[1].Value=7.2.3.2841
Sig[2].Name=Problemsignatur 03
Sig[2].Value=5a57e48a
Sig[3].Name=Problemsignatur 04
Sig[3].Value=SmSqlService
Sig[4].Name=Problemsignatur 05
Sig[4].Value=7.2.3.2841
Sig[5].Name=Problemsignatur 06
Sig[5].Value=5a57e3a2
Sig[6].Name=Problemsignatur 07
Sig[6].Value=1889
Sig[7].Name=Problemsignatur 08
Sig[7].Value=48
Sig[8].Name=Problemsignatur 09
Sig[8].Value=System.AccessViolationException
DynamicSig[1].Name=Betriebsystemversion
DynamicSig[1].Value=6.1.7601.2.1.0.272.7
DynamicSig[2].Name=Gebietsschema-ID
DynamicSig[2].Value=3079
DynamicSig[22].Name=Zusatzinformation 1
DynamicSig[22].Value=bc57
DynamicSig[23].Name=Zusatzinformation 2
DynamicSig[23].Value=bc57dda065f2405645d4dd94b450c860
DynamicSig[24].Name=Zusatzinformation 3
DynamicSig[24].Value=9831
DynamicSig[25].Name=Zusatzinformation 4
DynamicSig[25].Value=9831588f2eb215a1f1124e068ca38dd0
UI[2]=C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrService.exe
UI[5]=Online nach einer Lösung suchen (empfohlen)
UI[6]=Später nach einer Lösung suchen (empfohlen)
UI[7]=Schließen
UI[8]=SnapMgrService Application wurde beendet und geschlossen.
UI[9]=Die Anwendung wird aufgrund eines Problems nicht mehr richtig ausgeführt. Sie erhalten Nachricht, wenn eine Lösung verfügbar ist.
UI[10]=S&chließen
LoadedModule[0]=C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrService.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\ADVAPI32.dll
LoadedModule[6]=C:\Windows\system32\msvcrt.dll
LoadedModule[7]=C:\Windows\SYSTEM32\sechost.dll
LoadedModule[8]=C:\Windows\system32\RPCRT4.dll
LoadedModule[9]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscoreei.dll
LoadedModule[10]=C:\Windows\system32\SHLWAPI.dll
LoadedModule[11]=C:\Windows\system32\GDI32.dll
LoadedModule[12]=C:\Windows\system32\USER32.dll
LoadedModule[13]=C:\Windows\system32\LPK.dll
LoadedModule[14]=C:\Windows\system32\USP10.dll
LoadedModule[15]=C:\Windows\system32\IMM32.DLL
LoadedModule[16]=C:\Windows\system32\MSCTF.dll
LoadedModule[17]=C:\Windows\system32\VERSION.dll
LoadedModule[18]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
LoadedModule[19]=C:\Windows\system32\MSVCR120_CLR0400.dll
LoadedModule[20]=C:\Windows\assembly\NativeImages_v4.0.30319_64\mscorlib\b308b9c61f65cf2dfd876031ee385ba4\mscorlib.ni.dll
LoadedModule[21]=C:\Windows\system32\ole32.dll
LoadedModule[22]=C:\Windows\system32\CRYPTBASE.dll
LoadedModule[23]=C:\Windows\system32\api-ms-win-core-xstate-l2-1-0.dll
LoadedModule[24]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clrjit.dll
LoadedModule[25]=C:\Windows\system32\MSVCR110.dll
LoadedModule[26]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System\095a3392942c3d4eb888e6a32036acd8\System.ni.dll
LoadedModule[27]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Serv759bfb78#\34b9fb782bc249da96266a5231d51873\System.ServiceProcess.ni.dll
LoadedModule[28]=C:\Program Files\NetApp\SnapManager for SQL Server\SmSqlServiceHost.dll
LoadedModule[29]=C:\Program Files\NetApp\SnapManager for SQL Server\SmSqlService.dll
LoadedModule[30]=C:\Windows\system32\OLEAUT32.dll
LoadedModule[31]=C:\Windows\system32\MSVCP110.dll
LoadedModule[32]=C:\Windows\system32\VSSAPI.DLL
LoadedModule[33]=C:\Windows\system32\ATL.DLL
LoadedModule[34]=C:\Windows\system32\VssTrace.DLL
LoadedModule[35]=C:\Windows\system32\ODBC32.dll
LoadedModule[36]=C:\Windows\system32\CLUSAPI.dll
LoadedModule[37]=C:\Windows\system32\cryptdll.dll
LoadedModule[38]=C:\Windows\system32\atl110.DLL
LoadedModule[39]=C:\Windows\system32\SHELL32.dll
LoadedModule[40]=C:\Windows\system32\NETAPI32.dll
LoadedModule[41]=C:\Windows\system32\netutils.dll
LoadedModule[42]=C:\Windows\system32\srvcli.dll
LoadedModule[43]=C:\Windows\system32\wkscli.dll
LoadedModule[44]=C:\Windows\system32\odbcint.dll
LoadedModule[45]=C:\Program Files\NetApp\SnapManager for SQL Server\FSRService.dll
LoadedModule[46]=C:\Windows\system32\CRYPTSP.dll
LoadedModule[47]=C:\Windows\system32\rsaenh.dll
LoadedModule[48]=C:\Windows\Microsoft.Net\assembly\GAC_64\SmSqlServiceContracts\v4.0_5.1.0.0__bd6c565e52f1c855\SmSqlServiceContracts.dll
LoadedModule[49]=C:\Windows\system32\PSAPI.DLL
LoadedModule[50]=C:\Windows\Microsoft.Net\assembly\GAC_64\SmCommonData\v4.0_5.1.0.0__1eb58525dba932ee\SmCommonData.dll
LoadedModule[51]=C:\Program Files\NetApp\SnapManager for SQL Server\SmSqlServiceCommon.dll
LoadedModule[52]=C:\Program Files\NetApp\SnapManager for SQL Server\SmSDBroker.dll
LoadedModule[53]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\nlssorting.dll
LoadedModule[54]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Core\75913bbaf1bee617a94dcd6b5df12a5d\System.Core.ni.dll
LoadedModule[55]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Configuration\36778d2072c745f0ad72f7e219122258\System.Configuration.ni.dll
LoadedModule[56]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Xml\8821b72d5d51079acf96e90c4af19a96\System.Xml.ni.dll
LoadedModule[57]=C:\Windows\system32\profapi.dll
LoadedModule[58]=C:\Windows\system32\bcrypt.dll
LoadedModule[59]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.ServiceModel\da1a143bfdb77511e8b81e41482b73d7\System.ServiceModel.ni.dll
LoadedModule[60]=C:\Windows\assembly\NativeImages_v4.0.30319_64\SMDiagnostics\c7d01590f25b87c1d82c1b48e56d5865\SMDiagnostics.ni.dll
LoadedModule[61]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Servd1dec626#\9fab28f14be5a0da526b1ceaaa04a4c3\System.ServiceModel.Internals.ni.dll
LoadedModule[62]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Runteb92aa12#\190c40c1f98dddf624b7e442286d76d4\System.Runtime.Serialization.ni.dll
LoadedModule[63]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Serv30e99c02#\d876aaecebd9ea482120a1905ba2babe\System.ServiceModel.Channels.ni.dll
LoadedModule[64]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Servf73e6522#\37e8138f6301df1b77f76d6660ce3241\System.ServiceModel.Web.ni.dll
LoadedModule[65]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.IdentityModel\0a637affd530a4ee90f0ed36c3febc79\System.IdentityModel.ni.dll
LoadedModule[66]=C:\Windows\system32\pcwum.DLL
LoadedModule[67]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Xaml\76a6a6b0f7fb1fbd64a800b5fc3d47bb\System.Xaml.ni.dll
LoadedModule[68]=C:\Windows\system32\CLBCatQ.DLL
LoadedModule[69]=C:\Windows\system32\wbem\wmidcprv.dll
LoadedModule[70]=C:\Windows\system32\wbem\FastProx.dll
LoadedModule[71]=C:\Windows\system32\wbemcomn2.dll
LoadedModule[72]=C:\Windows\system32\WS2_32.dll
LoadedModule[73]=C:\Windows\system32\NSI.dll
LoadedModule[74]=C:\Windows\system32\NTDSAPI.dll
LoadedModule[75]=C:\Windows\system32\RpcRtRemote.dll
LoadedModule[76]=C:\Windows\system32\wbem\wbemprox.dll
LoadedModule[77]=C:\Windows\system32\wbem\wbemsvc.dll
LoadedModule[78]=C:\Windows\system32\wbem\wmiutils.dll
LoadedModule[79]=C:\Windows\System32\msxml3.dll
LoadedModule[80]=C:\Program Files\NetApp\SnapDrive\SWSvcps.dll
LoadedModule[81]=C:\Windows\WinSxS\amd64_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_08e61857a83bc251\MSVCR90.dll
LoadedModule[82]=C:\Windows\system32\mswsock.dll
LoadedModule[83]=C:\Windows\System32\wshtcpip.dll
LoadedModule[84]=C:\Windows\System32\wship6.dll
LoadedModule[85]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Transactions\963e23452dd4b751573f32fac3a29c02\System.Transactions.ni.dll
LoadedModule[86]=C:\Windows\Microsoft.Net\assembly\GAC_64\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll
LoadedModule[87]=C:\Windows\system32\secur32.dll
LoadedModule[88]=C:\Windows\system32\SSPICLI.DLL
LoadedModule[89]=C:\Windows\system32\credssp.dll
LoadedModule[90]=C:\Windows\system32\msv1_0.DLL
LoadedModule[91]=C:\Program Files\NetApp\SnapManager for SQL Server\SmSqlSMO.dll
LoadedModule[92]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Data\55389b61c315fb0ad52077f949c7a8dc\System.Data.ni.dll
LoadedModule[93]=C:\Windows\Microsoft.Net\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll
LoadedModule[94]=C:\Windows\system32\CRYPT32.dll
LoadedModule[95]=C:\Windows\system32\MSASN1.dll
LoadedModule[96]=C:\Windows\system32\urlmon.dll
LoadedModule[97]=C:\Windows\system32\api-ms-win-downlevel-ole32-l1-1-0.dll
LoadedModule[98]=C:\Windows\system32\api-ms-win-downlevel-shlwapi-l1-1-0.dll
LoadedModule[99]=C:\Windows\system32\api-ms-win-downlevel-advapi32-l1-1-0.dll
LoadedModule[100]=C:\Windows\system32\api-ms-win-downlevel-user32-l1-1-0.dll
LoadedModule[101]=C:\Windows\system32\api-ms-win-downlevel-version-l1-1-0.dll
LoadedModule[102]=C:\Windows\system32\api-ms-win-downlevel-normaliz-l1-1-0.dll
LoadedModule[103]=C:\Windows\system32\normaliz.DLL
LoadedModule[104]=C:\Windows\system32\iertutil.dll
LoadedModule[105]=C:\Windows\system32\WININET.dll
LoadedModule[106]=C:\Windows\system32\USERENV.dll
LoadedModule[107]=C:\Windows\system32\api-ms-win-downlevel-advapi32-l2-1-0.dll
LoadedModule[108]=C:\Windows\system32\WINTRUST.dll
LoadedModule[109]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscorsecimpl.dll
LoadedModule[110]=C:\Windows\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18837_none_a4d981ff711297b6\COMCTL32.dll
LoadedModule[111]=C:\Windows\system32\imagehlp.dll
LoadedModule[112]=C:\Windows\system32\ncrypt.dll
LoadedModule[113]=C:\Windows\system32\bcryptprimitives.dll
LoadedModule[114]=C:\Windows\system32\GPAPI.dll
LoadedModule[115]=C:\Windows\system32\cryptnet.dll
LoadedModule[116]=C:\Windows\system32\WLDAP32.dll
LoadedModule[117]=C:\Windows\system32\SensApi.dll
LoadedModule[118]=C:\Windows\system32\security.dll
LoadedModule[119]=C:\Windows\system32\schannel.DLL
LoadedModule[120]=C:\Windows\system32\kerberos.DLL
LoadedModule[121]=C:\Windows\system32\LOGONCLI.DLL
LoadedModule[122]=C:\Program Files\Microsoft SQL Server\90\Shared\instapi.dll
LoadedModule[123]=C:\Windows\WinSxS\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.6229_none_88dcc0bf2fb1b808\MSVCR80.dll
LoadedModule[124]=C:\Windows\system32\DNSAPI.dll
LoadedModule[125]=C:\Windows\system32\IPHLPAPI.DLL
LoadedModule[126]=C:\Windows\system32\WINNSI.DLL
LoadedModule[127]=C:\Windows\system32\rasadhlp.dll
LoadedModule[128]=C:\Windows\System32\fwpuclnt.dll
LoadedModule[129]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Ente96d83b35#\bcab827b24e870428fcdda58e1ebec20\System.EnterpriseServices.ni.dll
LoadedModule[130]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Ente96d83b35#\bcab827b24e870428fcdda58e1ebec20\System.EnterpriseServices.Wrapper.dll
LoadedModule[131]=C:\Windows\Microsoft.Net\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll
LoadedModule[132]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Numerics\9744e094346545d417a938174608d0ad\System.Numerics.ni.dll
LoadedModule[133]=C:\Windows\system32\cscapi.dll
LoadedModule[134]=C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Management\45d49301a9e8ff19669155b1ec5c45ce\System.Management.ni.dll
LoadedModule[135]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\wminet_utils.dll
LoadedModule[136]=C:\Program Files\Microsoft SQL Server\80\Tools\binn\SQLDMO.DLL
LoadedModule[137]=C:\Windows\system32\odbcbcp.dll
LoadedModule[138]=C:\Program Files\Microsoft SQL Server\80\Tools\binn\Resources\1033\SQLDMO.RLL
LoadedModule[139]=C:\Windows\system32\resutils.dll
LoadedModule[140]=C:\Windows\system32\odbccp32.dll
LoadedModule[141]=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\diasymreader.dll
FriendlyEventName=Nicht mehr funktionsfähig
ConsentKey=CLR20r3
AppName=SnapMgrService Application
AppPath=C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrService.exe

 

I try to reinstall the snapmanager and snapdrive.. also try to uninstall .net framework 4.7 and install 4.0.. all without any success 😞

 

In the windows log i see the following:

 

Application: SnapMgrService.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
   at <Module>.CNtapSqlBackup.DoSIFDataSetBackup(CNtapSqlBackup*, _SMSQL_BACKUP_ALLOUT**, Int32, _SMSQL_BACKUP_IN*, UInt16*, _SME_VLD_LIST*)
   at <Module>.CBackupGrouping.SQLBackupSubJob(CBackupGrouping*, _SMSQL_BACKUP_IN*, _SMSQL_INSTANCES*, _SME_VLD_LIST*, std.vector<std::vector<std::list<int,std::allocator<int> >,std::allocator<std::list<int,std::allocator<int> > > >,std::allocator<std::vector<std::list<int,std::allocator<int> >,std::allocator<std::list<int,std::allocator<int> > > > > >*, Int32, _SMSQL_BACKUP_ALLOUT***, Int32*, SmsqlSkippedDbs*, std.list<int,std::allocator<int> >*)
   at <Module>.CBackupGrouping.SmSQLBackupInteralV2(CBackupGrouping*, _SMSQL_BACKUP_IN*, _SMSQL_BACKUP_RESULT**, _SMSQL_INSTANCES*, _SME_VLD_LIST*, Int32)
   at <Module>.CNtapSnapMgrSql.SmSQLBackup(CNtapSnapMgrSql*, _SMSQL_BACKUP_IN*, _SMSQL_BACKUP_RESULT**, _SMSQL_INSTANCES*, _SME_VLD_LIST*, Int32)
   at <Module>.CNtapSnapMgrSql.SmSQLBackup_OneServer(CNtapSnapMgrSql*, _SMSQL_BACKUP_IN*, _SMSQL_BACKUP_RESULT**, _SMSQL_INSTANCES*, _SME_VLD_LIST*, UInt16*, UInt16*, Int32)
   at <Module>.RemoteBkupThreadProc(Void*)
 
I hope someone can help me!
thanks!
 
1 ACCEPTED SOLUTION

Mastaghandi
2,366 Views

Hi matte,

 

thanks for your reply. In the meanwhile i found the problem. The customer moved 2 dbs to another LUN but leave the LOGs of this dbs on the same LUN as the other dbs used.

 

i moved the LOG files from this dbs to the same lun where the dbs now saved and BUMM.... no .NET error.

 

wow.... 3 days of work cause of an crazy error message.. 😞

 

thanks!

View solution in original post

2 REPLIES 2

matte
2,409 Views

Hi

 

Which kind of backup are you trying to create?

I've seen smilar problme creating backup + snapvaul on (and only) a system Dbs.

If that is the case  please  try to backup a system DB with no snapvault or perfomr a user Db + system db + snavault.

 

 

Mastaghandi
2,367 Views

Hi matte,

 

thanks for your reply. In the meanwhile i found the problem. The customer moved 2 dbs to another LUN but leave the LOGs of this dbs on the same LUN as the other dbs used.

 

i moved the LOG files from this dbs to the same lun where the dbs now saved and BUMM.... no .NET error.

 

wow.... 3 days of work cause of an crazy error message.. 😞

 

thanks!

Public