I have IPCC 3.5 running. We have a script where calls are sent to different queues based on a code that the caller enters. We then use that code to perform a database lookup to get the CSQ and the voicemail box to send calls that callers do not want to wait in queue for. They wanted the ability to send a call to a different extension per queue if the caller was on hold for more than 4 minutes.
I was able to setup the if/then statement to hardcode the same extension for all. After that, we edited the table (teams) and added the column called call_redirect as a string. I changed the DBget function to add the field name to local variable setting. This is the same variable that we were using before when we transferred all calls after 4 minutes.
Once we changed this, the script bombs. After entering the code that should be able to be looked up, instead of being transferred to the queue, we hear a phone ringing, then we hear that we are experiencing system error.
Am I missing something?
How can I troubleshoot this and debug it?