An automatic solution and system for the backlog of power on and off instructions

Abstract

The present invention provides an automatic solution and system for the backlog of power-on and power-off instructions, which relates to the technical field of telecommunications operator business support, including: real-time monitoring of the power-on and power-off instruction temporary storage table of each city to determine whether there is a backlog of instructions; if the judgment result is yes, querying the host where the power-on and power-off instruction processing process of the city is located; if the host is the host itself, determining the change of the power-on and power-off sending log of the city; if there is a change, respectively collecting the error code of the power-on and power-off sending log and the return time of the connection platform, obtaining the cause of the problem, and sending an alarm message; if there is no change, terminating the process and allocating a new process. The present invention monitors the power-on and power-off instruction temporary storage table in real time, obtains the backlog of instructions in real time, and identifies the backlog problem, quickly handles the abnormal situation, ensures the timeliness of the power-on and power-off instructions, and improves user satisfaction.

Description

Technical Field

[0001] The present invention relates to the technical field of telecommunication operator business support, and in particular to an automatic solution and system for backlog of power on and off instructions. Background Art

[0002] With the development of the telecommunications industry, the requirements for the timeliness of instructions are becoming increasingly higher. It is necessary to send the user's power on and off instructions to the network element equipment as quickly as possible to improve user satisfaction and reduce complaints and losses.

[0003] At present, due to the large number of system instructions, instructions are prone to backlog in high concurrency, resulting in delays in issuing instructions, affecting user experience, causing unnecessary personnel investment and losses, and reducing customer satisfaction. Summary of the invention

[0004] In view of the above problems, the present invention provides an automatic solution and system for the backlog of power on and off instructions, which can quickly identify the backlog of instructions, automatically handle abnormal problems, and ensure the timeliness of instructions.

[0005] To achieve the above purpose, the present invention discloses an automatic solution to the backlog of power on / off instructions, including:

[0006] Real-time monitoring of the temporary storage table of power on and off commands in various cities to determine whether there is a backlog of commands;

[0007] If the judgment result is yes, then query the host where the power on / off command processing process of the city is located;

[0008] If the host is the host itself, then determine the change of the power on / off sending log of the city;

[0009] If there is a change, the error code of the power on / off log and the return time of the connection platform are collected respectively, the cause of the problem is obtained, and an alarm message is sent;

[0010] If there are no changes, the process is terminated and a new one is allocated.

[0011] As a further improvement of the present invention, the determining whether there is an instruction backlog includes:

[0012] The amount of data in the power on / off command temporary storage table with a sending status of zero is determined, and if the amount of data exceeds a preset threshold, it is determined that there is a backlog of commands.

[0013] As a further improvement of the present invention, the querying of the host where the power on / off instruction processing process of the city is located includes:

[0014] Determine the home location register of the home city according to the name of the power on / off command temporary storage table;

[0015] Query the process number and host information corresponding to the home location register in the configuration table.

[0016] As a further improvement of the present invention, the step of determining the change of the power on / off sending log of the city includes:

[0017] Find the power on / off sending logs of the city;

[0018] Determine the change of the power on / off sending log within 5 minutes.

[0019] As a further improvement of the present invention,

[0020] If the log does not change within 5 minutes, the process is determined to be dead, and the process is terminated directly. The system reassigns a new process to the city.

[0021] As a further improvement of the present invention, the error code of the power on / off sending log and the return time of the connection platform are collected respectively to obtain the cause of the problem, including:

[0022] Collect error codes in logs within 1 minute;

[0023] Calculate the cause of the problem based on the preset error code change algorithm;

[0024] Collect the return time of the connection platform within 1 minute in the log;

[0025] Calculate the cause of the problem based on the preset return time algorithm.

[0026] As a further improvement of the present invention, alarm information is sent respectively for the acquired problem causes.

[0027] As a further improvement of the present invention, the error code change algorithm includes:

[0028] Determine whether the error code is within the preset range. If it is within the range:

[0029] Calculate the impact value of each error code;

[0030] Calculate the impact ratio based on the number of error codes;

[0031] Based on the comparison of past periods, calculate the past impact value;

[0032] According to the preset weights, the degree of the problem is calculated based on the error code impact value, impact ratio value, and past impact values.

[0033] As a further improvement of the present invention, the sending of the warning information includes:

[0034] Parameter exception error is reported and sent to developers;

[0035] Network platform reports errors and sends them to network personnel and developers;

[0036] The surge in data volume leads to backlogs, which requires developers and maintainers to be sent to the server, and increases the number of program threads and concurrency.

[0037] Network connectivity problems or network fluctuation problems are sent to the network side and maintenance personnel, and the backup machine address is automatically switched for sending;

[0038] The transaction return time fluctuation problem is sent to the network side and maintenance personnel.

[0039] The present invention also provides an automatic solution system for the backlog of power on / off instructions, including: a determination module, a discrimination module and a processing module;

[0040] The determination module is used to:

[0041] Real-time monitoring of the temporary storage table of power on and off commands in various cities to determine whether there is a backlog of commands;

[0042] The identification module is used to:

[0043] If the judgment result is yes, then query the host where the power on / off command processing process of the city is located;

[0044] If the host is the host itself, then determine the change of the power on / off sending log of the city;

[0045] If there is a change, the error code of the power on / off log and the return time of the connection platform are collected to obtain the cause of the problem.

[0046] The processing module is used to:

[0047] If there is a change, an alarm message will be sent based on the cause of the problem;

[0048] If there are no changes, the process is terminated and a new one is allocated.

[0049] Beneficial effects of the present invention:

[0050] The present invention monitors the power on and off command temporary storage table in real time, obtains the command backlog in real time, identifies the backlog problem, and quickly handles the abnormal situation, thereby ensuring the timeliness of the power on and off command and improving user satisfaction.

[0051] The automatic solution of the present invention avoids unnecessary human input and losses, can automatically handle system problems, reduce users' perception of faults, and further reduce complaints and losses. BRIEF DESCRIPTION OF THE DRAWINGS

[0052] Figure 1 A flowchart of an automatic solution to a backlog of power on / off instructions disclosed in an embodiment of the present invention;

[0053] Figure 2 A schematic diagram of an automatic solution system for power on / off command backlog disclosed in an embodiment of the present invention;

[0054] Figure 3 A detailed flow chart of an automatic solution to a backlog of power on / off instructions disclosed in an embodiment of the present invention. DETAILED DESCRIPTION

[0055] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0056] The present invention is further described in detail below in conjunction with the accompanying drawings:

[0057] like Figure 1 , 3 As shown, the present invention provides an automatic solution to the backlog of power on / off instructions, including:

[0058] S1. Real-time monitoring of the temporary storage table of power on / off commands in various cities to determine whether there is a backlog of commands;

[0059] in,

[0060] The amount of data with a sending status of zero in the power on / off command temporary storage table (wsndcmddday table) is determined. If the amount of data exceeds a preset threshold, it is determined that there is a backlog of commands.

[0061] Furthermore,

[0062] The preset threshold is 2000. If the backlog exceeds 2000, it means that there is a backlog of instructions.

[0063] S2. If the judgment result is yes, query the host where the power on / off command processing process of the city is located;

[0064] in,

[0065] Query the database;

[0066] Determine the home location register (hlr) of the home city according to the name of the power on / off command temporary storage table;

[0067] Query the process number and host information corresponding to the home location register (hlr) in the configuration table.

[0068] Based on the host information, determine whether the process is running on the host itself, that is, determine whether the host is the host itself.

[0069] S3. If the host is the host itself, determine the change of the power on / off sending log of the city;

[0070] in,

[0071] Find the power on / off sending logs of the city;

[0072] Determine the changes in the power on / off logs within 5 minutes.

[0073] S4. If there is any change, the error code of the power on / off log and the return time of the connection platform are collected to obtain the cause of the problem and send an alarm message;

[0074] in,

[0075] Collect error codes in logs within 1 minute;

[0076] Obtain the cause of the problem based on the preset error code change algorithm;

[0077] Collect the return time of the connection platform within 1 minute in the log;

[0078] Obtain the cause of the problem based on the preset return time algorithm;

[0079] Send warning information for each of the acquired problem causes;

[0080] Furthermore,

[0081] Error code change algorithm, including:

[0082] Determine whether the error code is within the preset range. If not, directly determine it as abnormal;

[0083] If within the preset range:

[0084] Calculate the impact value of each error code;

[0085] Calculate the impact ratio based on the number of error codes;

[0086] Based on the comparison of past periods, calculate the past impact value;

[0087] According to the preset weights, the problem severity is calculated based on the error code impact value, impact ratio value, and past impact values.

[0088] Returns the duration algorithm, including:

[0089] Test network connectivity. If the network connectivity is abnormal, directly determine the abnormality;

[0090] Based on the return time within 1 minute, if the proportion of transactions with a return time longer than 30 seconds is greater than a specific threshold, it is directly determined to be abnormal; if the transaction volume in 30 seconds is not greater than the specific threshold, the impact value is calculated based on the timeout ratio;

[0091] The impact value is calculated based on the proportion of each time interval and time distribution of the transaction returns within 10 seconds; the past impact value is calculated based on the comparison of past time; and the degree of problem in the final system is calculated through the different weights of each category.

[0092] Furthermore, warning information is sent for each of the acquired problem causes, including:

[0093] Parameter exception error is reported and sent to developers;

[0094] Network platform reports errors and sends them to network personnel and developers;

[0095] The surge in data volume leads to backlogs, which requires developers and maintainers to be sent to the server, and increases the number of program threads and concurrency.

[0096] Network connectivity problems or network fluctuation problems are sent to the network side and maintenance personnel, and the backup machine address is automatically switched for sending;

[0097] The transaction return time fluctuation problem is sent to the network side and maintenance personnel.

[0098] S5. If there is no change, terminate the process and assign a new process.

[0099] in,

[0100] If the log does not change within 5 minutes, the process is determined to be dead, and the process is terminated directly. The system reassigns a new process to the city.

[0101] like Figure 2 As shown, the present invention also provides an automatic solution system for the backlog of power on / off instructions, including: a determination module, a discrimination module and a processing module;

[0102] A determination module is used to:

[0103] Real-time monitoring of the temporary storage table of power on and off commands in various cities to determine whether there is a backlog of commands;

[0104] Identification module for:

[0105] If the judgment result is yes, then query the host where the power on / off command processing process of the city is located;

[0106] If the host is the host itself, then determine the changes in the power on / off logs sent by the city;

[0107] If there is a change, collect the error code of the power on / off log and the return time of the connection platform to obtain the cause of the problem.

[0108] Processing modules for:

[0109] If there is a change, an alarm message will be sent based on the cause of the problem;

[0110] If there are no changes, the process is terminated and a new one is allocated.

[0111] Advantages of the present invention:

[0112] (1) The present invention monitors the power on / off instruction temporary storage table in real time, obtains the instruction backlog in real time, identifies the backlog problem, and quickly handles the abnormal situation, thereby ensuring the timeliness of the power on / off instruction and improving the satisfaction.

[0113] (2) The automatic solution of the present invention avoids unnecessary human input and losses, can automatically handle system problems, reduce users' perception of failures, and thus reduce complaints and losses.

[0114] The above are only preferred embodiments of the present invention and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. An automatic solution to the backlog of power on / off instructions, characterized in that: include: Real-time monitoring of the temporary storage table of power on and off commands in various cities to determine whether there is a backlog of commands; If the judgment result is yes, query the host where the power on / off instruction processing process of the city is located; query the database; determine the belonging location register of the city according to the name of the power on / off instruction temporary storage table; query the process number and host information corresponding to the belonging location register in the configuration table; determine whether the process is running on the own host according to the host information, that is, determine whether the host is the own host; If the host is the host itself, then determine the change of the power on / off sending log of the city; If there is a change, the error code of the power on / off log and the return time of the connection platform are collected respectively, the cause of the problem is obtained, and an alarm message is sent; If there are no changes, the process is terminated and a new one is allocated.

2. The automatic solution according to claim 1, characterized in that: The determining whether there is an instruction backlog includes: The amount of data in the power on / off command temporary storage table with a sending status of zero is determined, and if the amount of data exceeds a preset threshold, it is determined that there is a backlog of commands.

3. The automatic solution according to claim 1, characterized in that: The determining of changes in the power on / off sending logs of the city includes: Find the power on / off sending logs of the city; Determine the change of the power on / off sending log within 5 minutes.

4. The automatic solution according to claim 3, characterized in that: If the log does not change within 5 minutes, the process is determined to be dead, and the process is terminated directly. The system reassigns a new process to the city.

5. The automatic solution according to claim 1, characterized in that: Collect the error code of the power on / off log and the return time of the connection platform to obtain the cause of the problem, including: Collect error codes in logs within 1 minute; Calculate the cause of the problem based on the preset error code change algorithm; Collect the return time of the connection platform within 1 minute in the log; Calculate the cause of the problem based on the preset return time algorithm.

6. The automatic solution according to claim 5, characterized in that: Send warning information for each of the acquired problem causes.

7. The automatic solution according to claim 5, characterized in that: The error code change algorithm includes: Determine whether the error code is within the preset range. If it is within the range: Calculate the impact value of each error code; Calculate the impact ratio based on the number of error codes; Based on the comparison of past periods, calculate the past impact value; According to the preset weights, the problem degree is calculated based on the error code impact value, impact ratio value, and past impact values.

8. The automatic solution according to claim 1, characterized in that: The sending of warning information includes: Parameter exception error is reported and sent to developers; Network platform reports errors and sends them to network personnel and developers; The surge in data volume leads to backlogs, which requires developers and maintainers to be sent to the server, and increases the number of program threads and concurrency. Network connectivity problems or network fluctuation problems are sent to the network side and maintenance personnel, and the backup machine address is automatically switched for sending; The transaction return time fluctuation problem is sent to the network side and maintenance personnel.

9. A system for implementing the automatic solution as claimed in any one of claims 1 to 8, characterized in that: include: Determination module, identification module and processing module; The determination module is used to: Real-time monitoring of the temporary storage table of power on and off commands in various cities to determine whether there is a backlog of commands; The identification module is used to: If the judgment result is yes, query the host where the power on / off instruction processing process of the city is located; query the database; determine the belonging location register of the city according to the name of the power on / off instruction temporary storage table; query the process number and host information corresponding to the belonging location register in the configuration table; determine whether the process is running on the own host according to the host information, that is, determine whether the host is the own host; If the host is the host itself, then determine the change of the power on / off sending log of the city; If there is a change, the error code of the power on / off log and the return time of the connection platform are collected to obtain the cause of the problem. The processing module is used to: If there is a change, an alarm message will be sent based on the cause of the problem; If there are no changes, the process is terminated and a new one is allocated.

Images