Why does my SIP trunk report that the SIP connection offline and doesnt send OPTIONS packets?

The following behavior can only occur in V10 if the server was upgraded from V8 or V9.

Symptoms:

In the Wireshark trace, you can see that the SIP trunk is not sending any OPTIONS packets.

The SIP trunk reports "SIP Connection offline":

Check the diagnostics for the affected SIP trunk.

If the “XccB2BuaSipProtocol” parameter shows “0 / 0x0,” follow the steps below. 

Solution:

Stop the XPhone Connect Server service.

Open SQL Server Management Studio and connect to the XPCONNECT database.

Expand XPDATA, then Tables, and locate the table dbo.t_c4bAtlasPBX. Right-click on the table to display the first 1000 entries, and then locate the GUID of the SIP gateway with the offline SIP Connection.

You can determine which trunk is involved by checking the port in the col_c4bAtlasPBX_Enabled field. This matches the port that was assigned as the remote port during the SIP connection to the PBX:

This port can be used to determine which "dir_Guid" is required:

You can now use this GUID to check the parameter's dir_OrdNo. Below is the corresponding call; please replace "GUID" with the actual GUID of the gateway.
 

SELECT TOP (1000) [dir_ID]
      ,[dir_Guid]
      ,[dir_PropertyName]
      ,[dir_OrdNo]
      ,[dir_Value]
  FROM [XPDATA].[dbo].[tableArray]
  WHERE dir_Guid='GUID';

 
In the results table, look for the "XccB2BuaSipProtocol" parameter under dir_Value (near the bottom of the column) and take dir_OrdNo + 1. 

dir_OrdNo + 1, which in this case is 54.

This result is then the value for the INDEX placeholder in the UPDATE statement.

Now execute the following command to make the change in the TCP database. Replace GUID and INDEX with the values you determined.

UPDATE tableArray SET dir_Value='1' WHERE dir_Guid='GUID' AND dir_OrdNo='INDEX';

To verify, you can run the Select command (see above) again. The line under "XccB2BuaSipProtocol" should now have a dir_Value of 1: