Fehler nach Update 2017 auf 2024

[mbauer@radiomatic.com]

Hallo,

nach dem Update von Version 2017 auf die neueste Version 2024 erhalte ich leider einige SQL Fehler:

An error occured on executing an sql statement
UserGetId

An error occured on executing an sql statement
UserGetId
Für die Prozedur oder Funktion UserGetId wurden zu viele Argumente angegeben.

---------------------------

  at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
  at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
  at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
  at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
  at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
  at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
  at Microsoft.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 Microsoft.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 Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
  at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
  at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader()
  at CloudAdminDataAccess.SqlDataAccessor.InitializeUser(String username, String domain, String sid, Int32 type, String extraTag)



An error occured on executing an sql statement

An error occured on executing an sql statement
ExtraTag

---------------------------

  at Microsoft.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
  at Microsoft.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
  at CloudAdminDataAccess.SqlDataAccessor.HasColumnAndNotDbNull(SqlDataReader r, String columnName)



Das Update der Datenbank hat ohne Fehler funktioniert. Ich bitte um Unterstützung!

[DevOma]

Please execute the 2 follwong sql scripts on your migrated database - first update, then StoredProc - warnings can be ignored

[mbauer@radiomatic.com]

Thank you for the quick response. I just ran the above mentiond scripts. For the StoredProcs.txt I received the following message:

Das Modul "ClearAll" ist abhängig vom fehlenden Objekt "Initialize". Das Modul wird trotzdem erstellt. Es kann jedoch erst erfolgreich ausgeführt werden, wenn das Objekt vorhanden ist.

Abschlusszeit: 2024-07-01T13:47:25.0353670+02:00


But altough ther seems to be a module missing, I do not receive any Error in Rocket RDP anymore. Do I have to add the missing module "Initialize"?

Kind regards
Matthias

[DevOma]

Nein alles gut so