Ran SolidCPInstaller 1.1.2 that came with SolidCP 1.1.2 and it has found update 1.2.0 for Enterprise Server, Server and Portal.
Started updating Enterprise Server 1.1.2 to 1.2.0 but it failed with error "Access to the path 'C:SolidCPEnterprise ServerbinMicrosoft.Web.Services3.dll' is denied.".
Then I downloaded new installer 1.2.1 (which has overwritten old one) and now it doesn't find SolidCP existing installation, but rather giving me fresh install.
I uninstalled new installer and reinstalled the old one but it doesn't find existing installation files anymore.
My question: what can I do to fix installer to see the existing installation files again and how to overcome error Access denied?
Any help appreciated. Thank you.
Hello,
You will need to remake the installer config file. You can find a sample at http://installer.solidcp.com/Files/Stable/Tools/SolidCP.Installer.exe.zip but it will need your db and cryptokey from the Enterprise web.config. We would recommend updating the installer to the latest version also.
The error you said sounds like the Enterprise server was in use when the upgrade was completed. The easiest way to unlock the file would be to run a iisreset.
Thank you Trevor for input. I used the the backup file (SolidCP.Installer.exe.config) which was thankfully saved in zip.
Tried to update again, with IIS restarted and got same error:
[9.6.2017. 21:33:45] ERROR: File delete error
System.UnauthorizedAccessException: Access to the path 'C:SolidCPEnterprise ServerbinMicrosoft.Web.Services3.dll' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileInfo.Delete()
at SolidCP.Setup.FileUtils.DeleteFileInternal(String fileName)
at SolidCP.Setup.FileUtils.DeleteFile(String fileName)
at SolidCP.Setup.FileUtils.DeleteDirectory(String directory)
at SolidCP.Setup.ExpressInstallPage.DeleteFiles(String file)
When tried to delete the file manually I found out it was used in SolidCP.SchedulerService. Stopped the service from Task manager and installed successfully.
Edit:
I then tried (three times, restarted IIS + stopped services) to update from 1.2.0 to 1.2.1 using the latest installer. It gives the following error:
[9.6.2017. 21:46:14] ERROR: Run sql error
System.Exception: Can't run SQL script C:Program Files (x86)SolidCP InstallerTmpsetupupdate_db.sql ---> System.Exception: Error executing SQL command:
IF EXISTS (SELECT * FROM [dbo].[ScheduleTasks] WHERE [TaskID] = 'SCHEDULE_TASK_LETSENCRYPT_RENEWAL' )
BEGIN
DELETE FROM [dbo].[ScheduleTasks]
WHERE [TaskID] = 'SCHEDULE_TASK_LETSENCRYPT_RENEWAL';
END
---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_ScheduleTaskViewConfiguration_ScheduleTaskViewConfiguration". The conflict occurred in database "SolidCP", table "dbo.ScheduleTaskViewConfiguration", column 'TaskID'.
The statement has been terminated.
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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
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()
Thank you so much for your post. I had the same issue and stopping the scheduler servicer the upgraded was installed successfully.
