ODBC Phone book integration almost working - Index was outside the bounds of the array

[commerce1]

Hi All,

I have 3CX 15.5 (PRO) and am trying to complete the ODBC contact integration. The test program works as expected but nothing being saved into the contact list.

DSN connection is correct, and running a SQL profiler, I can see my query being run on the SQL server against the correct database, but the results are not being saved.

3CXSystemService.log has the following error (number changed);

2018/09/18 11:40:52.786|2968|0008|Verb|Not processed. Number=0123456789, connection=3065, state=Dialing
2018/09/18 11:40:52.786|2968|0008|Verb|Add to processing. Number=0123456789, connection=3065, state=Dialing
2018/09/18 11:40:52.786|2968|0008|Info|ProcessActiveConnections(). Attached entries to connection:
2018/09/18 11:40:52.786|2968|0008|Verb|LocalMatches=. Number=0123456789, connection=3065, state=Dialing
2018/09/18 11:40:52.786|2968|0025|Info|SQL: Synchronize(...) called. processed=0
2018/09/18 11:40:52.786|2968|0025|Info|SQL: Looking for number: 0123456789
2018/09/18 11:40:52.786|2968|0025|Info|Looking for 456789 according to Minimal Matching Strategy in 3CX
2018/09/18 11:40:52.789|2968|0025|Info|General error in SQL query: Index was outside the bounds of the array.
2018/09/18 11:40:52.789|2968|0025|Info|SQL: No result found for number: 0123456789
2018/09/18 11:40:52.789|2968|0025|Verb|Removed from processing. Number=0123456789
2018/09/18 11:40:52.789|2968|0025|Info|CRM: processing of 0123456789 has been finished


SQL query is as follows;

SELECT FirstName,Surname,Company, Business2, Home, Mobile, Business FROM vw3CXContacts WHERE [Business2] LIKE '%%number%' OR [Home] LIKE '%%number%' OR [Mobile] LIKE '%%number%' OR [Business] LIKE '%%number%';


And I am mapping all 7 fields in the ODBC setup page;




Appreciate any help on this one as I think I am nearly there.