Unable to create a new contact

[Frank_I]

WIN SRV 2012 R2 on VMWare ESXI 6.0
PBX Server Version: 15.5.8801.3

When I try to create a new contact using the webgui I receive the message "Internal Server Error(500)

TCX.Configuration.Exceptions.ObjectSavingException: Commit failed on transaction Save TCX.Configuration.PhoneBookEntry
   bei TCX.Configuration.PhoneSystem.WBatchUpdater.Commit()
   bei TCX.Configuration.PhoneSystem.WBatchUpdater.SaveBatch[T](T obj, Wbase[] wobjs)
   bei TCX.Configuration.PhoneBookEntry.Save()
   bei ConfigurationManagementModel.CfgItemBase.Save()
   bei ManagementConsoleJS.Services.Editor.Save()
   bei ManagementConsoleJS.Services.EditorService.SaveActiveObject(Int32 id)
   bei ManagementConsoleJS.Controllers.EditController.Save(Int32 id)
   bei Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__12.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   bei Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__10.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   bei Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
   bei Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   bei Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__14.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   bei Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.d__22.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   bei Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
   bei Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   bei Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.d__17.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   bei Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.d__15.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   bei Microsoft.AspNetCore.Builder.RouterMiddleware.d__4.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   bei ManagementConsoleJS.Middleware.ExceptionWrapperMiddleware.d__3.MoveNext()

 

[craigreilly]

SP3? Perhaps updating would fix this or even a reboot?

 

[Frank_I]

Just updated to 15.5.13103.5
Unfortunately same error. Editing an existing contact is possible.
Is it related to the postgres database or rather to the 3cx server?

 

[YiannisH_3CX]

Hello @Frank_I

Are you manually trying to add the contacts or are you trying to import using a csv file? If you are trying to import make sure that no duplicate contacts exist in the file and try again. A good way to troubleshoot the issue is to open the browse console and see the error produced when trying to import a contact. Alternatively you can create a ticket with our support department so they can look at the system logs to determine the cause of the issue.

 

[Frank_I]

Hi YiannisH,

the same error appears when importing a contact from a .csv file.
The event log doesn't show anything. Where can I find the syslog file you have mentioned?

 

[YiannisH_3CX]

What i meant is open the browser console while you are trying to add a contact. That will normally give you more info regarding the error. For example in Google Chrome you can press F12 and navigate to console.

 

[Frank_I]

it just says syntax error.

 

[Frank_I]

in Chrome the console shows a different message:
befor the error 500 there is an error 401! Any idea what could be the authorization issue?

 

[craigreilly]

are you logged in as "admin" or another such user?

 

[Frank_I]

yes, logged in with the administrative user

 

[YiannisH_3CX]

It looks like the issue is with the database. Perhaps something go corrupted or there is an invalid character saved that is causing the error when you try to insert a new contact.
In this case i would recommend creating a full backup so you can easily restore your configuration.
Then as a first step export all your contacts from the management console and then delete them. While the contacts list is empty try to create a new contact and see if that works. If it does we will need to look at the contacts in the csv to see where the issue is.
If you still get the error you will need to un-install the system, download the new installer and re-install the system using your backup.