Hello All,<div><br></div><div>I have difficulty with Inbound SLA. Outbound SLA working without any issue. Inbound SLA not working.</div><div><br></div><div>FreeSWITCH Version - FreeSWITCH Version 1.0.head (git-6875a97 2010-09-08 16-33-50 -0500)</div>

<div><br></div><div>Linksys SPA942 - 6.1.5(a)</div><div><br></div><div>Once the inbound call answered the following SQL Error appear on the debug log.  Please let me know how to fix this issue.</div><div><br></div><div><br>

</div><div><div>2010-09-08 23:06:25.086299 [ERR] sofia_presence.c:687 PROCESS PRESENCE EVENT</div><div>2010-09-08 23:06:25.086299 [ERR] sofia_presence.c:1827 PRES SQL select sip_from_user,sip_from_host,call_info,call_info_state,uuid from sip_dialogs where hostname=&#39;li176-12&#39; and sip_from_user=&#39;200&#39; and sip_from_host=&#39;<a href="http://mydomain.com">mydomain.com</a>&#39;</div>

<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1848 PRES SQL select call_id,expires,sub_to_user,sub_to_host,event from sip_subscriptions where expires &gt; -1 and hostname=&#39;li176-12&#39; and sub_to_user=&#39;200&#39; and sub_to_host=&#39;<a href="http://mydomain.com">mydomain.com</a>&#39; and (event=&#39;call-info&#39; or event=&#39;line-seize&#39;)</div>

<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 0 [call_id]=[<a href="mailto:5c0f4043-aaa7bbd0@192.168.240.104">5c0f4043-aaa7bbd0@192.168.240.104</a>]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 1 [expires]=[1284008633]</div>

<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 2 [sub_to_user]=[200]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 3 [sub_to_host]=[<a href="http://mydomain.com">mydomain.com</a>]</div>

<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 4 [event]=[call-info]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 0 [call_id]=[<a href="mailto:696f8b47-50fa4cba@192.168.240.110">696f8b47-50fa4cba@192.168.240.110</a>]</div>

<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 1 [expires]=[1284008691]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 2 [sub_to_user]=[200]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 3 [sub_to_host]=[<a href="http://mydomain.com">mydomain.com</a>]</div>

<div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1675 SLA3: 4 [event]=[call-info]</div><div>2010-09-08 23:06:25.087545 [ERR] sofia_presence.c:1863 CLEAR SQL delete from sip_dialogs where sip_from_user=&#39;200&#39; and sip_from_host=&#39;<a href="http://mydomain.com">mydomain.com</a>&#39; and call_info_state=&#39;seized&#39;</div>

<div>2010-09-08 23:06:25.088541 [ERR] sofia_presence.c:680 STATE SQL update sip_dialogs set call_info=&#39;appearance-index=1&#39;,call_info_state=&#39;active&#39; where hostname=&#39;li176-12&#39; and uuid=&#39;00f17b14-2e0b-4711-b082-a7c5a90621d8&#39;</div>

<div>2010-09-08 23:06:25.088541 [ERR] sofia_presence.c:687 PROCESS PRESENCE EVENT</div><div>2010-09-08 23:06:25.088541 [ERR] sofia_presence.c:1827 PRES SQL select sip_from_user,sip_from_host,call_info,call_info_state,uuid from sip_dialogs where hostname=&#39;li176-12&#39; and sip_from_user=&#39;200&#39; and sip_from_host=&#39;<a href="http://mydomain.com">mydomain.com</a>&#39;</div>

<div>2010-09-08 23:06:25.088541 [ERR] sofia_presence.c:1848 PRES SQL select call_id,expires,sub_to_user,sub_to_host,event from sip_subscriptions where expires &gt; -1 and hostname=&#39;li176-12&#39; and sub_to_user=&#39;200&#39; and sub_to_host=&#39;<a href="http://mydomain.com">mydomain.com</a>&#39; and (event=&#39;call-info&#39; or event=&#39;line-seize&#39;)</div>

<div>2010-09-08 23:06:25.089546 [ERR] sofia_presence.c:1863 CLEAR SQL delete from sip_dialogs where sip_from_user=&#39;200&#39; and sip_from_host=&#39;<a href="http://mydomain.com">mydomain.com</a>&#39; and call_info_state=&#39;seized&#39;</div>

</div><div><br></div><div><br></div><div><br clear="all">Thanks</div><div>Lloyd<br><br>
</div>