DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2818840 - Last Review: February 25, 2013 - Revision: 2.0

Symptoms

When refreshing a virtual machine in System center 2012 Virtual Machine Manager, the VMM service crashes and generates the following error:

Ensure that the SQL Server is running and configured correctly, then try the operation again. ---> System.Data.SqlClient.SqlException: Error converting data type int to smallint.

Cause

This can occur if minimum Dynamic memory is set to a value larger than 32GB.

Resolution

Microsoft is aware of this issue and is investigating the fix. As a workaround, any virtual machines using Dynamic memory that have more than 32GB set as ‘Minimum Memory’ should have this amount of memory lowered below 32GB. 

More information

A stack trace will show entries similar to the following:

00136802 737.03070068 [5424] Ensure that the SQL Server is running and configured correctly, then try the operation again. ---> System.Data.SqlClient.SqlException: Error converting data type int to smallint.
00136803 737.03070068 [5424]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
00136804 737.03070068 [5424]    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
00136805 737.03070068 [5424]    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
00136806 737.03070068 [5424]    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
00136807 737.03070068 [5424]    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
00136808 737.03070068 [5424]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
00136809 737.03070068 [5424]    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
00136810 737.03070068 [5424]    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
00136811 737.03070068 [5424]    at Microsoft.VirtualManager.DB.SqlRetryCommand.ExecuteNonQuery() 
00136812 737.03070068 [5424]    --- End of inner exception stack trace ---
00136813 737.03070068 [5424]    at Microsoft.VirtualManager.DB.SqlRetryCommand.ExecuteNonQuery()
00136814 737.03070068 [5424]    at Microsoft.VirtualManager.DB.ImageLibrary.VMDBAccess.AddOrUpdateVM(VMData vmData, ImgLibCatalog catalog, Boolean isAdd)
00136815 737.03070068 [5424]    at Microsoft.VirtualManager.DB.ImageLibrary.VMDBAccess.Update(VMData vmData, ImgLibCatalog catalog)
00136816 737.03070068 [5424]    at Microsoft.VirtualManager.Engine.ImageLibrary.CommonVMBase.AddOrUpdateObjectInDB(ImgLibCatalog catalog)
00136817 737.03070068 [5424]    at Microsoft.VirtualManager.Engine.ImageLibrary.VM.AddOrUpdateObjectInDB(ImgLibCatalog catalog)
00136818 737.03070068 [5424]    at Microsoft.VirtualManager.Engine.ImageLibrary.LibObjectBase.UpdateDB(ImgLibCatalog catalog)
00136819 737.03070068 [5424]    at Microsoft.VirtualManager.Engine.ImageLibrary.SharableLibObject.UpdateDB(ImgLibCatalog catalog)
00136820 737.03070068 [5424]    at Microsoft.VirtualManager.Engine.ImageLibrary.LibObjectBase.UpdateDB(Boolean audit)
00136821 737.03070068 [5424]    at Microsoft.VirtualManager.Engine.BitBos.VMRefresherBase.UpdateFullVMObjectToCarmine(IVMComputerSystem vmComputer, VMData vmData, UpdateRequired updateRequired, Boolean vmObjectHasChanged)
00136822 737.03070068 [5424]    at Microsoft.VirtualManager.Engine.BitBos.VMRefresherBase.FullyRefreshVM(FullyResheshVMParamObject param)
00136823 737.03070068 [5424] at Microsoft.VirtualManager.Engine.BitBos.VMRefresherBase.<>c__DisplayClassc.<RunFullRefresher>b__a(Object paramObj)


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.

Applies to
  • Microsoft System Center 2012 Virtual Machine Manager
Keywords: 
KB2818840
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support