Enterprise reports, error handler and audits compartmentalized by web application

Abstract

A method and system for implementing an enterprise error handler and audit module for a web application. The method framework approach embodied in the present invention provides a site-wide error handler and audit for web applications on multiple servers across an enterprise with compartmentalized error and audit reports per application. The present invention focuses on software development user interface and user responses, and so teaches error details and audits from clients to support troubleshooting for different development teams.

Claims

1. A method for implementing an enterprise error handler and audit module for a web application, comprises: registering one or more custom variables to an error and audit application for creating an error handler and audit trail; identifying a web application that created the error or audit trail; identifying a development team associated with said web application; enabling a compartmentalized reporting to be sent to said development team, wherein a reporting framework is defined for different groups based on customs variables within each application configuration files, and wherein each custom variable is configured to associate one or more data sources with each web application; associating a database with said reporting framework; capturing each executed error handler or audit trail for each web application, wherein the one or more data sources comprise servers and development environments; assigning one or more roles to each user of each web application, wherein each custom variable is configured to map each role to said error handler or audit trail; and providing a menu for filtering each executed error handler or audit captured in said database by at least one of the following: by role and by development environment.

2. A system for implementing an enterprise error handler and audit module for a web application, comprises: a hardware processor; a memory electrically connected to the hardware processor; one or more web applications operatively associated with the hardware processor; an enterprise error handler and audit module operatively associated with each web application; a variable file configured to map custom variables for capturing each executed error handler or audit trail for each web application, wherein an error or audit variables are captured and inserted into one or more database tables; roles created for each user of each web application and assigned to a development team responsible for said web application; and a dashboard configured to display application errors, to allow filtering of custom web application variables, and to the errors or audits variables to the development team for debugging.

Description

BRIEF DESCRIPTION OF THE DRAWINGS

(1) FIG. 1 is a diagram of a ColdFusion server's Default Log Files;

(2) FIG. 2 is a diagram of Data Source Connections with a generic service account;

(3) FIG. 3 is a diagram of Error and Audit Logging into a Database capturing application mapped custom variables;

(4) FIG. 4A is a diagram of a Dashboard (System Admin);

(5) FIG. 4B is a diagram of a Dashboard (Power User—Budget Application); and

(6) FIG. 5 is a diagram of where to define the Site-wide Error Handler with the ColdFusion Admin page.

(7) FIG. 6 is a flowchart of an exemplary embodiment of the present invention, illustrating a method for implementing an enterprise error handler and audit module for a web application.

DETAILED DESCRIPTION OF THE INVENTION

(8) The following detailed description is of the best currently contemplated modes of carrying out exemplary embodiments of the invention. The description is not to be taken in a limiting sense, but is made merely for the purpose of illustrating the general principles of the invention, since the scope of the invention is best defined by the appended claims.

(9) The present invention includes a site-wide error handler and audit for web applications on multiple servers across an enterprise with compartmentalized error and audit reports per application. Oracle and other types of databases may be the data source.

(10) Referring to FIG. 1, the standard default settings for ColdFusion is to log all errors in every application on the server by default into the same error log file. The error log files contain very limited error information. This is not always enough information to help the development team fix the error. There is a debugger that the development teams use to provide more details about the application errors. For production servers this debugger is recommended to be turned off for security reasons due to the highly sensitive variable data that the debugger can display to end users.

(11) Referring to FIG. 2, another issue is service accounts are sometimes used to connect to data sources and this creates issues with tracking which user connected to the data source and created the error. Some applications may use one data connection or multiple data sources. This information is not captured within the error log file and makes it hard to figure out who created the error and if the error is based on a missing security role or someone trying to hack into the system.

(12) FIG. 3 illustrates the capture of errors and audits of file access with custom variables mapped and the data flow for multiple applications with load balanced servers or a single server with different environments. A module of ColdFusion pages captures all CGI, Custom Session and CF Error Variables. Variables have been added to identify different servers, different application names and development environments. Those variables are used to filter or group and report by application.

(13) FIG. 4A includes a Dashboard (System Admin). The Dashboard allows for the reports to be aggregated across multiple servers or isolated down to a single application with detailed custom mapped variables. This information can be exported to help development teams debug issues.

(14) FIG. 4B includes a Dashboard (Power User—Budget Application), including a wireframe mockup of the Error Report. By creating a secondary Menu each application can allow for custom filters of custom mapped variable data. Each application can have a System Admin or Power User login and review their own Application for Errors. This also provides Application owners on-site to export errors or audit reports that can be provided to an off-site development team.

(15) FIG. 5 illustrates where to define the Site-wide Error Handler in the ColdFusion Admin Page. ColdFusion allows a developer to create a custom error handling page and provides a form to define the file path for custom Site-wide Error page. The module of the present invention allows the local developers to provide more detailed error information for bug fixes. By adding extra session variables for application error handling and access controls for users, the present invention may restrict aggerate reporting to only the teams responsible for each application. The errors can be reviewed by users for each application.

(16) The present invention may include the following: a variable file to map custom variables for each application to capture, wherein the error or audit variables are captured and inserted into the database tables; roles are created for each application and assigned to the users responsible for that application; a dashboard displays application errors and allows for filtering of common variables and custom application variables; and the dashboard allows for the export of errors or audits that can be provided to the development team for debugging.

(17) A method of making the present invention may include creating a module and ColdFusion pages and scripts that capture the audit and error and custom mapped variables by application. Tables are created for capturing audits and errors and mapped custom variables for each application. Forms are created to configure and enter the mapping of users to roles for each application. Reports with custom filters may be created for exporting audits and errors for each of the different applications. The Server Admin needs to enable CGI on the web server. The Server Admin/ColdFusion developer adds a few custom Session variables into the Application.cfm or Application.cfc files. The database admin creates an application service user in the database and runs the database scripts to generate the tables. The Server Admin need to configure the database connection and define the path for the Site-wide Error Handler within the ColdFusion Admin page.

(18) Forms are created for defining Application Names and Role Names and mapping Applications to Roles. Forms are used to map users to roles. FIGS. 4A & 4B display two different users with different roles a System Admin with all application access and a Power User with only the Budget Application access. Custom Error fields are mapped and defined for a Secondary Menu Filter per application; and Export fields can be defined per Role.

(19) The ordered combination of various ad hoc and automated tasks in the presently disclosed platform necessarily achieve technological improvements through the specific processes described more in detail below. In addition, the unconventional and unique aspects of these specific automation processes represent a sharp contrast to merely providing a well-known or routine environment for performing a manual or mental task.

(20) It should be understood, of course, that the foregoing relates to exemplary embodiments of the invention and that modifications may be made without departing from the spirit and scope of the invention as set forth in the following claims.