Errors after upgrad...
 
Notifications
Clear all

Errors after upgrading 1.4.9 to 1.5.0

18 Posts
5 Users
2 Reactions
326 Views
Posts: 15
 coax
Topic starter
(@coax)
Eminent Member
Joined: 8 years ago

I manually restored everything back to 1.4.9 and this is the conclusion:

- Error in "Edit Domain" is gone, so it definitely has something to do with upgrade to 1.5.0

- Errors in "Mail Aliases" and "Groups" (for certain accounts) are there, so it must be an issue not related to 1.5.0. I did a server migration and imported resources in 1.4.9 so the issue is probably there. Doesn't matter as I can recreate aliases and groups.

 

A side note: I have initially upgraded from 1.4.9 to 1.5.0 via PowerShell script. When I checked for updates via SolidCP Installer 1.4.9, it saw my installation as 1.4.9 and offered an upgrade again. When I let it upgrade, it did successfully Portal and Server, but threw error on Enterprise Server:

[8.12.2024. 12:46:02] START: Copying files
[8.12.2024. 12:46:02] INFO: Copying files from "C:\Program Files (x86)\SolidCP Installer\Tmp" to "C:\SolidCP\Enterprise Server"
[8.12.2024. 12:46:02] END: Copied files
[8.12.2024. 12:46:02] START: Installing database objects
[8.12.2024. 12:46:02] INFO: Executing 1624 database commands
[8.12.2024. 12:46:04] ERROR: Run sql error
System.Exception: Can't run SQL script C:\Program Files (x86)\SolidCP Installer\Tmp\setup\update_db.sql ---> System.Exception: Error executing SQL command:  ---> System.InvalidOperationException: ExecuteNonQuery: CommandText property has not been initialized
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   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 SolidCP.Setup.SqlProcess.Run()
   --- End of inner exception stack trace ---
   at SolidCP.Setup.SqlProcess.Run()
   --- End of inner exception stack trace ---
   at SolidCP.Setup.SqlProcess.Run()
   at SolidCP.Setup.ExpressInstallPage.RunSqlScript(String connectionString, String database, String fileName)
   at SolidCP.Setup.ExpressInstallPage.ExecuteSqlScript(String file)
[8.12.2024. 12:46:08] INFO: RollBackPage loaded.
[8.12.2024. 12:46:08] START: Rolling back
[8.12.2024. 12:46:09] INFO: Setup wizard was canceled by user
[8.12.2024. 12:46:09] INFO: Setup wizard was canceled by user
[8.12.2024. 12:46:09] INFO: Setup wizard closed.
[8.12.2024. 12:46:09] INFO: Setup wizard was canceled by user

I know you are overwhelmed by everything else going on, so I don't expect you to deal with this any longer.

Reply
Posts: 107
 Ben
(@maoxiong)
Estimable Member
Joined: 7 years ago

I'm also getting an edit domain error after updating to 1.50, but mine is a little different. Occurs same time though, opening any domain.

 

(Checked all updates are 1.5.0 - running DNS 2019)

 

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at SolidCP.EnterpriseServer.ServerController.GetDomain(Int32 domainId, Boolean withLog)
at SolidCP.EnterpriseServer.esServers.GetDomain(Int32 domainId)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.EnterpriseServer.esServers.GetDomain(Int32 domainId)
at SolidCP.Portal.DomainsEditDomain.BindDomain()
Reply
6 Replies
Admin
(@trobinson)
Joined: 9 years ago

Noble Member
Posts: 1509

@maoxiong Can you check the Windows Event Viewer -> Applications -> SolidCP for any more detailed errors on the DNS server?

Reply
 Ben
(@maoxiong)
Joined: 7 years ago

Estimable Member
Posts: 107

@trobinson No errors listed there.

 

I don't know if it's a DNS issue, as it also appears for domains they don't have DNS enabled.

But for domains that do have DNS enabled, the (DNS) editor works fine and properly updates the DNS server.

 

Just so I'm clear, it's the page that shows up directly after you click a domain name in the Domains list.

 

image
Reply
Admin
(@trobinson)
Joined: 9 years ago

Noble Member
Posts: 1509

@maoxiong Could you try the SQL i posted below to see if it does help fix the error?

Reply
 Ben
(@maoxiong)
Joined: 7 years ago

Estimable Member
Posts: 107

@trobinson Afraid not, here is the whole error:

image

Windows 2019 / IIS 10 / MS DNS 2019

 

I also tried running the upgrade.sql file again just in case something had gone wrong with that, but still no joy 🙁

 

Thank you for the help 🙂

Reply
 Ben
(@maoxiong)
Joined: 7 years ago

Estimable Member
Posts: 107

Not sure if it's a clue - but if I enable Preview Domain, the error goes and the page shows correctly.

But removing the preview domain the error returns.

Thought it might also be due to an old domain, so tried adding a new one and get the same error.

In fact, looking at the page that does work (3 domains do) - they all have the "Reseller

Tick this option if you like to offer this domain to your customers to create their own free sub-domains." at the bottom, whereas the error domains don't
Reply
Admin
(@trobinson)
Joined: 9 years ago

Noble Member
Posts: 1509

@maoxiong It looks like you are correct a preview domain does appear to break DNS with the new TTL changes. I am working on a fix for this

Reply
Posts: 15
 coax
Topic starter
(@coax)
Eminent Member
Joined: 8 years ago

The only errors I got from SolidCP in Event Viewer are these, but these are happening since always and have thousands of them:

ERROR: Could not retrieve Web Deploy key from the registry
System.NullReferenceException: Object reference not set to an instance of an object.
   at SolidCP.Providers.Web.IIs70.IsWebDeployInstalled()
Reply
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

If you are still running 1.5.0 could you try run the following on your SolidCP database for me to see if it helps fix the issue?

 

IF NOT EXISTS (Select * from [ServiceProperties] INNER JOIN Services ON ServiceProperties.ServiceID=Services.ServiceID Where Services.ProviderID IN (7, 9, 24, 28, 55, 56, 410, 1703, 1901, 1902, 1903) AND ServiceProperties.PropertyName = N'RecordMinimumTTL')
BEGIN
DECLARE service_cursor CURSOR FOR SELECT ServiceId FROM Services WHERE ProviderID IN (7, 9, 24, 28, 55, 56, 410, 1703, 1901, 1902, 1903)
DECLARE @ServiceID INT
OPEN service_cursor
FETCH NEXT FROM service_cursor INTO @ServiceID
WHILE @@FETCH_STATUS = 0
BEGIN
	BEGIN
		INSERT [dbo].[ServiceProperties] ([ServiceID], [PropertyName], [PropertyValue]) VALUES (@ServiceID, N'RecordMinimumTTL', N'3600')
		INSERT [dbo].[ServiceProperties] ([ServiceID], [PropertyName], [PropertyValue]) VALUES (@ServiceID, N'RecordDefaultTTL', N'86400')
	END
	
	FETCH NEXT FROM service_cursor INTO @ServiceID
END

CLOSE service_cursor
DEALLOCATE service_cursor
END
GO
Reply
1 Reply
Customer
(@gns)
Joined: 1 month ago

New Member
Posts: 1

@trobinson 

We run the script but we still get the same error when editing domains after upgrading to 1.5 
Any ides on how to resolve this issue?

Reply
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Today we released v1.5.1 which includes a fix for the issue with preview domains.

Reply
1 Reply
 Ben
(@maoxiong)
Joined: 7 years ago

Estimable Member
Posts: 107

@trobinson All good now, thank you kind sir 🙂

Reply
Page 2 / 2
Share: