Solved V15 Update 15.0.62928.5 fails

[Prometheus DBA]

Hi all,

I try to update my 3CX server to the latest 15.0.62928.5 version. But this update keeps failing, and i don't quite understand why.

2017-03-07 08:11:35.418|0012| Transaction database_single: executing script

**SQL script is running in this prat but its too long to post here**

2017-03-07 08:11:36.042|0012| ERROR: ExecuteScript returns FAIL: Npgsql.PostgresException (0x80004005): 23505: duplicate key value violates unique constraint "parameter_name_key"
at Npgsql.NpgsqlConnector.DoReadMessage(DataRowLoadingMode dataRowLoadingMode, Boolean isPrependedMessage)
at Npgsql.NpgsqlConnector.ReadMessageWithPrepended(DataRowLoadingMode dataRowLoadingMode)
at Npgsql.NpgsqlDataReader.NextResultInternal()
at Npgsql.NpgsqlDataReader.NextResult()
at Npgsql.NpgsqlCommand.Execute(CommandBehavior behavior)
at Npgsql.NpgsqlCommand.ExecuteScalarInternal()
at Updater2Db.UpdateInfoExtractor.ExecuteScript(String sqlQuery, String transactionName)
2017-03-07 08:11:36.042|0001| Overall result of update is fail. Failed task(s):
2017-03-07 08:11:36.042|0001| Update DB Instance1 task
2017-03-07 08:11:36.042|0001| Starting to rollback...
2017-03-07 08:11:36.339|0001| System.UnauthorizedAccessException: Access to the path 'C:\Program Files\3CX Phone System\Bin\System.Runtime.InteropServices.RuntimeInformation.dll.tmp' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.InternalDelete(String path, Boolean checkHost)
at Updater2.CopyFilesTask.CleanTemps()
2017-03-07 08:11:38.602|0001| Done. Deleting rollback folder
2017-03-07 08:11:42.224|0001| Starting services...


Can anyone help me to solve this problem?

Greets,
Jeffrey

 

[GiannosC_3CX]

Hi Jeffrey,

I have sent you a p.m.

 

[Mehmet Gunay]

Hi we have this problem. Ho can I fixed it. thanks for help

 

[GiannosC_3CX]

Hi ,

Prometheus DBA removed every last bit of 3CX off his machine, he did a complete reinstall, upgraded the PhoneSystem, and restored a backup. This not a solution but it is a workaround to get the upgrade.

Therefore this problem comes from downgrade process, SP5 beta or SP5 backup and restore to SP4 this might work but it is not recommended and not supported.
While the update process is running, the system adds some new parameters to the existing service pack. Finally the following error "duplicate key value violates unique constraint "parameter_name_key"" indicates that this value is added in the System Phone twice and the upgrade process halts on that point. Every service pack that is released may have new parameters, new db_tables etc.. so the downgrade is not recommended and may brake the 3CX Phone system.