CN101431768A - Single-pass fault distinguishing method - Google Patents

Abstract

This invention refers to a judging method of single-pass default, which extracts a terminative MTC ultra-short ticket of charge gateway ticket business platform, then mergers an original ticket cdr*.txt file so as to form a single file cdr.txt, transfers an analyzing program to analyze cdr.txt and generate a database file cdr.sql, and uses sqlplus to execute cdr.sql, inputs cdr data to a database blank, check the important information result via SQL sentences, extracts an A opening circuit CIC intensively distributed bases on the checked result to perform the test of taking circuit, or based on a cover sub-area (LAIGCI) intensively distributed to test, in order to find the circuit having the single-pass default or the cover sub-area to process. This method can effectively solve the single-pass problem, and the developing personnel does not need to have the very special number 7 signaling research, without processing the extra hardware platform development, researching the extra signal isolating device development and costing expensive research cost.

Description

A kind of single-pass fault distinguishing method

Technical field

The present invention relates to the core network technology field, particularly a kind of single-pass fault distinguishing method.

Technical background

" single-pass " fault mostly occurs in the network adjustment, the circuit cutover, after the network capacity extension, the voice single-channel fault is one of common faults in the communication system, its appearance has had a strong impact on the running quality of whole network, and to user satisfaction index influence greatly, " single-pass " often shows as when fault occurs can not normal talking, but wanting regular fee, is one of focus of customer complaint.Along with mobile network's expansion gradually, the quick increase of number of users, the frequency that this type of fault occurs is also in rising trend.Located this type of fault in the past and had following point: need carry out one by one test calls to every repeat circuit, complexity is set, each office direction is reset, testing point is many, the attendant of counties and cities cooperates substantive test etc.Therefore, how to differentiate " single-pass " fault fast, reduce the influence that this type of fault produces, for the current mobile communication system that increases fast, seem very crucial.

For this reason, the technology that detects " single-pass " fault has occurred, as being to disclose a kind of method by analysis circuit duration of call testing circuit single-pass in the Chinese patent application file of " 200510102558.1 " at one piece of application number, it comprises the steps: from No. 7 signaling network to obtain link signal; The data that get access to are analyzed, extracted the characteristic value and the synthetic call detail record of signaling according to different agreement with unique identification repeat circuit information; To call detail record synthetic in the certain hour scope, add up total talk times on each bar circuit and less than the talk times of default duration of call threshold value; Judge each bar circuit successively, exceed certain thresholding, determine that then this circuit is the single-pass circuit if exceed certain thresholding or account for total talk times ratio less than the talk times of default duration of call threshold value less than the talk times of default duration of call threshold value; With total talk times of the single-pass circuit determined, notify the user less than the talk times information of default duration of call threshold value.Should there be following defective by " single-pass " fault detection technique: 1, need at length resolve the various frame structures of signalling system No.7, must spend the research of suitable time and specialty.2, need research and development hardware acquisition platform with the message of extracting these signalings and reassemble into complete Message Record.3, consider influence to the existing network signaling, need exploitation spacer assembly in addition, external signal is to the influence of existing network when preventing to gather.4, the cost height of whole device is at present based on the instrument market price of this type of technological development at least more than several ten thousand yuan.Therefore the scope of application is restricted, and can not effectively solve " single-pass " problem.

Summary of the invention

The purpose of this invention is to provide a kind of single-pass fault distinguishing method, this method can not only solve " single-pass " problem effectively, and the developer be need not to possess very professional signalling system No.7 research, need not to carry out extra hardware platform exploitation, need not extra signal isolating device research and development, need not to spend valuable R﹠D costs.

Method of the present invention is achieved in that and may further comprise the steps: step 1, login soft switchcall server charging gateway CDR console, the format of billing that Original CDR is set is termination ticket MTC, the duration that ticket is set is less than some seconds, the cdr*.txt text of the Original CDR that derivation satisfies condition comprises following important information in this cdr*.txt file: the calling number of Extra-short-conversation-time bills, called number, conversation time started, end of conversation time, home base station controller BSC, cic circuit identification code CIC, base station coverage cell LAIGCI; Step 2, Original CDR cdr*.txt text is carried out merger, form single file cdr.txt; Step 3, call analysis program and resolve cdr.txt, and generate database file cdr.sql, described analysis program is a development sequence, and its workflow is as follows: initialization; Searching comprises the row of CDR character string; With symbol "=" is separator registration cdr logging field value, and each field name and field value are circulated, up to the cdr logging result; Print insert warehouse-in sql one by one; Judge whether field is handled, if yes, then withdraw from cyclic program, and spanned file, if not, then jump to " row that searching comprises the CDR character string " this step and continue and down carry out; Step 4, utilization sqlplus carry out cdr.sql, and the cdr data are input in the database table; Step 5, carry out the important information result queries by SQL statement, extract the A mouth circuit CIC that concentrates that distributes based on Query Result and account for circuit test, the coverage cell of perhaps distribute concentrating (LAIGCI) is tested, comprise to every repeat circuit carry out one by one test calls, complexity be set, each office direction is reset, testing point is many, the attendant of counties and cities cooperates substantive test etc.

Method of the present invention is simple, realize easily, can not only solve " single-pass " problem effectively, and the developer be need not to possess very professional signalling system No.7 research, need not to carry out extra hardware platform exploitation, need not extra signal isolating device research and development, need not to spend valuable R﹠D costs.

Description of drawings

Fig. 1 is the step schematic diagram of method of the present invention.

Fig. 2 is the schematic flow sheet of analysis program of the present invention.

Embodiment

Below, in conjunction with the accompanying drawings specific embodiments of the invention are further elaborated.

As shown in Figure 1, method of the present invention may further comprise the steps: step 1, the login G9 of Huawei soft switchcall server charging gateway CDR console, the format of billing that Original CDR is set is termination ticket MTC, the duration that ticket is set is less than some seconds (as less than 3 seconds), the cdr*.txt text of the Original CDR that derivation satisfies condition comprises following important information: the calling number of Extra-short-conversation-time bills in this cdr*.txt file, called number, the conversation time started, the end of conversation time, home base station controller BSC, cic circuit identification code CIC, base station coverage cell LAIGCI.As follows:

callingNumber?＝?13101852233

calledNumber ＝?13860336610

initial?time ＝?2008-07-21?00:09:00

end?time?＝?2008-07-21?00:09:03

mscOutgoingROUTE_ROUTEName?＝?NDEGM1061-BSC30608

mscOutgoingCircuit?＝?449

called_location_LAI?＝?64?F0?00?60?34

called_location_cellID?＝?4E?57

The cdr*.txt of step 2, above-mentioned derivation is pure text, and it is too many to comprise information among every CDR, find the important information that satisfies condition very difficult, therefore the Extra-short-conversation-time bills text program of developing that need these are original is handled, at first under unix environment, Original CDR cdr*.txt text is carried out merger, form single file cdr.txt.Call analysis program cdr.awk then and resolve cdr.txt, under unix environment, fill order: awk-f cdr.awkcdr.txt cdr.sql obtains the cdr.sql file after resolving, analysis program is a development sequence, its workflow is as follows: initialization; Searching comprises the row of CDR character string; With symbol "=" is separator registration cdr logging field value, and each field name and field value are circulated, up to the cdr logging result; Print insert warehouse-in sql one by one; Judge whether field is handled, if yes, then withdraw from cyclic program, and spanned file, if not, then jumping to " row that searching comprises the CDR character string " this step and continue and down carry out, its source program is as follows:

BEGIN{

FS＝″＝″

printf(″truncate?table?cm_cdr_manual；\n″)

}

/CDR/{

fieldList＝″CDR″

gsub(″CDR″，″″，$0)

fieldVal＝trim($0)

cnt＝1

while(NF＝＝1)

{ getline }

while(NF！＝1)

{

field＝trim($1)

gsub(″″，″_″，field)

if(field＝＝″size″)

{

field＝″sizes″

}else?if?(field~/ServiceCode/)

{

field＝″ServiceCode″

}else?if(field~/CUGInterlockCode/)

{

field＝″CUGInterlockCode″

}

cnt++

if(cnt％50＝＝0)

{

fieldList＝sprintf(″％s，\n％s″，fieldList，field)

fieldVal＝sprintf(″％s，\n’％s’″，fieldVal，trim($2))

}

else{

fieldList＝sprintf(″％s，％s″，fieldList，field)

fieldVal＝sprintf(″％s，’％s’″，fieldVal，trim($2))

}

getline

}

printf(″insert?into?cm_cdr_manual(％s)\nvalues(％s)；\n″，fieldList，

fieldVal)

}

END{

printf(″commit；\nquit；″)

}

function?trim(str)

{

gsub(/^[[：space：]]+|[[：space：]]+$/，″″，str)

return?str

}

Step 3, utilization sqlplus carry out cdr.sql, the cdr data be input among the database table cm_cdr_manual, and under unix environment, fill order sqlplus-s $DBLINK @cdr.sql.

Step 4, carry out the important information result queries by SQL statement, it is as follows to carry out the SQL caller:

Select initial time zero-time, the end time concluding time,

The callingNumber calling number, the calledNumber called number,

’46000’||substr(replace(called_location_LAI，”，”)，7)||

Replace (called_location_cellID, ", ") sub-district, called number place,

MscOutgoingROUTE_ROUTEName called number place BSC,

mscOutgoingCircuit?cic

from?cm_cdr_manual；

Obtain the important information relevant with " single-pass ", important information comprises: numbers of calling and called parties, conversation beginning concluding time, ownership BSC, cic circuit identification code (CIC), base station coverage cell (LAIGCI), extract the A mouth circuit CIC that concentrates that distributes based on the Query Result interface and account for circuit test, the coverage cell of concentrating (LAIGCI) that perhaps distributes is tested, and is beneficial to find the circuit or the coverage cell of single-channel fault to occur and in time handle.

This method can improve the efficient of handling the single-pass problem greatly, has solved and has located the problem that this type of fault exists in the past: to every repeat circuit carry out one by one test calls, complexity be set, each office direction is reset, testing point is many, the attendant of counties and cities cooperates substantive test etc.

Claims (1)

1. single-pass fault distinguishing method is characterized in that: may further comprise the steps:

Step 1, login soft switchcall server charging gateway CDR console, the format of billing that Original CDR is set is termination ticket MTC, the duration that ticket is set is less than some seconds, the cdr*.txt text of the Original CDR that derivation satisfies condition comprises following important information in this cdr*.txt file: the calling number of Extra-short-conversation-time bills, called number, conversation time started, end of conversation time, home base station controller BSC, cic circuit identification code CIC, base station coverage cell LAIGCI;

Step 2, Original CDR cdr*.txt text is carried out merger, form single file cdr.txt, call analysis program and resolve cdr.txt, and generate database file cdr.sql, described analysis program is a development sequence, and its workflow is as follows: initialization; Searching comprises the row of CDR character string; With symbol "=" is separator registration cdr logging field value, and each field name and field value are circulated, up to the cdr logging result; Print insert warehouse-in sql one by one; Judge whether field is handled, if yes, then withdraw from cyclic program, and spanned file, if not, then jump to " row that searching comprises the CDR character string " this step and continue and down carry out;

Step 3, utilization sqlplus carry out cdr.sql, and the cdr data are input in the database table;

Step 4, carry out the important information result queries by SQL statement, extract the A mouth circuit CIC that concentrates that distributes based on Query Result and account for circuit test, the coverage cell of concentrating (LAIGCI) that perhaps distributes is tested, and is beneficial to find the circuit or the coverage cell of single-channel fault to occur and in time handle.

Images