Inbound calls Local Closer Transfer call does not xfer

[Noah]

Quick Description:
This problem started out as a
"Sorry, there are no available sessions"

I know this problem looked at all known possible reasons for this. None of the usual reasons applied.

Remember the message pops up: if (strlen($session_id) < 1) From line 2790 ish of /agc/vicidial.php

OK the session_id isn't being passed from the db query to the vicidial_conferences table. Dig a bit deeper...

This issue arrived from a bulk phone insert which corrupted the phone table in some way. The client indicated there was a duplicate entry that the bulk phone insert caught, but something occurred to cause a corruption. Seemingly not right away but only after a mysql check optimize and repair process script that runs nightly.

Luckily we have backups of the db that run nightly so we restored the phone table and agents were now able to login without the "Sorry, there are no available sessions" issue.

However we still have a lingering issue where agents can't transfer an Inbound call to another ingroup using the local closer button.

Somehow it seems on an inbound call and transfer using the local closer button attempts to trigger the function to transfer the call, but the voice channel remains and the dispo box pops up for the transferring agent to choose. And yes the agent and transferred party are still speaking to each other.

*************
What tables should we look at restoring to help correct this problem for the local closer transfer???
Or something else? Any guidance to capture a log for this issue?
*************

Grabbed the conference channel info on both an inbound and an outbound call to show the difference with the same local closer transfer process.

Inbound Call still remains with agent after transfer to local closer

VERSION: 2.6-359c BUILD: 121130-0734 Server: 192.168.100.52
Hide conference call channel information
LIVE CALLS IN YOUR SESSION:
# REMOTE CHANNEL HANGUP VOLUME
1 SIP/777-00008a0f HANGUP
2 Local/58600051@default-f7d7,2 recording
3 IAX2/dialer1-12224 HANGUP

After Transfer local closer button has been clicked and dispo screen appears
The IAX call in the cluster still remains connected to the call

LIVE CALLS IN YOUR SESSION:
# REMOTE CHANNEL HANGUP VOLUME
1 SIP/777-00008a0f HANGUP
2 IAX2/dialer1-12224 HANGUP


Outbound call

LIVE CALLS IN YOUR SESSION:
# REMOTE CHANNEL HANGUP VOLUME
1 SIP/777-00008a0f HANGUP
2 Local/58600051@default-3c82,2 recording
3 Local/8600051@default-6ce7,2 HANGUP


# REMOTE CHANNEL HANGUP VOLUME
1 SIP/777-00008a0f HANGUP

[Noah]

UPDATE: SOLVED

On the db live_sip_channels please take note of the channels from all your servers in the cluster.
If this table is not updating within a cluster. Perhaps the other telephony machines are not updating this table.
Reboot the dialers/telephony machines to reconnect to the db and cluster. OR probably just issue service vicidial restart and check to make sure asterisk is running after.

[williamconley]

often resolved by rebooting nightly.