After upgrading from WSP to SolidCP when trying to delete a user. I get the following error.
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'REMOVE_USER' task on '' ORGANIZATION ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'CheckSfBUserExists'. 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.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, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) in D:gitv1.0SolidCPSourcesSolidCP.EnterpriseServer.CodeDataSQLHelper.cs:line 1232 at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in D:gitv1.0SolidCPSourcesSolidCP.EnterpriseServer.CodeDataSQLHelper.cs:line 1148 at SolidCP.EnterpriseServer.DataProvider.CheckSfBUserExists(Int32 accountId) in D:gitv1.0SolidCPSourcesSolidCP.EnterpriseServer.CodeDataDataProvider.cs:line 4434 at SolidCP.EnterpriseServer.OrganizationController.DeleteUser(Int32 itemId, Int32 accountId) in D:gitv1.0SolidCPSourcesSolidCP.EnterpriseServer.CodeHostedSolutionOrganizationController.cs:line 3118 --- End of inner exception stack trace --- at SolidCP.EnterpriseServer.OrganizationController.DeleteUser(Int32 itemId, Int32 accountId) in D:gitv1.0SolidCPSourcesSolidCP.EnterpriseServer.CodeHostedSolutionOrganizationController.cs:line 3179 at SolidCP.EnterpriseServer.esOrganizations.DeleteUser(Int32 itemId, Int32 accountId) in D:gitv1.0SolidCPSourcesSolidCP.EnterpriseServeresOrganizations.asmx.cs:line 370 --- End of inner exception stack trace ---
I checked and there was no procedure CheckSfBUserExists referencing the lyncUsers since there is no SFBUSers Table.
As a workaround I created the procedure.
USE [WebsitePanel]
GO
/*** Object: StoredProcedure [dbo].[CheckSfBUserExists] Script Date: 08/31/2016 12:31:14 ***/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[CheckSfBUserExists]
@AccountID int
AS
BEGIN
SELECT
COUNT(AccountID)
FROM
dbo.LyncUsers
WHERE AccountID = @AccountID
END
