Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mital Gohil 8 posts 78 karma points
    Aug 24, 2023 @ 14:35
    Mital Gohil
    0

    When i try to migrate umbraco 7.15.6 to umbraco 8.2.3 Facing error Invalid object name 'umbracoKeyValue'.

    Here is site error

    Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
    
    -> Umbraco.Core.Exceptions.BootFailedException: Could not check the upgrade state.
      at Umbraco.Core.RuntimeState.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\a\1\s\src\Umbraco.Core\RuntimeState.cs:line 223
      at Umbraco.Core.Runtime.CoreRuntime.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, IProfilingLogger profilingLogger) in D:\a\1\s\src\Umbraco.Core\Runtime\CoreRuntime.cs:line 259
      at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer) in D:\a\1\s\src\Umbraco.Core\Runtime\CoreRuntime.cs:line 149
    
    -> System.Data.SqlClient.SqlException: Invalid object name 'umbracoKeyValue'.
      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, 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 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 221
      at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in D:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 172
      at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)
      at NPoco.Database.ExecuteDataReader(DbCommand cmd)
      at NPoco.Database.<QueryImp>d__164`1.MoveNext()
      at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
      at Umbraco.Core.Services.Implement.KeyValueService.GetValue(IUmbracoDatabase database, String key) in D:\a\1\s\src\Umbraco.Core\Services\Implement\KeyValueService.cs:line 213
      at Umbraco.Core.RuntimeState.EnsureUmbracoUpgradeState(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\a\1\s\src\Umbraco.Core\RuntimeState.cs:line 256
      at Umbraco.Core.RuntimeState.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\a\1\s\src\Umbraco.Core\RuntimeState.cs:line 206
    

    Here is log file

    {"@t":"2023-08-24T14:21:31.2576204Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Booting Umbraco 8.2.3.","TimingId":"1fadba7","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"ea99c354-ecd8-4f5d-a25e-9e03e61da4e7"}
    {"@t":"2023-08-24T14:21:31.3218694Z","@mt":"Booting site '{HostingSiteName}', app '{HostingApplicationID}', path '{HostingPhysicalPath}', server '{MachineName}'.","HostingSiteName":"MHS_Home_8","HostingApplicationID":"/LM/W3SVC/2/ROOT","HostingPhysicalPath":"C:\\inetpub\\vhosts\\MHS_Home_8\\","MachineName":"SERVER1","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"ea99c354-ecd8-4f5d-a25e-9e03e61da4e7"}
    {"@t":"2023-08-24T14:21:31.9607528Z","@mt":"Acquiring.","SourceContext":"Umbraco.Core.MainDom","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"ea99c354-ecd8-4f5d-a25e-9e03e61da4e7"}
    {"@t":"2023-08-24T14:21:31.9631667Z","@mt":"Acquired.","SourceContext":"Umbraco.Core.MainDom","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"ea99c354-ecd8-4f5d-a25e-9e03e61da4e7"}
    {"@t":"2023-08-24T14:21:34.8098228Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoKeyValue'.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n   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)\r\n   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)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 221\r\n   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in D:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryPolicy.cs:line 172\r\n   at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n   at NPoco.Database.ExecuteDataReader(DbCommand cmd)\r\n   at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)\r\n   at Umbraco.Core.Services.Implement.KeyValueService.GetValue(IUmbracoDatabase database, String key) in D:\\a\\1\\s\\src\\Umbraco.Core\\Services\\Implement\\KeyValueService.cs:line 213\r\n   at Umbraco.Core.RuntimeState.EnsureUmbracoUpgradeState(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 256\r\n   at Umbraco.Core.RuntimeState.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 206\r\nClientConnectionId:acddde6d-07e5-4769-ad90-c6c5aac842fd\r\nError Number:208,State:1,Class:16","InstanceId":"7c8a5732","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"ea99c354-ecd8-4f5d-a25e-9e03e61da4e7"}
    {"@t":"2023-08-24T14:21:35.2341579Z","@mt":"Could not check the upgrade state.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoKeyValue'.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n   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)\r\n   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)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 221\r\n   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in D:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryPolicy.cs:line 172\r\n   at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n   at NPoco.Database.ExecuteDataReader(DbCommand cmd)\r\n   at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)\r\n   at Umbraco.Core.Services.Implement.KeyValueService.GetValue(IUmbracoDatabase database, String key) in D:\\a\\1\\s\\src\\Umbraco.Core\\Services\\Implement\\KeyValueService.cs:line 213\r\n   at Umbraco.Core.RuntimeState.EnsureUmbracoUpgradeState(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 256\r\n   at Umbraco.Core.RuntimeState.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 206\r\nClientConnectionId:acddde6d-07e5-4769-ad90-c6c5aac842fd\r\nError Number:208,State:1,Class:16","SourceContext":"Umbraco.Core.RuntimeState","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"WARN ","HttpRequestNumber":1,"HttpRequestId":"ea99c354-ecd8-4f5d-a25e-9e03e61da4e7"}
    {"@t":"2023-08-24T14:21:53.5354605Z","@mt":"{FailMessage} ({Duration}ms) [Timing {TimingId}]","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Could not check the upgrade state. ---> System.Data.SqlClient.SqlException: Invalid object name 'umbracoKeyValue'.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n   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)\r\n   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)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 221\r\n   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in D:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryPolicy.cs:line 172\r\n   at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n   at NPoco.Database.ExecuteDataReader(DbCommand cmd)\r\n   at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)\r\n   at Umbraco.Core.Services.Implement.KeyValueService.GetValue(IUmbracoDatabase database, String key) in D:\\a\\1\\s\\src\\Umbraco.Core\\Services\\Implement\\KeyValueService.cs:line 213\r\n   at Umbraco.Core.RuntimeState.EnsureUmbracoUpgradeState(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 256\r\n   at Umbraco.Core.RuntimeState.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 206\r\n   --- End of inner exception stack trace ---\r\n   at Umbraco.Core.RuntimeState.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 223\r\n   at Umbraco.Core.Runtime.CoreRuntime.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, IProfilingLogger profilingLogger) in D:\\a\\1\\s\\src\\Umbraco.Core\\Runtime\\CoreRuntime.cs:line 259\r\n   at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer) in D:\\a\\1\\s\\src\\Umbraco.Core\\Runtime\\CoreRuntime.cs:line 149","FailMessage":"Boot failed.","Duration":22239,"TimingId":"1fadba7","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"ea99c354-ecd8-4f5d-a25e-9e03e61da4e7"}
    {"@t":"2023-08-24T14:22:03.8674764Z","@mt":"Stopping ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.MainDom","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO "}
    {"@t":"2023-08-24T14:22:03.8812660Z","@mt":"Released ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.MainDom","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO "}
    {"@t":"2023-08-24T14:22:03.9788306Z","@mt":"Application shutdown. Details: {ShutdownReason}\r\n\r\n_shutDownMessage={ShutdownMessage}\r\n\r\n_shutDownStack={ShutdownStack}","ShutdownReason":"InitializationError","ShutdownMessage":"Initialization Error\r\nHostingEnvironment initiated shutdown\r\nHostingEnvironment caused shutdown","ShutdownStack":"   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)\r\n   at System.Environment.get_StackTrace()\r\n   at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()\r\n   at System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand()\r\n   at System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)\r\n   at System.Web.HttpRuntime.AppDomainShutdownTimerCallback(Object state)\r\n   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)\r\n   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)\r\n   at System.Threading.TimerQueueTimer.CallCallback()\r\n   at System.Threading.TimerQueueTimer.Fire()\r\n   at System.Threading.TimerQueue.FireNextTimers()","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":25,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO "}
    {"@t":"2023-08-24T14:26:13.8582908Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Booting Umbraco 8.2.3.","TimingId":"9993cf0","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":33,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3cc4e0a5-6e15-420c-a8cb-aaf44e636518"}
    {"@t":"2023-08-24T14:26:13.9100335Z","@mt":"Booting site '{HostingSiteName}', app '{HostingApplicationID}', path '{HostingPhysicalPath}', server '{MachineName}'.","HostingSiteName":"MHS_Home_8","HostingApplicationID":"/LM/W3SVC/2/ROOT","HostingPhysicalPath":"C:\\inetpub\\vhosts\\MHS_Home_8\\","MachineName":"SERVER1","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":33,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3cc4e0a5-6e15-420c-a8cb-aaf44e636518"}
    {"@t":"2023-08-24T14:26:14.0565469Z","@mt":"Acquiring.","SourceContext":"Umbraco.Core.MainDom","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":33,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3cc4e0a5-6e15-420c-a8cb-aaf44e636518"}
    {"@t":"2023-08-24T14:26:14.0702423Z","@mt":"Acquired.","SourceContext":"Umbraco.Core.MainDom","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":33,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3cc4e0a5-6e15-420c-a8cb-aaf44e636518"}
    {"@t":"2023-08-24T14:26:14.6211245Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoKeyValue'.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n   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)\r\n   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)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 221\r\n   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in D:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryPolicy.cs:line 172\r\n   at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n   at NPoco.Database.ExecuteDataReader(DbCommand cmd)\r\nClientConnectionId:6b39a612-57fd-4d38-ad9e-c3bd1927f4bb\r\nError Number:208,State:1,Class:16","InstanceId":"ba4ffdaa","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":33,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"3cc4e0a5-6e15-420c-a8cb-aaf44e636518"}
    {"@t":"2023-08-24T14:26:14.6386141Z","@mt":"Could not check the upgrade state.","@l":"Warning","@x":"System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoKeyValue'.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n   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)\r\n   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)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 221\r\n   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in D:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryPolicy.cs:line 172\r\n   at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n   at NPoco.Database.ExecuteDataReader(DbCommand cmd)\r\n   at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)\r\n   at Umbraco.Core.Services.Implement.KeyValueService.GetValue(IUmbracoDatabase database, String key) in D:\\a\\1\\s\\src\\Umbraco.Core\\Services\\Implement\\KeyValueService.cs:line 213\r\n   at Umbraco.Core.RuntimeState.EnsureUmbracoUpgradeState(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 256\r\n   at Umbraco.Core.RuntimeState.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 206\r\nClientConnectionId:6b39a612-57fd-4d38-ad9e-c3bd1927f4bb\r\nError Number:208,State:1,Class:16","SourceContext":"Umbraco.Core.RuntimeState","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":33,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"WARN ","HttpRequestNumber":1,"HttpRequestId":"3cc4e0a5-6e15-420c-a8cb-aaf44e636518"}
    {"@t":"2023-08-24T14:26:20.4411381Z","@mt":"{FailMessage} ({Duration}ms) [Timing {TimingId}]","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Could not check the upgrade state. ---> System.Data.SqlClient.SqlException: Invalid object name 'umbracoKeyValue'.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n   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)\r\n   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)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 221\r\n   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in D:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryPolicy.cs:line 172\r\n   at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n   at NPoco.Database.ExecuteDataReader(DbCommand cmd)\r\n   at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)\r\n   at Umbraco.Core.Services.Implement.KeyValueService.GetValue(IUmbracoDatabase database, String key) in D:\\a\\1\\s\\src\\Umbraco.Core\\Services\\Implement\\KeyValueService.cs:line 213\r\n   at Umbraco.Core.RuntimeState.EnsureUmbracoUpgradeState(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 256\r\n   at Umbraco.Core.RuntimeState.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 206\r\n   --- End of inner exception stack trace ---\r\n   at Umbraco.Core.RuntimeState.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\RuntimeState.cs:line 223\r\n   at Umbraco.Core.Runtime.CoreRuntime.DetermineRuntimeLevel(IUmbracoDatabaseFactory databaseFactory, IProfilingLogger profilingLogger) in D:\\a\\1\\s\\src\\Umbraco.Core\\Runtime\\CoreRuntime.cs:line 259\r\n   at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer) in D:\\a\\1\\s\\src\\Umbraco.Core\\Runtime\\CoreRuntime.cs:line 149","FailMessage":"Boot failed.","Duration":6615,"TimingId":"9993cf0","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":33,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"3cc4e0a5-6e15-420c-a8cb-aaf44e636518"}
    {"@t":"2023-08-24T14:26:30.5486433Z","@mt":"Stopping ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.MainDom","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":28,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO "}
    {"@t":"2023-08-24T14:26:30.5497267Z","@mt":"Released ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.MainDom","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":28,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO "}
    {"@t":"2023-08-24T14:26:30.5988595Z","@mt":"Application shutdown. Details: {ShutdownReason}\r\n\r\n_shutDownMessage={ShutdownMessage}\r\n\r\n_shutDownStack={ShutdownStack}","ShutdownReason":"InitializationError","ShutdownMessage":"Initialization Error\r\nHostingEnvironment initiated shutdown\r\nHostingEnvironment caused shutdown","ShutdownStack":"   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)\r\n   at System.Environment.get_StackTrace()\r\n   at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()\r\n   at System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand()\r\n   at System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)\r\n   at System.Web.HttpRuntime.AppDomainShutdownTimerCallback(Object state)\r\n   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)\r\n   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)\r\n   at System.Threading.TimerQueueTimer.CallCallback()\r\n   at System.Threading.TimerQueueTimer.Fire()\r\n   at System.Threading.TimerQueue.FireNextTimers()","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":7848,"ProcessName":"iisexpress","ThreadId":28,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"SERVER1","Log4NetLevel":"INFO "}
    
  • Jack Chamberlain 4 posts 94 karma points
    Aug 27, 2023 @ 06:36
    Jack Chamberlain
    0

    Are you trying to do this locally or on a server? I had a similar problem recently on a server and it ended up being a permissions issue with the SQL login I was using.

  • Mital Gohil 8 posts 78 karma points
    Aug 29, 2023 @ 06:29
    Mital Gohil
    0

    I am doing this on server with administrator access to connectivity into database

  • Jack Chamberlain 4 posts 94 karma points
    Aug 29, 2023 @ 13:47
    Jack Chamberlain
    0

    I'd try doing the same steps but locally. Just so you can rule this in or out as a possibility.

Please Sign in or register to post replies

Write your reply to:

Draft