{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["基站派单规则","基站关联规则","基站控制器派单规则","高铁派单规则","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"基站派单规则","index":0,"n_rows":148,"n_cols":11,"rows_kept":148,"cut":false,"hidden":false,"merged":[[108,9,113,9],[122,9,124,9],[129,9,131,9],[139,9,143,9],[2,8,25,8],[26,8,70,8],[71,8,78,8],[80,8,131,8],[132,8,143,8],[2,7,25,7],[26,7,70,7],[71,7,78,7],[80,7,131,7],[132,7,143,7],[135,3,136,3],[137,3,138,3],[139,3,143,3],[2,6,25,6],[26,6,70,6],[71,6,78,6],[80,6,131,6],[132,6,143,6],[73,3,74,3],[75,3,77,3],[98,3,113,3],[129,3,131,3],[132,3,133,3],[137,2,138,2],[139,2,143,2],[6,3,7,3],[8,3,11,3],[12,3,14,3],[15,3,16,3],[17,3,18,3],[19,3,20,3],[21,3,23,3],[27,3,28,3],[31,3,32,3],[33,3,34,3],[35,3,36,3],[38,3,40,3],[41,3,44,3],[45,3,69,3],[98,2,113,2],[114,2,128,2],[129,2,131,2],[132,2,134,2],[135,2,136,2],[37,2,44,2],[45,2,69,2],[73,2,74,2],[75,2,77,2],[79,2,97,2],[2,2,7,2],[8,2,16,2],[17,2,23,2],[26,2,30,2],[31,2,36,2],[2,1,25,1],[26,1,70,1],[71,1,78,1],[80,1,131,1],[132,1,143,1],[2,0,25,0],[26,0,70,0],[71,0,78,0],[79,0,131,0],[132,0,143,0]]}
["序号","派单规则名称","厂家","网络类型","告警号","告警名称","延迟时间","派单窗口期","处理时限","备注"]
[1,"大面积基站\n（30个以上基站退服）--新增20210902","全厂家","2/3/4/5G","2/3/4G厂家告警号为：\n\"7704\",\"7706\",\"21807\",\"7650\",\"7750\",\"40012\",\"198092068\",\"71058\",\"76504001\",\"198099803（3/4G）,\"\"9047\",\"198083023\",\"OAM_0017_00005\"\n华为5G厂家告警号为：\n\"29840\",\"301\"\n中兴5G厂家告警号为：\n\"200201014\",\"1014\"\n爱立信5G告警标题：网元链路断\n备注：工程告警不参与关联，[衍生告警]不参与关联。",null,"5min","24小时派单"]
[2,"基站退服类","华为","2G",21807,"OML故障告警","15min","06:00：00-23:59:59","8*60min"]
[null,null,null,"3G",22214,"NodeB不可用告警"]
[]
[null,null,null,"3G/4G",40012,"网元连接中断"]
[null,null,null,"5G",29840,"gNodeB退服告警"]
[{"$nulls":4},301,"网元连接中断"]
[null,null,"中兴","3G",198099803,"网元断链告警"]
[{"$nulls":4},198083023,"NodeB退服"]
[{"$nulls":4},199083023,"NodeB退服",null,null,null,"新增"]
[{"$nulls":4},198092068,"基站主电源断告警",null,null,null,"暂定"]
[null,null,null,"4G",198099803,"网元断链告警"]
[{"$nulls":4},198094833,"基站退出服务"]
[{"$nulls":4},198094422,"基站退出服务"]
[null,null,null,"5G",200201014,"gNodeB退服"]
[{"$nulls":4},1014,"网元链路断"]
[null,null,"诺西","2G",7704,"基站传输断"]
[{"$nulls":4},7706,"基站操作维护信令断"]
[null,null,null,"3G",7650,"BASE STATION FAULTY"]
[{"$nulls":4},7750,"FAILURE IN WCDMA WBTS O&M CONNECTION"]
[null,null,null,"4G",71058,"MRBTS基站O&M连接故障"]
[{"$nulls":4},76504001,"BASE STATION FAULTY"]
[{"$nulls":4},9047,"NE3SWS AGENT NOT RESPONDING TO REQUESTS",null,null,null,"（条件项取反）对告警正文进行模糊匹配 = java.net.SocketTimeoutException: Read timed out"]
[null,null,"贝尔","3G","OAM_0017_00005","loss of supervision"]
[null,null,"爱立信","5G",701,"网元链路断",null,null,null,"暂定"]
[3,"小区退服类","华为","2G",21801,"GSM小区退出服务告警","30min","06:00:00-23:59:59","12*60min"]
[null,null,null,"3G",22202,"UMTS小区不可用告警"]
[{"$nulls":4},28203,"本地小区不可用告警"]
[null,null,null,"4G",29240,"小区不可用告警"]
[null,null,null,"5G",29841,"NR小区不可用"]
[null,null,"中兴","3G",198083022,"小区退服"]
[{"$nulls":4},199083022,"小区退服"]
[null,null,null,"4G",198094419,"LTE小区退出服务"]
[{"$nulls":4},198094832,"LTE小区退出服务"]
[null,null,null,"5G",200201001,"DU小区退服"]
[{"$nulls":4},200201041,"基站DU退服"]
[null,null,"诺西","2G",7767,"广播信道丢失，掉小区"]
[null,null,null,"3G",7651,"BASE STATION OPERATION DEGRADED"]
[{"$nulls":4},7653,"CELL FAULTY"]
[{"$nulls":4},7771,"WCDMA CELL OUT OF USE"]
[null,null,null,"4G",76523030,"RP3光接口故障"]
[{"$nulls":4},76533030,"RP3光接口故障"]
[{"$nulls":4},711510,"RP3光接口故障",null,null,null,"新增"]
[{"$nulls":4},711610,"RP3光接口故障"]
[null,null,"贝尔","3G","BTS_0332_00054 ","检测到IP RAN以太网连接错误。",null,null,null,"？"]
[{"$nulls":4},"BTS_0306_00064","小区中断"]
[{"$nulls":4},"BTS_0314_00033","温高告警"]
[{"$nulls":4}," BTS_0306_00005 ","此报警表明CCM/iCCM和TRM/iTRM中层3链路之间的联系丢失"]
[{"$nulls":4}," BTS_0255_00005 ","DDM硬件告警"]
[{"$nulls":4}," BTS_0306_00047 ","此报警表明CCM/iCCM和RRH中层3链路的联系丢失"]
[{"$nulls":4}," BTS_0316_00047 ","到RRH的光连接未激活"]
[{"$nulls":4}," BTS_0341_00064 ","到TRDU的光连接未激活"]
[{"$nulls":4}," BTS_0201_00006 ","MCPA达到第二个温度门限90°C，停止工作。"]
[{"$nulls":4}," BTS_0338_00047 ","RRH的一个接收路径故障"]
[{"$nulls":4}," BTS_0229_00091 ","RRH 发射通道1 PA内部的增益控制环路工作不正常"]
[{"$nulls":4}," BTS_0306_00004 ","此报警表明CCM/iCCM和CCM/iCEM中层3链路之间的联系丢失"]
[{"$nulls":4}," BTS_0209_00007 ","DDM和TRM/iTRM间没有通信。"]
[{"$nulls":4}," BTS_0243_00033 ","不能监测DDM"]
[{"$nulls":4}," BTS_0001_00004 ","自测失败了，CEM/iCEM/xCEM在启动期间"]
[{"$nulls":4}," BTS_0207_00065 ","主集驻波比达到阈值3，与PA有关的是关闭的，因此，PA将无法指出结束的故障"]
[{"$nulls":4}," BTS_0306_00039 ","此报警表明CCM/iCCM和boraod中层3链路的联系丢失"]
[{"$nulls":4}," BTS_0404_00054 ","iBTS没收到RNC的heartbeat请求"]
[{"$nulls":4}," BTS_0229_00006 ","MCPA的增益控制环没有正常工作。"]
[{"$nulls":4}," BTS_0198_00103 ","RRH发射通道PA1模块内部的增益控制环路工作不正常"]
[{"$nulls":4}," BTS_0176_00091 ","有至少一个TX channelizer在以失败告终的RRH的HTRM上"]
[{"$nulls":4}," BTS_0215_00047 ","RRH模块硬件故障"]
[{"$nulls":4}," BTS_0345_00004 ","xCEM的OneChipPlus模块无法运行"]
[{"$nulls":4}," BTS_0274_00047 ","RRH的电源已经检测到一个交流电压故障"]
[{"$nulls":4}," BTS_0201_00064","温度已达到更高的阀值，TRDU_PA已关闭"]
[null,null,"爱立信","5G",356,"NR小区退服",null,null,null,"暂定"]
[4,"驻波类","华为","2G/3G/4G/5G",26529,"射频单元驻波告警","120min","07:00:00-19:00:00","48*60min"]
[null,null,"中兴","3G/4G/5G",198098465,"天馈驻波比异常"]
[null,null,"诺基亚","4G",76531837,"驻波比严重告警"]
[{"$nulls":4},71131837,"驻波比次要告警",null,null,null,"暂定"]
[null,null,"贝尔","3G"," BTS_0207_00008 ","主集驻波比超过门限3，DDM和天线之间的连接失败"]
[{"$nulls":4},"BTS_0207_00051 "]
[{"$nulls":4}," BTS_0207_00065 ","主集驻波比达到阈值3，与PA有关的是关闭的，因此，PA将无法指出结束的故障"]
[null,null,"爱立信","5G",315,"驻波比超过门限/VSWR Over Threshold",null,null,null,"暂定"]
[5,null,"华为","3G/4G/5G",26503,"射频单元光模块收发异常告警"]
[null,"光口类和硬件类",null,"3G/4G/5G",26504,"射频单元CPRI接口异常告警","30min","06:00:00-23:59:59","24*60min"]
[null,null,null,"3G/4G/5G",26235,"射频单元维护链路异常告警"]
[null,null,null,"3G/4G/5G",26231,"BBU CPRI光模块/电接口不在位告警"]
[null,null,null,"3G/4G/5G",26540,"射频单元交流掉电告警"]
[null,null,null,"3G/4G/5G",26110,"BBU风扇堵转告警"]
[null,null,null,"3G/4G/5G",25621,"直流输出异常告警",null,null,null,"新增","5G是否有此类告警？"]
[null,null,null,"3G/4G/5G",25622,"市电输入异常告警",null,null,null,"新增"]
[null,null,null,"3G/4G/5G",26112,"BBU直流输出异常告警",null,null,null,"新增"]
[null,null,null,"3G",28206,"本地小区能力下降告警"]
[null,null,null,"3G/4G",26214,"单板下电告警"]
[null,null,null,"4G",29213,"基站S1控制面传输中断告警",{"$nulls":4},"20210416修改"]
[null,null,null,"4G",26789,"RHUB交流掉电告警"]
[null,null,null,"3G/4G/5G",26200,"单板硬件故障告警"]
[null,null,null,"3G/4G/5G",26532,"射频单元硬件故障告警"]
[null,null,null,"3G/4G",26782,"RHUB光模块收发异常告警"]
[null,null,null,"3G/4G",26765,"RHUB硬件故障告警"]
[null,null,null,"3G/4G",26783,"RHUB CPRI接口异常告警"]
[null,null,null,"3G/4G",26507,"射频单元光模块故障告警"]
[null,null,"诺西","4G",76534072,"Parallel RP3"]
[{"$nulls":4},76553050,"Fan failure"]
[{"$nulls":4},76536253,"Cell configuration data distribution failed"]
[{"$nulls":4},71162004,"光路告警"]
[{"$nulls":4},71161910,"射频模块故障"]
[{"$nulls":4},76533020,"基带总线故障"]
[{"$nulls":4},71154003,"Transmission path failure"]
[{"$nulls":4},71131957,"射频天线故障"]
[{"$nulls":4},76566308,"BASE STATION VITY LOST,S1 interface setup failure",{"$nulls":4},"20210416新增"]
[{"$nulls":4},71161927,"射频模块高温告警"]
[{"$nulls":4},76534090,"Cell power failure",null,null,null,"省内无3G派单"]
[{"$nulls":4},76523050,"风扇故障"]
[{"$nulls":4},76523040,"温度告警"]
[{"$nulls":4},76533010,"射频模块故障"]
[{"$nulls":4},76554057,"射频发射或接收通道异常"]
[{"$nulls":4},71162002,"Failure in optical interface的子类告警"]
[null,null,"中兴","3G/4G/5G",198097605,"RRU链路断"]
[null,null,null,"3G/4G",198092057,"单板电源关断",null,null,null,"4G新增"]
[null,null,null,"3G",198097060,"单板通讯链路断"]
[null,null,null,"3G/4G",198092069,"FCE风扇故障",null,null,null,"4G新增"]
[null,null,null,"4G",198094830,"S1断链告警"]
[null,null,null,"3G/4G/5G",198098440,"PA去使能",null,null,null,"5G新增"]
[null,null,null,"3G/4G/5G",198097004,"单板硬件故障"]
[null,null,null,"3G/4G/5G",198092265,"主用电源输入断电告警",null,null,null,"是否存在5G？，4/5G新增"]
[null,null,null,"3G/4G/5G",198092053,"输入电压异常",null,null,null,"是否存在5G？"]
[null,null,null,"3G/4G/5G",198098466,"温度异常",{"$nulls":4},"新增4G"]
[null,null,null,"3G/4G/5G",198097061,"温度异常",{"$nulls":4},"新增4G"]
[null,null,null,"3G/4G/5G",198092363,"主用电源故障告警",{"$nulls":4},"新增4G"]
[null,null,null,"4G",198092295,"设备掉电"]
[null,null,null,"3G/4G/5G",198098111,"风扇故障",{"$nulls":4},"新增4G"]
[null,null,null,"3G/4G/5G",198098319,"光口链路故障",{"$nulls":4},"新增4G"]
[null,null,"爱立信","5G",315,"RHUB链路断",null,null,null,"暂定"]
[{"$nulls":4},315,"硬件故障"]
[{"$nulls":4},106,"供电故障"]
[6,"时钟类","华为","5G",26532,"射频单元硬件故障","30min","06:00:00-23:59:59","48*60min"]
[{"$nulls":4},26262,"时钟参考源异常"]
[null,null,null,"3G/4G/5G",26260,"系统时钟不可用",null,null,null,"新增"]
[null,null,"诺西","4G",7652]
[{"$nulls":4},7115]
[null,null,"中兴","5G",198096837,"GNSS接收机搜星故障"]
[{"$nulls":4},198096836,"GNSS天馈链路故障"]
[null,null,"爱立信","5G",506,"时钟引用失败/TimeSyncIO Reference Failed",null,null,null,"暂定"]
[{"$nulls":4},356,"日历时钟所有的NTP服务器失联/Calendar Clock All NTP Servers Unavailable"]
[{"$nulls":4},356,"日历时钟失联/Calendar Clock Misaligned"]
[{"$nulls":4},14,"日历时钟NTP服务器不可用/Calendar Clock NTP Server Unavailable"]
[{"$nulls":4},506,"时钟引用长时间丢失/Clock Reference Missing For Long Time"]
["备注："]
["1、考虑2G基站故障取消，不做设置，跟踪SDR  4G状态"]
["2、派单窗口期以外发的的故障，如果到达派单时间的时候未恢复，所有派单告警打包到一张工单中派发。"]
["3、基站下挂小区全部退服衍生为基站退服。"]

{"sheet":"基站关联规则","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"基站控制器派单规则","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"高铁派单规则","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":4,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,8,0],[9,0,17,0]]}
["网络类型","告警标题","告警厂家","退服类型","厂家告警号","是否送DOP"]
["5G","Service Unavailable","爱立信","小区退服（NR小区不可用）",356,"已送"]
[null,"Heartbeat Failure","爱立信","基站退服（网元链路断）",701,"已送"]
[null,"NR小区不可用告警","华为","小区退服",29841,"已送"]
[null,"gNodeB退服告警","华为","基站退服",29840,"未送"]
[null,"网元连接中断","华为","基站退服",40012,"已送"]
[null,"NR分布单元小区不可用告警","华为","小区退服",29844,"未送"]
[null,"DU小区退服","中兴","小区退服",200201001,"未送"]
[null,"网元链路断","中兴","基站退服",1014,"已送"]
["4G","小区不可用告警","华为","小区退服",29240,"已送"]
[null,"LTE小区退出服务","中兴","小区退服",198094419,"已送"]
[null,"NE3SWS AGENT NOT RESPONDING TO REQUESTS","诺基亚","基站退服",9047,"已送"]
[null,"网元断链告警","中兴","基站退服",198099803,"已送"]
[null,"基站退出服务","中兴","基站退服",198094422,"未送"]
[null,"网元连接中断","华为","基站退服",40012,"已送"]
[null,"CELL FAULTY","诺基亚","小区退服",711610,"已送"]
[null,"Service Unavailable","爱立信","小区退服（NR小区不可用）",356,"已送"]
[null,"Heartbeat Failure","爱立信","基站退服（网元链路断）",701,"已送"]
["3G","NodeB退服","中兴","小区退服","198083023/199083023"]