Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

Solved V15 Update 15.0.62928.5 fails

Discussion in '3CX Phone System - General' started by Prometheus DBA, Mar 7, 2017.

Thread Status:
Not open for further replies.
  1. Prometheus DBA

    Joined:
    Mar 7, 2017
    Messages:
    54
    Likes Received:
    2
    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
     
  2. GiannosC_3CX

    GiannosC_3CX Guest

    Hi Jeffrey,

    I have sent you a p.m.
     
  3. Mehmet Gunay

    Joined:
    Mar 7, 2017
    Messages:
    2
    Likes Received:
    0
    Hi we have this problem. Ho can I fixed it. thanks for help
     
  4. GiannosC_3CX

    GiannosC_3CX Guest

    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.
     
Thread Status:
Not open for further replies.