衍生成功日志案例

2016-06-29 11:15:28,408 [schedulerFactoryBean_Worker-1] INFO com.eastcom.soc.added.SocWeekInherit - 解析入库:2016062700>>>>>>>2016062724段告警完成
2016-06-30 11:00:00,016 [schedulerFactoryBean_Worker-7] INFO com.eastcom.soc.added.SocWeekInherit - 初始化数据完成》》
2016-06-30 11:00:00,020 [schedulerFactoryBean_Worker-7] INFO com.eastcom.soc.added.SocWeekInherit - 开始解析:2016062800>>>>>>>2016062824段告警
2016-06-30 11:00:00,020 [schedulerFactoryBean_Worker-7] INFO com.eastcom.soc.added.SocWeekInherit - doSelect: true
2016-06-30 11:00:00,020 [schedulerFactoryBean_Worker-7] INFO com.eastcom.soc.added.SocWeekInherit - sqlHour:select a.HOUR_ID time, a.CITY city,a.ALARM_LEVEL alarmlevel, a.ALARM_TYPE alarmtype, a.OBJECT_TYPE objectType, a.OBJECT_NAME object, a.VALUE_CODE||a.OBJECT_TYPE indicateId ,a.VALUE_NAME temtitle,a.VALUE_NAME_0 indicate, a.VALUE_NAME_0||' '||to_char(a.VALUE_0,'fm9999999990.0000')||a.VALUE_UNIT_0||'; 阈值 '||a.VALUE_THRESHOLD||a.VALUE_UNIT_0||';'|| a.VALUE_NAME_1||' '||to_char(a.VALUE_1,'fm9999999990.0000')||a.VALUE_UNIT_1||';'||a.VALUE_NAME_2||' '||a.VALUE_2||a.VALUE_UNIT_2 ||';'|| 'CELL覆盖率是'||to_char(b.LTE_UE_MR_CELL_C_001*100,'fm9999999990.0000')||'%,质差用户数'||b.LTE_UE_MR_CELL_008||',质差用户占比'||to_char(b.LTE_UE_MR_CELL_008/b.LTE_UE_MR_CELL_007*100,'fm9999999990.0000')||'%;'|| 'SinrUL平均值是'||b.LTE_UE_MR_CELL_C_002||',质差用户数'||b.LTE_UE_MR_CELL_009||',质差用户占比'||to_char(b.LTE_UE_MR_CELL_009/b.LTE_UE_MR_CELL_007*100,'fm9999999990.0000')||'%;'|| '模三干扰强度是'||b.LTE_UE_MR_CELL_C_003||',质差用户数'||b.LTE_UE_MR_CELL_010||',质差用户占比'||to_char(b.LTE_UE_MR_CELL_010/b.LTE_UE_MR_CELL_007*100,'fm9999999990.0000')||'%;'|| 'RRC连接建立成功率是'||to_char(c.LTE_UU_CELL_C_001*100,'fm9999999990.0000')||'%,质差用户数'||c.LTE_UU_CELL_004||',质差用户占比'||to_char(c.LTE_UU_CELL_004/c.LTE_UU_CELL_003*100,'fm9999999990.0000')||'%;'|| '切换成功率是'||to_char(d.LTE_X2_CELL_C_001*100,'fm9999999990.0000')||'%,质差用户数'||d.LTE_X2_CELL_004||',质差用户占比'||to_char(d.LTE_X2_CELL_004/d.LTE_X2_CELL_003*100,'fm9999999990.0000')||'%;' context from DX_SOC_RP_ALARM_DATA a left join gdsignal.F_LTE_UE_MR_CELL_H b on a.HOUR_ID=b.HOUR_ID and a.OBJECT_ID=b.ECELL_OID left join gdsignal.F_LTE_UU_CELL_H c on a.HOUR_ID=c.HOUR_ID and a.OBJECT_ID=c.ECELL_OID left join gdsignal.F_LTE_X2_CELL_H d on a.HOUR_ID=d.HOUR_ID and a.OBJECT_ID=d.ECELL_OID where a.OBJECT_TYPE='小区' and a.HOUR_ID>=? and a.HOUR_ID<= ?
2016-06-30 11:00:00,253 [schedulerFactoryBean_Worker-7] ERROR com.eastcom.soc.added.SocWeekInherit - startrun:org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [select HOUR_ID time, CITY city,ALARM_LEVEL alarmlevel, ALARM_TYPE alarmtype, OBJECT_TYPE objectType, OBJECT_NAME object, VALUE_CODE||OBJECT_TYPE indicateId ,VALUE_NAME temtitle,VALUE_NAME_0 indicate, VALUE_NAME_0||' '||to_

char(VALUE_0,'fm9999999990.0000')||VALUE_UNIT_0||'; 阈值 '||VALUE_THRESHOLD||VALUE_UNIT_0||';'||VALUE_NAME_1||' '||to_char(VALUE_1,'fm9999999990.0000')||VALUE_UNIT_1||';' ||VALUE_NAME_2||' '||VALUE_2||VALUE_UNIT_2 context from DX_SOC_RP_ALARM_DATA where HOUR_ID>= ? and HOUR_ID< ? and OBJECT_TYPE!='小区' ]; 无法从套接字读取更多的数据; nested exception is java.sql.SQLRecoverableException: 无法从套接字读取更多的数据
2016-07-01 11:00:00,021 [schedulerFactoryBean_Worker-7] INFO com.eastcom.soc.added.SocWeekInherit - 初始化数据完成》》
2016-07-01 11:00:00,023 [schedulerFactoryBean_Worker-7] INFO com.eastcom.soc.added.SocWeekInherit - 开始解析:2016062900>>>>>>>2016062924段告警
2016-07-01 11:00:00,023 [schedulerFactoryBean_Worker-7] INFO com.eastcom.soc.added.SocWeekInherit - doSelect: true
2016-07-01 11:00:00,023 [schedulerFactoryBean_Worker-7] INFO com.eastcom.soc.added.SocWeekInherit - sqlHour:select a.HOUR_ID time, a.CITY city,a.ALARM_LEVEL alarmlevel, a.ALARM_TYPE alarmtype, a.OBJECT_TYPE objectType, a.OBJECT_NAME object, a.VALUE_CODE||a.OBJECT_TYPE indicateId ,a.VALUE_NAME temtitle,a.VALUE_NAME_0 indicate, a.VALUE_NAME_0||' '||to_char(a.VALUE_0,'fm9999999990.0000')||a.VALUE_UNIT_0||'; 阈值 '||a.VALUE_THRESHOLD||a.VALUE_UNIT_0||';'|| a.VALUE_NAME_1||' '||to_char(a.VALUE_1,'fm9999999990.0000')||a.VALUE_UNIT_1||';'||a.VALUE_NAME_2||' '||a.VALUE_2||a.VALUE_UNIT_2 ||';'|| 'CELL覆盖率是'||to_char(b.LTE_UE_MR_CELL_C_001*100,'fm9999999990.0000')||'%,质差用户数'||b.LTE_UE_MR_CELL_008||',质差用户占比'||to_char(b.LTE_UE_MR_CELL_008/b.LTE_UE_MR_CELL_007*100,'fm9999999990.0000')||'%;'|| 'SinrUL平均值是'||b.LTE_UE_MR_CELL_C_002||',质差用户数'||b.LTE_UE_MR_CELL_009||',质差用户占比'||to_char(b.LTE_UE_MR_CELL_009/b.LTE_UE_MR_CELL_007*100,'fm9999999990.0000')||'%;'|| '模三干扰强度是'||b.LTE_UE_MR_CELL_C_003||',质差用户数'||b.LTE_UE_MR_CELL_010||',质差用户占比'||to_char(b.LTE_UE_MR_CELL_010/b.LTE_UE_MR_CELL_007*100,'fm9999999990.0000')||'%;'|| 'RRC连接建立成功率是'||to_char(c.LTE_UU_CELL_C_001*100,'fm9999999990.0000')||'%,质差用户数'||c.LTE_UU_CELL_004||',质差用户占比'||to_char(c.LTE_UU_CELL_004/c.LTE_UU_CELL_003*100,'fm9999999990.0000')||'%;'|| '切换成功率是'||to_char(d.LTE_X2_CELL_C_001*100,'fm9999999990.0000')||'%,质差用户数'||d.LTE_X2_CELL_004||',质差用户占比'||to_char(d.LTE_X2_CELL_004/d.LTE_X2_CELL_003*100,'fm9999999990.0000')||'%;' context from DX_SOC_RP_ALARM_DATA a left join gdsignal.F_LTE_UE_MR_CELL_H b on a.HOUR_ID=b.HOUR_ID and a.OBJECT_ID=b.ECELL_OID left join gdsignal.F_LTE_UU_CELL_H c on a.HOUR_ID=c.HOUR_ID and a.OBJECT_ID=c.ECELL_OID left join gdsignal.F_LTE_X2_CELL_H d on a.HOUR_ID=d.HOUR_ID and a.OBJECT_ID=d.ECELL_OID where a.OBJECT_TYPE='小区' and a.HOUR_ID>=? and a.HOUR_ID<= ?
2016-07-01 11:00:00,026 [schedulerFactoryBean_Worker-7] ERROR com.eastcom.soc.added.SocWeekInherit - startrun:org.springframework.da

o.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select HOUR_ID time, CITY city,ALARM_LEVEL alarmlevel, ALARM_TYPE alarmtype, OBJECT_TYPE objectType, OBJECT_NAME object, VALUE_CODE||OBJECT_TYPE indicateId ,VALUE_NAME temtitle,VALUE_NAME_0 indicate, VALUE_NAME_0||' '||to_char(VALUE_0,'fm9999999990.0000')||VALUE_UNIT_0||'; 阈值 '||VALUE_THRESHOLD||VALUE_UNIT_0||';'||VALUE_NAME_1||' '||to_char(VALUE_1,'fm9999999990.0000')||VALUE_UNIT_1||';' ||VALUE_NAME_2||' '||VALUE_2||VALUE_UNIT_2 context from DX_SOC_RP_ALARM_DATA where HOUR_ID>= ? and HOUR_ID< ? and OBJECT_TYPE!='小区' ]; OALL8 处于不一致状态; nested exception is java.sql.SQLException: OALL8 处于不一致状态







2016-07-01 13:50:21,381 [main] INFO com.eastcom.soc.added.SocWeekInherit - Server started!
2016-07-01 13:52:00,032 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - 初始化数据完成》》
2016-07-01 13:52:00,042 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - 开始解析:2016062900>>>>>>>2016062924段告警
2016-07-01 13:52:00,042 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - doSelect: false
2016-07-01 13:52:00,042 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - 解析入库:2016062900>>>>>>>2016062924段告警完成
2016-07-01 13:52:00,042 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - 开始对原始告警进行衍生处理》》
2016-07-01 13:52:06,667 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 开始入库
2016-07-01 13:52:06,671 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 参数:{recordId:=12674816;eventId:=SOC-LTE_SOC_ATTACH_C_003MME-INHERIT-ALARM;childEventId:=null;recordType:=1;occurTime:=Sun Jun 26 13:52:06 CST 2016;collectTime:=Sun Jun 26 13:52:06 CST 2016;startTime:=Fri Jul 01 13:52:06 CST 2016;lastTime:=Fri Jul 01 13:52:06 CST 2016;counts:=26;level:=2;facility:=1;title:=[周衍生告警]MME附着成功率;descr:=MME附着成功率 34.3750%; 阈值 50%; ;context:=上周(2016-06-24 00:00:00至2016-06-30 23:59:59)期间有2天产生[周衍生告警]MME附着成功率告警.
2016-06-25: MME附着成功率 34.3750%; 阈值 50%;
2016-06-27: MME附着成功率 18.6813%; 阈值 50%;
;keyValue:=佛山市ZJIMME205BZxLTE_SOC_ATTACH_C_003MME andMME;nmsAlarmId:=null;parentId:=0;inherit:=true;hasChildren:=false;inheritType:=0;sourceInfo:=null;deviceId:=ZJIMME205BZx;deviceName:=ZJIMME205BZx;deviceAlias:=LTE_SOC_ATTACH_C_003MME;ipaddress:=null;deviceDescr:=;deviceVendor:=null;deviceModel:=MME;service:=null;status:=null;status2:=;deviceProvince:=null;deviceCity:=佛山市;subId:=null;subName:=null;subAlias:=佛山市ZJIMME205BZxLTE_SOC_ATTACH_C_003MME andMME;subType:=0;resourceNmsStatus:=0;customerId:=null;customerName:=null;customerFullName:=null;customerCode:=null;customerLevel:=null;customerLogo:=nul

l;customerCity:=null;customerService:=null;customerNmsStatus:=0;productId:=null;productType:=null;productName:=null;productCode:=null;productInfo:=null;productDescr:=null;productStatus:=null;productLevel:=null;neType:=null;OperatorType:=0;}
2016-07-01 13:52:06,815 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - >>入库成功,RECORDID12725238
2016-07-01 13:52:06,815 [schedulerFactoryBean_Worker-0] INFO com.eastcom.database.impl.OracleDatabase4soc - ---------更新记录:12725238---------
2016-07-01 13:52:06,833 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12725238,childrecordId:12725242
2016-07-01 13:52:06,840 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12725238,childrecordId:12674816
2016-07-01 13:52:06,840 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - <<<衍生完成




2016-07-01 13:52:06,969 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 开始入库
2016-07-01 13:52:06,971 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 参数:{recordId:=12669035;eventId:=SOC-LTE_SOC_TCPSETUP_C_001天SGW-INHERIT-ALARM;childEventId:=null;recordType:=1;occurTime:=Sun Jun 26 13:52:06 CST 2016;collectTime:=Sun Jun 26 13:52:06 CST 2016;startTime:=Fri Jul 01 13:52:06 CST 2016;lastTime:=Fri Jul 01 13:52:06 CST 2016;counts:=1;level:=2;facility:=1;title:=[周衍生告警]TCP建立成功率(天);descr:=TCP建立成功率(天) 67.2798%; 阈值 70%;阀值 1GB;总流量 6782.49GB;context:=上周(2016-06-24 00:00:00至2016-06-30 23:59:59)期间有2天产生[周衍生告警]TCP建立成功率(天)告警.
2016-06-27: TCP建立成功率(天) 66.4832%; 阈值 70%;阀值 1GB;总流量 6872.7951GB
2016-06-24: TCP建立成功率(天) 67.2798%; 阈值 70%;阀值 1GB;总流量 6782.49GB
;keyValue:=佛山FOSSAEGW801BErLTE_SOC_TCPSETUP_C_001天SGW andSGW;nmsAlarmId:=null;parentId:=0;inherit:=true;hasChildren:=false;inheritType:=0;sourceInfo:=null;deviceId:=FOSSAEGW801BEr;deviceName:=FOSSAEGW801BEr;deviceAlias:=LTE_SOC_TCPSETUP_C_001天SGW;ipaddress:=null;deviceDescr:=;deviceVendor:=null;deviceModel:=SGW;service:=null;status:=null;status2:=;deviceProvince:=null;deviceCity:=佛山;subId:=null;subName:=null;subAlias:=佛山FOSSAEGW801BErLTE_SOC_TCPSETUP_C_001天SGW andSGW;subType:=0;resourceNmsStatus:=0;customerId:=null;customerName:=null;customerFullName:=null;customerCode:=null;customerLevel:=null;customerLogo:=null;customerCity:=null;customerService:=null;customerNmsStatus:=0;productId:=null;productType:=null;productName:=null;productCode:=null;productInfo:=null;productDescr:=null;productStatus:=null;productLevel:=null;neType:=null;OperatorType:=0;}
2016-07-01 13:52:07,047 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - >>入库成功,RECORDID12511057
2016-07-01 13:52:07,048 [schedulerFactoryBea

n_Worker-0] INFO com.eastcom.database.impl.OracleDatabase4soc - ---------更新记录:12511057---------
2016-07-01 13:52:07,060 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12511057,childrecordId:12725253
2016-07-01 13:52:07,067 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12511057,childrecordId:12669035
2016-07-01 13:52:07,067 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - <<<衍生完成


2016-07-01 13:52:07,203 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 开始入库
2016-07-01 13:52:07,204 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 参数:{recordId:=12658067;eventId:=SOC-LTE_SOC_ATTACH_C_003MME-INHERIT-ALARM;childEventId:=null;recordType:=1;occurTime:=Sun Jun 26 13:52:07 CST 2016;collectTime:=Sun Jun 26 13:52:07 CST 2016;startTime:=Fri Jul 01 13:52:07 CST 2016;lastTime:=Fri Jul 01 13:52:07 CST 2016;counts:=16;level:=2;facility:=1;title:=[周衍生告警]MME附着成功率;descr:=MME附着成功率 33.3333%; 阈值 50%; ;context:=上周(2016-06-24 00:00:00至2016-06-30 23:59:59)期间有2天产生[周衍生告警]MME附着成功率告警.
2016-06-27: MME附着成功率 10.9756%; 阈值 50%;
2016-06-24: MME附着成功率 33.3333%; 阈值 50%;
;keyValue:=佛山市SZHMME501BErLTE_SOC_ATTACH_C_003MME andMME;nmsAlarmId:=null;parentId:=0;inherit:=true;hasChildren:=false;inheritType:=0;sourceInfo:=null;deviceId:=SZHMME501BEr;deviceName:=SZHMME501BEr;deviceAlias:=LTE_SOC_ATTACH_C_003MME;ipaddress:=null;deviceDescr:=;deviceVendor:=null;deviceModel:=MME;service:=null;status:=null;status2:=;deviceProvince:=null;deviceCity:=佛山市;subId:=null;subName:=null;subAlias:=佛山市SZHMME501BErLTE_SOC_ATTACH_C_003MME andMME;subType:=0;resourceNmsStatus:=0;customerId:=null;customerName:=null;customerFullName:=null;customerCode:=null;customerLevel:=null;customerLogo:=null;customerCity:=null;customerService:=null;customerNmsStatus:=0;productId:=null;productType:=null;productName:=null;productCode:=null;productInfo:=null;productDescr:=null;productStatus:=null;productLevel:=null;neType:=null;OperatorType:=0;}
2016-07-01 13:52:07,253 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - >>入库成功,RECORDID12695117
2016-07-01 13:52:07,253 [schedulerFactoryBean_Worker-0] INFO com.eastcom.database.impl.OracleDatabase4soc - ---------更新记录:12695117---------
2016-07-01 13:52:07,265 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12695117,childrecordId:12725241
2016-07-01 13:52:07,272 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12695117,childrecordId:12658067
2016-07-01 13:52:07,273 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - <<<衍生完成
2016-07-01 13:52:07,402 [schedulerFactoryB

ean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 开始入库
2016-07-01 13:52:07,403 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 参数:{recordId:=12658069;eventId:=SOC-LTE_SOC_ATTACH_C_003MME-INHERIT-ALARM;childEventId:=null;recordType:=1;occurTime:=Sun Jun 26 13:52:07 CST 2016;collectTime:=Sun Jun 26 13:52:07 CST 2016;startTime:=Fri Jul 01 13:52:07 CST 2016;lastTime:=Fri Jul 01 13:52:07 CST 2016;counts:=16;level:=2;facility:=1;title:=[周衍生告警]MME附着成功率;descr:=MME附着成功率 28.3019%; 阈值 50%; ;context:=上周(2016-06-24 00:00:00至2016-06-30 23:59:59)期间有2天产生[周衍生告警]MME附着成功率告警.
2016-06-27: MME附着成功率 24.5509%; 阈值 50%;
2016-06-24: MME附着成功率 28.3019%; 阈值 50%;
;keyValue:=佛山市GZMME1603BErLTE_SOC_ATTACH_C_003MME andMME;nmsAlarmId:=null;parentId:=0;inherit:=true;hasChildren:=false;inheritType:=0;sourceInfo:=null;deviceId:=GZMME1603BEr;deviceName:=GZMME1603BEr;deviceAlias:=LTE_SOC_ATTACH_C_003MME;ipaddress:=null;deviceDescr:=;deviceVendor:=null;deviceModel:=MME;service:=null;status:=null;status2:=;deviceProvince:=null;deviceCity:=佛山市;subId:=null;subName:=null;subAlias:=佛山市GZMME1603BErLTE_SOC_ATTACH_C_003MME andMME;subType:=0;resourceNmsStatus:=0;customerId:=null;customerName:=null;customerFullName:=null;customerCode:=null;customerLevel:=null;customerLogo:=null;customerCity:=null;customerService:=null;customerNmsStatus:=0;productId:=null;productType:=null;productName:=null;productCode:=null;productInfo:=null;productDescr:=null;productStatus:=null;productLevel:=null;neType:=null;OperatorType:=0;}
2016-07-01 13:52:07,440 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - >>入库成功,RECORDID12698662
2016-07-01 13:52:07,449 [schedulerFactoryBean_Worker-0] INFO com.eastcom.database.impl.OracleDatabase4soc - ---------更新记录:12698662---------
2016-07-01 13:52:07,464 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12698662,childrecordId:12725244
2016-07-01 13:52:07,470 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12698662,childrecordId:12658069
2016-07-01 13:52:07,470 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - <<<衍生完成
2016-07-01 13:52:07,596 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 开始入库
2016-07-01 13:52:07,597 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 参数:{recordId:=12658068;eventId:=SOC-LTE_SOC_ATTACH_C_003MME-INHERIT-ALARM;childEventId:=null;recordType:=1;occurTime:=Sun Jun 26 13:52:07 CST 2016;collectTime:=Sun Jun 26 13:52:07 CST 2016;startTime:=Fri Jul 01 13:52:07 CST 2016;lastTime:=Fri Jul 01 13:52:07 CST 2016;counts:=13;level:=2;facility:=1;title:=[周衍生告警]MME附着成功率;descr:=MME附着成功率 18.36

73%; 阈值 50%; ;context:=上周(2016-06-24 00:00:00至2016-06-30 23:59:59)期间有2天产生[周衍生告警]MME附着成功率告警.
2016-06-27: MME附着成功率 18.7500%; 阈值 50%;
2016-06-24: MME附着成功率 18.3673%; 阈值 50%;
;keyValue:=佛山市SHTMME304BHwLTE_SOC_ATTACH_C_003MME andMME;nmsAlarmId:=null;parentId:=0;inherit:=true;hasChildren:=false;inheritType:=0;sourceInfo:=null;deviceId:=SHTMME304BHw;deviceName:=SHTMME304BHw;deviceAlias:=LTE_SOC_ATTACH_C_003MME;ipaddress:=null;deviceDescr:=;deviceVendor:=null;deviceModel:=MME;service:=null;status:=null;status2:=;deviceProvince:=null;deviceCity:=佛山市;subId:=null;subName:=null;subAlias:=佛山市SHTMME304BHwLTE_SOC_ATTACH_C_003MME andMME;subType:=0;resourceNmsStatus:=0;customerId:=null;customerName:=null;customerFullName:=null;customerCode:=null;customerLevel:=null;customerLogo:=null;customerCity:=null;customerService:=null;customerNmsStatus:=0;productId:=null;productType:=null;productName:=null;productCode:=null;productInfo:=null;productDescr:=null;productStatus:=null;productLevel:=null;neType:=null;OperatorType:=0;}
2016-07-01 13:52:07,637 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - >>入库成功,RECORDID12695070
2016-07-01 13:52:07,637 [schedulerFactoryBean_Worker-0] INFO com.eastcom.database.impl.OracleDatabase4soc - ---------更新记录:12695070---------
2016-07-01 13:52:07,650 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12695070,childrecordId:12725240
2016-07-01 13:52:07,656 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12695070,childrecordId:12658068
2016-07-01 13:52:07,656 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - <<<衍生完成
2016-07-01 13:52:07,787 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 开始入库
2016-07-01 13:52:07,788 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 参数:{recordId:=12682597;eventId:=SOC-SUCCESS_RATE_SP_GW-INHERIT-ALARM;childEventId:=null;recordType:=5;occurTime:=Sun Jun 26 13:52:07 CST 2016;collectTime:=Sun Jun 26 13:52:07 CST 2016;startTime:=Fri Jul 01 13:52:07 CST 2016;lastTime:=Fri Jul 01 13:52:07 CST 2016;counts:=2;level:=2;facility:=5;title:=[周衍生告警]下载响应成功率（剔除用户原因）;descr:=下载响应成功率（剔除用户原因） 51.7200%; 阈值 90%;流量 16600.2500KB;SP下载响应成功率 100%;context:=上周(2016-06-24 00:00:00至2016-06-30 23:59:59)期间有3天产生[周衍生告警]下载响应成功率（剔除用户原因）告警.
2016-06-26: 下载响应成功率（剔除用户原因） 77.7800%; 阈值 90%;流量 1026651.6250KB;SP下载响应成功率 100%
2016-06-25: 下载响应成功率（剔除用户原因） 51.7200%; 阈值 90%;流量 16600.2500KB;SP下载响应成功率 100%
2016-06-27: 下载响应成功率（剔除用

户原因） 58.8900%; 阈值 90%;流量 1308935.6250KB;SP下载响应成功率 98.8889%
;keyValue:=东莞QQ空间( https://www.360docs.net/doc/5e588697.html,,10.0.0.172)/DOGSAEGW201BHwSUCCESS_RATE_SP_GW andSP_GW;nmsAlarmId:=null;parentId:=0;inherit:=true;hasChildren:=false;inheritType:=0;sourceInfo:=null;deviceId:=QQ空间( https://www.360docs.net/doc/5e588697.html,,10.0.0.172)/DOGSAEGW201BHw;deviceName:=QQ空间( https://www.360docs.net/doc/5e588697.html,,10.0.0.172)/DOGSAEGW201BHw;deviceAlias:=SUCCESS_RATE_SP_GW;ipaddress:=null;deviceDescr:=;deviceVendor:=null;deviceModel:=SP_GW;service:=null;status:=null;status2:=;deviceProvince:=null;deviceCity:=东莞;subId:=null;subName:=SP_GW-QQ空间DOGSAEGW201BHw;subAlias:=东莞QQ空间( https://www.360docs.net/doc/5e588697.html,,10.0.0.172)/DOGSAEGW201BHwSUCCESS_RATE_SP_GW andSP_GW;subType:=0;resourceNmsStatus:=0;customerId:=null;customerName:=null;customerFullName:=null;customerCode:=null;customerLevel:=null;customerLogo:=null;customerCity:=null;customerService:=null;customerNmsStatus:=0;productId:=null;productType:=null;productName:=null;productCode:=null;productInfo:=null;productDescr:=null;productStatus:=null;productLevel:=null;neType:=null;OperatorType:=0;}
2016-07-01 13:52:07,866 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - >>入库成功,RECORDID12804030
2016-07-01 13:52:07,866 [schedulerFactoryBean_Worker-0] INFO com.eastcom.database.impl.OracleDatabase4soc - ---------新增记录:12804030---------
2016-07-01 13:52:07,889 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12804030,childrecordId:12725248
2016-07-01 13:52:07,902 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12804030,childrecordId:12711728
2016-07-01 13:52:07,917 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12804030,childrecordId:12682597
2016-07-01 13:52:07,917 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - <<<衍生完成
2016-07-01 13:52:08,069 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 开始入库
2016-07-01 13:52:08,071 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 参数:{recordId:=12711718;eventId:=SOC-LTE_SOC_ATTACH_C_003MME-INHERIT-ALARM;childEventId:=null;recordType:=1;occurTime:=Sun Jun 26 13:52:08 CST 2016;collectTime:=Sun Jun 26 13:52:08 CST 2016;startTime:=Fri Jul 01 13:52:08 CST 2016;lastTime:=Fri Jul 01 13:52:08 CST 2016;counts:=9;level:=2;facility:=1;title:=[周衍生告警]MME附着成功率;descr:=MME附着成功率 37%; 阈值 50%; ;context:=上周(2016-06-24 00:00:00至2016-06-30 23:59:59)期间有2天产生[周衍生告警]MME附着成功率告警.
2016-06-26: MME附着成功率 37%; 阈值 50%;
2016-06-27: MME附着成功率 43%; 阈值 50%;
;keyValue:=佛山市SHTMME101BHwLTE_SOC_ATTACH_C_003MME andMME;nmsAlarmId:=null;parentId:=0;inherit:=true;hasChildren:=false;inheritType:=0;sourceInfo:=null;deviceId:=SHTMME101BHw;deviceName:=S

HTMME101BHw;deviceAlias:=LTE_SOC_ATTACH_C_003MME;ipaddress:=null;deviceDescr:=;deviceVendor:=null;deviceModel:=MME;service:=null;status:=null;status2:=;deviceProvince:=null;deviceCity:=佛山市;subId:=null;subName:=null;subAlias:=佛山市SHTMME101BHwLTE_SOC_ATTACH_C_003MME andMME;subType:=0;resourceNmsStatus:=0;customerId:=null;customerName:=null;customerFullName:=null;customerCode:=null;customerLevel:=null;customerLogo:=null;customerCity:=null;customerService:=null;customerNmsStatus:=0;productId:=null;productType:=null;productName:=null;productCode:=null;productInfo:=null;productDescr:=null;productStatus:=null;productLevel:=null;neType:=null;OperatorType:=0;}
2016-07-01 13:52:08,125 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - >>入库成功,RECORDID12804031
2016-07-01 13:52:08,125 [schedulerFactoryBean_Worker-0] INFO com.eastcom.database.impl.OracleDatabase4soc - ---------新增记录:12804031---------
2016-07-01 13:52:08,142 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12804031,childrecordId:12725239
2016-07-01 13:52:08,150 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12804031,childrecordId:12711718
2016-07-01 13:52:08,150 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - <<<衍生完成
2016-07-01 13:52:08,313 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 开始入库
2016-07-01 13:52:08,314 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - 参数:{recordId:=12658070;eventId:=SOC-LTE_SOC_ATTACH_C_003MME-INHERIT-ALARM;childEventId:=null;recordType:=1;occurTime:=Sun Jun 26 13:52:08 CST 2016;collectTime:=Sun Jun 26 13:52:08 CST 2016;startTime:=Fri Jul 01 13:52:08 CST 2016;lastTime:=Fri Jul 01 13:52:08 CST 2016;counts:=16;level:=2;facility:=1;title:=[周衍生告警]MME附着成功率;descr:=MME附着成功率 34.4262%; 阈值 50%; ;context:=上周(2016-06-24 00:00:00至2016-06-30 23:59:59)期间有2天产生[周衍生告警]MME附着成功率告警.
2016-06-27: MME附着成功率 35.2381%; 阈值 50%;
2016-06-24: MME附着成功率 34.4262%; 阈值 50%;
;keyValue:=佛山市SHTMME201BHwLTE_SOC_ATTACH_C_003MME andMME;nmsAlarmId:=null;parentId:=0;inherit:=true;hasChildren:=false;inheritType:=0;sourceInfo:=null;deviceId:=SHTMME201BHw;deviceName:=SHTMME201BHw;deviceAlias:=LTE_SOC_ATTACH_C_003MME;ipaddress:=null;deviceDescr:=;deviceVendor:=null;deviceModel:=MME;service:=null;status:=null;status2:=;deviceProvince:=null;deviceCity:=佛山市;subId:=null;subName:=null;subAlias:=佛山市SHTMME201BHwLTE_SOC_ATTACH_C_003MME andMME;subType:=0;resourceNmsStatus:=0;customerId:=null;customerName:=null;customerFullName:=null;customerCode:=null;customerLevel:=null;customerLogo:=null;customerCity:=null;customerService:=null;customerNmsStatus:=0;productId:=null;productType:=null;productName:=null;productCode:=null;prod

uctInfo:=null;productDescr:=null;productStatus:=null;productLevel:=null;neType:=null;OperatorType:=0;}
2016-07-01 13:52:08,366 [schedulerFactoryBean_Worker-0] DEBUG com.eastcom.database.impl.OracleDatabase4soc - >>入库成功,RECORDID12695928
2016-07-01 13:52:08,367 [schedulerFactoryBean_Worker-0] INFO com.eastcom.database.impl.OracleDatabase4soc - ---------更新记录:12695928---------
2016-07-01 13:52:08,381 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12695928,childrecordId:12725243
2016-07-01 13:52:08,387 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - parentrecordId:12695928,childrecordId:12658070
2016-07-01 13:52:08,388 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - <<<衍生完成
2016-07-01 13:52:08,388 [schedulerFactoryBean_Worker-0] INFO com.eastcom.soc.added.SocWeekInherit - 本次衍生告警处理完成《《
^C
[ipnet@SOC-WEB01-VM log]$