WO2008042428A2 - Process automation system and method employing multi-stage report generation - Google Patents

Process automation system and method employing multi-stage report generation Download PDF

Info

Publication number
WO2008042428A2
WO2008042428A2 PCT/US2007/021314 US2007021314W WO2008042428A2 WO 2008042428 A2 WO2008042428 A2 WO 2008042428A2 US 2007021314 W US2007021314 W US 2007021314W WO 2008042428 A2 WO2008042428 A2 WO 2008042428A2
Authority
WO
WIPO (PCT)
Prior art keywords
properties
diagnostics information
log file
property
machine
Prior art date
Application number
PCT/US2007/021314
Other languages
French (fr)
Other versions
WO2008042428A3 (en
Inventor
John Ousterhout
Anders Wallgren
Sandeep Tamhankar
Scott Stanton
Usman Muzaffar
Original Assignee
Electric Cloud, Inc.
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Electric Cloud, Inc. filed Critical Electric Cloud, Inc.
Publication of WO2008042428A2 publication Critical patent/WO2008042428A2/en
Publication of WO2008042428A3 publication Critical patent/WO2008042428A3/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Definitions

  • This invention relates generally to the field of computer aided software engineering. More particularly, the invention relates to managing distributed processes in a process automation system.
  • Process automation systems are used to perform a variety of computerized tasks.
  • software developers use process automation systems to build, test and package software applications.
  • the functions performed by these systems may include managing source code; building executable files; executing tests on the software builds; collecting and analyzing diagnostic information related to the builds; and generating detailed reports.
  • FIG. 1 illustrates one such system developed by BuildForge, Inc. (recently acquired by International Business Machines, Inc).
  • a central database 110 enables communication between the jobs 101-103 and allocates resources to each of the jobs upon request. For example, when a job requires access to a particular resource, it opens a connection to the database 110 and executes a query to determine if that resource is available. If the resource is not available, the job waits for a period of time and then checks the database 110 again. Once the resource becomes available, it is allocated to the job and the information needed to complete the job (e.g., source files, environmental variables, etc) is retrieved from the database. The database is then updated to reflect the allocation of the resource to the new job.
  • the information needed to complete the job e.g., source files, environmental variables, etc
  • one embodiment of the invention implements a general purpose property mechanism in which arbitrary data is attached to any object in the system (e.g., projects, procedures, jobs, job steps, resources, etc), thereby providing a convenient way to configure the system without modifying the underlying program code.
  • a three-tier hierarchy of data object is employed: "projects,” “procedures,” and “steps” (or “projects,” “jobs” and “job steps” during runtime).
  • a property may be attached to any object on any tier of the hierarchy to configure that object and (potentially) all of the objects which reference the property.
  • the properties and property sheets may be attached both statically (before runtime) and dynamically (during runtime).
  • one embodiment of the invention employs a unique property substitution syntax to allow the value for a particular property to be located and substituted dynamically at runtime.
  • FIG. 1 illustrates an exemplary prior art distributed process automation system.
  • FIG. 2a illustrates a system architecture according to one embodiment of the invention.
  • FIG. 2b illustrates a central command server according to one embodiment of the invention.
  • FIG. 2c illustrates one embodiment of the invention in which one or more of the agents are configured as build machines for performing program builds.
  • FIG. 2d illustrates a Web-based graphical user interface employed in one embodiment of the invention.
  • FIGS. 3a-b illustrate property attachment mechanisms employed in one embodiment of the invention.
  • FIG. 4 illustrates a property sheet hierarchy employed in one embodiment of the invention.
  • FIG. 5 illustrates a parameter substitution syntax employed in one embodiment of the invention.
  • FIG. 6 illustrates data gathering and report generation employed in one embodiment of the invention.
  • FIG. 7 illustrates a first report generated in accordance with one embodiment of the invention.
  • FIG. 8 illustrates a second report generated in accordance with one embodiment of the invention.
  • one embodiment of the invention implements a general purpose property mechanism in which arbitrary data is attached to any object in the system (e.g., projects, procedures, jobs, job steps, resources, etc), thereby providing a convenient way to configure the system without modifying the underlying program code.
  • a three-tier hierarchy of data object is employed: "projects,” “procedures,” and “steps” (or “projects,” “jobs” and “job steps” during runtime).
  • a property may be attached to any object on any tier of the hierarchy to configure that object and (potentially) all of the objects which reference the property.
  • the properties and property sheets may be attached both statically (before runtime) and dynamically (during runtime).
  • one embodiment of the invention employs a unique property substitution syntax to allow the value for a particular property to be located and substituted dynamically at runtime.
  • report generation process is logically separated into a data gathering stage and a report generation stage.
  • the data gathering stage extracts certain specified metrics and diagnostic information from each job step.
  • the extracted information is then stored in a highly flexible, reusable data format which is used to create different types of user- configurable reports.
  • Figure 2a illustrates a system architecture according to one embodiment of the invention which includes a central command server 200, a Web server 201 , a central database 210, a command line tool 202, and a plurality of system agents 230-234 (sometimes referred to as system “resources”) which communicate with the central command server over a network 220.
  • a central command server 200 a Web server 201 , a central database 210, a command line tool 202, and a plurality of system agents 230-234 (sometimes referred to as system “resources”) which communicate with the central command server over a network 220.
  • system agents 230-234 sometimes referred to as system "resources”
  • the central command server 200 implements the various property management techniques described below and acts as a central arbiter for access to both the central database 210 and the system agents 230-234.
  • the central command server 200 includes property attachment logic 250 for executing the property attachment mechanisms described herein; parameter substitution logic 252 for substituting parameters within projects, procedures, jobs, and steps using properties; scheduling logic 251 for executing jobs on the agents 230-234 based on a predefined execution schedule; and resource management logic 253 for continually monitoring the state of each of the agents 230- 234 and initiating new jobs only when resources for those jobs are available.
  • Figure 2b also illustrates post-processing logic 260 comprised of a post-processing engine 254 for gathering and processing data related to the execution of each job step; and a report generator 255 for generating associated reports.
  • post-processing logic 260 comprised of a post-processing engine 254 for gathering and processing data related to the execution of each job step; and a report generator 255 for generating associated reports. The details of each of these system components will be described in detail below.
  • the Web server 201 provides a graphical Web-based interface to control the central command server.
  • the Web server 201 allows users to enter execution schedules (e.g., nightly builds, tests, etc); manually initiate projects and procedures; associate properties (and property sheets) with objects; and review logs and reports.
  • An exemplary Web-based user interface is illustrated in Figure 2d which includes a listing of each of the custom properties 391 associated with a particular procedure.
  • a "create new property" link 290 is provided to allow the user to specify additional properties and attach the properties to the procedure.
  • the link 290 is selected, the user is provided with a set of data entry fields (not shown) in which to enter the name/value pairs for each property.
  • the command line tool 202 provides similar functionality to the Web server but using shell commands rather than graphical user interface elements. It should be noted, however, that the underlying principles of the invention are not limited to any particular type of user interface.
  • the central database 210 is a relational database such as those currently available from Oracle, Microsoft, and IBM. In another embodiment, the MySqI database is used.
  • the central command server 200 communicates with the central database 210 using standard Relational Database Management System (RDBMS) commands and queries.
  • RDBMS Relational Database Management System
  • any type of database system may be employed while still complying with the underlying principles of the invention.
  • the central database 210 stores information about all of the objects in the system such as projects, procedures, steps, schedules, and jobs.
  • Information stored in the database falls into four general classes: a description of the various processes to be executed (procedures, steps, etc); information about when to execute the various processes (schedules); and information about the results of executing processes (results of the jobs and job steps); and administrative information such as information related to users and groups.
  • the network 220 is an Ethernet network for coupling the central command server to each of the agents 230-234 (e.g., a 100Mbit/s or 1000Mbit/s network).
  • the agents 230-234 may be heterogeneous servers, equipped with different operating systems and/or processing capabilities.
  • the agents 230-234 may include Solaris machines, Windows machines (e.g., Windows XP, 2003, etc), and Linux machines.
  • the particular type of machine on which a job is to execute may be specified by the user via the Web server 201 and command-line tool 202 and/or may be selected automatically by the central command server 200 based on the resource requirements of the job. Although only five agents are illustrated in Figure 2a, virtually any number of agents may be coupled to the system while still complying with the underlying principles of the invention.
  • One or more of the agents 230-234 may be configured as "build machines" for performing program builds in response to commands from the command server 200 and/or the user.
  • Figure 2c illustrates one such implementation in which an agent 234 initiates and controls a program build by executing jobs in parallel across a series of nodes 260-265.
  • the cluster manager 270 illustrated in Figure 2c monitors the status of each of the nodes and allocates nodes to the build machine 234 upon request.
  • the cluster manager 270 may be implemented as a module within the central command server 200.
  • the build machine 234, cluster manager 270 and nodes 260-265 operate as described in US Patent No. 7,086,063, Serial No. 10/397, 139, entitled SYSTEM AND METHOD FOR FILE CACHING IN A DISTRIBUTED PROGRAM BUILD ENVIRONMENT, which is assigned to the assignee of the present application and which is incorporated herein by reference.
  • One additional implementation in which source files are exchanged directly between nodes is described in the co-pending patent application entitled A SYSTEM AND METHOD FOR INTELLIGENTLY DISTRIBUTING SOURCE FILES WITHIN A DISTRIBUTED BUILD ENVIRONMENT, Serial No. 10/715,974, Filed November 17, 2003, which is also assigned to the assignee of the present application and which is incorporated herein by reference.
  • the property attachment logic 250 within the central command server 200 implements a general purpose property mechanism in which arbitrary data may be attached to any object in the system.
  • One exemplary multi-tiered architecture illustrated in Figure 3a, includes a "resource” object 302 with a group of attached properties 303a- b and a "project” object 304 with a group of attached properties 305a-b.
  • the resource object 302 represents a particular resource in the system (e.g., a particular agent 230-234) and the properties 303a-b associated with the resource object 302 are values defining attributes of the resource.
  • property 303a may represent a particular platform (e.g., Solaris) and property 303b may represent a version number (e.g., version 3.4).
  • Various other resource-specific properties may be attached to the resource object 302 while still complying with the underlying principles of the invention (e.g., memory size, processor type/speed, last job executed on the resource, etc).
  • the project object 304 which is at the top of the multi-tier hierarchy mentioned previously, represents a particular project designed by a user.
  • the project may include one or more "procedures” and each procedure may include one or more "steps.”
  • each project object 304 is associated with one or more "procedure” objects 306, 308, 310 which represent procedures to be executed on the system resources (i.e., the agents 230-234).
  • each procedure object is associated with one or more "step” objects 312, 314, 316, which represent one or more commands to be executed by the system resources.
  • properties 307, 309a-b, 311 and 313a-b, 315a-b, 317 may be associated with the procedure objects 306, 308, 310 and step objects 313, 314, 316, respectively.
  • the central command server 200 manages the property attachment process using the central database 210. Specifically, in one embodiment, tables are maintained within the central database 210 which contain steps, procedures, projects, properties, and properties.
  • the container objects that associate the properties for a particular object are referred to as "property sheets.”
  • the tables managed by the database mimic the hierarchy illustrated in Figure 3a.
  • Each object in the system has a property sheet associated with it by default.
  • Project objects 304 for example, are stored in the database with their property sheets.
  • Database joins are used to attach a particular object to a property sheet that stores its properties.
  • a property is attached to a particular object by specifying the property name and the object name to the central command server 200 (e.g., "set property X on object Y"). The central command server 200 then "attaches" the property to that object.
  • Figure 4 illustrates the structure of an exemplary property sheet as well as the hierarchical relationships which may exist between property sheets.
  • a property sheet 400 is identified by its name and is comprised of a series of name/value pairs 401.
  • the names/values represent the properties associated with a particular object (e.g., version number, resource type, etc).
  • Certain entries within a property sheet may point to other property sheets.
  • the entry identified by "Name 5" includes a pointer, "Pointer 5,” which points to property sheet 410.
  • property sheet 410 includes an entry identified by "Name 6" which includes a pointer, "Pointer 6" which points to property sheet 420.
  • hierarchical relationships between property sheets are defined using pointers which point to other property sheets.
  • the hierarchical relationships between the objects are used to identify the properties associated with the objects.
  • Objects lower in the hierarchy use properties attached to objects further up the hierarchy.
  • each of the steps 312, 314, 316 use property 307 attached to procedure 306.
  • the property 307 specifies a particular repository for source code (e.g., repository. P4. electric, com)
  • each of the steps will use that repository.
  • the property 307 specifies a particular platform (e.g., Linux), then each of the steps will use that platform.
  • all of the procedures and steps under project 304 will use its properties 305a-b.
  • a "job” is a runtime implementation of a procedure - i.e., it is an "instance” of that procedure.
  • a "job step” is a runtime implementation of a procedure step. This relationship is illustrated generally in Figure 3b in which job 326 is a runtime instance of procedure 306 and job steps 322, 324, 326 are runtime instances of steps 312, 314, 316, respectively.
  • properties 313, 313b, 313c, 315c, 317c are dynamically generated and attached to jobs, job steps and/or other objects during runtime (i.e., rather than statically, prior to runtime).
  • the dynamically generated properties may be used for a variety of purposes including data collection during execution, passing information between jobs/job steps during execution and setting parameters within jobs and job steps prior to execution.
  • a job step may be programmed to attach a first property identifying the time that the job step started executing and a second property indicating the time that the job completed execution.
  • the job step may attach/update properties which indicate the number of compiles executed, the number of tests run, the number of errors or warnings triggered, etc, after the job step has completed executing.
  • this information is collected by the central command server 200 and stored back into the central database 210 upon completion of the job step. The collected information may then be used for analysis and report generation following the completion of a project (as described in greater detail below).
  • the property mechanism may be used to pass information between jobs, job steps and other objects during runtime and/or prior to runtime. For example, if two or more job steps need to be executed on the same resource, then the first job step may dynamically attach a property identifying the resource. The property will then be used by the other job steps to identify the resource on which to execute. Similarly, if the other job steps rely on the start time of the first job, then the first job may dynamically attach a property indicating the start time. The properties may be attached to the individual job steps or to the job with which the job steps are associated. A virtually unlimited number of different types of properties may be set by job steps in this manner.
  • parameters may be set prior to the execution of a job or job step.
  • a "parameter” is a special type of property which is substituted by the server at job creation time and is unique to the job. For example, a user may wish to run a job or job step on a particular version of software and/or on a particular platform (e.g., Solaris, version 3.14). As such, the user may pass in a parameter prior to execution which is stored as a property of the job. Upon execution, the job and/or job step is executed with the new set of parameters.
  • one embodiment of the invention includes property substitution logic 252 for substituting property values from procedure steps to job steps during runtime using a unique substitution syntax.
  • a procedure step 500 when defined, it typically includes at least one command to be executed 501 and a resource on which to execute the command 502.
  • the values of the commands and resources may be specified explicitly or, alternatively, the substitution syntax may be employed to generate the values dynamically at runtime by combining property values with fixed text..
  • the syntax $[string] instructs the property substitution logic 252 to find the value of the property which is referenced inside of the brackets and use that value in place of the $[string] entry.
  • the property substitution logic 252 scans through the job step 500 and wherever it sees the $[string] syntax, it searches for and substitutes the value. In the illustrated example, when it locates the platform property, it makes the substitution within the job step.
  • the parameter substitution logic 252 searches for a Resource Name property and, when located, replaces the $[resName] entry with the identity of a physical resource on the system.
  • the properties described above are stored in one or more property sheets within the central database 210.
  • procedures are parameterized and stored within the central database 210.
  • a first step in a job may be configured to attach a time limit property which is respected by all other steps.
  • a job step may also be configured to invoke another procedure, the name of which is stored in the system as a property.
  • a hierarchical naming system is employed to identify a specific point in the hierarchy in which to look for a property (rather than merely lookup up the hierarchy). For example, the format $[/projects/foo/procedures/bar/xyz] uses slashes to separate different property sheets.
  • the parameter substitution logic 252 searches through projects to find project foo; searches through procedures within foo to identify the procedure named bar, and then identifies the value in that procedure for property xyz. The property substitution logic 252 then substitutes that value within the job step.
  • the substitution syntax uses starting points, or "roots" which indicate where to lookup the first element in the property pathname.
  • roots may be defined such as “/projects,” “/myResource,” and “/myJob.”
  • a root is not specified, then one is implied from the context. For example, if the property "foo" is requested from within a running job step, then the command server starts in the job step and searches up the hierarchy as described above.
  • the property attachment logic 250 may first look for the named property in the procedure for which the parameter is defined. If it is not found there then the property attachment logic 250 searches in the project containing the procedure.
  • it may first look in the job step, followed by the parameters for the job, then in the global properties for the job.
  • different search paths may be defined depending on the context in which the substitution is occurring.
  • Various generic system attributes may be identified in this manner. For example, like myResource (mentioned above), myJob identifies the current job, myProcedure identifies the current procedure; and myProject identifies the current project. Each of these attributes will have a different value depending on the current execution context. In one embodiment, words identifying these system attributes are reserved by the system (i.e., so that users cannot create jobs with these names). [0050] In one embodiment, the notion of "property" is generalized to include not just the extra custom information that users specify, but built-in system information as well. For example, the central command server 200 defines a field for each resource, "resourceName," that contains, the name of the resource.
  • this field may be accessed in the same way as a user-defined property, e.g., "/myResource/resourceName.”
  • each procedure, step, etc appears as a property sheet, whose individual properties include both the built-in system values and any user-defined values.
  • the term "attribute” is sometimes used herein when referring to a built-in value to distinguish it from a custom property.
  • one embodiment of the invention includes post-processing logic 260 comprised of a post processing engine 254 for collecting and formatting data from each job step and report generation logic 255 for generating reports using the formatted data.
  • the postprocessor 260 runs on the same machine as the job step whose output it is analyzing, and it runs after the job step itself completes.
  • the Job Step 601 will produce a log file 603 containing an indication of the commands which executed during the execution of the job step and the results (e.g., compiles, tests failed, tests passed, tests skipped, warnings, errors, etc).
  • useful information is embedded within the log file 603 but it is difficult to identify. For example, a user may be interested in specific errors or warnings which occurred during the execution of the job step but, in order to locate this information, the user must perform a manual search for specific text or other specific data patterns within the log file 603.
  • a post processor 604 scans through the log file 603 at the end of each job step, extracts the useful information from the log file 603, and stores the extracted information in a highly flexible, reusable data format. Specifically, as illustrated in Figure 6, the post processor 604 generates a set of properties 605 and a diagnostics file 606.
  • the set of properties 605 comprises user-specified variables which are particularly relevant to the job step 601. In the case of a program build operation, for example, the properties may include the number of compiles which executed, the number of tests run, and the number of errors and warnings. Once collected, the set of properties are then stored as a property sheet and attached to the job step 601 (as described above).
  • the post processor 604 extracts detailed blocks of information form the log file 603 which are related to one or more of the extracted properties. For example, in the case of a test failure, the post processor 604 may extract all of the information related to the reason for the failure and any additional pertinent information (e.g., such as the platform on which the failure occurred).
  • the diagnostics file 606 is an XML file; however, any convenient file format may be used.
  • the diagnostics file 606 information is stored as a set of properties within the central database 210.
  • the post processor 604 searches for specific strings and/or other data patterns within the log 603.
  • the post processor may search for strings indicating a compile operation (e.g., cl followed by a space for the Microsoft C compiler).
  • a first instance of the word "failed" in combination with another sequence of characters may indicate the start of information related to a test failure and a second instance of the word "failed" in combination with the sequence of characters may indicate the end of the information related to the test failure.
  • the post processor 694 extracts all of the information contained between the two instances of the word "failed." This is, of course, merely one example of how the post processor identifies the useful information within the log file. Various other well known pattern matching techniques may be employed to identify the useful information while still complying with the underlying principles of the invention. [0057]
  • the report generation logic 607 combines the information from both files to generate different types of reports 610-611. For example, the report generation logic may organize the properties in a high-level summary report containing links to the more detailed information from the diagnostic file 606.
  • FIG. 7 One particular type of report, illustrated in Figure 7, is a table with separate columns 701-704 for each type of platform and separate rows 700 for each job step.
  • a separate column is provided for a Solaris platform 701 , a Windows XP platform 702, a Windows 2003 platform, and a Linux platform 704.
  • each cell within the table represents the results of a different step executed on a different platform.
  • the cells may be color-coded to indicate the results of each of the steps. For example, in one embodiment, warnings are colored yellow, errors are colored red, successful operations (e.g., tests and compiles) are colored green, and steps which were not performed on a particular platform (e.g., the "no data" cells in Figure 7) are colored gray.
  • the report generation logic 607 reads properties from multiple steps to produce its report.
  • hyperlinks are inserted within certain cells that point to more detailed information from the diagnostics file 606.
  • the hyperlink is configured to point to the complete information related to a particular error, failure or warning within the diagnostics file.
  • Similar hyperlinks may be embedded to point to other pertinent information within the diagnostics file (successful tests, compiles, etc).
  • Figure 8 Another type of report is illustrated in Figure 8.
  • this report provides a more detailed, serial representation of each of the executed job steps and the associated results (e.g., start time, how long each job ran, commands executed, resources the job executed on, arguments for each procedure, etc).
  • the results are all properties 605 collected during the execution of each job step.
  • the listing of the more detailed report may be color-coded to indicate the results and hyperlinks may be inserted to point to more detailed information within the diagnostics file 606.
  • different report generators are used which not only format their output differently, but they gather and process the underlying data in very different ways. For example, one report generator may display the results of each step within a single job as described above. By contrast, another report generator may scan over all of the jobs over a specified time period (e.g., the last month) looking only at one particular step in each job, and produce summary information about the success or failure of that particular step over time.
  • a specified time period e.g., the last month
  • a separate post processor is run for every job step to gather the information for that step.
  • the user is provided a very concise description of the results of each step along with links to the more detailed information within the diagnostics file 606.
  • separating the reporting process into a data gathering step and a reporting step provides a more flexible architecture than prior systems. For example, new types of reports can easily be generated using the properties 605 and the diagnostics file 606 based on the specific needs of the end user.
  • central command server 200 may not necessarily be implemented as a separate physical "server.” Rather the term “server” is used broadly herein to refer to a software module which may be executed on any machine or group of machines.
  • Embodiments of the invention may include various steps as set forth above.
  • the steps may be embodied in machine-executable instructions.
  • the instructions can be used to cause a general-purpose or special-purpose processor to perform certain steps.
  • these steps may be performed by specific hardware components that contain hardwired logic for performing the steps, or by any combination of programmed computer components and custom hardware components.
  • Elements of the present invention may also be provided as a machine-readable medium for storing the machine-executable instructions.
  • the machine-readable medium may include, but is not limited to, floppy diskettes, optical disks, CD-ROMs, and magneto-optical disks, ROMs, RAMs, EPROMs, EEPROMs, magnetic or optical cards, propagation media or other type of media/machine-readable medium suitable for storing electronic instructions.
  • the present invention may be downloaded as a computer program which may be transferred from a remote computer (e.g., a server) to a requesting computer (e.g., a client) by way of data signals embodied in a carrier wave or other propagation medium via a communication link (e.g., a modem or network connection).
  • a remote computer e.g., a server
  • a requesting computer e.g., a client
  • a communication link e.g., a modem or network connection

Abstract

The embodiments of the invention described herein employ sophisticated techniques for managing distributed processes in a process automation system. Specifically, one embodiment of the invention implements a general purpose property mechanism in which arbitrary data is attached to any object in the system (e.g., projects, procedures, jobs, job steps, resources, etc.), thereby providing a convenient way to configure the system without modifyhg the underlying program code. In addition, advanced report generation techniques are described below in which the report generation process is logically separated into a data gathering stage and a report generation stage. The data gathering stage extracts (604) certain specified properties (605) and diagnostic information (606) from each job step (601). The extracted information is then stored in a highly flexible, reusable data format which is used to create (607) different types of user-configurable reports (610, 611 ).

Description

PROCESS AUTOMATION SYSTEM AND METHOD EMPLOYING MULTI-STAGE REPORT GENERATION
BACKGROUND Field of the Invention
[0001] This invention relates generally to the field of computer aided software engineering. More particularly, the invention relates to managing distributed processes in a process automation system.
Description of the Related Art
[0002] Process automation systems are used to perform a variety of computerized tasks. By way of example, software developers use process automation systems to build, test and package software applications. Within this context, the functions performed by these systems may include managing source code; building executable files; executing tests on the software builds; collecting and analyzing diagnostic information related to the builds; and generating detailed reports.
[0003] Given the size and complexity of many software projects, "distributed" process automation systems have been developed in which multiple independent jobs are executed concurrently on a set of shared resources (e.g., computer systems). Figure 1 illustrates one such system developed by BuildForge, Inc. (recently acquired by International Business Machines, Inc). In this system, multiple jobs 101-103 are executed concurrently in response to commands from a Web server 100. A central database 110 enables communication between the jobs 101-103 and allocates resources to each of the jobs upon request. For example, when a job requires access to a particular resource, it opens a connection to the database 110 and executes a query to determine if that resource is available. If the resource is not available, the job waits for a period of time and then checks the database 110 again. Once the resource becomes available, it is allocated to the job and the information needed to complete the job (e.g., source files, environmental variables, etc) is retrieved from the database. The database is then updated to reflect the allocation of the resource to the new job.
SUMMARY
[0004] The embodiments of the invention described herein employ sophisticated techniques for managing distributed processes in a process automation system. Specifically, one embodiment of the invention implements a general purpose property mechanism in which arbitrary data is attached to any object in the system (e.g., projects, procedures, jobs, job steps, resources, etc), thereby providing a convenient way to configure the system without modifying the underlying program code. In addition, in one embodiment, a three-tier hierarchy of data object is employed: "projects," "procedures," and "steps" (or "projects," "jobs" and "job steps" during runtime). A property may be attached to any object on any tier of the hierarchy to configure that object and (potentially) all of the objects which reference the property. The properties and property sheets may be attached both statically (before runtime) and dynamically (during runtime). Moreover, one embodiment of the invention employs a unique property substitution syntax to allow the value for a particular property to be located and substituted dynamically at runtime.
[0005] In addition, advanced report generation techniques are described below in which the report generation process is logically separated into a data gathering stage and a report generation stage. The data gathering stage extracts certain specified properties and diagnostic information from each job step. The extracted information is then stored in a highly flexible, reusable data format which is used to create different types of user- configurable reports.
BRIEF DESCRIPTION OF THE DRAWINGS
[0006] A better understanding of the present invention can be obtained from the following detailed description in conjunction with the following drawings, in which:
[0007] FIG. 1 illustrates an exemplary prior art distributed process automation system.
[0008] FIG. 2a illustrates a system architecture according to one embodiment of the invention.
[0009] FIG. 2b illustrates a central command server according to one embodiment of the invention.
[0010] FIG. 2c illustrates one embodiment of the invention in which one or more of the agents are configured as build machines for performing program builds.
[0011] FIG. 2d illustrates a Web-based graphical user interface employed in one embodiment of the invention.
[0012] FIGS. 3a-b illustrate property attachment mechanisms employed in one embodiment of the invention.
[0013] FIG. 4 illustrates a property sheet hierarchy employed in one embodiment of the invention. [0014] FIG. 5 illustrates a parameter substitution syntax employed in one embodiment of the invention.
[0015] FIG. 6 illustrates data gathering and report generation employed in one embodiment of the invention.
[0016] FIG. 7 illustrates a first report generated in accordance with one embodiment of the invention.
[0017] FIG. 8 illustrates a second report generated in accordance with one embodiment of the invention.
DETAILED DESCRIPTION
[0018] In the following description, for the purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced without some of these specific details. In other instances, well-known structures and devices are shown in block diagram form to avoid obscuring the underlying principles of the present invention.
A SYSTEM AND METHOD FOR MANAGING DISTRIBUTED PROCESSES IN A PROCESS AUTOMATION SYSTEM
[0019] The embodiments of the invention described below employ sophisticated techniques for managing distributed processes in a process automation system. Specifically, one embodiment of the invention implements a general purpose property mechanism in which arbitrary data is attached to any object in the system (e.g., projects, procedures, jobs, job steps, resources, etc), thereby providing a convenient way to configure the system without modifying the underlying program code. In addition, in one embodiment, a three-tier hierarchy of data object is employed: "projects," "procedures," and "steps" (or "projects," "jobs" and "job steps" during runtime). A property may be attached to any object on any tier of the hierarchy to configure that object and (potentially) all of the objects which reference the property. The properties and property sheets may be attached both statically (before runtime) and dynamically (during runtime). Moreover, one embodiment of the invention employs a unique property substitution syntax to allow the value for a particular property to be located and substituted dynamically at runtime.
[0020] In addition, advanced report generation techniques are described below in which the report generation process is logically separated into a data gathering stage and a report generation stage. The data gathering stage extracts certain specified metrics and diagnostic information from each job step. The extracted information is then stored in a highly flexible, reusable data format which is used to create different types of user- configurable reports.
1. System Architecture
[0021] Figure 2a illustrates a system architecture according to one embodiment of the invention which includes a central command server 200, a Web server 201 , a central database 210, a command line tool 202, and a plurality of system agents 230-234 (sometimes referred to as system "resources") which communicate with the central command server over a network 220.
[0022] The central command server 200 implements the various property management techniques described below and acts as a central arbiter for access to both the central database 210 and the system agents 230-234. As illustrated in Figure 2b, the central command server 200 includes property attachment logic 250 for executing the property attachment mechanisms described herein; parameter substitution logic 252 for substituting parameters within projects, procedures, jobs, and steps using properties; scheduling logic 251 for executing jobs on the agents 230-234 based on a predefined execution schedule; and resource management logic 253 for continually monitoring the state of each of the agents 230- 234 and initiating new jobs only when resources for those jobs are available. Figure 2b also illustrates post-processing logic 260 comprised of a post-processing engine 254 for gathering and processing data related to the execution of each job step; and a report generator 255 for generating associated reports. The details of each of these system components will be described in detail below.
[0023] Returning again to Figure 2a, the Web server 201 provides a graphical Web-based interface to control the central command server. For example, the Web server 201 allows users to enter execution schedules (e.g., nightly builds, tests, etc); manually initiate projects and procedures; associate properties (and property sheets) with objects; and review logs and reports. An exemplary Web-based user interface is illustrated in Figure 2d which includes a listing of each of the custom properties 391 associated with a particular procedure. A "create new property" link 290 is provided to allow the user to specify additional properties and attach the properties to the procedure. In one embodiment, when the link 290 is selected, the user is provided with a set of data entry fields (not shown) in which to enter the name/value pairs for each property. [0024] The command line tool 202 provides similar functionality to the Web server but using shell commands rather than graphical user interface elements. It should be noted, however, that the underlying principles of the invention are not limited to any particular type of user interface.
[0025] In one embodiment of the invention, the central database 210 is a relational database such as those currently available from Oracle, Microsoft, and IBM. In another embodiment, the MySqI database is used. Thus, in one embodiment, the central command server 200 communicates with the central database 210 using standard Relational Database Management System (RDBMS) commands and queries. However, virtually any type of database system may be employed while still complying with the underlying principles of the invention.
[0026] The central database 210 stores information about all of the objects in the system such as projects, procedures, steps, schedules, and jobs. Information stored in the database falls into four general classes: a description of the various processes to be executed (procedures, steps, etc); information about when to execute the various processes (schedules); and information about the results of executing processes (results of the jobs and job steps); and administrative information such as information related to users and groups.
[0027] In one embodiment of the invention, the network 220 is an Ethernet network for coupling the central command server to each of the agents 230-234 (e.g., a 100Mbit/s or 1000Mbit/s network). However, virtually any network hardware or protocols may be used. One particular implementation runs over TCP/IP, and uses HTTP for the basic exchange mechanism, with XML used to represent the data injthe messages. [0028] The agents 230-234 may be heterogeneous servers, equipped with different operating systems and/or processing capabilities. For example, the agents 230-234 may include Solaris machines, Windows machines (e.g., Windows XP, 2003, etc), and Linux machines. The particular type of machine on which a job is to execute may be specified by the user via the Web server 201 and command-line tool 202 and/or may be selected automatically by the central command server 200 based on the resource requirements of the job. Although only five agents are illustrated in Figure 2a, virtually any number of agents may be coupled to the system while still complying with the underlying principles of the invention.
[0029] One or more of the agents 230-234 may be configured as "build machines" for performing program builds in response to commands from the command server 200 and/or the user. Figure 2c illustrates one such implementation in which an agent 234 initiates and controls a program build by executing jobs in parallel across a series of nodes 260-265. The cluster manager 270 illustrated in Figure 2c monitors the status of each of the nodes and allocates nodes to the build machine 234 upon request. The cluster manager 270 may be implemented as a module within the central command server 200.
[0030] In one embodiment, the build machine 234, cluster manager 270 and nodes 260-265 operate as described in US Patent No. 7,086,063, Serial No. 10/397, 139, entitled SYSTEM AND METHOD FOR FILE CACHING IN A DISTRIBUTED PROGRAM BUILD ENVIRONMENT, which is assigned to the assignee of the present application and which is incorporated herein by reference. One additional implementation in which source files are exchanged directly between nodes is described in the co-pending patent application entitled A SYSTEM AND METHOD FOR INTELLIGENTLY DISTRIBUTING SOURCE FILES WITHIN A DISTRIBUTED BUILD ENVIRONMENT, Serial No. 10/715,974, Filed November 17, 2003, which is also assigned to the assignee of the present application and which is incorporated herein by reference.
2. Property Attachment and Management
[0031] As mentioned above, the property attachment logic 250 within the central command server 200 implements a general purpose property mechanism in which arbitrary data may be attached to any object in the system. One exemplary multi-tiered architecture, illustrated in Figure 3a, includes a "resource" object 302 with a group of attached properties 303a- b and a "project" object 304 with a group of attached properties 305a-b.
[0032] The resource object 302 represents a particular resource in the system (e.g., a particular agent 230-234) and the properties 303a-b associated with the resource object 302 are values defining attributes of the resource. For example, property 303a may represent a particular platform (e.g., Solaris) and property 303b may represent a version number (e.g., version 3.4). Various other resource-specific properties may be attached to the resource object 302 while still complying with the underlying principles of the invention (e.g., memory size, processor type/speed, last job executed on the resource, etc).
[0033] The project object 304, which is at the top of the multi-tier hierarchy mentioned previously, represents a particular project designed by a user. The project may include one or more "procedures" and each procedure may include one or more "steps." Thus, each project object 304 is associated with one or more "procedure" objects 306, 308, 310 which represent procedures to be executed on the system resources (i.e., the agents 230-234). Similarly, each procedure object is associated with one or more "step" objects 312, 314, 316, which represent one or more commands to be executed by the system resources. As indicated in Figure 3a, properties 307, 309a-b, 311 and 313a-b, 315a-b, 317 may be associated with the procedure objects 306, 308, 310 and step objects 313, 314, 316, respectively. The central command server 200 manages the property attachment process using the central database 210. Specifically, in one embodiment, tables are maintained within the central database 210 which contain steps, procedures, projects, properties, and properties.
[0034] The container objects that associate the properties for a particular object are referred to as "property sheets." The tables managed by the database mimic the hierarchy illustrated in Figure 3a. Each object in the system has a property sheet associated with it by default. Project objects 304, for example, are stored in the database with their property sheets. Database joins are used to attach a particular object to a property sheet that stores its properties. A property is attached to a particular object by specifying the property name and the object name to the central command server 200 (e.g., "set property X on object Y"). The central command server 200 then "attaches" the property to that object.
[0035] Figure 4 illustrates the structure of an exemplary property sheet as well as the hierarchical relationships which may exist between property sheets. As illustrated, a property sheet 400 is identified by its name and is comprised of a series of name/value pairs 401. The names/values represent the properties associated with a particular object (e.g., version number, resource type, etc). Certain entries within a property sheet may point to other property sheets. In Figure 4, for example, the entry identified by "Name 5" includes a pointer, "Pointer 5," which points to property sheet 410. Similarly, property sheet 410 includes an entry identified by "Name 6" which includes a pointer, "Pointer 6" which points to property sheet 420. Thus, hierarchical relationships between property sheets are defined using pointers which point to other property sheets.
[0036] In one embodiment, the hierarchical relationships between the objects are used to identify the properties associated with the objects. Objects lower in the hierarchy use properties attached to objects further up the hierarchy. For example, in Figure 3a, each of the steps 312, 314, 316 use property 307 attached to procedure 306. Thus, if the property 307, for example, specifies a particular repository for source code (e.g., repository. P4. electric, com), each of the steps will use that repository. Similarly, if the property 307 specifies a particular platform (e.g., Linux), then each of the steps will use that platform. Moreover, all of the procedures and steps under project 304 will use its properties 305a-b.
[0037] In one embodiment, if a particular property is attached to both an object lower in the hierarchy and an object higher in the hierarchy, then the value specified by the object lower in the hierarchy will be used instead of the value specified by the object higher in the hierarchy. For example, in Figure 3a, if properties 317 and 307 have the same name, then the value of property 317 will be used in place of the value of property 307.
[0038] As used herein, a "job" is a runtime implementation of a procedure - i.e., it is an "instance" of that procedure. Similarly, a "job step" is a runtime implementation of a procedure step. This relationship is illustrated generally in Figure 3b in which job 326 is a runtime instance of procedure 306 and job steps 322, 324, 326 are runtime instances of steps 312, 314, 316, respectively. [0039] In one embodiment of the invention, properties 313, 313b, 313c, 315c, 317c are dynamically generated and attached to jobs, job steps and/or other objects during runtime (i.e., rather than statically, prior to runtime). The dynamically generated properties may be used for a variety of purposes including data collection during execution, passing information between jobs/job steps during execution and setting parameters within jobs and job steps prior to execution.
[0040] By way of example, during runtime, a job step may be programmed to attach a first property identifying the time that the job step started executing and a second property indicating the time that the job completed execution. Similarly, if the job step is involved in a program build operation, the job step may attach/update properties which indicate the number of compiles executed, the number of tests run, the number of errors or warnings triggered, etc, after the job step has completed executing. In one embodiment of the invention, this information is collected by the central command server 200 and stored back into the central database 210 upon completion of the job step. The collected information may then be used for analysis and report generation following the completion of a project (as described in greater detail below).
[0041] In addition, in one embodiment of the invention, the property mechanism may be used to pass information between jobs, job steps and other objects during runtime and/or prior to runtime. For example, if two or more job steps need to be executed on the same resource, then the first job step may dynamically attach a property identifying the resource. The property will then be used by the other job steps to identify the resource on which to execute. Similarly, if the other job steps rely on the start time of the first job, then the first job may dynamically attach a property indicating the start time. The properties may be attached to the individual job steps or to the job with which the job steps are associated. A virtually unlimited number of different types of properties may be set by job steps in this manner.
[0042] In addition, in one embodiment, parameters may be set prior to the execution of a job or job step. As used herein, a "parameter" is a special type of property which is substituted by the server at job creation time and is unique to the job. For example, a user may wish to run a job or job step on a particular version of software and/or on a particular platform (e.g., Solaris, version 3.14). As such, the user may pass in a parameter prior to execution which is stored as a property of the job. Upon execution, the job and/or job step is executed with the new set of parameters.
3. Property Substitution
[0043] As mentioned above, one embodiment of the invention includes property substitution logic 252 for substituting property values from procedure steps to job steps during runtime using a unique substitution syntax. As illustrated in Figure 5, when a procedure step 500 is defined, it typically includes at least one command to be executed 501 and a resource on which to execute the command 502. The values of the commands and resources may be specified explicitly or, alternatively, the substitution syntax may be employed to generate the values dynamically at runtime by combining property values with fixed text..
[0044] For example, as illustrated in Figure 5, the syntax $[string] instructs the property substitution logic 252 to find the value of the property which is referenced inside of the brackets and use that value in place of the $[string] entry. Thus, before using any of the string values, the property substitution logic 252 scans through the job step 500 and wherever it sees the $[string] syntax, it searches for and substitutes the value. In the illustrated example, when it locates the platform property, it makes the substitution within the job step. Similarly, the parameter substitution logic 252 searches for a Resource Name property and, when located, replaces the $[resName] entry with the identity of a physical resource on the system. Consequently, specific parameters do not need to be hard-coded as part of the job step, thereby creating greater flexibility and making the code re-usable with virtually unlimited number of parameters. For example, the command "make all PLATFORM=$[plat]" is expanded to "make all PLATFORM=windows" if the property $[plat] is equal to "windows".
[0045] In one embodiment, the properties described above are stored in one or more property sheets within the central database 210. Thus, using the foregoing architecture, procedures are parameterized and stored within the central database 210.
[0046] The foregoing architecture is useful in a variety of circumstances. For example, a first step in a job may be configured to attach a time limit property which is respected by all other steps. A job step may also be configured to invoke another procedure, the name of which is stored in the system as a property. These specific examples are, of course, merely provided for the purpose of explanation. The underlying principles of the invention are not limited to any particular application.
[0047] In addition, in one embodiment of the invention, a hierarchical naming system is employed to identify a specific point in the hierarchy in which to look for a property (rather than merely lookup up the hierarchy). For example, the format $[/projects/foo/procedures/bar/xyz] uses slashes to separate different property sheets. In response to detecting this syntax, the parameter substitution logic 252 searches through projects to find project foo; searches through procedures within foo to identify the procedure named bar, and then identifies the value in that procedure for property xyz. The property substitution logic 252 then substitutes that value within the job step.
[0048] In one embodiment, the substitution syntax uses starting points, or "roots" which indicate where to lookup the first element in the property pathname. For the sake of convenience, a variety of roots may be defined such as "/projects," "/myResource," and "/myJob." In one embodiment, if a root is not specified, then one is implied from the context. For example, if the property "foo" is requested from within a running job step, then the command server starts in the job step and searches up the hierarchy as described above. Similarly, when expanding the value of a procedure parameter the property attachment logic 250 may first look for the named property in the procedure for which the parameter is defined. If it is not found there then the property attachment logic 250 searches in the project containing the procedure. Moreover, when expanding a property for a job step, it may first look in the job step, followed by the parameters for the job, then in the global properties for the job. Thus, different search paths may be defined depending on the context in which the substitution is occurring.
[0049] Various generic system attributes may be identified in this manner. For example, like myResource (mentioned above), myJob identifies the current job, myProcedure identifies the current procedure; and myProject identifies the current project. Each of these attributes will have a different value depending on the current execution context. In one embodiment, words identifying these system attributes are reserved by the system (i.e., so that users cannot create jobs with these names). [0050] In one embodiment, the notion of "property" is generalized to include not just the extra custom information that users specify, but built-in system information as well. For example, the central command server 200 defines a field for each resource, "resourceName," that contains, the name of the resource. In one embodiment, this field may be accessed in the same way as a user-defined property, e.g., "/myResource/resourceName." Moreover, each procedure, step, etc, appears as a property sheet, whose individual properties include both the built-in system values and any user-defined values. The term "attribute" is sometimes used herein when referring to a built-in value to distinguish it from a custom property. In sum, all of the information in the system (projects, procedures, schedules, jobs, and so on) appear to be linked to a single, large hierarchical property sheet that contains all of the properties and attributes. This is valuable in that it provides a single, uniform mechanism for accessing all of the information in the system.
[0051] Thus, all of the configuration information within the system and the content of the objects themselves may be accessible as properties using the same notation, providing great flexibility in the way the system can be managed. Moreover, using the "my" syntax, a step does not need to known the name of its procedure; rather, this information can be determined at runtime. Consequently, the job step will still run correctly even if the procedure name is changed.
[0052] In addition, in one embodiment of the invention, if the value of a property that is actually a property sheet is read, a description the entire sheet (and all of its descendents) is provided to the reader. If this value is then assigned to another property name, that property will now become a property sheet whose contents (and descendents, etc.) duplicate the contents of the original read property. This feature provides a simple mechanism for copying aggregates of data from one place to another.
4. Data Gathering and Reporting
[0053] As previously mentioned, one embodiment of the invention includes post-processing logic 260 comprised of a post processing engine 254 for collecting and formatting data from each job step and report generation logic 255 for generating reports using the formatted data. The postprocessor 260 runs on the same machine as the job step whose output it is analyzing, and it runs after the job step itself completes. In operation, the Job Step 601 will produce a log file 603 containing an indication of the commands which executed during the execution of the job step and the results (e.g., compiles, tests failed, tests passed, tests skipped, warnings, errors, etc). Often, useful information is embedded within the log file 603 but it is difficult to identify. For example, a user may be interested in specific errors or warnings which occurred during the execution of the job step but, in order to locate this information, the user must perform a manual search for specific text or other specific data patterns within the log file 603.
[0054] To address the foregoing issues, a post processor 604 scans through the log file 603 at the end of each job step, extracts the useful information from the log file 603, and stores the extracted information in a highly flexible, reusable data format. Specifically, as illustrated in Figure 6, the post processor 604 generates a set of properties 605 and a diagnostics file 606. The set of properties 605 comprises user-specified variables which are particularly relevant to the job step 601. In the case of a program build operation, for example, the properties may include the number of compiles which executed, the number of tests run, and the number of errors and warnings. Once collected, the set of properties are then stored as a property sheet and attached to the job step 601 (as described above).
[0055] To generate the diagnostics file 606, the post processor 604 extracts detailed blocks of information form the log file 603 which are related to one or more of the extracted properties. For example, in the case of a test failure, the post processor 604 may extract all of the information related to the reason for the failure and any additional pertinent information (e.g., such as the platform on which the failure occurred). In one embodiment, the diagnostics file 606 is an XML file; however, any convenient file format may be used. In an alternate embodiment, the diagnostics file 606 information is stored as a set of properties within the central database 210.
[0056] In one embodiment, in order to identify the "useful" information, the post processor 604 searches for specific strings and/or other data patterns within the log 603. By way of example, to identify a compile, the post processor may search for strings indicating a compile operation (e.g., cl followed by a space for the Microsoft C compiler). Similarly, a first instance of the word "failed" in combination with another sequence of characters may indicate the start of information related to a test failure and a second instance of the word "failed" in combination with the sequence of characters may indicate the end of the information related to the test failure. Thus, in one embodiment, the post processor 694 extracts all of the information contained between the two instances of the word "failed." This is, of course, merely one example of how the post processor identifies the useful information within the log file. Various other well known pattern matching techniques may be employed to identify the useful information while still complying with the underlying principles of the invention. [0057] Once the properties 605 and diagnostic file 606 have been generated for each job step, the report generation logic 607 combines the information from both files to generate different types of reports 610-611. For example, the report generation logic may organize the properties in a high-level summary report containing links to the more detailed information from the diagnostic file 606. One particular type of report, illustrated in Figure 7, is a table with separate columns 701-704 for each type of platform and separate rows 700 for each job step. In the specific example shown in Figure 7, a separate column is provided for a Solaris platform 701 , a Windows XP platform 702, a Windows 2003 platform, and a Linux platform 704. Thus, each cell within the table represents the results of a different step executed on a different platform. The cells may be color-coded to indicate the results of each of the steps. For example, in one embodiment, warnings are colored yellow, errors are colored red, successful operations (e.g., tests and compiles) are colored green, and steps which were not performed on a particular platform (e.g., the "no data" cells in Figure 7) are colored gray. In one embodiment, the report generation logic 607 reads properties from multiple steps to produce its report.
[0058] In addition, as indicated in Figure 7, hyperlinks are inserted within certain cells that point to more detailed information from the diagnostics file 606. Referring again to the above example, the hyperlink is configured to point to the complete information related to a particular error, failure or warning within the diagnostics file. Similar hyperlinks may be embedded to point to other pertinent information within the diagnostics file (successful tests, compiles, etc).
|0059] Another type of report is illustrated in Figure 8. In contrast to the summary report illustrated in Figure 7, this report provides a more detailed, serial representation of each of the executed job steps and the associated results (e.g., start time, how long each job ran, commands executed, resources the job executed on, arguments for each procedure, etc). Like the first type of report, the results are all properties 605 collected during the execution of each job step. In addition, as in the first type of report, the listing of the more detailed report may be color-coded to indicate the results and hyperlinks may be inserted to point to more detailed information within the diagnostics file 606.
[0060] In one embodiment, different report generators are used which not only format their output differently, but they gather and process the underlying data in very different ways. For example, one report generator may display the results of each step within a single job as described above. By contrast, another report generator may scan over all of the jobs over a specified time period (e.g., the last month) looking only at one particular step in each job, and produce summary information about the success or failure of that particular step over time. Various additional report generators may be employed while still complying with the underlying principles of the invention.
[0061] In one embodiment, a separate post processor is run for every job step to gather the information for that step. Thus, the user is provided a very concise description of the results of each step along with links to the more detailed information within the diagnostics file 606. Moreover, separating the reporting process into a data gathering step and a reporting step provides a more flexible architecture than prior systems. For example, new types of reports can easily be generated using the properties 605 and the diagnostics file 606 based on the specific needs of the end user. [0062] In the foregoing description, for the purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced without some of these specific details. For example, while the embodiments described above focus on specific properties, the underlying principles of the invention may be employed using virtually any type of properties. Moreover, the central command server 200 may not necessarily be implemented as a separate physical "server." Rather the term "server" is used broadly herein to refer to a software module which may be executed on any machine or group of machines.
[0063] Embodiments of the invention may include various steps as set forth above. The steps may be embodied in machine-executable instructions. The instructions can be used to cause a general-purpose or special-purpose processor to perform certain steps. Alternatively, these steps may be performed by specific hardware components that contain hardwired logic for performing the steps, or by any combination of programmed computer components and custom hardware components.
[0064] Elements of the present invention may also be provided as a machine-readable medium for storing the machine-executable instructions. The machine-readable medium may include, but is not limited to, floppy diskettes, optical disks, CD-ROMs, and magneto-optical disks, ROMs, RAMs, EPROMs, EEPROMs, magnetic or optical cards, propagation media or other type of media/machine-readable medium suitable for storing electronic instructions. For example, the present invention may be downloaded as a computer program which may be transferred from a remote computer (e.g., a server) to a requesting computer (e.g., a client) by way of data signals embodied in a carrier wave or other propagation medium via a communication link (e.g., a modem or network connection).

Claims

CLAIMSWhat is claimed is:
1. A system for generating reports within a process automation system comprising: a post processor module to scan through a log file and responsively generate a set of properties and specified diagnostics information from the log file; and a report generator to generate one or more reports using both the set of properties and the specified diagnostics information.
2. The system as in claim 1 wherein the log file is generated following the execution of a job step, the log file containing an indication of the commands which executed during the job step and the results of the commands.
3. The system as in claim 2 further comprising: property attachment logic to attach the set of properties to the job step following execution.
4. The system as in claim 1 wherein the report generator embeds hyperlinks in the displayed properties of one of the reports, the hyperlinks pointing to a subset of the diagnostics information related to the properties.
5. The system as in claim 1 wherein the set of properties include number of compiles, tests failed, tests passed, warnings and errors.
6. The system as in claim 1 wherein, to identify the set of properties and specified diagnostics information, the post processor scans through the log file to identify specific patterns indicating specific properties and diagnostics information.
7. The system as in claim 1 wherein the diagnostics information is stored in an XML file.
8. A method for generating reports within a process automation system comprising: scanning through a log file and responsively generating a set of properties and specified diagnostics information from the log file; and generating one or more reports using both the set of properties and the specified diagnostics information.
9. The method as in claim 8 wherein the log file is generated following the execution of a job step, the log file containing an indication of the commands which executed during the job step and the results of the commands.
10. The method as in claim 9 further comprising: attaching the set of properties to the job step following execution.
11. The method as in claim 8 further comprising embedding hyperlinks in the displayed properties of one of the reports, the hyperlinks pointing to a subset of the diagnostics information related to the properties.
12. The method as in claim 8 wherein the set of properties include number of compiles, tests failed, tests passed, warnings and errors.
13. The method as in claim 8 further comprising: scanning through the log file to identify specific patterns indicating specific properties and diagnostics information to identify the set of properties and specified diagnostics information.
14. The method as in claim 8 wherein the diagnostics information is stored in an XML file.
15. A machine-readable medium having program code stored thereon which, when executed by a machine, causes the machine to perform the operations of: scanning through a log file and responsively generating a set of properties and specified diagnostics information from the log file; and generating one or more reports using both the set of properties and the specified diagnostics information.
16. The machine-readable medium as in claim 15 wherein the log file is generated following the execution of a job step, the log file containing an indication of the commands which executed during the job step and the results of the commands.
17. The machine-readable medium as in claim 16 comprising additional program code to cause the machine to perform the operations of: attaching the set of properties to the job step following execution.
18. The machine-readable medium as in claim 15 further comprising embedding hyperlinks in the displayed properties of one of the reports, the hyperlinks pointing to a subset of the diagnostics information related to the properties.
19. The machine-readable medium as in claim 15 wherein the set of properties include number of compiles, tests failed, tests passed, warnings and errors.
20. The machine-readable medium as in claim 15 comprising additional program code to cause the machine to perform the operations of: scanning through the log file to identify specific patterns indicating specific properties and diagnostics information to identify the set of properties and specified diagnostics information.
21. The machine-readable medium as in claim 15 wherein the diagnostics information is stored in an XML file.
PCT/US2007/021314 2006-10-03 2007-10-03 Process automation system and method employing multi-stage report generation WO2008042428A2 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US11/543,367 US8042089B2 (en) 2006-10-03 2006-10-03 Process automation system and method employing multi-stage report generation
US11/543,367 2006-10-03

Publications (2)

Publication Number Publication Date
WO2008042428A2 true WO2008042428A2 (en) 2008-04-10
WO2008042428A3 WO2008042428A3 (en) 2008-09-04

Family

ID=39262254

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2007/021314 WO2008042428A2 (en) 2006-10-03 2007-10-03 Process automation system and method employing multi-stage report generation

Country Status (2)

Country Link
US (1) US8042089B2 (en)
WO (1) WO2008042428A2 (en)

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8458661B2 (en) 2006-03-31 2013-06-04 Ebay Inc. Distributed parallel build system
US20090158255A1 (en) * 2007-12-18 2009-06-18 Electronics And Telecommunications Research Institute Test method and test device for unit code using unit test code
US20100094988A1 (en) * 2008-10-09 2010-04-15 International Business Machines Corporation automatic discovery framework for integrated monitoring of database performance
US8789071B2 (en) 2008-10-09 2014-07-22 International Business Machines Corporation Integrated extension framework
US20120084224A1 (en) * 2010-10-04 2012-04-05 International Business Machines Corporation Automatically created report generator for managing information technology service projects
CN103049509B (en) * 2012-12-16 2016-04-27 四川久远新方向智能科技有限公司 Rail traffic ticket automatic selling and checking system station control center bordereaux generation method
CN104123184B (en) 2013-04-28 2017-12-22 国际商业机器公司 A kind of method and system for being used to distribute resource for the task in building process
US11687362B2 (en) 2021-04-22 2023-06-27 Incredibuild Software Ltd. Storage and reuse of computing-task outputs using system-call interception

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040205565A1 (en) * 2001-10-23 2004-10-14 Sun Microsystems, Inc. XML based report generator
US20040254919A1 (en) * 2003-06-13 2004-12-16 Microsoft Corporation Log parser

Family Cites Families (47)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1993020511A1 (en) * 1992-03-31 1993-10-14 Aggregate Computing, Inc. An integrated remote execution system for a heterogenous computer network environment
US5574898A (en) * 1993-01-08 1996-11-12 Atria Software, Inc. Dynamic software version auditor which monitors a process to provide a list of objects that are accessed
US5325533A (en) * 1993-06-28 1994-06-28 Taligent, Inc. Engineering system for modeling computer programs
US5500881A (en) * 1993-07-12 1996-03-19 Digital Equipment Corporation Language scoping for modular, flexible, concise, configuration descriptions
DE4417588A1 (en) * 1993-08-30 1995-03-02 Hewlett Packard Co Method and apparatus for capturing and forwarding window events to a plurality of existing applications for simultaneous execution
US5692193A (en) * 1994-03-31 1997-11-25 Nec Research Institute, Inc. Software architecture for control of highly parallel computer systems
US6094528A (en) * 1996-10-24 2000-07-25 Sun Microsystems, Inc. Method and apparatus for system building with a transactional interpreter
EP0859314A3 (en) 1996-12-18 2001-12-19 Sun Microsystems, Inc. Distributed make methods, apparatus, and computer program products
US6026413A (en) * 1997-08-01 2000-02-15 International Business Machines Corporation Determining how changes to underlying data affect cached objects
JP3703616B2 (en) * 1998-01-09 2005-10-05 株式会社東芝 Agent system, information processing method, and recording medium recording information processing program
US6263348B1 (en) * 1998-07-01 2001-07-17 Serena Software International, Inc. Method and apparatus for identifying the existence of differences between two files
US6240429B1 (en) * 1998-08-31 2001-05-29 Xerox Corporation Using attached properties to provide document services
US6237143B1 (en) * 1998-09-17 2001-05-22 Unisys Corp. Method and system for monitoring and capturing all file usage of a software tool
US6578045B1 (en) * 1999-04-20 2003-06-10 Microsoft Corporation System and method for retrieving registry data
US7197547B1 (en) * 1999-05-11 2007-03-27 Andrew Karl Miller Load balancing technique implemented in a data network device utilizing a data cache
US6601233B1 (en) * 1999-07-30 2003-07-29 Accenture Llp Business components framework
US6457170B1 (en) * 1999-08-13 2002-09-24 Intrinsity, Inc. Software system build method and apparatus that supports multiple users in a software development environment
US7020697B1 (en) * 1999-10-01 2006-03-28 Accenture Llp Architectures for netcentric computing systems
US6449715B1 (en) * 1999-10-04 2002-09-10 Fisher-Rosemount Systems, Inc. Process control configuration system for use with a profibus device network
US6327143B1 (en) * 1999-11-05 2001-12-04 Cray, Inc. Radial computer system and method
CA2297994A1 (en) * 2000-02-04 2001-08-04 Ibm Canada Limited-Ibm Canada Limitee Automated testing computer system components
US6785848B1 (en) * 2000-05-15 2004-08-31 Microsoft Corporation Method and system for categorizing failures of a program module
US7100133B1 (en) * 2000-06-23 2006-08-29 Koninklijke Philips Electronics N.V Computer system and method to dynamically generate system on a chip description files and verification information
US6601223B1 (en) * 2000-09-29 2003-07-29 International Business Machines Corporation System and method for fast interconnect delay estimation through iterative refinement
US7055128B2 (en) * 2000-12-04 2006-05-30 Microsoft Corporation System and method to communicate, collect and distribute generated shared files
US6938252B2 (en) * 2000-12-14 2005-08-30 International Business Machines Corporation Hardware-assisted method for scheduling threads using data cache locality
CA2343437A1 (en) * 2001-04-06 2002-10-06 Ibm Canada Limited-Ibm Canada Limitee Method and system for cross platform, parallel processing
US20020194319A1 (en) * 2001-06-13 2002-12-19 Ritche Scott D. Automated operations and service monitoring system for distributed computer networks
US7003759B2 (en) * 2001-06-21 2006-02-21 Codefast, Inc. Collection makefile generator
CA2704252C (en) * 2001-07-26 2011-09-27 Irise System and process for interacting with a user to define a behavior of a portion of an interactive presentation
US20030126304A1 (en) * 2001-12-31 2003-07-03 Wyatt David A. Method for attaching a resource to a parent within a global resource namespace
US7177868B2 (en) * 2002-01-02 2007-02-13 International Business Machines Corporation Method, system and program for direct client file access in a data management system
US6948163B2 (en) * 2002-01-29 2005-09-20 International Business Machines Corporation Remote electronic file builder
US7093004B2 (en) 2002-02-04 2006-08-15 Datasynapse, Inc. Using execution statistics to select tasks for redundant assignment in a distributed computing platform
US6922827B2 (en) * 2002-02-22 2005-07-26 Bea Systems, Inc. Iterative software development environment with prioritized build rules
US20030184926A1 (en) * 2002-04-01 2003-10-02 Uis Abler Electronics Co., Ltd. Hybrid switch module for an AC power capacitor
US6988139B1 (en) * 2002-04-26 2006-01-17 Microsoft Corporation Distributed computing of a job corresponding to a plurality of predefined tasks
US7210143B2 (en) * 2002-07-17 2007-04-24 International Business Machines Corporation Deployment of applications in a multitier compute infrastructure
US7150012B2 (en) * 2002-10-15 2006-12-12 Nokia Corporation Method and apparatus for accelerating program execution in platform-independent virtual machines
US7168064B2 (en) * 2003-03-25 2007-01-23 Electric Cloud, Inc. System and method for supplementing program builds with file usage information
US7395529B1 (en) * 2003-03-25 2008-07-01 Electric Cloud, Inc. Conflict detection and correction in a program build environment
US8627489B2 (en) * 2003-10-31 2014-01-07 Adobe Systems Incorporated Distributed document version control
US7437705B1 (en) * 2003-12-05 2008-10-14 Sprint Communications Company L.P. System and method for building an application on a computing device which includes an environment-controlling process
US7526479B2 (en) * 2003-12-30 2009-04-28 Sap Ag Configuration manager in enterprise computing system
US7735068B2 (en) * 2005-12-01 2010-06-08 Infosys Technologies Ltd. Automated relationship traceability between software design artifacts
US7890921B2 (en) * 2006-07-31 2011-02-15 Lifecylce Technologies, Inc. Automated method for coherent project management
US7886265B2 (en) * 2006-10-03 2011-02-08 Electric Cloud, Inc. Process automation system and method employing property attachment techniques

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040205565A1 (en) * 2001-10-23 2004-10-14 Sun Microsystems, Inc. XML based report generator
US20040254919A1 (en) * 2003-06-13 2004-12-16 Microsoft Corporation Log parser

Also Published As

Publication number Publication date
WO2008042428A3 (en) 2008-09-04
US8042089B2 (en) 2011-10-18
US20080082588A1 (en) 2008-04-03

Similar Documents

Publication Publication Date Title
US7886265B2 (en) Process automation system and method employing property attachment techniques
US7725524B2 (en) Process automation system and method having a hierarchical architecture with multiple tiers
US8042089B2 (en) Process automation system and method employing multi-stage report generation
Fischer et al. Populating a release history database from version control and bug tracking systems
US7562339B2 (en) System architecture for business process development and execution with introspection and generic components
US6226788B1 (en) Extensible network management system
US6505228B1 (en) Dynamic determination of execution sequence
US8561036B1 (en) Software test case management
EP2246787B1 (en) Systems and methods for identifying the root cause of an application failure in a mainframe environment based on relationship information between interrelated applications
US7143392B2 (en) Hyperbolic tree space display of computer system monitoring and analysis data
US6769124B1 (en) Persistent storage of information objects
Kazman et al. Architecture reconstruction guidelines
US8839107B2 (en) Context based script generation
US20060143144A1 (en) Rule sets for a configuration management system
US20060179116A1 (en) Configuration management system and method of discovering configuration data
US20060037000A1 (en) Configuration management data model using blueprints
EP0596591A1 (en) Method and apparatus for a real-time data collection and display system
US7676589B2 (en) Automatic generation of portlets for visualizing data by exploiting object relationships
US20080320071A1 (en) Method, apparatus and program product for creating a test framework for testing operating system components in a cluster system
Vogel et al. Incremental model synchronization for efficient run-time monitoring
CA2350735A1 (en) A method for providing open access to application profiling data
WO2002021269A1 (en) Software application development
WO2009127639A1 (en) Query processing visualization system and method of visualizing query processing
US20030226134A1 (en) Representation of core files in a generic format
Porter et al. Skoll: A process and infrastructure for distributed continuous quality assurance

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 07852521

Country of ref document: EP

Kind code of ref document: A2

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 07852521

Country of ref document: EP

Kind code of ref document: A2