METHOD AND SYSTEM FOR ROOT CAUSE ANALYSIS OF DATA PROBLEMS

• US 20120216081A1
• Filed: 02/17/2011
• Published: 08/23/2012
• Est. Priority Date: 02/17/2011
• Status: Abandoned Application

• Current Assignee: HCL America Incorporated (HCL Technologies Limited)
• Original Assignee: HCL America Incorporated (HCL Technologies Limited)
• Inventors: Duvvoori, Vikram, Chodavarapu, Prasad A., Mohan, Ram
• Application Number:
  US13/029,284
• Publication Number:
  US 20120216081A1
• Time in Patent Office: Days
• US Class Current: 714/48
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/103 Workflow collaboration or project management
• CPC Class Codes: G06Q 30/01 Customer relationship services

Abstract

A method and system comprising an issue report module to receive a data problem report indicative of the occurrence of a data problem during the performance of a process. The data problem report includes at least one descriptor to identify a problematic data item and may include at least one activity descriptor to identify a particular process activity during which the data problem was encountered. A root cause analysis engine performs automated root cause analysis based on the at least one descriptor of the problematic data item, to identify at least one potential cause of the data problem. The system may include at least one memory having stored thereon data dependency information which comprises, with respect to each of a plurality of entity attributes, information regarding process elements and/or process activities which contribute to the provisioning of data items which are instances of the respective entity attribute, automated root cause analysis being based on the data dependency information. The system may include a data issue repository comprising information regarding earlier data problem reports and respective results of root cause analyses.

Claims

1. A system comprising:

an issue report module to receive or generate a data problem report indicative of occurrence of a data problem during performance of a process, the data problem comprising unavailability or incorrectness of a problematic data item, the data problem report including at least one descriptor to identify the problematic data item; and

a computer including a root cause analysis engine to perform automated root cause analysis based at least in part on the at least one descriptor of the problematic data item, to identify at least one potential cause of the data problem indicated by the data problem report.

2. The system of claim 1, further comprising at least one memory having stored thereon data dependency information which comprises, with respect to each of a plurality of entity attributes, information regarding process elements and/or process activities which contribute to provisioning of data items which are instances of the respective entity attributes, the root cause analysis engine to perform the automated root cause analysis based at least in part on the data dependency information.

3. The system of claim 2, wherein the at least one descriptor of the problematic data item comprises at least one of:

an entity instance identifier to identify a particular entity associated with the problematic data item, an attribute identifier to identify an entity attribute of which the problematic data item is an instance, and a failure type identifier to identify an associated type of data problem.

4. The system of claim 2, wherein the data problem report includes an entity instance identifier to identify a particular entity associated with the problematic data item, and an attribute identifier to identify an entity attribute of which the problematic data item is an instance.

5. The system of claim 2, wherein the data problem report further includes at least one activity descriptor identifying a particular process activity in which the data problem was encountered.

6. The system of claim 5, wherein the data dependency information comprise, with respect to each of a plurality of process activities, data dependencies for data items associated with the respective process activities, the root cause analysis engine being configured to perform the automated root cause analysis based at least in part on the at least one activity descriptor.

7. The system of claim 1, wherein the data problem report includes a suggested value for the problematic data item.

8. The system of claim 2, wherein the root cause analysis engine is to produce a listing of process activities and/or process elements which contribute, based on the data dependency information, to provisioning of the problematic data item.

9. The system of claim 2, wherein the issue report module is to require, in response to entry of information regarding the data problem, input with respect to the at least one descriptor.

10. The system of claim 9, wherein the issue report module is to require input with respect to the a minimum required descriptors by providing a predetermined list of options from which a particular option is to be selected, and receiving input indicating selection of the particular option.

11. The system of claim 10, wherein the issue report module is to generate the predetermined list of options with reference to an enterprise data model which contains information regarding predefined descriptors for identifying the problematic data item.

12. The system of claim 10, wherein the issue report module is to generate the predetermined list of options with reference to, at least, process management information which contains information regarding predefined activity descriptors to identify a particular process activity in which the data problem was encountered.

13. The system of claim 1, further comprising:

a data issue repository comprising information regarding earlier data problem reports and respective results of root cause analyses previously performed with respect to the earlier data problem reports; and

a data issue query module to query the data issue repository upon receiving the data problem report, to identify similar earlier data problems, and in response to identifying a similar earlier data problem report in the data issue repository, providing as a result of the root cause analysis with respect to the data problem report the results of root cause analyses previously performed with respect to the similar earlier data problem report.

14. The system of claim 8, further comprising:

a parsing module to parse process logs of an automated process activity identified in the listing, to identify an exception indicating an instance of malperformance of the automated process activity; and

a re-triggering module to re-trigger execution of the automated process activity.

15. The system of claim 14, further comprising a remediation module to execute a remediation script to remediate a process failure resulting from the data problem indicated in the data problem report.

16. A computer-implemented method comprising:

receiving a data problem report indicative of occurrence of a data problem during performance of a process, the data problem comprising unavailability or incorrectness of a problematic data item, the data problem report including at least one descriptor to identify the problematic data item; and

performing automated root cause analysis to identify at least one potential cause of the data problem indicated by the data problem report, the root cause analysis being based at least in part on the at least one descriptor of the problematic data item.

17. The computer-implemented method of claim 16, wherein the root cause analysis is based at least in part on data dependency information which comprises, for each of a plurality of entity attributes, information regarding process elements and/or process activities which contribute to provisioning of data items which are instances of the respective entity attributes the at least one descriptor of the problematic data item comprises at least one of:

an entity instance identifier to identify a particular entity associated with the problematic data item, an attribute identifier to identify an entity attribute of which the problematic data item is an instance, and a failure type identifier to identify an associated type of data problem.

18. The computer-implemented method of claim 17, wherein the at least one descriptor of the problematic data item comprises at least one of:

an entity instance identifier to identify a particular entity associated with the problematic data item, an attribute identifier to identify an entity attribute of which the problematic data item is an instance, and a failure type identifier to identify an associated type of data problem.

19. The computer-implemented method of claim 17, wherein the data problem report further includes at least one activity descriptor identifying a particular process activity in which the data problem was encountered.

20. The computer-implemented method of claim 19, wherein the data dependency information comprise, with respect to each of a plurality of process activities, data dependencies for data items associated with the respective process activities, the root cause analysis engine being configured to perform the automated root cause analysis based at least in part on the at least one activity descriptor.

21. The computer-implemented method of claim 16, wherein the data problem report includes a suggested value for the problematic data item.

22. The computer-implemented method of claim 17, further comprising producing, as a result of the automated root cause analysis, a listing of process activities and/or process elements which contribute, based on the data dependency information, to provisioning of the problematic data item.

23. The computer-implemented method of claim 17, further comprising, in response to entry of information regarding the data problem, requiring input with respect to the at least one descriptor of the problematic data item and at least one activity descriptor identifying a particular process activity in which the data problem was encountered, and associating the at least one descriptor of the problematic data item and the at least one activity descriptor with the entered information regarding the data problem, to generate the data problem report.

24. The computer-implemented method of claim 23, wherein requiring input with respect to the at least one descriptor of the problematic data item and the at least one descriptor identifying the process activity in which the data problem was encountered comprises providing at least one predetermined list of options from which a particular option is to be selected, and receiving input indicating selection of the particular option.

25. The computer-implemented method of claim 24, wherein a predetermined list of options for the at least one descriptor of the problematic data item is generated with reference to an enterprise data model which contains information regarding predefined descriptors.

26. The computer implemented method of claim 22, wherein a predetermined list of options for the at least one activity descriptor is generated with reference to process management information which contains information regarding predefined activity descriptors.

27. The computer-implemented method of claim 16, further comprising:

a upon receiving the data problem report, querying a data issue repository based at least in part on the at least one descriptor of the problematic data item, to identify similar earlier data problems, the data issue repository comprising a record of earlier data problem reports together with respective results of root cause analyses previously performed with respect to the earlier data problem reports; and

in response to identifying a similar earlier data problem report in the data issue repository, providing as a result of the root cause analysis with respect to the data problem report the results of root cause analyses previously performed with respect to the similar earlier data problem report.

28. The computer-implemented method of claim 27, further comprising adding to the data issue repository information regarding the data problem indicated by the data problem report, together with results of the associated root cause analysis.

29. The computer-implemented method of claim 22, further comprising:

parsing process logs of an automated process activity identified in the listing, to identify an exception indicating an instance of malperformance of the activity; and

re-triggering execution of the activity.

30. The computer-implemented method of claim 29, further comprising executing a remediation script to remediate a process failure resulting from the data problem indicated in the data problem report.

31. A non-transitory machine-readable storage medium storing instructions which, when performed by a machine, cause the machine to:

receive a data problem report indicative of occurrence of a data problem during performance of a process, the data problem comprising unavailability or incorrectness of a problematic data item, the data problem report including at least one descriptor to identify the problematic data item; and

perform automated root cause analysis to identify at least one potential cause of the data problem indicated by the data problem report, the root cause analysis being based at least in part on the at least one descriptor of the problematic data item.

32. A system comprising:

means for receiving a data problem report indicative of occurrence of a data problem during performance of a process, the data problem comprising unavailability or incorrectness of a problematic data item, the data problem report including at least one descriptor to identify the problematic data item; and

means for performing automated root cause analysis to identify at least one potential cause of the data problem indicated by the data problem report, the root cause analysis being based at least in part on the at least one descriptor of the problematic data item.