1381
Running QueueMetrics / Re: JasperException - Cannot compile class 1.6.0.1
« on: May 06, 2010, 18:28:52 »
What is in teh queuemetrics/WEB-INf/libs directory?
QueueMetrics professional call center suite for the Asterisk PBX
News:
Welcome to the new forum!
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1382
QueueMetrics installation / Re: The following error occurred in the Transaction handler
« on: May 06, 2010, 18:27:44 »
Which version of MySQL are you using?
Did you create the database and load it?
Did you create the database and load it?
1383
Running QueueMetrics / Re: JasperException - Cannot compile class 1.6.0.1
« on: May 05, 2010, 10:50:43 »
If you did not change it, it is enabled by default on Debian.
See http://astrecipes.net/index.php?q=astrecipes/installing+queuemetrics+on+debian
See http://astrecipes.net/index.php?q=astrecipes/installing+queuemetrics+on+debian
1385
Realtime Live / Re: Calls in Realtime Live
« on: May 04, 2010, 15:41:39 »
If you see a call in the reports but not in the Realtime page, it usually a timezone offset problem.
If you sue MySQL you can check on the DB inspector, like here: http://queuemetrics.com/faq.jsp#faq-072-detecting-rt-issues
If you sue MySQL you can check on the DB inspector, like here: http://queuemetrics.com/faq.jsp#faq-072-detecting-rt-issues
1386
Outbound and QueueMetrics / Re: Caller ID outbounb
« on: May 04, 2010, 15:40:07 »
I'd use CALLERID(all) - see e.g. here: http://www.asteriskguru.com/tutorials/calleridall_function.html
1387
Running QueueMetrics / Re: Got 3 identical SQL records for a single call
« on: May 04, 2010, 15:38:25 »
You had a funny mistake - nice we found the problem!
1388
Running QueueMetrics / Re: report unanswered call´s & waiting time
« on: May 04, 2010, 15:37:52 »
You can run a filter on through the Custom Report so that you pick only calls that are longer than 10 seconds.
1389
Running QueueMetrics / Re: How can i disconnect calls in queue ?
« on: May 04, 2010, 15:36:59 »
Please look on the log what it is writing. It should be logging a more detailed entry.
1390
Running QueueMetrics / Re: JasperException - Cannot compile class 1.6.0.1
« on: May 04, 2010, 15:33:07 »
Are you using a JDK from SUN?
1391
Running QueueMetrics / Re: JasperException - Cannot compile class 1.6.0.1
« on: May 04, 2010, 15:32:30 »
Do you have Tomcat Security enabled?
1392
General Asterisk configuration / Re: Most stable app_queue version.
« on: May 04, 2010, 15:32:02 »
This is a tricky question - it really depends on which features you're needing. Unfortunately the feature set of Asterisk is quite volatile 
1393
Running QueueMetrics / Re: Got 3 identical SQL records for a single call
« on: May 03, 2010, 14:48:02 »
Do the following (requires MySQL 5):
1. Stop all qloaderd's - you should see no data being appended
2. Create a new table called queue_log_b that has the same definition as your current queue_log table:
3. Copy all data from queue_log to queue_log_b
4. Delete the queue_log table
5. Copy all unique rows back to queue_log
this may take a while.
6. Restart ONE instance of qloaderd.
1. Stop all qloaderd's - you should see no data being appended
2. Create a new table called queue_log_b that has the same definition as your current queue_log table:
Code: [Select]
CREATE TABLE `queue_log_b` (
`partition` varchar( 20 ) NOT NULL default '',
`time_id` int( 11 ) unsigned NOT NULL default '0',
`call_id` varchar( 30 ) NOT NULL default '',
`queue` varchar( 30 ) NOT NULL default '',
`agent` varchar( 30 ) NOT NULL default '',
`verb` varchar( 30 ) NOT NULL default '',
`data1` varchar( 30 ) NOT NULL default '',
`data2` varchar( 30 ) NOT NULL default '',
`data3` varchar( 30 ) NOT NULL default '',
`data4` varchar( 30 ) NOT NULL default '',
`serverid` varchar( 10 ) NOT NULL default '',
`unique_row_count` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
KEY `idx_sel` ( `partition` , `time_id` , `queue` ( 2 ) ) ,
KEY `partizione_b` ( `partition` , `time_id` , `unique_row_count` ) ,
KEY `by_hotdesk` ( `partition` ( 5 ) , `verb` ( 5 ) , `time_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
3. Copy all data from queue_log to queue_log_b
Code: [Select]
INSERT INTO queue_log_b
SELECT *
FROM queue_log
4. Delete the queue_log table
Code: [Select]
TRUNCATE TABLE queue_log5. Copy all unique rows back to queue_log
Code: [Select]
INSERT INTO queue_log (
SELECT `partition`, `time_id`, `call_id`, `queue`, `agent`,
`verb`, `data1`, `data2`, `data3`, `data4`,
`serverid`, MIN(`unique_row_count`)
FROM queue_log_b
GROUP BY `partition`, `time_id`, `call_id`, `queue`,
`agent`, `verb`, `data1`, `data2`, `data3`,
`data4`, `serverid`
ORDER BY time_id, MIN(unique_row_count)
)
this may take a while.
6. Restart ONE instance of qloaderd.
1394
Problems / MOVED: Got 3 identical SQL records for a single call
« on: May 03, 2010, 14:44:37 »
This topic has been moved to Running QueueMetrics.
http://forum.queuemetrics.com/index.php?topic=876.0
http://forum.queuemetrics.com/index.php?topic=876.0
1395
Realtime Live / Re: Calls in Realtime Live
« on: May 03, 2010, 14:26:09 »
You sure the clock is correct between Asterisk, MySQL and QM?