→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AndreR250282
Engaged Sweeper

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?
2 ACCEPTED SOLUTIONS
Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

Hello there!

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

View solution in original post

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

View solution in original post

2 REPLIES 2
Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

Hello there!

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

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