This topic has 1 reply, 2 voices, and was last updated 1 year, 9 months ago by MSPControl.

  • Author
    Posts
  • #8788

    I have upgraded to the stated version and all was good.
    Now two days later the server will not allow us to login.

    I have reinstalled the Portal to ensure it is not a corrupt install.

    System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Data.SqlClient.SqlException: Procedure or function AddBackgroundTask has too many arguments specified.
    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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.ApplicationBlocks.Data.SqlHelper.Rp3P9JSr8SA4abgIyXJ(Object )
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
    at MSPControl.EnterpriseServer.DataProvider.AddBackgroundTask(Guid guid, String taskId, Int32 scheduleId, Int32 packageId, Int32 userId, Int32 effectiveUserId, String taskName, Int32 ItemID, String itemName, DateTime startDate, Int32 indicatorCurrent, Int32 indicatorMaximum, Int32 maximumExecutionTime, String source, Int32 severity, Boolean completed, Boolean notifyOnComplete, BackgroundTaskStatus status, Int32 minimumRecordSeverityForSave)
    at MSPControl.EnterpriseServer.TaskController.ovkDRTGJ8bXOZY1JKKOd(Guid guid, Object , Int32 scheduleId, Int32 packageId, Int32 userId, Int32 effectiveUserId, Object , Int32 ItemID, Object , DateTime startDate, Int32 indicatorCurrent, Int32 indicatorMaximum, Int32 maximumExecutionTime, Object , Int32 severity, Boolean completed, Boolean notifyOnComplete, BackgroundTaskStatus status, Int32 minimumRecordSeverityForSave)
    at MSPControl.EnterpriseServer.TaskController.AddTask(BackgroundTask task)
    at MSPControl.EnterpriseServer.TaskManager.StartTask(String taskId, String source, String taskName, Object itemName, Int32 itemId, Int32 scheduleId, Int32 packageId, Int32 maximumExecutionTime, List`1 parameters, Int32 minimumRecordSeverityForSave)
    at MSPControl.EnterpriseServer.TaskManager.StartTask(String source, String taskName, Object itemName, Int32 itemId, Int32 scheduleId, Int32 packageId, Int32 maximumExecutionTime, List`1 parameters, Int32 minimumRecordSeverityForSave)
    at MSPControl.EnterpriseServer.TaskManager.StartTask(String source, String taskName, Object itemName, Int32 itemId, List`1 parameters)
    at MSPControl.EnterpriseServer.TaskManager.StartTask(String source, String taskName, Object itemName, Int32 itemId)
    at MSPControl.EnterpriseServer.TaskManager.f54w8aGm4OMpFSApmDTx(Object , Object , Object , Int32 itemId)
    at MSPControl.EnterpriseServer.TaskManager.StartTask(String source, String taskName, Object itemName)
    at MSPControl.EnterpriseServer.UserController.AuthenticateUser(String username, String password, String ip, Nullable`1 twoFactorWasCorrect)
    at MSPControl.EnterpriseServer.esAuthentication.AuthenticateUser(String username, String password, String ip)
    — End of inner exception stack trace —
    at MSPControl.EnterpriseServer.BusinessErrorCodes.GetMessage(SoapException ex, Boolean code)
    at MSPControl.Portal.MSPControlModuleBase.ShowErrorMessage(String moduleName, String messageKey, Exception ex, String[] additionalParameters

    0
    Be the first one to like this.
    Please wait...
    #8792
     MSPControl
    Keymaster

    Looks like SQL is not updated.

    1
    1 person likes this.
    Please wait...
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

©2020 MSPControl | Privacy Policy

Log in with your credentials

or    

Forgot your details?

Create Account