Installed Umbraco version 7.11.1 via nuget in Visual Studio. Its using SQL Server CE. Im getting constant database errors. Sometimes it tells me that there is a sharing violation.
Some of the errors from the log file are:
2018-07-04 11:02:38,137 [P9980/D2/T14] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: User
2018-07-04 11:02:38,139 [P9980/D2/T14] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step User failed.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentNullException: Value cannot be null.
Parameter name: sqlSyntax
at Umbraco.Core.Persistence.Repositories.PetaPocoRepositoryBase`2..ctor(IScopeUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax)
at Umbraco.Core.Persistence.RepositoryFactory.CreateUserRepository(IScopeUnitOfWork uow)
at Umbraco.Core.Services.UserService.GetUserById(Int32 id)
at Umbraco.Web.Install.InstallSteps.NewInstallStep.Execute(UserModel user)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
2018-07-04 11:02:38,139 [P9980/D2/T14] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 2ms)
2018-07-04 11:02:38,140 [P9980/D2/T14] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step User
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentNullException: Value cannot be null.
Parameter name: sqlSyntax
2018-07-04 11:36:08,294 [P9980/D2/T30] WARN Umbraco.Core.Persistence.DbConnectionExtensions - Configured database is reporting as not being available! DataSource: DARKRASFCAB, InitialCatalog: umbraco7_1. Exception: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'umbraco'.
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Umbraco.Core.Persistence.DbConnectionExtensions.IsAvailable(IDbConnection connection)
Many errors on local version of Umbraco version 7.11.1
Installed Umbraco version 7.11.1 via nuget in Visual Studio. Its using SQL Server CE. Im getting constant database errors. Sometimes it tells me that there is a sharing violation.
Some of the errors from the log file are:
2018-07-04 11:02:38,137 [P9980/D2/T14] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: User 2018-07-04 11:02:38,139 [P9980/D2/T14] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step User failed. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentNullException: Value cannot be null. Parameter name: sqlSyntax at Umbraco.Core.Persistence.Repositories.PetaPocoRepositoryBase`2..ctor(IScopeUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax) at Umbraco.Core.Persistence.RepositoryFactory.CreateUserRepository(IScopeUnitOfWork uow) at Umbraco.Core.Services.UserService.GetUserById(Int32 id) at Umbraco.Web.Install.InstallSteps.NewInstallStep.Execute(UserModel user) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) 2018-07-04 11:02:38,139 [P9980/D2/T14] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 2ms) 2018-07-04 11:02:38,140 [P9980/D2/T14] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step User System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentNullException: Value cannot be null. Parameter name: sqlSyntax
2018-07-04 11:36:08,294 [P9980/D2/T30] WARN Umbraco.Core.Persistence.DbConnectionExtensions - Configured database is reporting as not being available! DataSource: DARKRASFCAB, InitialCatalog: umbraco7_1. Exception: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'umbraco'. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource
1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Umbraco.Core.Persistence.DbConnectionExtensions.IsAvailable(IDbConnection connection)is working on a reply...