Internal Server Error(500) - New SIP Trunk

[Key4ce]

Hello,

I have just made a totally fresh install of 3CX v15.0.57336.0 with a pro license but I appear to be having a issue adding a 2nd SIP Trunk.

When adding a new SIP Trunk i get a Internal Server Error(500) on the server with the following text

TCX.Configuration.Exceptions.ObjectSavingException: Commit failed on transaction Save ExternalLine.0 - '10001'
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.<InvokeActionFilterAsync>d__28.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeAsync>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.<Invoke>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.<Invoke>d__3.MoveNext()

I have noticed there is also a new PostgreSQL event in the Windows event log at the same time with the following:

ERROR: duplicate key value violates unique constraint "externalline_authid_key"
DETAIL: Key (authid)=() already exists.
STATEMENT: insert into externalline (direction,authid,authpswd,outcid,maxcalls,didnumbers,linenumber,fkidgateway,fkiddn) values(3,'','','',10,'12345','12345',10,32) RETURNING *

I am fine to remove and add another sip trunk but it appears to be the 2nd which is causing the issue. I did set the Activity Log to Verbose but it didn't appear to log anything about this error.

Hope somebody is able to help.

Key4ce

 

[lneblett]

Are the parameters of the two trunks different with regard to the credentials and numbers? The error message indicates that there is a duplicate value when it apparently wants a unique entry. It seems to indicate the AuthID is at fault.