The VMM service crashes when a virtual machine is refreshed - "Error converting data type int to smallint”

Article ID: 2818840 - View products that this article applies to.
Expand all | Collapse all

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 for other considerations.

Properties

Article ID: 2818840 - Last Review: February 25, 2013 - Revision: 2.0
Applies to
  • Microsoft System Center 2012 Virtual Machine Manager
Keywords: 
KB2818840

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com