Hi all SolidCP has been working great until I attempted creating a new customer.
Pretty stuck now and urgently need help.
Getting the following error :
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Exception: Error executing ‘ADD’ task on ‘avatar’ USER —> System.Data.SqlClient.SqlException: Procedure or function ‘AddUser’ expects parameter ‘@PeerRoleId ‘, which was not supplied.
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)
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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at SolidCP.EnterpriseServer.DataProvider.AddUser(Int32 actorId, Int32 ownerId, Int32 roleId, Int32 statusId, String subscriberNumber, Int32 loginStatusId, Boolean isDemo, Boolean isPeer, String comments, String username, String password, String firstName, String lastName, String email, String secondaryEmail, String address, String city, String country, String state, String zip, String primaryPhone, String secondaryPhone, String fax, String instantMessenger, Boolean htmlMail, String companyName, Boolean ecommerceEnabled)
at SolidCP.EnterpriseServer.UserController.AddUser(UserInfo user, Boolean sendLetter, String password)
— End of inner exception stack trace —
at SolidCP.EnterpriseServer.UserController.AddUser(UserInfo user, Boolean sendLetter, String password)
at SolidCP.EnterpriseServer.esUsers.AddUser(UserInfo user, Boolean sendLetter, String password)
— End of inner exception stack trace —
at SolidCP.Portal.PortalUtils.AddUserAccount(List`1 log, UserInfo user, Boolean sendLetter, String password)
at SolidCP.Portal.UserCreateUserAccount.SaveUser()
I have upgraded now to SolidCP 1.1.0 redid the MSPtoSCP DB update and the SolidCP 1.1.0 DB update all went through without a hitch. Then received an error trying to log in to SolidCP with “invalid Column : PeerRoleID and also TwoFactorToken – Manually added the columns in the User Table to just see what it does.
Could log in again after I did, then tried adding a new Customer again and got the same error again as above.
Trevor could this issue not be with the command being passed to the SQL DB when “Create” is clicked ?
Just grabbing at straws here as my programming skills is VERY limited but I am pretty desperate as I need to implement a new customer tomorrow with their hosted mailboxes.