1
QueueMetrics installation / Re: Unable to complie class for JSP error when requesting call detail
« on: June 21, 2012, 09:40:50 »
That fixed it!
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.
An error occurred at line: 7 in the jsp file: /qm/./qm_recordtag_list_ajx_ds.jsp
Generated servlet error:
/srv/www/tomcat5/base/work/Catalina/localhost/QueueMetrics/org/apache/jsp/qm/popup_005fcall_jsp.java:340: cannot find symbol
symbol : method format(java.lang.String,java.lang.Integer)
location: class java.lang.String
String color = String.format("%06x", new Integer(lt.getI(r, colorCol)));
^
1 error
Generated servlet error:
Jun 11, 2012 9:50:27 AM org.apache.jasper.compiler.Compiler generateClass
SEVERE: Javac exception
Compile failed; see the compiler error output for details.
at org.apache.tools.ant.taskdefs.Javac.compile(Javac.java:933)
at org.apache.tools.ant.taskdefs.Javac.execute(Javac.java:757)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:407)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:497)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:476)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:464)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:662)
An error occurred at line: 7 in the jsp file: /qm/./qm_recordtag_list_ajx_ds.jsp
Generated servlet error:
/srv/www/tomcat5/base/work/Catalina/localhost/QueueMetrics/org/apache/jsp/qm/popup_005fcall_jsp.java:340: cannot find symbol
symbol : method format(java.lang.String,int)
location: class java.lang.String
String color = String.format("%06x", lt.getI(r, colorCol));
^
1 error
String.color = "blue";
everything works OK.classpath=/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/classes/:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/JID3.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/QueueMetrics-12.5.1.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/loway-tpf-193p.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/mysql-connector-java-3.1.14-bin.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/redstone-xmlrpc-1.1.1.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/slf4j-api-1.6.3.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/slf4j-jdk14-1.6.3.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/xerces.jar:/srv/www/tomcat5/base/work/Catalina/localhost/QueueMetrics:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/classes/:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/JID3.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/QueueMetrics-12.5.1.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/loway-tpf-193p.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/mysql-connector-java-3.1.14-bin.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/redstone-xmlrpc-1.1.1.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/slf4j-api-1.6.3.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/slf4j-jdk14-1.6.3.jar:/srv/www/tomcat5/base/webapps/QueueMetrics/WEB-INF/lib/xerces.jar:/usr/share/tomcat5/common/classes/:/usr/share/java/xerces-j2-2.7.1.jar:/usr/share/java/xerces-j2-2.7.1.jar:/usr/share/java/jta-1.0.1.jar:/usr/share/java/jakarta-commons-collections-3.1.jar:/usr/share/java/javamail/smtp-1.3.3_01.jar:/usr/share/java/javamail/pop3-1.3.3_01.jar:/usr/share/java/jakarta-commons-collections-3.1.jar:/usr/share/java/jspapi-5.0.18.jar:/usr/share/java/servletapi5-5.0.18.jar:/usr/share/java/jakarta-commons-pool-1.2.jar:/home/jdk1.6.0_30/jre/lib/rt.jar:/usr/share/java/javamail/pop3-1.3.3_01.jar:/usr/share/java/javamail/mailapi-1.3.3_01.jar:/usr/share/java/mx4j/mx4j-jmx-1.1.1.jar:/usr/share/tomcat5/common/lib/jasper-compiler.jar:/usr/share/java/servletapi5-5.0.18.jar:/home/jdk1.6.0_30/jre/lib/rt.jar:/usr/share/java/jakarta-commons-el-1.0.jar:/usr/share/java/ant-1.6.5.jar:/usr/share/java/jta-1.0.1.jar:/usr/share/tomcat5/common/lib/naming-factory.jar:/usr/share/java/javamail/mailapi-1.3.3_01.jar:/usr/share/java/javamail/smtp-1.3.3_01.jar:/usr/share/java/jakarta-commons-dbcp-1.2.1.jar:/usr/share/java/javamail/pop3-1.3.3_01.jar:/usr/share/java/javamail/imap-1.3.3_01.jar:/usr/share/java/jakarta-commons-logging-api-1.0.4.jar:/home/jdk1.6.0_30/jre/lib/rt.jar:/usr/share/tomcat5/common/lib/jasper-runtime.jar:/usr/share/java/javamail/imap-1.3.3_01.jar:/usr/share/java/log4j-1.2.12.jar:/usr/share/java/mx4j/mx4j-jmx-1.1.1.jar:/usr/share/java/javamail/smtp-1.3.3_01.jar:/usr/share/java/jspapi-5.0.18.jar:/usr/share/java/log4j-1.2.12.jar:/usr/share/java/jaf-1.0.2.jar:/usr/share/tomcat5/common/lib/naming-resources.jar:/usr/share/java/jspapi-5.0.18.jar:/usr/share/java/ant-1.6.5.jar:/usr/share/java/javamail/mailapi-1.3.3_01.jar:/usr/share/java/jakarta-commons-logging-api-1.0.4.jar:/usr/share/java/javamail/imap-1.3.3_01.jar:/usr/share/java/javamail/imap-1.3.3_01.jar:/usr/share/java/jakarta-commons-el-1.0.jar:/usr/share/tomcat5/common/lib/naming-java.jar:/usr/share/tomcat5/common/lib/naming-common.jar:/usr/share/java/servletapi5-5.0.18.jar:/usr/share/java/jakarta-commons-pool-1.2.jar:/usr/share/java/javamail/smtp-1.3.3_01.jar:/usr/share/java/jaf-1.0.2.jar:/usr/share/java/javamail/mailapi-1.3.3_01.jar:/usr/share/java/jakarta-commons-dbcp-1.2.1.jar:/home/jdk1.6.0_30/jre/lib/rt.jar:/usr/share/java/javamail/pop3-1.3.3_01.jar:/home/jdk1.6.0_30/lib/tools.jar:/usr/share/tomcat5/bin/bootstrap.jar:/usr/share/tomcat5/bin/commons-logging-api.jar:/usr/share/java/mx4j/mx4j-tools-1.1.1.jar:/usr/share/java/mx4j/mx4j-jmx-1.1.1.jar:/usr/share/java/mx4j/mx4j-actions-1.1.1.jar:/usr/share/java/mx4j/mx4j-jmx-1.1.1.jar:/home/jdk1.6.0_30/jre/lib/ext/dnsns.jar:/home/jdk1.6.0_30/jre/lib/ext/sunpkcs11.jar:/home/jdk1.6.0_30/jre/lib/ext/sunjce_provider.jar:/home/jdk1.6.0_30/jre/lib/ext/localedata.jar
Java Runtime: Version: 1.6.0_30
Vendor: Sun Microsystems Inc.
Class Version: 50.0
Java Home: /home/jdk1.6.0_30/jre
"[JSP] org.apache.jasper.JasperException - -- Inner Exception -- Exception: org.apache.jasper.JasperException Error: Unable to compile class for JSP An error occurred at line: 7 in the jsp file: /qm/./qm_recordtag_list_ajx_ds.jsp Generated servlet error: /srv/www/tomcat5/base/work/Catalina/localhost/QueueMetrics/org/apache/jsp/qm/popup_005fcall_jsp.java:340: cannot find symbol symbol : method format(java.lang.String,int) location: class java.lang.String String color = String.format('%06x', lt.getI(r, colorCol)); ^ 1 error Generated servlet error: May 28, 2012 12:27:48 PM org.apache.jasper.compiler.Compiler generateClass SEVERE: Javac exception Compile failed; see the compiler error output for details. at org.apache.tools.ant.taskdefs.Javac.compile(Javac.java:933) at org.apache.tools.ant.taskdefs.Javac.execute(Javac.java:757) at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:407) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:497) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:476) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:464) at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at ... "
mysql> select * from agenti_noti where nome_agente = 'Agent/897';
+-----------+-------------+-------------------+----------+----------+------------------+---------+---------------+--------------+--------------+---------------------+--------------------+---------------------+-------------------+--------------+---------------+
| id_agente | nome_agente | descr_agente | location | group_by | current_terminal | vnc_url | supervised_by | xmpp_address | payroll_code | sys_dt_creazione | sys_user_creazione | sys_dt_modifica | sys_user_modifica | sys_optilock | chiave_agente |
+-----------+-------------+-------------------+----------+----------+------------------+---------+---------------+--------------+--------------+---------------------+--------------------+---------------------+-------------------+--------------+---------------+
| 286 | Agent/897 | Sandiswa Mtombeni | 1 | 1 | - | | 0 | | | 0000-00-00 00:00:00 | 0 | 0000-00-00 00:00:00 | 0 | 0 | |
+-----------+-------------+-------------------+----------+----------+------------------+---------+---------------+--------------+--------------+---------------------+--------------------+---------------------+-------------------+--------------+---------------+
1 row in set (0.00 sec)
mysql>
mysql> select * from queue_log where call_id = '1314683706.47546';
+-----------+------------+------------------+-------+-----------+------------+-------+------------+-------+-------+-------+----------+------------------+
| partition | time_id | call_id | queue | agent | verb | data1 | data2 | data3 | data4 | data5 | serverid | unique_row_count |
+-----------+------------+------------------+-------+-----------+------------+-------+------------+-------+-------+-------+----------+------------------+
| P001 | 1314683706 | 1314683706.47546 | 958 | Agent/897 | ENTERQUEUE | - | 0736509200 | | | | | 1 |
| P001 | 1314683713 | 1314683706.47546 | 958 | Agent/897 | ABANDON | 1 | 1 | 7 | | | | 1 |
+-----------+------------+------------------+-------+-----------+------------+-------+------------+-------+-------+-------+----------+------------------+