Editing SIP Trunks

[tbit.com.mt]

Hey everyone,

Since upgrade to version 15.5 ( issue also was present in v15.0 ) i get the following error when trying to edit a sip trunk ( for example to add a DID or any other change. )

TCX.Configuration.Exceptions.ObjectSavingException: Commit failed on transaction Save ExternalLine.52 - '10002'
at TCX.Configuration.PhoneSystem.WBatchUpdater.Commit()
at TCX.Configuration.ExternalLine.DoSave(WBatchUpdater updater)
at TCX.Configuration.ExternalLine.Save()
at ConfigurationManagementModel.CfgItemBase.Save()
at ManagementConsoleJS.Services.Editor.Save()
at ManagementConsoleJS.Services.EditorService.SaveActiveObject(Int32 id)
at ManagementConsoleJS.Controllers.EditController.Save(Int32 id)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__28.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__18.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Builder.RouterMiddleware.d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at ManagementConsoleJS.Middleware.ExceptionWrapperMiddleware.d__3.MoveNext()

In the event log:

The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

ERROR: duplicate key value violates unique constraint "codec2gateway_fkidgateway_priority_key"
DETAIL: Key (fkidgateway, priority)=(1, 0) already exists.
STATEMENT: insert into codec2gateway (priority,fkidgateway,fkidcodec) values(0,1,65536) RETURNING *


I have a Patton gateway and 4 SIP trunks in the 3cx console all pointing to the patton gateway on different Auth IDs.

Help is appreciated.

Regards,
Terence

 

[YiannisH_3CX]

Hello @tbit.com.mt

The issue you are facing is probably caused to the fact that the template you are using to provision the Patton device is old (came from a previous version) or the Patton device was manually configured. Please try deleting the current configuration of the trunks and re-provision the Patton device with the default config file generated from the management console. The Patton should appear as 1 trunk and not 4.

 

[tbit.com.mt]

Thank you for your reply.

I can confirm that the template in the Patton gateway was configured using an old template. This should solve this issue.

Thank you for your kind reply.