CC产品V200R001C31报表业务出现“接通率报表有数据,但web chat详单没有数据”

发布时间:  2014-05-21 浏览次数:  245 下载次数:  0
问题描述
版本信息:V200R001C31
组网概述:如下图
故障现象:登录BIR报表,Huawei CC多媒体报表,查询WEB CHAT详单没有查询到数据;
告警信息
处理过程
1)针对“java.sql.SQLException: Inserted value too large for column:”
登录mongo数据库所在的服务器
#su – mongo
$ps –ef|grep mongo
mongo    24445     1  0 Feb13 ?        02:25:56 /home/mongo/mongodb/bin/mongod --port 20001 --dbpath /mongodata/mongo/dbspace --oplogSize 3000 --fork --logpath /mongodata/mongo/logs/mongo.log –auth
$cd /home/mongo/mongodb/bin
$./mongo –-port 20001 admin
//说明20001为ps -ef |grep mongo查询出来的端口号,即斜体部分
>use wecc
>db.auth(‘wecc’,’Huawei@123’)
>db.IcsChatBill.find()
>db.IcsChatBill.remove()
//说明 remove操作需要慎重执行;

2)针对“ChatEvtPostHandlerTask”的错误,参考处理过程:
设置~/tomcat7/webapps/icsclient/WEB-INF/menuExcel /athene.xls的接入码,为文本格式,重启服务;
根因
1)首先检查icsgateway的ETl.log(/home/prometheus/icsgateway/log/Etl.log)是否存在告警异常;
如果存在SQLException异常,如下,则参考处理过程1);
[2014-04-28 02:11:34, 034] transferIcsChatBill  for oracle error.message:{} (OracleProduceDAOImpl.java:236)
java.sql.SQLException: Inserted value too large for column: "尊敬的客户您好!欢迎使用华为在线客户服务中心。请直接点击以下链接菜单,选择您所需要的服务:"
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.oracore.OracleTypeCHAR.pickle81(OracleTypeCHAR.java:266)
at oracle.jdbc.oracore.OracleTypeADT.pickle81rec(OracleTypeADT.java:1813)
at oracle.jdbc.oracore.OracleTypeADT.pickle81(OracleTypeADT.java:1658)
at oracle.jdbc.oracore.OracleTypeUPT.pickle81(OracleTypeUPT.java:230)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.pickle81(OracleTypeCOLLECTION.java:310)
at oracle.jdbc.oracore.OracleTypeADT.pickle81(OracleTypeADT.java:1637)
at oracle.jdbc.oracore.OracleTypeADT.linearize(OracleTypeADT.java:1256)
at oracle.sql.ArrayDescriptor.toBytes(ArrayDescriptor.java:683)
at oracle.sql.ARRAY.toBytes(ARRAY.java:632)
at oracle.jdbc.driver.OraclePreparedStatement.setArrayCritical(OraclePreparedStatement.java:5556)
at oracle.jdbc.driver.OraclePreparedStatement.setARRAYInternal(OraclePreparedStatement.java:5515)
at oracle.jdbc.driver.OraclePreparedStatement.setArrayInternal(OraclePreparedStatement.java:5478)
at oracle.jdbc.driver.OracleCallableStatement.setArray(OracleCallableStatement.java:3931)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setArray(OraclePreparedStatementWrapper.java:110)
at com.huawei.prometheus.adapter.etl.dao.impl.OracleProduceDAOImpl.transferIcsChatBill(OracleProduceDAOImpl.java:227)
at com.huawei.prometheus.adapter.etl.IcsChatBillThread.run(IcsChatBillThread.java:121)
at java.lang.Thread.run(Thread.java:662)

2)其次,检查~/tomcat7/logs/agentgateway/ agentgateway.log 异常信息;
如果存在“ChatEvtPostHandlerTask”的错误,说明为接入码类型出现错误,如下,则参考处理过程2);
[2014-05-20 06:17:57.215] ERROR Thread-14 update chat call sub session failed. callId1400566676-16791998 [ChatEvtPostHandlerTask.java:499]
java.lang.NumberFormatException: For input string: "22225.0"
         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48) ~[na:1.6.0_30]
         at java.lang.Integer.parseInt(Integer.java:458) ~[na:1.6.0_30]
         at java.lang.Integer.parseInt(Integer.java:499) ~[na:1.6.0_30]
         at com.huawei.elpis.common.util.ChatEvtPostHandlerTask.handleSaveChatSession(ChatEvtPostHandlerTask.java:456) [ChatEvtPostHandlerTask.class:na]
         at com.huawei.elpis.common.util.ChatEvtPostHandlerTask.handleEvt(ChatEvtPostHandlerTask.java:206) [ChatEvtPostHandlerTask.class:na]
         at com.huawei.elpis.common.util.ChatEvtPostHandlerTask.run(ChatEvtPostHandlerTask.java:105) [ChatEvtPostHandlerTask.class:na]
建议与总结

END