Data problem troubleshooting method, device, equipment and computer-readable storage medium

By adding a mask on the large-screen display page and calling the database access interface to obtain the transmitted data, the problem of cumbersome and inefficient data problem investigation process in the existing technology is solved, and the effect of quickly locate the source of the problem and improve the inspection efficiency is achieved.

CN114003483BActive Publication Date: 2024-11-08CHINA MOBILE (SUZHOU) SOFTWARE TECH CO LTD +1
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202010739648.6
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2020-07-28
Publication Date
2024-11-08
Estimated Expiration
2040-07-28

AI Technical Summary

Technical Problem

In the existing technology, the process of troubleshooting data on large-screen display pages is complicated, involving multiple collaborations, inefficient, and requires repeated viewing of the original front-end and back-end codes, making it difficult to quickly locate the source of the problem.

Method used

在数据显示页面上添加蒙版,通过蒙版中的选框调用数据库访问接口获取传输数据,直接定位问题产生的环节点,简化问题排查过程。

Benefits of technology

Problem investigators can independently complete data and problem visual inspections, reduce duplicate viewing of the original code of the front-end and interfaces, and improve the inspection efficiency and efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114003483B_ABST
    Figure CN114003483B_ABST
Patent Text Reader

Abstract

The embodiment of the present application provides a data problem troubleshooting method, device, equipment and computer-readable storage medium, wherein the method includes: receiving a data troubleshooting request; in response to the data troubleshooting request, determining a target selection box of the problem to be troubleshooted corresponding to the data troubleshooting request in the mask corresponding to the data display page; determining a target database access interface corresponding to the target selection box; obtaining transmission data corresponding to the target selection box transmitted by the target database access interface; and troubleshooting the display data on the data display page according to the transmission data. Through the present application, the link point where the problem occurs can be directly located according to the transmission data on the data display page, thereby simplifying the problem troubleshooting process and improving the problem troubleshooting efficiency.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The embodiments of the present application relate to the field of computers, and relate to but are not limited to a data problem troubleshooting method, apparatus, device, and computer-readable storage medium. Background Art

[0002] At present, the method for troubleshooting data problems on large-screen display pages is often to start from the front-end page, and in the developer tool mode, lock the display module with the problem to access the specific database operation interface, and then look at the back-end interface code to lock the data of the display module with the problem from which database table, under which parameter transmission, and which fields are queried to obtain the results. After knowing all the above information, the person responsible for troubleshooting can start to check the data problems in the database in detail, and then troubleshoot the causes of the data problems, such as interface errors, front-end code errors, source file data errors, missing, etc.

[0003] However, for pages that display in real time, when problems occur, what is needed is to quickly find the cause of the problem. However, the existing methods for troubleshooting data problems are cumbersome and involve many steps, involving front-end program code and back-end interface code. When troubleshooting problems, too many developers are involved in the early stage, and it requires collaboration among multiple people, which is very inefficient and cannot be completed independently by the troubleshooter. In addition, most problems are repetitive, but each developer develops and maintains a large number of systems and pages, and each page involves a large number of interfaces, database tables, and fields. When a problem occurs and needs to be troubleshooted, whether it is simply relying on human memory or repeatedly checking the original front-end and back-end codes, it is a very inefficient thing. Summary of the invention

[0004] The embodiments of the present application provide a data problem troubleshooting method, apparatus, device and computer-readable storage medium. A mask is provided on a data display page. A database access interface is called according to a selection box in the mask to obtain transmission data, thereby troubleshooting the displayed data on the data display page. The problem-generating point can be directly located according to the transmission data on the data display page, thereby simplifying the problem troubleshooting process and improving the problem troubleshooting efficiency.

[0005] The technical solution of the embodiment of the present application is implemented as follows:

[0006] In a first aspect, an embodiment of the present application provides a data problem troubleshooting method, comprising:

[0007] Receive a data troubleshooting request; in response to the data troubleshooting request, determine a target selection box corresponding to the data troubleshooting request in a mask corresponding to a data display page; determine a target database access interface corresponding to the target selection box; obtain transmission data corresponding to the target selection box transmitted by the target database access interface; and troubleshoot the display data on the data display page based on the transmission data.

[0008] In a second aspect, an embodiment of the present application provides a data problem troubleshooting device, comprising:

[0009] A receiving module is used to receive a data troubleshooting request; a first determining module is used to determine, in response to the data troubleshooting request, a target selection box of a problem to be troubleshooted corresponding to the data troubleshooting request in a mask corresponding to a data display page; a second determining module is used to determine a target database access interface corresponding to the target selection box; an acquiring module is used to acquire transmission data corresponding to the target selection box transmitted by the target database access interface; and a problem troubleshooting module is used to troubleshoot the display data on the data display page according to the transmission data.

[0010] In a third aspect, an embodiment of the present application provides a data problem troubleshooting device, comprising: a memory for storing executable instructions; and a processor for implementing the above method when executing the executable instructions stored in the memory.

[0011] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium storing executable instructions for causing a processor to execute and implement the above method.

[0012] In the embodiment of the present application, in response to a data troubleshooting request, in the mask corresponding to the data display page, a target selection box corresponding to the data troubleshooting request is determined; and a target database access interface corresponding to the target selection box is determined; transmission data corresponding to the target selection box transmitted by the target database access interface is obtained; and according to the transmission data, the display data on the data display page is troubleshooted. In this way, the target database access interface is called according to the target selection box in the mask to obtain the transmission data, so as to troubleshoot the display data on the data display page, and the link point where the problem occurs can be directly located according to the transmission data on the data display page. The troubleshooter can independently complete the visual troubleshooting of data problems based on the embodiment of the present application, without having to repeatedly check the front-end and interface original codes, thereby simplifying the troubleshooting process and improving the troubleshooting efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] Figure 1 This is an optional flowchart of the data problem troubleshooting method provided in the embodiment of the present application;

[0014] Figure 2 It is a schematic diagram of an application scenario of the data problem troubleshooting method provided in an embodiment of the present application;

[0015] Figure 3 This is an optional flowchart of the data problem troubleshooting method provided in the embodiment of the present application;

[0016] Figure 4 This is an optional flowchart of the data problem troubleshooting method provided in the embodiment of the present application;

[0017] Figure 5 This is an optional flowchart of the data problem troubleshooting method provided in the embodiment of the present application;

[0018] Figure 6 This is an optional flowchart of the data problem troubleshooting method provided in the embodiment of the present application;

[0019] Figure 7 This is an optional flowchart of the data problem troubleshooting method provided in the embodiment of the present application;

[0020] Figure 8 This is an optional flowchart of the data problem troubleshooting method provided in the embodiment of the present application;

[0021] Fig. 9 It is a schematic diagram of the structure of the data problem troubleshooting device provided in an embodiment of the present application;

[0022] Fig.10 It is a schematic diagram of the composition structure of the data problem troubleshooting device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0023] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings. The described embodiments should not be regarded as limiting the present application. All other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of this application.

[0024] In the following description, reference is made to "some embodiments", which describe a subset of all possible embodiments, but it is understood that "some embodiments" may be the same subset or different subsets of all possible embodiments, and may be combined with each other without conflict. Unless otherwise defined, all technical and scientific terms used in the embodiments of the present application have the same meaning as those commonly understood by those skilled in the art of the technical field of the embodiments of the present application. The terms used in the embodiments of the present application are only for the purpose of describing the embodiments of the present application and are not intended to limit the present application.

[0025] The embodiment of the present application proposes a visual data problem troubleshooting method, which can add a cover mask covering the entire page on the data display page. During the data problem troubleshooting process, the target database access interface can be called according to the target selection box in the mask to obtain the transmission data, thereby troubleshooting the displayed data on the data display page. The problem generating point can be directly located according to the transmission data on the data display page. The problem troubleshooter can independently complete the data problem troubleshooting based on the embodiment of the present application, and there is no need to repeatedly check the front-end and interface original code, thereby simplifying the problem troubleshooting process and improving the problem troubleshooting efficiency.

[0026] The following describes an exemplary application of the data problem troubleshooting device provided in the embodiment of the present application. The data problem troubleshooting device provided in the embodiment of the present application can be implemented as various types of terminals such as a laptop computer, a tablet computer, a desktop computer, a mobile device (for example, a mobile phone, a portable music player, a personal digital assistant, a dedicated messaging device, a portable gaming device), and can also be implemented as a server. The following describes an exemplary application of the data problem troubleshooting device when it is implemented as a server.

[0027] See also Figure 1 , Figure 1 This is an optional flow chart of the data problem troubleshooting method provided in the embodiment of the present application, which will be combined with Figure 1 The steps shown are explained.

[0028] Step S101, receiving a data search request.

[0029] Here, the data troubleshooting request can be a request triggered by the problem troubleshooter on the terminal. It should be noted that a problem troubleshooting application can be run on the terminal. The problem troubleshooter can trigger the data troubleshooting request through the problem troubleshooting application on the terminal to request troubleshooting of the display data of the data display page on the terminal.

[0030] The data troubleshooting request may include a selection box identifier, and the selection box identifier is used to identify the target selection box on the mask, so that after receiving the data troubleshooting request, the server can parse the data troubleshooting request to obtain the selection box identifier, and then determine the target selection box based on the selection box identifier. In some embodiments, a mask is provided on the data display page, and the mask includes at least one selection box. When the troubleshooter clicks on any selection box on the mask, the terminal automatically obtains the selection box identifier of the selection box, and carries the selection box identifier in the data troubleshooting request and sends it to the server. In other embodiments, the troubleshooter may also first obtain the identifier of the target selection box that he wants to troubleshoot, and then carry the identifier of the target selection box in the data troubleshooting request.

[0031] Step S102 , in response to the data troubleshooting request, determining a target selection box of the problem to be troubleshooted corresponding to the data troubleshooting request in a mask corresponding to the data display page.

[0032] Here, after receiving the data search request, the server parses the data search request to obtain the selection box identifier carried in the data search request, and determines the target selection box corresponding to the selection box identifier in the mask on the data display page.

[0033] The mask may have at least one selection box, each of which corresponds to an area on the data display page, and the area has a certain amount of display data. Therefore, on the same data display page, a selection box can select a part of the display data, that is, each selection box in the mask selects a certain amount of data in the data display page.

[0034] In the embodiment of the present application, the mask can be transparent. Therefore, when troubleshooting a problem, the troubleshooter can view the data displayed on the data display page through the mask. In addition, the mask is only displayed to authorized troubleshooters, that is, the troubleshooter can see the mask on the data display page only after logging in to an authorized account. Ordinary users or users who have not successfully logged in cannot see the mask on the data display page and can only see the data displayed on the data display page.

[0035] Step S103: determining a target database access interface corresponding to the target selection box.

[0036] In the embodiment of the present application, each checkbox corresponds to a database access interface, or multiple checkboxes correspond to a database access interface. There is an association relationship between each checkbox and the corresponding database access interface, and the database access interface corresponding to the checkbox can be determined through the association relationship.

[0037] The database access interface can access the database and obtain corresponding data from the database. It should be noted that the database access interface corresponding to any selection box can obtain the data displayed in the corresponding position of the selection box on the data display page.

[0038] Step S104: acquiring transmission data corresponding to the target selection box transmitted by the target database access interface.

[0039] Here, the transmission data transmitted by the target database access interface is the original data obtained by the target database access interface from the database, and the display data displayed on the data display page can be verified and corrected through the original data. In the embodiment of the present application, after determining the target database access interface, the transmission data corresponding to the above-mentioned target selection box in the database is transmitted by calling the target database access interface.

[0040] Step S105: troubleshooting the displayed data on the data display page according to the transmitted data.

[0041] In an embodiment of the present application, after determining the target selection box corresponding to the data troubleshooting request, the data to be troubleshooted is determined, and therefore, the transmission data transmitted by the target database access interface corresponding to the target selection box is obtained, wherein the transmission data is the original data to be displayed on the data display page, and the original data is compared with the display data. If the original data is the same as the display data, then the troubleshooting result shows that there is no problem with the data; if the original data is different from the display data, then it is found that there is a problem with the display data, thereby achieving problem troubleshooting of the display data on the data display page.

[0042] In some embodiments, the data troubleshooting request may further include multiple checkbox identifiers, so that it is possible to troubleshoot problems in multiple display data on the data display page.

[0043] In some embodiments, after troubleshooting the displayed data in the target selection box corresponding to the selection box identifier included in the data troubleshooting request, it is also possible to use the target selection box corresponding to the selection box identifier as a starting point to troubleshoot other selection boxes in the mask in turn, i.e., select the selection boxes one by one and execute steps S103 to S105 in a loop.

[0044] It should be noted that in the embodiment of the present application, the server can troubleshoot the display data on the data display page, the terminal can troubleshoot the display data on the data display page by itself, or the terminal and the server can work together to troubleshoot the display data on the data display page.

[0045] The data problem troubleshooting method provided in the embodiment of the present application responds to the data troubleshooting request, determines the target selection box corresponding to the selection box identifier in the mask on the data display page; and determines the target database access interface corresponding to the target selection box; obtains the transmission data corresponding to the target selection box transmitted by the target database access interface; and troubleshoots the display data on the data display page according to the transmission data. In this way, the target database access interface is called according to the target selection box in the mask to obtain the transmission data, thereby troubleshooting the display data on the data display page, and the link point where the problem occurs can be directly located according to the transmission data on the data display page. The troubleshooter can independently complete the visual troubleshooting of data problems based on the embodiment of the present application, without having to repeatedly check the front-end and interface original code, thereby simplifying the troubleshooting process and improving the troubleshooting efficiency.

[0046] Figure 2is a schematic diagram of an application scenario of the data problem troubleshooting method provided in an embodiment of the present application, such as Figure 2 As shown, a data problem troubleshooting system 10 for implementing a data problem troubleshooting method includes a terminal 100, a network 200, and a server 300. A user (which may be a problem troubleshooter) triggers a data troubleshooting request through the terminal 100, wherein the troubleshooting request includes a selection box identifier; the terminal 100 sends the selection box identifier to the server 300 through the network 200, and the server 300 responds to the data troubleshooting request and determines a target selection box corresponding to the selection box identifier in a mask on a data display page; and determines a target database access interface corresponding to the target selection box; and obtains the target database access interface corresponding to the target selection box. The target database access interface transmits the transmission data corresponding to the target selection box; after acquiring the transmission data, the server 300 sends the transmission data to the terminal 100 through the network 200, and the terminal 100 displays the transmission data 21 in the form of a pop-up window on the current interface 100-1, and the terminal 100 also displays display data 22 on the current interface 100-1, so that the troubleshooter can compare the display data 22 displayed on the current interface 100-1 with the transmission data 21 to realize troubleshooting of the display data.

[0047] In some embodiments, the data problem troubleshooting method can be applied to the above-mentioned data problem troubleshooting system. Figure 3 is an optional flow chart of the data problem troubleshooting method provided in the embodiment of the present application, such as Figure 3 As shown, the method comprises the following steps:

[0048] Step S301: The terminal receives a trigger operation from a user and forms a data search request.

[0049] Here, the trigger operation may be a click operation performed by the user on the mask on the data display page. When the terminal receives the click operation of the user, it determines the target selection box selected by the user, obtains the selection box identifier of the target selection box, and carries the selection box identifier in the data troubleshooting request. Alternatively, a trigger option is displayed on the display interface of the terminal, and the trigger option is used to select data problem troubleshooting. The trigger operation may be an operation in which the user selects the trigger option. When the user clicks to select the trigger option, the terminal reminds the user to enter or select a selection box identifier, thereby carrying the selection box identifier entered or selected by the user in the data troubleshooting request.

[0050] Step S302: The terminal sends the data search request to the server.

[0051] Step S303: In response to the data search request, the server determines a target selection box corresponding to the selection box identifier in the mask on the data display page.

[0052] Step S304: the server determines a target database access interface corresponding to the target selection box.

[0053] Step S305: the server obtains the transmission data corresponding to the target selection box transmitted by the target database access interface.

[0054] It should be noted that steps S303 to S305 are the same as the above-mentioned steps S102 to S104, and will not be described in detail in the embodiment of the present application.

[0055] Step S306: the server sends the transmission data to the terminal.

[0056] Step S307: The terminal displays the transmission data in an information display pop-up window.

[0057] Here, the transmission data is displayed in the form of a pop-up window, so as to avoid the problem troubleshooter from affecting the displayed data on the data display page. In addition, the information display pop-up window is independent of the current data display page, so it will not affect the content displayed on the current data display page. In addition, the transmission data is displayed in the form of a pop-up window. Since the data on the data display page will be updated as it is refreshed, the information display pop-up window only corresponds to the current data display page. In the next data display page, the information display pop-up window will also change accordingly.

[0058] Step S308: The terminal performs troubleshooting on the display data on the data display page according to the transmission data displayed in the information display pop-up window.

[0059] Here, the terminal may compare the transmission data and the display data by itself to troubleshoot the problem, or, in some embodiments, the terminal may only display the transmission data and the display data to provide them to troubleshooters for manual troubleshooting, or, in other embodiments, while displaying the transmission data and the display data, the terminal also compares the transmission data and the display data, and displays the comparison result as data on the current interface in addition to the transmission data and the display data, to facilitate users to check the terminal problem troubleshooting results.

[0060] In some embodiments, after the terminal compares the transmission data and the display data, the comparison result formed can be the difference data between the transmission data and the display data, or the location where the difference exists between the transmission data and the display data. Then, when displaying the comparison result, the terminal can display the difference data or the location of the difference.

[0061] In some embodiments, after comparing the transmission data and the display data, the terminal may mark the difference data on the transmission data and the display data to facilitate troubleshooters to quickly view the differences. For example, the display color of the difference data may be changed, or the font or font size of the difference data may be changed, or the difference data may be marked with an identification box or identification line.

[0062] The data problem troubleshooting method provided by the embodiment of the present application is that the troubleshooter triggers the operation of requesting data troubleshooting on the terminal, and the server responds to the data troubleshooting request of the terminal, and determines the target selection box corresponding to the selection box identifier in the mask on the data display page; and determines the target database access interface corresponding to the target selection box; obtains the transmission data corresponding to the target selection box transmitted by the target database access interface; so that the troubleshooter can troubleshoot the display data on the data display page according to the transmission data. In this way, the target database access interface is called according to the target selection box in the mask to obtain the transmission data, so as to troubleshoot the display data on the data display page, which enables the troubleshooter to directly locate the link point where the problem occurs according to the transmission data on the data display page. The troubleshooter can independently complete the visual troubleshooting of data problems based on the embodiment of the present application, without having to repeatedly check the front-end and interface original code, thereby simplifying the troubleshooting process and improving the troubleshooting efficiency.

[0063] Figure 4 is an optional flow chart of the data problem troubleshooting method provided in the embodiment of the present application, such as Figure 4 As shown, before step S103, the method further includes the following steps:

[0064] Step S401: adding the mask having at least one selection box on the data display page.

[0065] Step S402: determining a position selected by any one of the at least one selection box on the data display page as a target position.

[0066] Here, for any selection box in the at least one selection box, the position of the selection box selected on the data display page is determined as the target position.

[0067] Step S403: acquiring display data displayed by the data display page at the target position.

[0068] Here, after adding the mask, it is also necessary to associate the mask with the data display page, that is, to associate the selection box on the mask with the display data on the data display page. For example, the part of the display data selected by the selection box can be associated with the selection box.

[0069] Step S404: In the database access interface set, a database access interface for transmitting the display data is determined as a database access interface corresponding to any one of the check boxes.

[0070] Step S405 : Associating each check box with the database access interface corresponding to each check box, and obtaining a mapping relationship between each check box and the database access interface in the database access interface set.

[0071] In an embodiment of the present application, after associating the selection box with the display data, it is also necessary to associate the selection box with the database access interface that transmits the display data. This can be done by pre-establishing an association relationship between the selection box and the database access interface to form an association list, which makes it easier to find the database access interface corresponding to the selection box according to the association list during subsequent data problem troubleshooting.

[0072] Correspondingly, step S103 can be implemented by the following steps:

[0073] Step S406: obtaining a mapping relationship between each selection box in the mask and a database access interface in the database access interface set.

[0074] Step S407: determine the database access interface having the mapping relationship with the target selection box as the target database access interface.

[0075] Here, since a mapping relationship between the selection box and the database access interface is pre-established, or an association list of the mapping relationship between the selection box and the database access interface is pre-formed, the database access interface corresponding to the selection box can be directly determined based on the mapping relationship, or the database access interface corresponding to the selection box can be found in the association list.

[0076] Please continue to refer to Figure 4 In some embodiments, after step S104, the method further comprises the following steps:

[0077] Step S408, determining the data format of the transmission data and the data format of the display data.

[0078] Step S409, determining whether the data format of the transmission data is the same as the data format of the display data. If the determination result is yes, executing step S105; if the determination result is no, executing step S410.

[0079] Step S410: converting the transmission data into data having the same data format as the display data.

[0080] Here, the data format of the transmission data is converted so as to have the same data format as the display data on the current data display page, thereby facilitating comparison between the transmission data and the display data.

[0081] Step S411, displaying the converted transmission data in the information display pop-up window.

[0082] In an embodiment of the present application, the converted transmission data having the same format as the display data is displayed in an information display pop-up window. Since the transmission data in the information display pop-up window has the same data format as the display data on the current data display page, when troubleshooting, the differences between the transmission data and the display data can be directly compared, which makes the comparison more efficient.

[0083] For example, when the unit of data transmitted by the database access interface is byte (B), and the unit of data displayed on the data display page is KB (kilobyte), the unit of the transmitted data can be converted into KB before being displayed in the information display pop-up window.

[0084] Please continue to refer to Figure 4 , wherein step S105 can be implemented by the following steps:

[0085] Step S412, determining whether the transmission data is the same as the display data.

[0086] Here, it can be determined whether the transmission data is the same as all or part of the data in the display data. When the judgment result is yes, it is determined that there is no problem with the display data. When the judgment result is no, it is determined that there is a front-end code problem with the display data.

[0087] In some embodiments, the data problem troubleshooting system only allows troubleshooters to perform operations, that is, only authorized accounts are allowed to access the data display page with a mask, so as to operate the mask on the data display page to complete the data problem troubleshooting. Figure 4 , Figure 5 is an optional flow chart of the data problem troubleshooting method provided in the embodiment of the present application, such as Figure 5 As shown, before step S101, the method further includes the following steps:

[0088] Step S501: receiving an identity authentication request, wherein the identity authentication request includes an identifier of an identity to be authenticated.

[0089] Here, the identifier to be verified may be an account of a troubleshooter, and the troubleshooter may enter the account and password for identity authentication.

[0090] Step S502: Authentication of the identity to be authenticated is performed on the identity to be authenticated according to the identifier of the identity to be authenticated.

[0091] Step S503: When the identity authentication is passed, the outline of each selection box in the mask is displayed on the data display page.

[0092] Here, when the identity verification is passed, the display data is displayed on the data display page, and the outline of each selection box in the mask is also displayed, wherein the mask is transparent, and the existence of the mask does not affect the problem troubleshooter to view the display data. The mask includes at least one selection box, and each selection box corresponds to a specific area on the data display page, that is, the wheel frame of each selection box corresponds to the specific area, and a certain amount of display data is selected in the specific area of ​​each selection box. When the identity verification fails, the mask is hidden, that is, the mask is invisible, and the user can only see the display data on the data display page.

[0093] Figure 6 is an optional flow chart of the data problem troubleshooting method provided in the embodiment of the present application, such as Figure 6 As shown, the method comprises the following steps:

[0094] Step S601: receiving a data search request, wherein the data search request includes a check box identifier.

[0095] Step S602 , in response to the data troubleshooting request, determining a target selection box corresponding to the selection box identifier in a mask corresponding to the data display page for the problem to be troubleshooted.

[0096] Step S603: determine the target database access interface corresponding to the target selection box.

[0097] Step S604: acquiring transmission data corresponding to the target selection box transmitted by the target database access interface.

[0098] It should be noted that steps S601 to S604 are the same as the above-mentioned steps S101 to S104, and will not be repeated in the embodiment of the present application.

[0099] Step S605, determining whether the transmission data is the same as the display data.

[0100] When the judgment result is yes, step S608 is executed; when the judgment result is no, it is determined that there is a front-end code problem in the display data.

[0101] Step S606: receiving log information, which may be real-time log information returned by the backend.

[0102] Step S607: display the transmission data and the log information in an information display pop-up window.

[0103] Here, the information display pop-up window can be divided into two parts, wherein the first part displays the transmission data, and the second part displays the log information. The first part and the second part do not overlap, and the display contents of the first part and the second part do not affect or conflict with each other.

[0104] Step S608: Use a preset regular expression to match the log information to retain information of a preset type.

[0105] A regular expression is a logical formula for operating on a string (including common characters (for example, letters from a to z) and special characters (called "meta-characters")). It uses some pre-defined specific characters and the combination of these specific characters to form a "regular string". This "regular string" is used to express a filtering logic for the string. A regular expression is a text pattern that describes one or more strings to be matched when searching for text.

[0106] In the embodiment of the present application, a regular expression can be predefined, and the log information can be filtered by the predefined regular expression to retain the information in the log information that meets the conditions, that is, to retain the information in the log information that belongs to the preset type. For example, only information of the database table name, query field, transmission parameter type and parameter value, error information, etc. can be retained.

[0107] Step S609: judging whether there is any error in the interface code according to the retained information of the preset type.

[0108] When the judgment result is yes, it is determined that there is a transmission parameter problem or an interface code problem in the display data; when the judgment result is no, step S610 is executed.

[0109] Step S610, determining whether the transmission data displayed in the information display pop-up window is empty.

[0110] When the judgment result is yes, it is determined that the display data has a data aggregation problem or a source file error loss problem; when the judgment result is no, when the data display page is refreshed so that the display data on the data display page is updated, return to continue executing step S605.

[0111] The data problem troubleshooting method provided in the embodiment of the present application obtains transmission data and log information respectively, and displays the transmission data and log information in an information display pop-up window. In this way, through the transmission data and log information displayed in the information display pop-up window, it is possible to troubleshoot the front-end code problems, parameter transmission problems or interface code problems, data aggregation problems or source file error loss problems of the data displayed in the data display page. That is, by displaying the transmission data and log information in the information display pop-up window, it is convenient for problem troubleshooters to troubleshoot the above-mentioned various problems. Therefore, the problem troubleshooting process is simplified and the problem troubleshooting efficiency is improved.

[0112] The following is an explanation of an exemplary application of an embodiment of the present application in a practical application scenario.

[0113] The embodiment of the present application provides a data problem troubleshooting method, which realizes rapid problem troubleshooting of displayed data on a data display page through a visualized data problem troubleshooting process.

[0114] Figure 7 is an optional flow chart of the data problem troubleshooting method provided in the embodiment of the present application, such as Figure 7 As shown, the method comprises the following steps:

[0115] Step S701, adding a mask covering the entire large screen in the large screen page (ie, the data display page), the mask is transparent and does not affect the problem troubleshooter from viewing the data on the original large screen page.

[0116] Step S702, open an account in the system where the large screen is located that only troubleshooters have permission to access. The large screen page accessed by this account may not display the mask mentioned in step S701 compared to ordinary users, and ordinary users do not have permission to see the mask.

[0117] Step S703, when troubleshooting a problem, the troubleshooter can call the database access interface corresponding to the corresponding module of the large screen by clicking the corresponding module (i.e., the selection box) of the overlay mask above the corresponding module of the large screen, and pass the same parameters (including parameters with the same data type, the same value, etc.) to the database access interface, obtain the same data, and pop up a new information display window.

[0118] Step S704, the information display pop-up window in step S703 is divided into two parts, the upper and lower parts. The data obtained from the database access interface is directly displayed in the upper part of the information display pop-up window without any processing, and is used to compare with the display data of the front-end page. By checking whether the data in the upper part of the information display pop-up window is the same as the display data of the front-end page, or whether a certain format processing has been performed, it is possible to check whether there is a front-end code problem in the display data of the front-end page.

[0119] Step S705: In the lower part of the information display pop-up window, the backend log is displayed in real time using websocket (a protocol for full-duplex communication on a single TCP connection) technology.

[0120] Here, you can write a front-end websocket to receive the back-end websocket. This front-end websocket and the back-end websocket are also a controller, but they are special because they communicate using the WS protocol (i.e., the websocket protocol). After the front-end receives the real-time log information returned by the back-end, it matches the regular expression and only retains key information such as the database table name, query field, transfer parameter type and parameter value, and error information. This information can be used to determine whether the interface code has an error, and whether the cause of the error is due to incorrect database table name, query field, transfer parameter type, parameter value, etc., so as to check whether it is an interface code problem or a front-end parameter transmission code problem.

[0121] Step S706, if the upper part of the data is empty, and the possibility of front-end code problems and interface code problems has been ruled out through steps S704 and S705, it can be directly determined that the back-end summary is wrong, or the source file is lost by mistake.

[0122] Figure 8 is an optional flow chart of the data problem troubleshooting method provided in the embodiment of the present application, such as Figure 8 As shown, when troubleshooting data problems, troubleshooters can use the following steps to troubleshoot the displayed data on the data display page:

[0123] Step S801: The problem troubleshooter logs into the troubleshooter account in the data problem troubleshooting system.

[0124] Step S802: click the corresponding mask on the module to be checked to select the corresponding box.

[0125] Step S803, compare the data displayed in the upper part of the information display pop-up window with the data displayed on the large screen to see if they are the same. If they are the same, execute step S804; if they are different, conclude that the front-end code displays data errors.

[0126] Step S804, determining whether the interface transfer parameter type and parameter value displayed in the lower half of the pop-up window are reasonable.

[0127] If the judgment is reasonable, step S805 is executed; if the judgment is unreasonable, it is concluded that the front-end code passes an error in parameters to the interface.

[0128] Step S805, determining whether the database table name and query fields displayed in the lower half of the pop-up window are reasonable.

[0129] If the judgment is reasonable, step S806 is executed; if the judgment is unreasonable, a conclusion is drawn that the structured query language (SQL) part in the interface code is wrong.

[0130] Step S806, determining whether the data displayed in the upper half of the pop-up window is empty.

[0131] When it is judged to be empty, it is concluded that the backend summary is wrong or the source file is wrong or the source file is lost; when it is judged not to be empty, it returns to continue to execute step S803.

[0132] The data problem troubleshooting method provided in the embodiment of the present application can directly locate the key points where the problem occurs on the page by adding a cover mask covering the entire large screen in the large screen page. The problem troubleshooter can independently complete the data problem troubleshooting process based on the mask, without having to repeatedly check the front-end and interface original code. The display of data obtained through the interface and the display of filtered system logs (extracted key information, such as the database table name, field and value and type of the parameter transmitted by the interface) can quickly locate the problem.

[0133] The method provided in the embodiment of the present application is different from the visual data troubleshooting method in the related art. It helps troubleshooters to quickly identify the database table name, field name and transmitted parameters involved in the problem, and then conduct troubleshooting without repeatedly looking for front-end and back-end personnel to cooperate, and without checking the original code.

[0134] Based on the foregoing embodiments, the embodiments of the present application provide a data problem troubleshooting device, which includes the modules included and the components included in the modules, and can be implemented by a processor in the data problem troubleshooting device; of course, it can also be implemented by a logic circuit; in the implementation process, the processor can be a central processing unit (CPU, Central Processing Unit), a microprocessor (MPU, Micro Processor Unit), a digital signal processor (DSP, Digital Signal Processing) or a field programmable gate array (FPGA, Field Programmable Gate Array), etc.

[0135] Fig. 9 is a schematic diagram of the structure of the data problem troubleshooting device provided in the embodiment of the present application, such as Fig. 9 As shown, the data problem troubleshooting device 900 includes:

[0136] A receiving module 901 is used to receive a data troubleshooting request; a first determining module 902 is used to determine, in response to the data troubleshooting request, a target selection box corresponding to the data troubleshooting request in a mask corresponding to the data display page; a second determining module 903 is used to determine a target database access interface corresponding to the target selection box; an acquiring module 904 is used to acquire transmission data corresponding to the target selection box transmitted by the target database access interface; a problem troubleshooting module 905 is used to troubleshoot the display data on the data display page according to the transmission data.

[0137] In some embodiments, the second determination module is further used to: obtain a mapping relationship between each selection box in the mask and a database access interface in a database access interface set; and determine the database access interface having the mapping relationship with the target selection box as the target database access interface.

[0138] In some embodiments, the device also includes: an adding module, used to add the mask having at least one selection box on the data display page; a third determining module, used to determine the position selected by any selection box in the at least one selection box on the data display page as the target position; a display data acquisition module, used to acquire the display data displayed on the data display page at the target position; a fourth determining module, used to determine, in the database access interface set, the database access interface used to transmit the display data as the database access interface corresponding to any selection box; and an associating module, used to associate each selection box with the database access interface corresponding to each selection box, so as to obtain a mapping relationship between each selection box and the database access interface in the database access interface set.

[0139] In some embodiments, the troubleshooting module is further used to: when the transmission data is completely or partially different from the display data, determine that there is a front-end code problem in the display data.

[0140] In some embodiments, the device also includes: a log information receiving module for receiving log information; the troubleshooting module is also used to: display the transmission data and the log information in an information display pop-up window; and perform troubleshooting on the display data on the data display page based on the transmission data and the log information displayed in the information display pop-up window.

[0141] In some embodiments, the troubleshooting module is also used for: when the transmission data is the same as the display data, using a preset regular expression to match the log information to retain information of a preset type; when it is determined that an interface code error exists based on the information of the preset type, determining that there is a problem with the transmission parameters or an interface code problem in the display data.

[0142] In some embodiments, the troubleshooting module is also used to: when the transmission data is the same as the display data, and the display data does not have the transmission parameter problem and the interface code problem, determine whether the transmission data displayed in the information display pop-up window is empty; when the transmission data displayed in the information display pop-up window is empty, determine that the display data has a data aggregation problem or a source file error loss problem.

[0143] In some embodiments, the device also includes: a conversion module, which is used to convert the transmission data into data having the same data format as the display data when the data format of the transmission data is different from the data format of the display data; and a first display module, which is used to display the converted transmission data in the information display pop-up window.

[0144] In some embodiments, the device also includes: an identity authentication request receiving module, used to receive an identity authentication request, wherein the identity authentication request includes an identifier of the identity to be authenticated; an identity authentication module, used to authenticate the identity to be authenticated based on the identifier of the identity to be authenticated; and a second display module, used to display the outline of each selection box in the mask on the data display page when the identity authentication is passed.

[0145] It should be noted that the description of the device of the embodiment of the present application is similar to the description of the above method embodiment, and has similar beneficial effects as the method embodiment, so it is not repeated. For technical details not disclosed in the embodiment of the device, please refer to the description of the method embodiment of the present application for understanding.

[0146] It should be noted that in the embodiments of the present application, if the above-mentioned data problem troubleshooting method is implemented in the form of a software function module and sold or used as an independent product, it can also be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the embodiment of the present application can be essentially or partly embodied in the form of a software product that contributes to the relevant technology. The computer software product is stored in a storage medium, including several instructions for a terminal to execute all or part of the methods described in each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as a U disk, a mobile hard disk, a read-only memory (ROM, Read Only Memory), a magnetic disk or an optical disk. In this way, the embodiments of the present application are not limited to any specific combination of hardware and software.

[0147] Correspondingly, the embodiment of the present application provides a data problem troubleshooting device, Fig.10 is a schematic diagram of the structure of the data problem troubleshooting device provided in the embodiment of the present application, such as Fig.10 As shown, the data problem troubleshooting device 1000 at least includes: a processor 1001, a communication interface 1002 and a computer-readable storage medium 1003 configured to store executable instructions, wherein the processor 1001 generally controls the overall operation of the data problem troubleshooting device. The communication interface 1002 enables the data problem troubleshooting device to communicate with other terminals or servers through a network. The computer-readable storage medium 1003 is configured to store instructions and applications executable by the processor 1001, and can also cache data to be processed or processed by each module in the processor 1001 and the data problem troubleshooting device 1000, which can be implemented through flash memory (FLASH) or random access memory (RAM, Random Access Memory).

[0148] It should be understood that "one embodiment" or "an embodiment" mentioned throughout the specification means that specific features, structures or characteristics related to the embodiment are included in at least one embodiment of the present application. Therefore, "in one embodiment" or "in an embodiment" appearing throughout the specification does not necessarily refer to the same embodiment. In addition, these specific features, structures or characteristics can be combined in one or more embodiments in any suitable manner. It should be understood that in various embodiments of the present application, the size of the sequence number of the above-mentioned processes does not mean the order of execution, and the execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application. The above-mentioned sequence numbers of the embodiments of the present application are only for description and do not represent the advantages and disadvantages of the embodiments.

[0149] It should be noted that, in this article, the terms "comprise", "include" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method or device including a series of elements includes not only those elements, but also includes other elements not explicitly listed, or also includes elements inherent to such process, method or device. In the absence of further restrictions, an element defined by the statement "comprises one..." does not exclude the presence of other identical elements in the process, method, article or device including the element. In several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. The device embodiments described above are merely schematic, for example, the division of the units is only a logical function division, and there may be other division methods in actual implementation, such as: multiple units or components can be combined, or can be integrated into another system, or some features can be ignored, or not executed.

[0150] The above is only an implementation method of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

Claims

1. A data problem troubleshooting method, characterized in that: include: Receive data search request; In response to the data troubleshooting request, determining a target selection box of the problem to be troubleshooted corresponding to the data troubleshooting request in a mask corresponding to the data display page; Determine a target database access interface corresponding to the target selection box; Acquire transmission data corresponding to the target selection box transmitted by the target database access interface; According to the transmission data, troubleshooting is performed on the display data on the data display page; The determining of the target database access interface corresponding to the target selection box includes: Obtaining a mapping relationship between each selection box in the mask and a database access interface in the database access interface set; Determine the database access interface having the mapping relationship with the target selection box as the target database access interface; Before obtaining the mapping relationship between each selection box in the mask and the database access interface in the database access interface set, the method further includes: Adding the mask having at least one selection box on the data display page; Determine the position selected by any one of the at least one selection box on the data display page as the target position; Acquire display data displayed by the data display page at the target position; In the database access interface set, the database access interface used for transmitting the display data is determined as the database access interface corresponding to any one of the selection boxes; Each of the selection boxes is associated with the database access interface corresponding to the selection box to obtain a mapping relationship between each of the selection boxes and the database access interface in the database access interface set.

2. The method according to claim 1, characterized in that The troubleshooting of the displayed data on the data display page according to the transmitted data includes: When the transmission data is completely or partially different from the display data, it is determined that there is a front-end code problem in the display data.

3. The method according to claim 1, characterized in that The method further includes: receiving log information; and troubleshooting the displayed data on the data display page according to the transmitted data, including: Displaying the transmission data and the log information in an information display pop-up window; According to the transmission data and the log information displayed in the information display pop-up window, troubleshoot the displayed data on the data display page.

4. The method according to claim 3, characterized in that The troubleshooting of the displayed data on the data display page according to the transmission data and the log information displayed in the information display pop-up window includes: When the transmission data is the same as the display data, a preset regular expression is used to match the log information to retain information of a preset type; When it is determined that an interface code error exists according to the information of the preset type, it is determined that a transmission parameter problem or an interface code problem exists in the display data.

5. The method according to claim 4, characterized in that The troubleshooting of the displayed data on the data display page according to the transmission data and the log information displayed in the information display pop-up window includes: When the transmission data is the same as the display data, and the display data does not have the transmission parameter problem and the interface code problem, determining whether the transmission data displayed in the information display pop-up window is empty; When the transmission data displayed in the information display pop-up window is empty, it is determined that the display data has a data aggregation problem or a source file error loss problem.

6. The method according to any one of claims 3 to 5, characterized in that: The method further comprises: When the data format of the transmission data is different from the data format of the display data, converting the transmission data into data having the same data format as the display data; The converted transmission data is displayed in the information display pop-up window.

7. The method according to claim 1, characterized in that The method further comprises: Receiving an identity verification request, wherein the identity verification request includes an identifier of an identity to be verified; Performing identity authentication on the identity to be verified according to the identifier of the identity to be verified; When the identity authentication is passed, the outline of each selection box in the mask is displayed on the data display page.

8. A data problem troubleshooting device, characterized in that: include: A receiving module, used for receiving a data search request; A first determination module is used to respond to the data troubleshooting request and determine a target selection box of the problem to be troubleshooted corresponding to the data troubleshooting request in a mask corresponding to the data display page; A second determination module, used to determine a target database access interface corresponding to the target selection box; The second determining module is further used for: Obtaining a mapping relationship between each selection box in the mask and a database access interface in the database access interface set; Determine the database access interface having the mapping relationship with the target selection box as the target database access interface; An adding module, used for adding the mask having at least one selection box on the data display page; A third determining module, configured to determine a position selected by any one of the at least one selection box on the data display page as a target position; A display data acquisition module, used to acquire display data displayed by the data display page at the target position; A fourth determining module, configured to determine, from the database access interface set, a database access interface for transmitting the display data as a database access interface corresponding to any one of the selection boxes; an associating module, used to associate each of the checkboxes with the database access interface corresponding to the checkboxes, so as to obtain a mapping relationship between each of the checkboxes and the database access interface in the database access interface set; An acquisition module, used for acquiring transmission data corresponding to the target selection box transmitted by the target database access interface; The troubleshooting module is used to troubleshoot the display data on the data display page according to the transmission data.

9. A data problem troubleshooting device, characterized in that: include: A memory for storing executable instructions; A processor, configured to implement the method according to any one of claims 1 to 7 when executing the executable instructions stored in the memory.

10. A computer-readable storage medium, characterized in that: Executable instructions are stored, which are used to cause a processor to execute the executable instructions to implement the method described in any one of claims 1 to 7.