Show Posts
1
Running QueueMetrics / 12.5.1 'Close Call' Feature creates exception error
« on: July 30, 2012, 16:03:31 »
We've only run QM 12.5.1, so I can't say if this is a new problem, configuration issue, or bug.
When we try to close a call that we didn't capture the COMPLETECALLER event (usually due to a Asterisk issue) by using the 'scissors' icon 'Close Call' feature, we have allways seen an java exception error thrown:
From this mornings testing:
INFO: Jul 30, 2012 8:39:30 AM org.apache.catalina.core.ApplicationContext log
INFO: LowayTransactionController: [752C41D7A3D5B4AC9DEEDA86CB3996ED] [ERR] Error (tech) in class 'it.loway.app.queuemetrics.callListen.closeCallEffettua'. -- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
In my thinking the error is in the SQL query that QM makes:
When running: SELECT time_id, LCase(verb), queue, agent, data1 FROM queue_log WHERE = 'P001' AND call_id = 'XXXXXX-1342622728.51969' AND verb IN ( 'ENTERQUEUE', 'CONNECT', 'COMPLETEAGENT', 'COMPLETECALLER', 'ABANDON' ) ORDER BY time_id DESC
There seems to be a missing argument for 'PARTITION' (ie: should have WHERE partition = 'P001' .... ) --
We run a clustered asterisk topology. each server's queue_log is handled by a qloader instance, each instance uses a unique partition name, P001,P002,etc.
I've been working around this issue by doing direct editing of the queu_log table and pruning calls where this event occurs. It's not very often, but I'd prefer to do it with the proper tool.
Any help or insight would be appreciated.
When we try to close a call that we didn't capture the COMPLETECALLER event (usually due to a Asterisk issue) by using the 'scissors' icon 'Close Call' feature, we have allways seen an java exception error thrown:
From this mornings testing:
INFO: Jul 30, 2012 8:39:30 AM org.apache.catalina.core.ApplicationContext log
INFO: LowayTransactionController: [752C41D7A3D5B4AC9DEEDA86CB3996ED] [ERR] Error (tech) in class 'it.loway.app.queuemetrics.callListen.closeCallEffettua'. -- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
In my thinking the error is in the SQL query that QM makes:
When running: SELECT time_id, LCase(verb), queue, agent, data1 FROM queue_log WHERE = 'P001' AND call_id = 'XXXXXX-1342622728.51969' AND verb IN ( 'ENTERQUEUE', 'CONNECT', 'COMPLETEAGENT', 'COMPLETECALLER', 'ABANDON' ) ORDER BY time_id DESC
There seems to be a missing argument for 'PARTITION' (ie: should have WHERE partition = 'P001' .... ) --
We run a clustered asterisk topology. each server's queue_log is handled by a qloader instance, each instance uses a unique partition name, P001,P002,etc.
I've been working around this issue by doing direct editing of the queu_log table and pruning calls where this event occurs. It's not very often, but I'd prefer to do it with the proper tool.
Any help or insight would be appreciated.