Hello,
I have just "inherited" new production servers and have big issue on one as the VMM console is failing with vmmservice.exe failing with error 1067. Terminated unexpectedly.
I've tried all I could to get it back to working but I'm not a VM specialist. I did do a extensive logman log file, but I have trouble understanding it, I include it here if any one would be so kind to help me spot the issue.
Many thanks
Results from log man:
------------------- Error Report -------------------
Error report created 5/3/2022 11:30:06 AM
CLR is not terminating
--------------- Bucketing Parameters ---------------
EventType=VMM20
P1(appName)=vmmservice.exe
P2(appVersion)=10.19.2292.0
P3(assemblyName)=Utils.dll
P4(assemblyVer)=10.19.2292.0
P5(methodName)=Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader
P6(exceptionType)=System.AggregateException
P7(callstackHash)=18a7
SCVMM Version=10.19.2292.0
SCVMM flavor=C-buddy-RTL-AMD64
Default Assembly Version=10.19.2292.0
Executable Name=vmmservice.exe
Executable Version=10.19.1013.0
Base Exception Target Site=140734141367280
Base Exception Assembly name=Utils.dll
Base Exception Method Name=Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader
Exception Message=One or more errors occurred.
EIP=0x00007fffaf249319
Build bit-size=64
------------ exceptionObject.ToString() ------------
System.AggregateException: One or more errors occurred. ---> Microsoft.VirtualManager.DB.CarmineSqlException: VMM is unable to perform this operation without a connection to a Virtual Machine Manager management server.
Use the Get-VMMServer cmdlet or the -VMMServer parameter to connect to a Virtual Machine Manager management server. For more information, type at the command prompt: Get-Help Get-VMMServer -detailed. ---> System.Data.SqlClient.SqlException: Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(TimeSpan expectedDuration)
--- End of inner exception stack trace ---
at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(TimeSpan expectedDuration)
at Microsoft.VirtualManager.Engine.IDListDBHelper.ParseObjectIDListFromSqlCmd(SqlRetryCommand cmd)
at Microsoft.VirtualManager.DB.ImageLibrary.ServiceTemplateDBAccess.GetAllIds(ConnectionProperties connectionProperties, IVmmDbContext ctx)
at Microsoft.VirtualManager.Engine.VirtualManagerService.LoadRefreshers(IVmmDbConnection dbConnection)
at Microsoft.VirtualManager.DB.SqlContext.Connect(Action1 action) at Microsoft.VirtualManager.Engine.VirtualManagerService.TimeStartupMethod(String description, TimedStartupMethod methodToTime) at System.Threading.Tasks.Task.Execute() --- End of inner exception stack trace --- at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions) at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) at Microsoft.VirtualManager.Engine.VirtualManagerService.WaitForStartupTasks() at Microsoft.VirtualManager.Engine.VirtualManagerService.TimeStartupMethod(String description, TimedStartupMethod methodToTime) at Microsoft.VirtualManager.Engine.VirtualManagerService.ExecuteRealEngineStartup() at Microsoft.VirtualManager.Engine.VirtualManagerService.TryStart(Object stateInfo) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.TimerQueueTimer.CallCallback() at System.Threading.TimerQueueTimer.Fire() at System.Threading.TimerQueue.FireNextTimers() ---> (Inner Exception #0) Microsoft.VirtualManager.DB.CarmineSqlException: VMM is unable to perform this operation without a connection to a Virtual Machine Manager management server. Use the Get-VMMServer cmdlet or the -VMMServer parameter to connect to a Virtual Machine Manager management server. For more information, type at the command prompt: Get-Help Get-VMMServer -detailed. ---> System.Data.SqlClient.SqlException: Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(TimeSpan expectedDuration) --- End of inner exception stack trace --- at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(TimeSpan expectedDuration) at Microsoft.VirtualManager.Engine.IDListDBHelper.ParseObjectIDListFromSqlCmd(SqlRetryCommand cmd) at Microsoft.VirtualManager.DB.ImageLibrary.ServiceTemplateDBAccess.GetAllIds(ConnectionProperties connectionProperties, IVmmDbContext ctx) at Microsoft.VirtualManager.Engine.VirtualManagerService.LoadRefreshers(IVmmDbConnection dbConnection) at Microsoft.VirtualManager.DB.SqlContext.Connect(Action
1 action)
at Microsoft.VirtualManager.Engine.VirtualManagerService.TimeStartupMethod(String description, TimedStartupMethod methodToTime)
at System.Threading.Tasks.Task.Execute()
*** Carmine error was: NoActiveConnection (1615); SQLServer
[s#f2] SqlRetryCommand.InternalExecuteReader(this: (SqlRetryCommand#[a6]) { cmd = (SqlCommand#1604022) System.Data.SqlClient.SqlCommand, errorTitle = (string) "errorTitle", sqlContext = (SqlContext#[5]) { [rw] SqlContext.ConnectconstructionIdentity = (WindowsIdentity#1051fab) System.Security.Principal.WindowsIdentity commandList: { n=94 { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=CPUPercentageReserve)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=DiskIOPercentageReserve)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=NetworkPercentageReserve)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=DiskSpaceReserveMB)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MemoryReserveMB)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=OperationsManagerServer)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=PlacementGoal)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MemoryPriority)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=DiskIOPriority)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=CPUPriority)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=NetworkPriority)", @5/3/2022 11:30:04 AM [+00:00:00.0156337] }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=CEIPOptIn)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=LibraryRefresherEnabled)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=LibraryRefresherFrequency)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMRCAccessAccount)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMRCDefaultPort)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectDefaultPort)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MinimumSupportedAgentVersion)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MinimumSupportedGuestAgentVersion)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MinimumSupportedHostAgentFunctionalLevel)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MACAddressRangeStart)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MACAddressRangeEnd)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMSubnetIDRangeStart)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMSubnetIDRangeEnd)", @5/3/2022 11:30:04 AM }, { Q:"dbo.prc_VMM_GetVmmServerAgentIDAll()", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=UpgradeTime)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=DKMEnabled)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=TopContainerName)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=ContainerName)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=AutomaticVirtualNetworkCreationEnabled)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=AutomaticLogicalNetworkCreationEnabled)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=LogicalNetworkMatchOption)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=LogicalNetworkMatchOptionBackup)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=ProductID)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=DatabaseVersion)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=QFEDatabaseVersion)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=SKUType)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectGatewayCertificateID)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectGatewayCertificateThumbprint)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectGatewayCertificateSubject)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectHyperVCertificateID)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectHyperVCertificateThumbprint)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectHyperVCertificateSubject)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectNCCertificateID)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectNCCertificateThumbprint)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectNCCertificateSubject)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectTokenTimeToLiveInMinutes)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectHostIdentificationMode)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=KeyProtectionServerUrl)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=AttestationServerUrl)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=FallbackKeyProtectionServerUrl)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=FallbackAttestationServerUrl)", @5/3/2022 11:30:04 AM }, { Q:"dbo.prc_WLC_GetAllSecureBootTemplates()", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=GlobalPortACL)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=ShieldingUtilityVhdId)", @5/3/2022 11:30:04 AM }, { Q:"dbo.prc_ADHC_Host_GetRef()", @5/3/2022 11:30:04 AM }, { Q:"dbo.prc_ADHC_HostCluster_GetAll()", @5/3/2022 11:30:04 AM }, { Q:"dbo.prc_ADHC_HostCluster_Get(@ClusterID=e0a6b7e4-8766-4422-8051-26e4b52b6779)", @5/3/2022 11:30:04 AM }, { Q:"dbo.prc_ADHC_Host_GetByClusterID(@HostClusterID=e0a6b7e4-8766-4422-8051-26e4b52b6779)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_BTBS_CustomPropertyValue_GetCPValIDByObjID(ObjectID=e0a6b7e4-8766-4422-8051-26e4b52b6779)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ST_GetStoragePoolIdsByClusterId(@HostClusterID=e0a6b7e4-8766-4422-8051-26e4b52b6779)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_BTBS_HostGroupDOSettings_GetByHostGroupID(@HostGroupID=469cc168-fe8d-46d8-85e1-44c6840660e9)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_HostCluster_Get(@ClusterID=c9680805-218c-41ba-8397-4544d69e49bb)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_Host_GetByClusterID(@HostClusterID=c9680805-218c-41ba-8397-4544d69e49bb)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_BTBS_CustomPropertyValue_GetCPValIDByObjID(ObjectID=c9680805-218c-41ba-8397-4544d69e49bb)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ST_GetStoragePoolIdsByClusterId(@HostClusterID=c9680805-218c-41ba-8397-4544d69e49bb)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_BTBS_HostGroupDOSettings_GetByHostGroupID(@HostGroupID=ed7103a0-5df4-44ca-8783-5319f2f8e46b)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_Library_GetAll()", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_AgentServer_Get(@AgentServerID=7e2a6b8a-4f29-4b60-a28e-b022eb9371e5)", @5/3/2022 11:30:05 AM [+00:00:00.0156280] }, { Q:"dbo.prc_ADHC_AgentServerRelation_GetByAgent(@AgentServerID=7e2a6b8a-4f29-4b60-a28e-b022eb9371e5)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_AgentServerRelation_GetVirtualizationSchemeByLibrary(@LibraryServerID=5dda9be9-7700-482c-80c1-1bedd2c773b3)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_Library_GetVMNetworkIdsByLibraryId(@LibraryID=5dda9be9-7700-482c-80c1-1bedd2c773b3)", @5/3/2022 11:30:05 AM [+00:00:00.0156279] }, { Q:"dbo.prc_NetMan_VMNetwork_GetByID(@ID=5e3f253c-f694-4002-a11c-3fe1d922af30)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_NetMan_VMNetwork_GetByID(@ID=cf117e93-6dbe-4e26-8015-4d5ca558c3e3)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_RBS_GetRunAsAccountConsumer(RunAsAccountID=, ObjectID=5dda9be9-7700-482c-80c1-1bedd2c773b3)", @5/3/2022 11:30:05 AM [+00:00:00.0156323] }, { NQ:"dbo.prc_VMM_AcquireLock(@ObjectID=7924f851-b669-49b2-a764-fe78fc16baba, @ObjectType=RunAsAccount, @TaskID=00000000-0000-0000-0000-000000000000, @ReqLockType=Read, @SubTaskID=00000000-0000-0000-0000-000000000000)", @5/3/2022 11:30:05 AM [+00:00:00.0156278] }, { Q:"dbo.prc_RBS_GetRunAsAccountById(RunAsAccountID=7924f851-b669-49b2-a764-fe78fc16baba)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_RBS_UserRoleSharedObjectRelation_GetSharedListForObject(ObjectID=7924f851-b669-49b2-a764-fe78fc16baba)", @5/3/2022 11:30:05 AM }, { NQ:"dbo.prc_VMM_ReleaseLock(@ObjectID=7924f851-b669-49b2-a764-fe78fc16baba, @TaskID=00000000-0000-0000-0000-000000000000, @LockType=Read)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_AgentServer_Get(@AgentServerID=a8d6d61c-bdaf-430b-8e39-89289c833415)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_AgentServerRelation_GetByAgent(@AgentServerID=a8d6d61c-bdaf-430b-8e39-89289c833415)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_AgentServerRelation_GetVirtualizationSchemeByLibrary(@LibraryServerID=ea1c825d-2b3f-479b-b550-2b446c61037e)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ADHC_Library_GetVMNetworkIdsByLibraryId(@LibraryID=ea1c825d-2b3f-479b-b550-2b446c61037e)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_NetMan_VMNetwork_GetByID(@ID=01336325-d3d5-4c86-9d41-74af24240a83)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_NetMan_VMNetwork_GetByID(@ID=88caf09a-f085-4b41-8b08-da55003476e2)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_RBS_GetRunAsAccountConsumer(RunAsAccountID=, ObjectID=ea1c825d-2b3f-479b-b550-2b446c61037e)", @5/3/2022 11:30:05 AM }, { NQ:"dbo.prc_VMM_AcquireLock(@ObjectID=7924f851-b669-49b2-a764-fe78fc16baba, @ObjectType=RunAsAccount, @TaskID=00000000-0000-0000-0000-000000000000, @ReqLockType=Read, @SubTaskID=00000000-0000-0000-0000-000000000000)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_RBS_GetRunAsAccountById(RunAsAccountID=7924f851-b669-49b2-a764-fe78fc16baba)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_RBS_UserRoleSharedObjectRelation_GetSharedListForObject(ObjectID=7924f851-b669-49b2-a764-fe78fc16baba)", @5/3/2022 11:30:05 AM }, { NQ:"dbo.prc_VMM_ReleaseLock(@ObjectID=7924f851-b669-49b2-a764-fe78fc16baba, @TaskID=00000000-0000-0000-0000-000000000000, @LockType=Read)", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ST_GetAllStorageProviders()", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_ST_GetAllStorageProviders()", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_WLC_GetAllServiceInstances()", @5/3/2022 11:30:05 AM }, { Q:"dbo.prc_WLC_GetAllServiceTemplateIDs()", @5/3/2022 11:30:05 AM } } , conn = (SqlConnection#1d21280) { State: Open Database: VirtualManagerDB DataSource: PRODVMM02 PacketSize: 8000 ServerVersion: 14.00.2037 StatisticsEnabled: False WorkstationId: PRODVMM02 } }, behavior = Default, failFast = (bool) False }, expectedDuration: (TimeSpan#23c34600) 00:01:00)
[s#d] SqlRetryCommand.ExecuteScalar(this: (SqlRetryCommand#[d]) { cmd = (SqlCommand#6b7dae) System.Data.SqlClient.SqlCommand, errorTitle = (string) "errorTitle", sqlContext = (SqlContext#[5]), behavior = Default, failFast = (bool) False }, expectedDuration: (TimeSpan#23c34600) 00:01:00, enablePerfLogging: (Boolean#1) True)
Full call stack from when the exception was thrown: at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(TimeSpan expectedDuration) at Microsoft.VirtualManager.Engine.IDListDBHelper.ParseObjectIDListFromSqlCmd(SqlRetryCommand cmd) at Microsoft.VirtualManager.DB.ImageLibrary.ServiceTemplateDBAccess.GetAllIds(ConnectionProperties connectionProperties, IVmmDbContext ctx) at Microsoft.VirtualManager.Engine.VirtualManagerService.LoadRefreshers(IVmmDbConnection dbConnection) at Microsoft.VirtualManager.DB.SqlContext.Connect(Action
1 action)
at Microsoft.VirtualManager.Engine.VirtualManagerService.TimeStartupMethod(String description, TimedStartupMethod methodToTime)
at System.Threading.Tasks.Task.Execute()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
at System.Threading.ThreadPoolWorkQueue.Dispatch()
--- SqlException details -----------------
System.Data.SqlClient.SqlException (0x80131904): Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(TimeSpan expectedDuration)
ClientConnectionId:a3b2b698-d93e-4c45-a233-13cdf809825d
Error Number:15517,State:1,Class:16
Error = 15517
Index #0
Source: .Net SqlClient Data Provider
Number: 15517
State: 1
Class: 16
Server: PRODVMM02
Message: Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.
Procedure: dbo.prc_WLC_GetAllServiceTemplateIDs
Line: 0
--- Caller StackTrace -----------------
FileName:; Method:InternalExecuteReader(); lineNo:0; ilOffset:204.
FileName:; Method:ParseObjectIDListFromSqlCmd(); lineNo:0; ilOffset:6.
FileName:; Method:GetAllIds(); lineNo:0; ilOffset:18.
FileName:; Method:LoadRefreshers(); lineNo:0; ilOffset:401.
FileName:; Method:Connect(); lineNo:0; ilOffset:31.
FileName:; Method:TimeStartupMethod(); lineNo:0; ilOffset:22.
FileName:; Method:Execute(); lineNo:0; ilOffset:16.
FileName:; Method:RunInternal(); lineNo:0; ilOffset:121.
FileName:; Method:Run(); lineNo:0; ilOffset:9.
FileName:; Method:ExecuteWithThreadLocal(); lineNo:0; ilOffset:225.
FileName:; Method:ExecuteEntry(); lineNo:0; ilOffset:150.
FileName:; Method:Dispatch(); lineNo:0; ilOffset:164.
<---
------------------- Scope Trace --------------------
[s#442] TaskRepository..ctor(this: (TaskRepository#[1]) { runningTasks = (SynchronizedDictionary2<Guid, ITask>#2308f08) Microsoft.VirtualManager.Utils.SynchronizedDictionary
2[System.Guid,Microsoft.VirtualManager.Engine.TaskRepository.ITask], metaTasksByConnectionID = (SynchronizedDictionary2<String, SynchronizedDictionary
2<Guid, List1<SubtaskBase>>>#1f9f46) Microsoft.VirtualManager.Utils.SynchronizedDictionary
2[System.String,Microsoft.VirtualManager.Utils.SynchronizedDictionary2[System.Guid,System.Collections.Generic.List
1[Microsoft.VirtualManager.Engine.TaskRepository.SubtaskBase]]] }) in f:\btvsts\60481\private\product\engine\TaskRepository\TaskRepository.cs:line 184
-------- exception.InnerException.ToString() -------
Microsoft.VirtualManager.DB.CarmineSqlException: VMM is unable to perform this operation without a connection to a Virtual Machine Manager management server.
Use the Get-VMMServer cmdlet or the -VMMServer parameter to connect to a Virtual Machine Manager management server. For more information, type at the command prompt: Get-Help Get-VMMServer -detailed. ---> System.Data.SqlClient.SqlException: Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(TimeSpan expectedDuration)
--- End of inner exception stack trace ---
at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(TimeSpan expectedDuration)
at Microsoft.VirtualManager.Engine.IDListDBHelper.ParseObjectIDListFromSqlCmd(SqlRetryCommand cmd)
at Microsoft.VirtualManager.DB.ImageLibrary.ServiceTemplateDBAccess.GetAllIds(ConnectionProperties connectionProperties, IVmmDbContext ctx)
at Microsoft.VirtualManager.Engine.VirtualManagerService.LoadRefreshers(IVmmDbConnection dbConnection)
at Microsoft.VirtualManager.DB.SqlContext.Connect(Action`1 action) at Microsoft.VirtualManager.Engine.VirtualManagerService.TimeStartupMethod(String description, TimedStartupMethod methodToTime) at System.Threading.Tasks.Task.Execute() *** Carmine error was: NoActiveConnection (1615); SQLServer [s#f2] SqlRetryCommand.InternalExecuteReader(this: (SqlRetryCommand#[a6]) { cmd = (SqlCommand#1604022) System.Data.SqlClient.SqlCommand, errorTitle = (string) "errorTitle", sqlContext = (SqlContext#[5]) { [rw] SqlContext.ConnectconstructionIdentity = (WindowsIdentity#1051fab) System.Security.Principal.WindowsIdentity commandList: { n=94 { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=CPUPercentageReserve)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=DiskIOPercentageReserve)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=NetworkPercentageReserve)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=DiskSpaceReserveMB)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MemoryReserveMB)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=OperationsManagerServer)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=PlacementGoal)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MemoryPriority)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=DiskIOPriority)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=CPUPriority)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=NetworkPriority)", @5/3/2022 11:30:04 AM [+00:00:00.0156337] }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=CEIPOptIn)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=LibraryRefresherEnabled)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=LibraryRefresherFrequency)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMRCAccessAccount)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMRCDefaultPort)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=VMConnectDefaultPort)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MinimumSupportedAgentVersion)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MinimumSupportedGuestAgentVersion)", @5/3/2022 11:30:04 AM }, { S:"dbo.prc_VM_GetGlobalProperty(@PropertyName=MinimumSupportedHostAgentFun