After migration to new server the Schema was not updated during install

[AndreR250282]

Hi,

I have a strange problem:

My lansweeper server was a Windows 10, x86 and the database hosted on a SQL Express 2012 (different machine from the lansweeper server)

I wanted to upgrade from 10.4 to 11.

The installer marked down the incompatible database.

So I moved the database from SQL 2012 Express to an SQL 2016 Express on a different server.

After backup and restore and using the ConfigEditor to set up the connection, everything worked fine.

So next update attempt: Lansweeper needs x64 OS... dammit.

okay, so I installed Lansweeper on a 2022 Std. Server. Copied everything including Encryption.txt to new server. 

At first the lansweeper service wouldn't come up as it demands that there's no field InstallStatus in TsysConfig ... after inserting it (Type int) and setting value 1 -> the service comes up and the web interface shows everything working.

But it seems there are more fields missing...

Spoiler

2024-05-02 12:51:39,925 [8] INFO 61635 vendor oid's loaded
2024-05-02 12:51:58,354 [10] ERROR SELECT accountid, SMTPserver, incomingmailserver, address, displayname, sslincoming, ssloutgoing, authenticationincoming, authenticationoutgoing, usernameincoming, usernameoutgoing, passwordincoming, passwordoutgoing, SMTPport, serverport, [default], protocol, protocoloutgoing, inboxfolders, archivefolder, trashfolder, PasswordKeyHash, noincoming, nooutgoing, ClientIdIncoming, TenantIdIncoming, ClientSecretIncoming, ClientIdOutgoing, TenantIdOutgoing, ClientSecretOutgoing, GraphEndpointIncoming, GraphEndpointOutgoing, lasttried FROM htblemailaccounts
System.Data.SqlClient.SqlException (0x80131904): Ungültiger Spaltenname "GraphEndpointIncoming".
Ungültiger Spaltenname "GraphEndpointOutgoing".
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Lansweeper.Service.DL.Infrastructure.DB.ExecuteDataset(IDbConnection sqlConn, DbTransaction transaction, String commandText, IDbDataParameter[] parameterValues)
ClientConnectionId:fa907cf2-13a8-4969-b352-8754336e214c
Error Number:207,State:1,Class:16
2024-05-02 12:51:59,799 [10] ERROR Error verifying agent versions
System.Data.SqlClient.SqlException (0x80131904): Ungültiger Spaltenname "IsExclusive".
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<>c.<NonQuery>b__4_0(DbCommand t, DbCommandInterceptionContext`1 c)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)
at Z.EntityFramework.Extensions.BatchUpdate.<>c.(DbCommand , DbCommandInterceptionContext , Nullable`1 )
at Z.EntityFramework.Extensions.BatchUpdate.Execute[T](IQueryable`1 query, Expression`1 updateFactory)
at DbContextExtensions.[](IQueryable`1 , Expression`1 , Action`1 , Boolean )
at DbContextExtensions.UpdateFromQuery[TEntity](IQueryable`1 query, Expression`1 updateExpression, Action`1 bulkOperationFactory)
at Z.EntityFramework.Plus.BatchUpdateExtensions.Update[T](IQueryable`1 query, Expression`1 updateFactory, Action`1 batchUpdateBuilder)
at Z.EntityFramework.Plus.BatchUpdateExtensions.Update[T](IQueryable`1 query, Expression`1 updateFactory)
at Lansweeper.Service.DL.Repositories.EchoGroupRepository.ResetLastChangedForAllGroups(IDbContext context)
at Lansweeper.Service.BL.Echo.EchoGroupManager.ResetLastChangedForAllGroups(IDbContext dbContext)
at LansweeperService.UpgradeActions.VerifyAndUpdateAgentVersions.#=znUzhIULXOyGn(DatabaseContext #=zpRZwNEs=, ISystemConfig #=znMqKa3E=, Agent #=zUUFqcWc=)
at LansweeperService.UpgradeActions.VerifyAndUpdateAgentVersions.Execute(IDbConnection sqlConnection)
ClientConnectionId:fa907cf2-13a8-4969-b352-8754336e214c
Error Number:207,State:1,Class:16
2024-05-02 12:51:59,814 [10] ERROR Error init LsAgent data
System.Exception: No data loaded from TsysASServers, check database connection.
at Lansweeper.Service.BL.DatabaseCache.TsysASServersCache.get_ThisServer()
at #=z7QtylkqJaJp_QxYuYmOc8vQ=.#=zxSx3De43K3pp(IDbConnection #=z1XYIkJvCzlzGf8KOaXyuqXQ=)
2024-05-02 12:52:00,087 [10] ERROR Error updating database with config data
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.
---> System.Data.SqlClient.SqlException (0x80131904): Ungültiger Spaltenname "UniTableCleanupDays".
Ungültiger Spaltenname "DelLapsDays".
Ungültiger Spaltenname "CleanSoftwareUnis".
Ungültiger Spaltenname "CleanAssetServiceUnis".
Ungültiger Spaltenname "CleanBootConfigurationUnis".
Ungültiger Spaltenname "CleanExtendedDisplayUnis".
Ungültiger Spaltenname "CleanFeatureUnis".
Ungültiger Spaltenname "CleanGroupUnis".
Ungültiger Spaltenname "CleanQuickFixEngineeringUnis".
Ungültiger Spaltenname "CleanShareUnis".
Ungültiger Spaltenname "CleanAutorunUnis".
Ungültiger Spaltenname "CleanDriverUnis".
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<>c.<Reader>b__6_0(DbCommand t, DbCommandInterceptionContext`1 c)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
ClientConnectionId:fa907cf2-13a8-4969-b352-8754336e214c
Error Number:207,State:1,Class:16
--- End of inner exception stack trace ---
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass41_0.<GetResults>b__1()
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass41_0.<GetResults>b__0()
at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__31_0()
at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
at System.Linq.Enumerable.TryGetFirst[TSource](IEnumerable`1 source, Boolean& found)
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.<>c__14`1.<GetElementFunction>b__14_1(IEnumerable`1 sequence)

or a report:

Spoiler

OS: Not latest Build of Windows 2022 (0)

Error: Ungültiger Objektname "tsysUsage".

what can I do?

[Obi_1_Cinobi · Accepted solution]

Hello there!

I would contact support for assistance, as your database might be corrupt: https://www.lansweeper.com/contact/contact-support/

[Obi_1_Cinobi · Accepted solution]

Hello there!

I would contact support for assistance, as your database might be corrupt: https://www.lansweeper.com/contact/contact-support/

[AndreR250282 · Accepted solution]

The support actually helped me through this.

I ended up restoring my old database and reinstall the current version of lansweeper at the time of the database backup. Then I did the upgrade and everything went through.

Remember: no backup, no pity