CN110807534A - Method for diagnosing and repairing abnormal expense control work order based on collection, operation and maintenance closed-loop management system - Google Patents

Abstract

The invention relates to a method for diagnosing and repairing abnormal fee control work order based on a collection operation and maintenance closed-loop management system, which comprises the following steps: (1) screening cost control detail data which do not generate work orders, and then removing the data; writing the screened data into a middle table, calling an Oracle fee control generation and storage process, generating a work order, and solving the problem of missing fee control failure details of the original interface; (2) scanning a fee control work order table of a closed-loop system at fixed time; (3) and the timing scanning adopts a charge control task execution condition table of the system. The invention is suitable for the charge control management system in the power industry, and the execution of the operation and maintenance closed-loop management field charge control service is collected after the remote charge control fails so as to ensure the integrity, real-time performance and timeliness of the closed-loop charge control work order.

Description

An abnormal diagnosis and repair method based on the collection, operation and maintenance closed-loop management system cost control work order method

technical field

The invention belongs to the technical field of abnormal diagnosis and repair, and in particular relates to a method for abnormal diagnosis and repair of work orders based on collection, operation and maintenance closed-loop management system cost control.

Background technique

With the implementation of the collection, operation and maintenance closed-loop management system, the original process of power failure and restoration has changed. The issuance of remote power failure and restoration failure work orders based on the collection, operation and maintenance closed-loop management system will become the main method of cost control business. The task comes from the marketing system. The marketing system initiates accounting, determines the electricity consumption status of electricity users, and initiates corresponding remote control instructions, and pushes the cost control instructions to the electricity consumption information collection system. After the electricity consumption information collection system receives the message, it sends the instructions. The corresponding concentrator terminal, the terminal sends the command to the electric meter, and the electric meter trips or closes according to the corresponding command. If the remote delivery fails, the data will be pushed to the closed-loop management system for collection, operation and maintenance, and the closed-loop system will be notified through webserver messages to generate work orders. The collection, operation and maintenance closed-loop management system searches for the detailed data of the failure of cost control according to the cost control message notification of the electricity consumption information collection system, and generates the cost control work order.

On-site operation and maintenance personnel or the person in charge of the corresponding station area, after receiving the on-site cost control (power restoration/power failure) task notification, log in to the closed-loop collection operation and maintenance system to distribute work orders, log in to the on-site operation terminal, and obtain cost control work orders (cost control report message (instruction information for power interruption and resumption) and identity authentication message, corresponding to the information of the station area, household number, user electricity address, meter address, meter asset number, etc.), rush to the scene, and conduct infrared interaction with the meter through the on-site operation terminal Identity authentication, after the authentication is passed, the status of the meter is modified, and the on-site power recovery or power failure is carried out.

There are four problems in the existing work order generation process:

First, due to the frequent interaction of multiple systems and the excessive amount of interactive data, the cost control work order cannot be generated when the data writing time of the power consumption collection system fails to be controlled later than the notification time of the webserver message.

Second, the file information used in the existing cost control work order generation process is less than the file information of the electricity consumption information collection system, resulting in incomplete work order data information and on-site operation terminals unable to perform tasks.

The third is that the collection closed-loop system fee control interface service is integrated into the closed-loop system service at this stage, and the server is shared with other services. If the service is down for other reasons, the webserver message pushed by the electricity consumption information collection system cannot be received. The ticket could not be generated.

Fourth, after the cost control work order pushed by the closed-loop system is generated, the user repeatedly executes the remote issuing cost control command. After the remote task is successfully executed remotely, there is no need to restore the power on the spot, and the person in charge of the station area cannot be notified in time, causing the person in charge of the station area. Running empty is a waste of human and material resources.

SUMMARY OF THE INVENTION

The invention is suitable for the power industry cost control management system. After the remote cost control fails, the collection, operation and maintenance closed-loop management is transferred to the execution of the on-site cost control business, so as to ensure the integrity, real-time and timeliness of the closed-loop cost control work order.

Technical scheme of the present invention:

A method for diagnosing and repairing anomalies of cost control work orders based on the collection, operation and maintenance closed-loop management system, comprising the following steps:

(1) Screen the detailed data of cost control that has not generated a work order, and then remove the data; write the filtered data into the intermediate table, and call the Oracle cost control generation stored procedure to generate work orders to solve the "missing" of the original interface Details of fee control failures;

(2) Regularly scan the cost control work order table of the closed-loop system, monitor in-transit cost control work orders, work orders with missing meter asset number, station area information and electricity user information, query and collect files, and complete missing work order data information ; And monitor the generation time and overdue time of the in-transit fee control work order;

(3) Regularly scan the cost control task execution table of the adopting system, query the users and corresponding electricity meters in the in-transit cost control work order table, and remotely perform power restoration or power failure successfully, then modify the closed-loop in-transit cost control work order status, and set the The work order is cancelled, and the reason is indicated, the remote power failure/recovery is successful, the work order status is modified, and the on-site operation terminal prompts that the work order status has been cancelled.

Further, step (1) uses the Oracle database to scan the cost control task intermediate table of the closed-loop system and the adoption system, and filters the detailed data of cost control for which no work order has been generated.

Further, step (1) removes one, and writes the detailed data in the intermediate table with time less than 1 minute.

Further, step (1) excludes the second, the batches are different, but the corresponding users and table assets are the same, and the detailed data of the cost control work order has been generated.

Further, step (1) excludes the third, there is an in-transit process and the same type of cost control work order.

Further, in step (2), the overdue time is uniformly set as the generation time plus two days.

Further, step (2) uses the Oracle database to regularly scan the cost control task execution status table of the adoption system.

Further, in step (2), the time period for regularly scanning the cost control work order table of the closed-loop system is 0.5-1 hour.

Further, step (3) uses the Oracle database to regularly scan the cost control task execution table of the adoption system.

Further, in step (3), the time period for the periodic scanning of the cost control task execution table of the adopting system is 0.5-1 hour.

Beneficial effects of the present invention:

The invention is suitable for the power industry cost control management system. After the remote cost control fails, the collection, operation and maintenance closed-loop management is transferred to the execution of the on-site cost control business, so as to ensure the integrity, real-time and timeliness of the closed-loop cost control work order. The invention supplements and improves the original cost control business process, and successfully realizes the problems of file completion in the process of cost control work order generation, jumping when the unified interface is abnormal, and task timing cancellation when the collection and remote delivery are successful. The collection, operation and maintenance closed-loop management system sorts out and analyzes abnormal phenomena in the process of generating cost control work orders, summarizes the internal laws, and forms a complete set of remote processing mechanisms for remote discovery, remote diagnosis, and remote repair, and remotely locates the cause of abnormal work orders. , which shortens the abnormal elimination cycle, improves the accuracy of work order distribution, reduces the number of times the operation and maintenance personnel go to the site, and reduces the workload of the on-site operation and maintenance personnel.

The specific performance is as follows:

1. Monitor the integrity of cost control work orders. Collect and push closed-loop cost control work orders If key data is missing, complete the incomplete cost control work order information to ensure the validity of the work order;

2. Ensure the timeliness of work orders. When there is an abnormal situation in the unified version of the interface, the cost control work order is generated instead of the interface. When an exception occurs in the unified version of the cost control interface (using WebService + intermediate table), such as downtime, message sending failure, message notification and data writing is not timely or out of sync, etc., it will run instead of the unified version of the cost control interface to perform cost control. Work order generation.

3. Monitor the timeliness of the cost control work order, correct the overdue days, judge the overdue status of the work order, and cancel the task if it is overdue. At the same time, the remote cost control execution results are regularly monitored and collected. After the remote task is successfully executed, the cost control task is cancelled.

Description of drawings

Figure 1 is a schematic structural diagram of the present invention.

FIG. 2 is a schematic diagram of the original whole process of the present invention.

FIG. 3 is a schematic flow chart of the present invention.

Detailed ways

The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all of the embodiments. The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the application, its application, or uses. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative work fall within the protection scope of the present application.

It should be noted that the terminology used herein is for the purpose of describing specific embodiments only, and is not intended to limit the exemplary embodiments according to the present application. As used herein, unless the context clearly dictates otherwise, the singular is intended to include the plural as well, furthermore, it is to be understood that when the terms "comprising" and/or "including" are used in this specification, it indicates that There are features, steps, operations, devices, components and/or combinations thereof.

The relative arrangement of the components and steps, the numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present application unless specifically stated otherwise. Meanwhile, it should be understood that, for the convenience of description, the dimensions of various parts shown in the accompanying drawings are not drawn in an actual proportional relationship. Techniques, methods, and devices known to those of ordinary skill in the relevant art may not be discussed in detail, but where appropriate, such techniques, methods, and devices should be considered part of the authorized description. In all examples shown and discussed herein, any specific value should be construed as illustrative only and not as limiting. Accordingly, other examples of exemplary embodiments may have different values. It should be noted that like numerals and letters refer to like items in the following figures, so once an item is defined in one figure, it does not require further discussion in subsequent figures.

In the description of this application, it should be understood that the orientations indicated by the orientation words such as "front, rear, top, bottom, left, right", "horizontal, vertical, vertical, horizontal" and "top, bottom" etc. Or the positional relationship is usually based on the orientation or positional relationship shown in the drawings, which is only for the convenience of describing the present application and simplifying the description, and these orientations do not indicate or imply the indicated device or element unless otherwise stated. It must have a specific orientation or be constructed and operated in a specific orientation, so it cannot be construed as a limitation on the protection scope of the application; the orientation words "inside and outside" refer to the inside and outside relative to the contour of each component itself.

For ease of description, spatially relative terms, such as "on", "over", "on the surface", "above", etc., may be used herein to describe what is shown in the figures. The spatial positional relationship of one device or feature shown to other devices or features. It should be understood that spatially relative terms are intended to encompass different orientations of the device in use or operation in addition to the orientation depicted in the figures. For example, if the device in the figures is turned over, elements described as "above" or "over" other devices or features would then be oriented "below" or "over" the other devices or features under other devices or constructions". Thus, the exemplary term "above" can encompass both an orientation of "above" and "below." The device may also be otherwise oriented (rotated 90 degrees or at other orientations) and the spatially relative descriptions used herein interpreted accordingly.

In addition, it should be noted that the use of words such as "first" and "second" to define components is only for the convenience of distinguishing corresponding components. Unless otherwise stated, the above words have no special meaning and therefore cannot be understood to limit the scope of protection of this application.

The technical solutions and structures of the present invention will be described in further detail below with reference to the accompanying drawings.

The present invention monitors and collects the cost control work order table for closed-loop management of operation and maintenance, monitors the table of electricity consumption information collection and cost control implementation, and monitors the intermediate table between the electricity consumption information collection system and the collection operation and maintenance closed-loop management system, through three-point monitoring and interaction. Response to ensure the integrity, timeliness, and effectiveness of cost control work orders. To ensure the development of cost control business.

The invention relies on the power consumption information collection system installed in the server cluster, and the Oracle database is shared between the collection operation and maintenance closed-loop management system database and the power consumption information collection system, and the collection operation and maintenance closed-loop system can access all the power consumption information collection system. Table data, through the big data mining of the electricity consumption information collection system, realizes intelligent monitoring of cost control tasks, and pushes tasks to be generated in real time; realizes that there is no file, and can generate cost control work orders; realizes the success of remote cost control, and automatically cancels the on-site cost control Task; the implementation replaces the original interface and generates a work order.

Specific steps are as follows:

Step 1: The electricity consumption information collection system remotely distributes the cost control task according to the marketing distribution, informs the marketing system of the failure result of the remote execution, and pushes the failure detailed data to the intermediate table of the collection operation and maintenance closed-loop system.

Step 2: The electricity information collection system writes a notification message, and by accessing the closed-loop interface service, the closed-loop system is notified to generate a work order.

Step 3: After the closed-loop system receives the message and finds the corresponding task, it generates a work order for the task according to the closed-loop file.

Step 4: Close-loop monitoring of the cost control task operation. In step 1, check whether there is a write for more than 1 minute, and the work order has not been generated. Query the existence of unprocessed work orders, write the data into the temporary table, and remove the in-transit cost control tasks that have been generated by the corresponding users and devices in the temporary table (the cost control tasks that are pushed repeatedly will not be generated repeatedly).

Step 5: Close-loop monitoring of the operation of the cost control task, write the temporary table data of cost control failure filtered in step 4 into the work order to generate a temporary table, and input the corresponding user number, asset number, marketing work order number, time, work order Type, operation type, special identifier (distinguish between manual and system push).

Step 6: Close-loop monitoring of the operation of the cost control task. Following step 5, the manual generation process of the transformed cost control task is called by traversal, and the operation type, special identifier, user information and other data in the temporary table are generated according to the work order, and the specified unique Fee control work order.

Step 7: If there is an abnormality in step 2, and the electricity consumption information collection system cannot notify the closed-loop interface service, then under the closed-loop monitoring cost control program, steps 4, 5, and 6 are executed periodically, thereby replacing the original interface program for cost control. Work order generation.

Step 8: If abnormal situation 1 occurs in step 3, the corresponding task is not queried after receiving the message, the execution of the original interface task ends, the result is notified to the electricity consumption information collection system, and the task is no longer executed. At this time, the closed-loop monitoring cost control task is running, and steps 4, 5, and 6 are executed cyclically, so that the cost control work order is generated for the tasks that have not been generated.

Step 9: If there is abnormal situation 2 in step 3, and there is no file in the closed loop, then through steps 1, 2, and 3, the generated cost control work order data is incomplete. Whether the work order generation is complete, through the closed-loop monitoring of the cost control task operation program, monitoring the in-transit cost control work orders generated within 2 days, querying key fields, table asset number, station area information, user electricity address and other information, if there is any missing information For work order data, look up the station area table, user table, and operating energy meter table corresponding to the electricity consumption information collection system, associate key fields, and complete the data.

Step 10: Close-loop monitoring of the cost control task program, regularly scan and collect the system cost control task execution table, and update the intermediate table of the electricity consumption information collection system and the collection operation and maintenance closed-loop system according to the details of successful remote execution. The corresponding tasks are of the same type and executed remotely. The time of success is later than the time of writing to the intermediate table.

Step 11: According to the intermediate table updated in step 10, write the remote fee control result into the fee control result intermediate table. And update the collection operation and maintenance closed-loop management cost control work order table. The corresponding equipment and unfiled in-transit expense control work orders will be revoked, and the reason, time, and operator of the revocation will be added.

Step 12: Migrate the tasks that were cancelled in the intermediate table in steps 10 and 11 to the intermediate history table to reduce the amount of data in the intermediate table.

Step 13: If the on-site operation and maintenance personnel and the person in charge of the station area have issued the work order to the on-site operation terminal, the terminal clears the cached data and logs in the next day when the data is refreshed, and the work order is not displayed on the handheld due to the status change.

Step 14: For the work orders generated in steps 1, 2, and 3, there are some work orders overdue time that does not meet the 2-day validity period required by the provincial company. Therefore, it is determined whether the overdue work order for cost control is equal to the work order generation time plus 2 days. After the task is overdue, the status of the cost control work order changes to Overdue Cancellation.

Among them, steps 1, 2, and 3 are the steps for generating the original cost control work order. If the cost control task is abnormal during the generation process. Then the fee control interface has no corresponding processing mechanism, so this method is extended and supplemented on the original basis.

In the supplementary content, 4, 5, and 6 are the independent cost control interfaces of the database. No matter whether the existing interface is running, the supplementary interface will always run, so that the work order can be generated on time, and the validity, integrity and real-time performance of the work order can be ensured.

When the handheld computer performs the cost control task, the most important meter approval address in the downloaded work order, the communication address comes from the download of the work order, the pre-program obtains the running meter information associated with the asset number in the cost control work order table. Therefore, the meter asset number must be included in the work order sheet.

On-site operation and maintenance personnel or the person in charge of the station area log in to the handheld on-site operation terminal, automatically download the cost control work order, and then arrive at the site to check the on-site meter status and meter type. Check whether the power meter is out of power (yellow light is always on, the dial has the word "opening") or the power is restored (yellow light is off, there is no "opening"), and check whether the meter is 09 meter, 13 meter, or object-oriented meter. And need to confirm the built-in switch or external switch.

If the site is an object-oriented electricity meter, the handheld execution failure message indicates that the meter is certified according to the 13 form.... The authentication failed, and the authentication according to the 09 form... The task execution failed. This type of error is related to the work order data. The site is an object-oriented protocol, and the protocol is stored as a 645 protocol in the marketing system and the electricity consumption information collection system. The protocol is wrong and the work order cannot be successfully executed. It is necessary to change the protocol in the marketing system, debug the corresponding station area data (synchronize marketing data) with the electricity collection system, and use the collection files directly in the closed-loop system, so it is only necessary to clear the handheld data and re-download the correct work order authentication message.

Now in the hand-held power restoration work order, the switch-on type work order is allowed to apply to all meters. If the on-site meter is 09, after the task is successfully executed, the on-site power transmission is successful. If the field is 13 tables or object-oriented tables. Then you need to press and hold the patrol button for 3 seconds, and you will hear the sound of the built-in switch closing. However, due to the uneven knowledge level of some on-site personnel, when this happens, the meter replacement process will be initiated. Therefore, optimize the task type. According to the equipment file, when generating the work order, it can intelligently distinguish the operation type of the restoration work order. The 09 form is generated to allow closing, and the 13 form and the object-oriented form are generated to directly close.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, but not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that it can still be Modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements on some of the technical features; it is obvious for those skilled in the art to combine multiple technical solutions of the present invention. However, these modifications or substitutions do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims (10)

1. A method for diagnosing and repairing anomalies of cost control work orders based on a closed-loop management system for collection, operation and maintenance, characterized in that it comprises the following steps: (1) screening detailed data on cost control for which work orders have not been generated, and then removing the data; The latter data is written into the intermediate table, and the Oracle cost control generation stored procedure is called to generate work orders to solve the “missing” cost control failure details of the original interface; (2) Regularly scan the cost control work order table of the closed-loop system to monitor In the in-transit cost control work order, if the meter asset number, station area information and electricity user information are missing, query the collection file, and complete the missing work order data information; and monitor the generation time and overdue time of the in-transit cost control work order; ( 3) Regularly scan the cost control task execution status table of the adoption system, query the users and corresponding electricity meters in the in-transit cost control work order table, and remotely perform power restoration or power failure successfully, then modify the closed-loop in-transit cost control work order status, The order is cancelled, and the reason is indicated, the remote power failure/recovery is successful, the work order status is modified, and the on-site operation terminal prompts that the work order status has been cancelled. 2. The method for diagnosing and repairing abnormal work orders based on the collection, operation and maintenance closed-loop management system of cost control according to claim 1, wherein step (1) uses the Oracle database to scan the closed-loop system and the cost control task of the procurement system The intermediate table filters out the detailed data of cost control for which work orders have not been generated. 3. A method for diagnosing and repairing abnormal work orders based on collection, operation and maintenance closed-loop management system cost control according to claim 1, characterized in that step (1) eliminates one, and writes the detailed data in the intermediate table for less than 1 minute . 4. A method for diagnosing and repairing abnormal work orders based on collection, operation and maintenance closed-loop management system cost control according to claim 3, characterized in that step (1) eliminates the second, the batches are different, but the corresponding users and table assets are the same And the detailed data of the cost control work order has been generated. 5. A method for diagnosing and repairing abnormality of cost control work orders based on the collection and operation and maintenance closed-loop management system according to claim 4, characterized in that, step (1) eliminates three, there are cost control work orders with the same type of process in transit and the same type . 6 . The method for diagnosing and repairing abnormal work orders based on collection, operation and maintenance closed-loop management system cost control according to claim 1 , wherein in step (2), the overdue time is uniformly set as the generation time plus two days. 7 . 7. The method for diagnosing and repairing abnormality of cost control work orders based on the collection, operation and maintenance closed-loop management system according to claim 1, wherein step (2) uses the Oracle database to regularly scan the execution status of the cost control tasks of the collection system surface. 8. The method for diagnosing and repairing abnormality of cost control work orders based on the collection and operation and maintenance closed-loop management system according to claim 1, wherein the time period of step (2) regularly scanning the cost control work order table of the closed-loop system is: 0.5-1 hour. 9. The method for diagnosing and repairing abnormality of cost control work orders based on the collection, operation and maintenance closed-loop management system according to claim 1, wherein step (3) uses the Oracle database to regularly scan the execution status of the cost control tasks of the collection system surface. 10. A method for diagnosing and repairing anomalies of cost control work orders based on the collection, operation and maintenance closed-loop management system according to claim 1, wherein step (3) regularly scans the time of the cost control task execution table of the collection system The period is 0.5-1 hour.

Images