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()
Hello,
Can you confirm for me if this database had been converted to MSP? The PeerRoleID normally comes from upgrading to MSP first.
Thanks,
Trevor Robinson
Hi Trevor,
Yes. I had WSP 2.1.0 then upgraded to MSP but had many issues then followed the tutorial to upgrade from MSP to SolidCP.
As I said everything worked great except now for the issue with creating a new Customer.
Could you please try re-download http://installer.solidcp.com/Files/stable/Tools/MSPtoSCP.zip and rerun it against the DB? I have just made some changes to this SQL script which allows it to support newer version of MSP.
getting this : 401 - Unauthorized: Access is denied due to invalid credentials. trying to download.
Nope now I get this when I try to open SolidCP Microsoft.Web.Services3.Security.SecurityFault: The security token could not be authenticated or authorized ---> System.Data.SqlClient.SqlException: Invalid column name 'PeerRoleId'. Invalid column name 'TwoFactorToken'.
Cleared Out my browser cache and at least got to the SolidCP Login screen now but once I login i get the following : Server Error in '/' Application. Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [NullReferenceException: Object reference not set to an instance of an object.] SolidCP.Portal.Login.ShortcutRedirect() +44 SolidCP.Portal.Login.LoginUser(String username, String password, Boolean rememberLogin, String preferredLocale, String theme) +783 SolidCP.Portal.Login.btnLogin_Click(Object sender, EventArgs e) +208 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +154 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3803 Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.36330
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.
That's correct in what you presume. The code does use stored procedures which are in the SQL database which cause the errors. With the extra script we are trying to clear up the DB so that all developers can expect the same fields for everyone.
Trevor
I seem to have found the issue.
My dbo.Users does not have an InstantMessenger Column. I figured this out while playing around with the "dbo.AddUser" Stored Procedure and submitting the Create User on the page checking the errors it brought up, initially it was just the PeerRoleId and TwoFactorToken that it stated was not passed to it by the script once I passed Null values to each of them I received a "Procedure or function AddUser has too many arguments specified". saw on the page Form that there is an InstaMessenger Variable but not in my dbo.Users Table.
So I created an InstantMessenger Column in the dbo.Users Table, added the @InstantMessenger Value Call and passed Null values to PeerRoleID & TwoFactorToken
Once this was done I could successfully create the new customer and Hosting spaces, Organizations etc.
Hello, Its strange you have these issues as the MSPtoSCP script should have taken care of this along with dropping the PeerRoleID & TwoFactorToken and updating alot of procedures. I have just tried it on an old MSPControl database and it appears to work fine. Did you get an error at all?
Hi yes strange indeed. I did get error messages when running the update DB but checked the forums and it was stated there that the ones I got was expected so I ignored them as they said.
