Abnormal TCH congestion in E******* BSC

[luganomu]

Please if you could Hellp the probable reasons , cells in BCS having abnormal congestion (TCH congestion with enough capacity).
Attched is a sample of cells

No any PGW issue and Utilization


BR

[shahram]

hi,see the hourly statistics instead of daily values,maybe congestion is happening in peak hour only and averaging the traffic will hide the peak of traffic so it will shown below capacity of the cell
also check the GPRS/EDGE traffic of your cell,if it is high and your setting is not allowing TBF preemption it will cause congestion
also check transcoder utilization

good luck

[luganomu]

Thanks

But this is busy hour statistics sir! trapool is ok

We are using packet abis in our BSCs and now the issue affect more than one BSC! can it be a cause if packet abis is not working propery some where?


Rgds

[luganomu]

Any feedback team?

[rfworld]

Can you share the BO Template?

[luganomu]

rfworld

What is BO? so i can send.

Br

[rfworld]

rfworld

What is BO? so i can send.

Br

by BO i mean Business Object. you must be using BO to generate the Traffic Report attached. how you generate the attached report?

[luganomu]

rfworld


SELECT *

FROM

(

SELECT DATETIME, TRUNC(DATETIME,'DD') AS "DATE",BSC, CELL
,TNUCHCNT AS NO_TS_Def
,CNUCHCNT AS NO_SDCCH_Def
,DIV(CAVAACC,CAVASCAN) AS No_SDCCH_Avail
,DIV(TAVAACC,TAVASCAN) AS No_TS_Avail
,TNUCHCNT - DIV(TAVAACC,TAVASCAN) AS No_TS_Var
,CCALLS-CMSESTAB AS SD_FAIL
,CNDROP-CNRELCONG AS CNDROP_NTC
,TFNDROP+THNDROP AS TNDROP
,CNDROP --AS CNDROP
,CMSESTAB --AS CMSESTAB
,CCALLS -- AS CCALLS
,TCASSALL --TFCASSALL+THCASSALL AS TCASSALL
,TASSALL --AS TASSALL
,TFNRELCONG+THNRELCONG+CNRELCONG AS TCONG
--,TASSALL AS TCONG_DENOM
,CCONGS -- AS CCONGS
--,CCALLS AS SCONG_DENOM
--,CMSESTAB AS SDR_DENOM
,ROUND(AIRCOM.DIV(TFTRALACC,TFNSCAN)+AIRCOM.DIV(THTRALACC,THNSCAN),2) AS T_TRAF
,ROUND(AIRCOM.DIV(CTRALACC,CNSCAN),2) AS S_TRAF
,ROUND(100*AIRCOM.DIV(TFNDROP+THNDROP,TCASSALL),2) AS TCH_DROP
,ROUND(100*AIRCOM.DIV(CNDROP-CNRELCONG,CMSESTAB),2) AS SDCCH_DROP
,ROUND(100*AIRCOM.DIV(CMSESTAB,CCALLS),2) AS SDCCH_ACC
,ROUND(100*AIRCOM.DIV(TCASSALL,TASSALL),2) AS TCH_ACC
,ROUND(100*(1-AIRCOM.DIV(TFNDROP+THNDROP,TCASSALL))*(1-AIRCOM.DIV(CNDROP-CNRELCONG,CMSESTAB))*
AIRCOM.DIV(CMSESTAB,CCALLS)*AIRCOM.DIV(TCASSALL,TASSALL),2) AS CSR
,ROUND(100*AIRCOM.DIV(CNRELCONG+TFNRELCONG+THNRELCONG,TASSALL),2) AS TCH_CONG
,ROUND(100*AIRCOM.DIV(CCONGS,CCALLS),2) AS SDCCH_CONG
,CNRELCONG AS CNRELCONG --, TCHSIG, SUMIHOSUCC
--,CDISQA, CDISSS, CDISTA, CNDROP-(CDISQA-CDISSS-CDISTA) AS CDISOTH
--,ROW_NUMBER() OVER (PARTITION BY TRUNC(DATETIME,'dd'),BSC, CELL ORDER BY ((AIRCOM.DIV(TFTRALACC,TFNSCAN)
--+ AIRCOM.DIV(THTRALACC,THNSCAN))) DESC NULLS LAST) RANK
,ROUND(AIRCOM.DIV(TDWNACC,TDWNSCAN)*100,2) AS T_DWN
,ROUND(100*AIRCOM.DIV(TAVAACC,(TAVASCAN*TNUCHCNT))) AS T_AVAIL
,ROUND(100*AIRCOM.DIV(CAVAACC,(CAVASCAN*CNUCHCNT))) AS S_AVAIL
,60*60*AIRCOM.DIV(AIRCOM.DIV(TFTRALACC,TFNSCAN)+AIRCOM.DIV(THTRALACC,THNSCAN),TFMSESTB+THMSESTB) AS TCH_MHT
,60*60*AIRCOM.DIV(AIRCOM.DIV(CTRALACC,CNSCAN),CMSESTAB) AS SDCCH_MHT
-- ,(TFDISSUL + THDISSUL) AS TCH_Drop_UL_SS --(TFDISSSUL + THDISSUL) AS TCH_Drop_UL_SS
,(TFDISSDL + THDISSDL) AS TCH_Drop_DL_SS --(TFDISSSDL + THDISSDL) AS TCH_Drop_DL_SS
,(TFDISSBL + THDISSBL) AS TCH_Drop_BL_SS
,(TFDISQAUL + THDISQAUL) AS TCH_Drop_UL_Qual
,(TFDISQADL + THDISQADL) AS TCH_Drop_DL_Qual
,(TFDISQABL + THDISQABL) AS TCH_Drop_BL_Qual
,(TFDISTA + THDISTA) AS TCH_Drop_TA
,(TFSUDLOS + THSUDLOS) AS TCH_Drop_SuddenLoss
,100 * DIV(CMSESTAB,CCALLS) AS SDCCH_Acc_Rate
--,CNDROP AS SDCCH_Drop
--,100*DIV(CNDROP,CMSESTAB) AS SDCCH_Drop_Rate
--,CCONGS AS SDCCH_Att_Congested
,CDISSS AS SDCCH_Drop_SS
,CDISQA AS SDCCH_Drop_Qual
,CDISTA AS SDCCH_Drop_TA
,CNDROP - (CDISSS + CDISQA + CDISTA) AS SDCCH_Drop_Other
--,DIV(CTRALACC,CNSCAN) AS SDCCH_Traff
--,100 * DIV(CCONGS,CCALLS) AS SDCCH_Cong_Rate
--,DIV((60 * CTRALACC * 60),( CNSCAN * CMSESTAB )) AS SDCCH_MHT
,100 * DIV(CMSESTAB,(CCALLS - CCONGS)) AS SDCCH_Acc_Rate_WO_Cong
--,(CNDROP - CNRELCONG) AS SDCCH_Drop_WO_Cong
--,100 * DIV((CNDROP - CNRELCONG),CMSESTAB) AS SDCCH_Drop_Rate_WO_Cong
,ROW_NUMBER() OVER (PARTITION BY TRUNC(DATETIME,'dd'),"BSC", CELL ORDER BY ((AIRCOM.DIV(TFTRALACC,TFNSCAN)+AIRCOM.DIV(THTRALACC,THNSCAN)))
DESC NULLS LAST) RANK
--FROM E*******_BSS.CELLSTATS_BHDY --CELL BH
FROM E*******_BSS.CELLSTATS

WHERE DATETIME BETWEEN TRUNC(SYSDATE,'DD')-1 AND TRUNC(SYSDATE, 'DD')-1/1440
--where datetime between to_date('17/10/2011 00:00','dd/mm/yyyy hh24:mi') and to_date('31/10/2011 23:59','dd/mm/yyyy hh24:mi')
--WHERE DATETIME >= SYSDATE-2
--WHERE DATETIME BETWEEN '01-NOV-2008' AND 'NOV'
--AND BSC<>'MP1001'
--AND (CELL LIKE '%DA%' OR CELL LIKE '%BGO%' OR CELL LIKE '%ZA%' OR CELL LIKE '%PBA%' OR CELL LIKE '%MOR%' OR CELL LIKE '%LND%' OR CELL LIKE '%MTR%')
--AND( BSC LIKE '%DABSC10%' OR BSC LIKE '%LDBSC01%')
--WHERE DATETIME >= '28-Nov-2007'
--AND (CELL LIKE '%MBY006A%' OR CELL LIKE '%MBY006B%' OR CELL LIKE '%MBY006C%')
--AND (BSC LIKE '%ARBSC02%' OR BSC LIKE '%DABSC10%')
AND ((BSC LIKE '%ARBSC01%' OR BSC LIKE '%ARBSC02%')
OR (BSC LIKE '%DABSC12%' OR BSC LIKE '%DABSC13%')
OR (BSC LIKE '%DABSC14%' OR BSC LIKE '%DABSC15%' OR BSC LIKE '%DABSC16%')
OR (BSC LIKE '%DABSC08%' OR BSC LIKE '%DABSC09%')
OR (BSC LIKE '%DABSC02%' OR BSC LIKE '%DABSC04%')
OR (BSC LIKE '%DABSC06%' OR BSC LIKE '%DABSC07%')
OR (BSC LIKE '%DOBSC02%' OR BSC LIKE '%MBBSC01%')
OR (BSC LIKE '%TGBSC01%' OR BSC LIKE '%TGBSC02%' OR BSC LIKE '%ZNBSC01%')
OR (BSC LIKE '%LDBSC01%' OR BSC LIKE '%MBBSC02%')
OR (BSC LIKE '%DABSC10%' OR BSC LIKE '%DABSC11%')
OR (BSC LIKE '%MOBSC01%' OR BSC LIKE '%MOBSC02%')
OR (BSC LIKE '%DABSC17%' OR BSC LIKE '%DABSC18%'))
ORDER BY "DATE" DESC
)

WHERE RANK = 1

ORDER BY "DATE" DESC