1 DEFINE{ query_name 'base_mod_req_failure_distribution';
2 max_lfta_disorder '1'; max_hfta_disorder '1';
3 comment 'distribution of causes of a modification request failure (base)';
6 select tb, gnb_id as GNB_ID,
7 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID,
9 sum( EQ(failureType,0) ) as count_protobuf_unspecified,
10 sum( EQ(failureType,1) ) as count_t310_Expiry,
11 sum( EQ(failureType,2) ) as count_randomAccessProblem,
12 sum( EQ(failureType,3) ) as count_rlc_MaxNumRetx,
13 sum( EQ(failureType,4) ) as count_synchReconfigFailure_SCG,
14 sum( EQ(failureType,5) ) as count_scg_reconfigFailure,
15 sum( EQ(failureType,6) ) as count_srb3_IntegrityFailure
16 From SGNBMODREQ.sgnb_mod_req
17 group by timestamp_ms/$window as tb, gnb_id,
18 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID
21 DEFINE{ query_name 'mod_req_failure_distribution';
22 max_lfta_disorder '1'; max_hfta_disorder '1';
23 comment 'distribution of causes of a modification request failure';
26 select ($window*(tb+1))/1000 as TS, GNB_ID,
27 $window/1000.0 as measurementInterval,
29 sum( count_protobuf_unspecified ) as count_protobuf_unspecified,
30 sum( count_t310_Expiry ) as count_t310_Expiry,
31 sum( count_randomAccessProblem ) as count_randomAccessProblem,
32 sum( count_rlc_MaxNumRetx ) as count_rlc_MaxNumRetx,
33 sum( count_synchReconfigFailure_SCG ) as count_synchReconfigFailure_SCG,
34 sum( count_scg_reconfigFailure ) as count_scg_reconfigFailure,
35 sum( count_srb3_IntegrityFailure ) as count_srb3_IntegrityFailure
36 From base_mod_req_failure_distribution
40 DEFINE{ query_name 'base_mod_req_failure_distribution_gtp_teid';
41 max_lfta_disorder '1'; max_hfta_disorder '1';
42 comment 'distribution of causes of a modification request failure (bas), labeled with gtp_teid';
45 select b.tb, b.GNB_ID as GNB_ID, m.gTP_TEID,
47 b.count_protobuf_unspecified,
49 b.count_randomAccessProblem,
50 b.count_rlc_MaxNumRetx,
51 b.count_synchReconfigFailure_SCG,
52 b.count_scg_reconfigFailure,
53 b.count_srb3_IntegrityFailure
54 LEFT_OUTER_JOIN from base_mod_req_failure_distribution b, gnb_ueid_teid_map m
55 where b.tb=m.TB and b.GNB_ID=m.GNB_ID and
56 b.id_MeNB_UE_X2AP_ID=m.id_MeNB_UE_X2AP_ID
59 DEFINE{ query_name 'mod_req_failure_distribution_gtp_teid';
60 max_lfta_disorder '1'; max_hfta_disorder '1';
61 comment 'distribution of causes of a modification request failure';
64 select ($window*(tb+1))/1000 as TS, GNB_ID, gTP_TEID,
65 $window/1000.0 as measurementInterval,
67 sum( count_protobuf_unspecified ) as count_protobuf_unspecified,
68 sum( count_t310_Expiry ) as count_t310_Expiry,
69 sum( count_randomAccessProblem ) as count_randomAccessProblem,
70 sum( count_rlc_MaxNumRetx ) as count_rlc_MaxNumRetx,
71 sum( count_synchReconfigFailure_SCG ) as count_synchReconfigFailure_SCG,
72 sum( count_scg_reconfigFailure ) as count_scg_reconfigFailure,
73 sum( count_srb3_IntegrityFailure ) as count_srb3_IntegrityFailure
74 From base_mod_req_failure_distribution_gtp_teid
75 group by tb, GNB_ID, gTP_TEID
78 DEFINE{ query_name 'base_mod_req_failure_distribution_pci';
79 max_lfta_disorder '1'; max_hfta_disorder '1';
80 comment 'distribution of causes of a modification request failure (bas), labeled with gtp_teid';
83 select b.tb, b.GNB_ID as GNB_ID, m.physCellId,
85 b.count_protobuf_unspecified,
87 b.count_randomAccessProblem,
88 b.count_rlc_MaxNumRetx,
89 b.count_synchReconfigFailure_SCG,
90 b.count_scg_reconfigFailure,
91 b.count_srb3_IntegrityFailure
92 LEFT_OUTER_JOIN from base_mod_req_failure_distribution b, gnb_ueid_cellid_map m
93 where b.tb=m.TB and b.GNB_ID=m.GNB_ID and
94 b.id_MeNB_UE_X2AP_ID=m.id_MeNB_UE_X2AP_ID
97 DEFINE{ query_name 'mod_req_failure_distribution_pci';
98 max_lfta_disorder '1'; max_hfta_disorder '1';
99 comment 'distribution of causes of a modification request failure';
102 select ($window*(tb+1))/1000 as TS, GNB_ID, physCellId,
103 $window/1000.0 as measurementInterval,
105 sum( count_protobuf_unspecified ) as count_protobuf_unspecified,
106 sum( count_t310_Expiry ) as count_t310_Expiry,
107 sum( count_randomAccessProblem ) as count_randomAccessProblem,
108 sum( count_rlc_MaxNumRetx ) as count_rlc_MaxNumRetx,
109 sum( count_synchReconfigFailure_SCG ) as count_synchReconfigFailure_SCG,
110 sum( count_scg_reconfigFailure ) as count_scg_reconfigFailure,
111 sum( count_srb3_IntegrityFailure ) as count_srb3_IntegrityFailure
112 From base_mod_req_failure_distribution_pci
113 group by tb, GNB_ID, physCellId