SQL Database integration (CRM Integration is working OK but contact number does not exist)

[anton_zolotarev]

Hi, all!

We have 3CX Server Professional Perpetual version 16.0.273. Database MsSQL integration configured and working, but we receive a message "CRM Integration is working OK but contact number does not exist. Check log for more info or try a different number." The incoming call does not display the contact name (we use 3CX Phone for Windows client and Web client). Query CRM set to Always.

Started scenario with empty id
Request text: ConnectionString: Server=
Statement: SELECT firstname, lastname, email, phonebusiness, phonemobile, faxbusiness FROM contacts WHERE phonemobile LIKE '%X%' or phonebusiness LIKE '%X%'

Response text: [{"firstname":"Anton","lastname":"Test","email":null,"phonebusiness":null,"phonemobile":"X","faxbusiness":null}]
Response finished
Finished scenario with empty id
Started CreateContactRecord
Response finished
Finished CreateContactRecord
Result obtained

How does the contact search mechanism work in SQL database? Should a contact be created in the contact list on the 3CX server?

 

[anton_zolotarev]

Solution found. The query to the database was specified incorrectly.