mc-core/mc/queries/mod_req_failure.gsql

   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)';
   4 }
   5 PARAM{ window uint;}
   6 select tb, gnb_id as GNB_ID,
   7         id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID,
   8         count(*) as cnt,
   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
  19 ;
  20
  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';
  24 }
  25 PARAM{ window uint;}
  26 select ($window*(tb+1))/1000 as TS, GNB_ID,
  27         $window/1000.0 as measurementInterval,
  28         sum(cnt) as cnt,
  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
  37 group by tb, GNB_ID
  38 ;
  39
  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';
  43 }
  44 PARAM{ window uint;}
  45 select b.tb, b.GNB_ID as GNB_ID, m.gTP_TEID,
  46         b.cnt,
  47         b.count_protobuf_unspecified,
  48         b.count_t310_Expiry,
  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
  57 ;
  58
  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';
  62 }
  63 PARAM{ window uint;}
  64 select ($window*(tb+1))/1000 as TS, GNB_ID, gTP_TEID,
  65         $window/1000.0 as measurementInterval,
  66         sum(cnt) as cnt,
  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
  76 ;
  77
  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';
  81 }
  82 PARAM{ window uint;}
  83 select b.tb, b.GNB_ID as GNB_ID, m.physCellId,
  84         b.cnt,
  85         b.count_protobuf_unspecified,
  86         b.count_t310_Expiry,
  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
  95 ;
  96
  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';
 100 }
 101 PARAM{ window uint;}
 102 select ($window*(tb+1))/1000 as TS, GNB_ID, physCellId,
 103         $window/1000.0 as measurementInterval,
 104         sum(cnt) as cnt,
 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
 114
 115