Assure 9.3 enhancements include:
Infogix ER Integration Improvements
In this release, Infogix Assure has the following new abilities when integrating with Infogix ER 9.3.
ER Inventory Item Update
Multiple capture control points can now update ER inventory items. This allows customers to improve research or matching efforts on the ER inventory items via improved field values as that data becomes available via Infogix Assure.
Update ER Inventory Item Status
Multiple capture control points may now also update the status of ER inventory items to close them. This capability is controlled by installation configuration in Infogix ER; see the Infogix ER 9.3 release notes for more information. This capability allows the controls developer to close inventory items without resorting to creation of match sets.
Data360 Govern Integration
This release provides Data360 Govern with metadata information about all control points, control fields and reports defined within Infogix Assure. Also included are key relationship data: which fields are captured by control points, which fields of other controls are read by control points, which control points run other control points, which fields are shown on reports and which reports are produced by control points. This information allows your data governance efforts to extend to the controls that Infogix Assure provides.
Data Export Improvements
This release makes several improvements for the export of control data and results.
Control Execution Results to Data360 DQ+
Infogix Assure has provided execution results to Data360 DQ+ since release 8.3 including overall result catalog information, results summary information, and the list of detailed results within the result catalog. In release 9.3, Infogix Assure can also provide the list of reports produced by the control point, and hyperlinks to the result catalog, reports, and detailed results. These improvements allow an analyst in Data360 DQ+ to provide dashboards that present the same information shown in Infogix Assure, and even to link back to Infogix Assure to natively present the reports and results of the control point execution.
Control Data Push to Data360 DQ+ Post Processing
Infogix Assure has had the ability to send the control data of a control entity to Data360 DQ+ since release 8.3. When the control data is selected for analysis in DQ+, every control point that potentially creates or updates control data will send the new or modified data to DQ+. This can result in a lot of data store files being sent to DQ+ and subsequently triggering a lot of analysis runs in DQ+. With release 9.3, the controls developer can choose which control points shall send control data, giving pinpoint control over when data is sent and analysis processing is triggered in DQ+ for that data.
Control Data Export Utility Control
Infogix Assure has provided an export control data utility since release 9.1. This utility allows you to produce a delimited data file of the control data of a control entity. You could export all control data, or control created or modified since a date and time.
In release 9.3, several improvements have been made to provide additional control over what data is exported by the utility. You can now specify the data to export based on cycle and run number range. Additionally, three new functions have been added to the system: @exec_last_end(), @exec_last_begin() and @exec_curr_begin(). The exec_last_end function returns the date and time that the currently running control point previously ended. The exec_last_begin function returns the data and time that the currently running control point previously started execution. The exec_curr_begin function returns that date and time that the current control point execution started.
Together, these improvements allow the controls developer to automate the execution of the control data export utility with the execute script action, with greater control over which control data records shall be exported.
Control Data Export from Control Point to CSV
Infogix Assure has included an “Export data” rule on a control point since release 3.0. This feature allowed you to insert rows in an external relational database corresponding to the instances being processed by a multi-capture or scanning control point.
In release 9.3, this capability is expanded to be able to produce a delimited file instead. This allows you to export the data to non-relational data stores and processes.
The following improvements to reporting have been incorporated into Infogix Assure 9.3.
Control Point References Report
The controls developer or rules viewer can now select a control point and view a report that shows what other control points trigger execution of the control point, as well as what result actions apply to the control point. This allows the controls developer to better understand the ramifications of any control point changes they are considering.
Control Entity Referenced By Report
The referenced-by report for a control entity or application now includes a section for result action rules which refer to any contained control point. This allows the controls developer to better understand the ramifications of any control point changes they are considering.
Alertable Result Report
A new system-wide rules report can be produced that lists all result templates in the system, their severity, which control points produce those results and with what associated return code, and which result action rules apply to those results either directly by the result template type or by the control point that produces them. This allows controls developers, auditors and knowledge workers to understand the results being produced by the system and what happens with them.
Reconciliation Task Catalog
A new system-wide rules extract in comma separated value format can be produced that lists all reconciliation tasks in the system with detailed information on the sources, data selection, matching criteria, and ER match set output mappings of each task. As an alternative to obtaining data about all reconciliation tasks, you can filter the rules based upon a modified since date, a control entity name including wildcards, and on the security profile that secures the control entities that contain reconciliation tasks. This allows you to keep a catalog of reconciliation tasks for your own reporting, and monitor them for change over time.
Execution Chains Report
A new system-wide rules report can be produce that lists all of the control points in the system, and for each shows what other control points run that control point, and what control points that control point runs. This report is hyperlinked so that you can step your way through an execution chain backwards and forwards. You can also choose a control point and filter the report to just those other control points that are related to it in a runs/run-by relationship in some fashion. This report allows a controls developer to better understand how control points begin execution in a complex rules environment.
The Execution Chains Report is only available when Data360 Govern integration is enabled.
Password Protected Microsoft Excel Files
Infogix Assure can now read password protected Microsoft Excel files. The password value can be stored in the rule, or defined as an expression that looks up the password in an external properties file, or even as an expression that uses a runtime hidden-text field value. This capability allows customers to improve security by capturing data from Microsoft Excel files without creating an unprotected version of the file.
Character Based Fixed Layouts
Fixed layouts can now be defined to process multi-byte character text files, such as files encoded with UTF-16. When defined for multi-byte character files, a fixed layout is prohibited from defining other types of encodings such as binary or packed data. This allows you to define layouts to extract wide-character reports with positional data extraction without the need for extra data conversion or workarounds with delimited layouts.
Infogix Assure controls developers can now create a new schedule or duration calendar by selecting an existing calendar and duplicating it. This improves the productivity of the controls developer who needs to schedule automatic control point execution.
Security Profile Duplication
Infogix Assure security administrators can now create a new security profile by selecting an existing profile and duplicating it. This improves the productivity of the security administrator.
End Capture Source Extraction Rule
The controls developer can now stop extraction processing for a capture source as soon as a condition is met. This can improve the efficiency of control point processing.
The controls developer can now limit the number of control data instances that a scan control point will process. This can simplify rules development for control points that perform significant actions per instance, such as executing other control points.
Instance Management Pre-Processing
The controls developer can now define control data pre-processing for a control point, with options to truncate all control data or delete all control data for the computed cycle. This can greatly improve the efficiency of control points, and aid in the rerun or restart ability of the control point.
Not Like Selection
The controls developer can now define control data selection criteria with a not like operator in addition to the like operator they could previously use. This allows the controls developer to write simpler to maintain control data selection rules.
Required Runtime Fields
The controls developer can now mark a runtime field of a control point as required. Required runtime fields must have a non-null value when the control point starts execution. This helps the controls developer prevent the effects of erroneous control point execution and simplify recovery steps when a problem does occur.
Stop Control Points with Long Running Queries
Previously, control points that are capturing data from a database layout source may not respond to a stop signal promptly. This occurred when the database query was submitted to the database but had not yet returned a result set to process. In release 9.3, Infogix Assure can abort these submitted database select statements and promptly halt a control point on request. This allows system operators to better respond to problems in their environments.
New Software Supported
The following is now supported:
- Wildfly v. 16.x
- Oracle 19c
In addition, both the Oracle and Microsoft SQL Server JDBC drivers were updated.
The complete list of supported software and hardware versions is included in the Infogix Technical Specifications Document included in the application documentation.
Java support now includes Corretto 8 JVM.
In this release, several third-party libraries were updated. These updates increase system security and reliability. Several libraries were updated specifically to address security vulnerabilities.
A major update was that for Hibernate, which is fully compliant with JPA 2.2 and features improved memory consumption.
LDAP Group Email Attribute
We now support retrieving the LDAP email attribute for groups.
JVM arguments stored in WebSphere properties
JVM arguments are now stored in custom WebSphere properties rather than generic arguments, which eliminates the need for parsing and simplifies deployment.
Fixed in this Release
The following issues have been fixed in this release:
IA-50142 The application session cookie is now fully configurable for http-only and secure attributes under both WildFly and WebSphere.
IA-50143 When editing a database channel override that uses JDBC and specifies username and password in the provided fields, the user must re-enter the JDBC password when completing the edit. Failure to do so results in control point execution failure because the database connection password is missing.
IA-50149 Creating or editing a result template incorrectly limits the template name to 40 characters instead of 80 characters as in past releases.
IA-50157 Switching tabs in the user interface may fail to display the tab being switched to.
IA-50217 An external service (plugin) layout incorrectly stores the value for the Path/URL when the data access method chosen is JMS.
IA-50219 External Layouts which use the standard data access method “JMS Message Queue” may not correctly consume all available messages. This problem occurs for those external layouts which process an input stream as a single “document”. External layout processing for a JMS Message Queue channel is enhanced to process each message as a separate input stream, which supports all types of external layout scenarios, including one document per input stream designs.
IA-50223 When creating a new reconciliation control point, the user is unable to create new reconciliation sources or targets.
IA-50228 When creating a new control entity, if the user switches to the Storage, Fields or Notes tab, and then switches back to the Details tab, the information entered on the Details tab is lost and must be re-entered.
IA-50239 The list of schedule calendars is empty on the Reconciliation and Timeliness control points.
IA-50282 The function @return_code() could not be used within field value or script parameter bindings of an action within the when-finished section of control point actions.
IA-50325 The rules developer cannot delete an extraction procedure when using the “fast rendering” extract tab.
IA-50332 Group By and Order By fields specified by the user on the Selection tab of a control data capture source, or history data item popup, are not saved. Additionally, for a “computed” control data capture source or history data item, errors on the Fields tab prevent the definition of computed fields.
IA-50333 When a capture source is edited for a single-capture or balancing control point, after editing a capture source for a multi-capture control point within the same user interface session, and the control point is saved, the control point performs incorrectly, producing two or more control data instances, and possibly resulting in control point failure.
IA-50240 Upon adding a result definition to the results tab of a reconciliation task popup, the results tab becomes blank and you cannot switch tabs. Additionally, removing or renaming a result definition that is in use on the Validation tab of the reconciliation task popup or validation popup of a capturing control point may be allowed when it should be prevented.
IA-50285 When a user adds a new history data item on the History tab of a capturing or scanning control point, if they attempt to save before switching to the Validate tab, the save does not complete.
IA-50328 When the JMS bus engine fails over on WebSphere, the API Queue processors take 5 minutes to recover. Generally the JMS bus becomes available within seconds, and the API Queue processors should recover within seconds.
IA-50410 When using Microsoft SQL Server, each DDL statement performed during a save of a control entity or control point, or during upgrades of dynamic tables for controls, is now performed in a separate transaction by default.
IA-50427 The export control data utility output of date control values may have the wrong value.
IA-50546 A user with view-only permissions or role, when choosing Generate PDF after navigating to a control point, incorrectly gets a PDF of the control entity, not the control point.
IA-50551 Asynchronous control point execution from client to server does not log correlation information sufficiently for problem diagnosis.
IA-50573 Reverting a layout to a version when it was a different type of layout does not change its type in the manage layouts list.
IA-50607 The system does not provide the list of external source field names on the Data tab of a simple translation rule that is using an external data source.
IA-50617 While viewing the definition report of a control entity, when the user chooses to generate a PDF of the report, the system does not provide feedback that the system is busy producing the report, and may not close the generate dialog when the report has been produced. If the user attempts to produce control entity definition reports for multiple entities within the same browser session, the system may not generate the PDF at all after the first one, requiring the user to logout and log back in to generate a second PDF.
IA-50634 Execute control point actions returned for execution at the client which were not using “local capture” did not run via the new asynchronous interaction model. Similarly, online control point tests performed for non-capturing control points such as a reconciliation control point, did not run via the new asynchronous interaction model.
IA-50668 The General tab of Results | Control Data for a control entity or application says “Most Resent Run” instead of “Most Recent Run”.
IA-50697 When a user is creating a new external service (plugin) layout rule, they might receive an XML parsing error when saving or switching to the Fields tab.
IA-50754 The recap report print view for a capturing or scanning control point has multiple filtering problems. The initial print view does not show the same filter the user was using on the main recap report view. The system loses its “print friendly” pagination when the user navigates to another page of data. When the user chooses “Add Criteria” in the filter panel, the new criteria row does not correctly display.
IA-50781 The system fails to show an edit error message if the user attempts to OK a new history data item from the Details tab without having specified settings on the Selection tab.
IA-50792 The system fails to provide the match field pairs in the Group By dropdown list when the user is editing the match set audit report task definition.
IA-50801 When the user is building a tracking rule, the system does not list available duration calendars in the Associated Calendar field.
IA-50803 After making a “Create” extract rule on a capture source, the user encounters #UUIP002 invalid parameter value errors.
IA-50804 The list of subfolders on the Choose File window for the test data repository may not have been sorted. This list is now sorted by name, ignoring case, ascending. The installer can configure this sort order to ascending or descending folder name, with or without case sensitivity.
IP-3775 SQL Server query causes Admin Console query error #UADC045.
IP-4058 Millisecond is missing for the timestamp datatype field in the SQL Server bulk load file.
IP-4087 Running the crypt-properties.sh script on z/OS for Infogix Assure clients caused the client.properties file to become to unreadable.
IP-4131 Parsing problem when duplicate -Djs.license.directory arguments are present with WebSphere.
IP-4593 WildFly commands don't work with Cygwin.
IP-4699 In WebSphere deployments when passing the parameters infogix.config.enabled and infogix.config.database as JVM arguments, parameter values were reset to true. This forced the administrator to manually revise values to false in the IBM administration console.
IP-4820 The cee-config.CONFIG_PREFIX value fails to evaluate.
IP-4966 Getting an error after generating a Heap Dump and clicking Copy Heap Dump.
IP-4980 Reset button on product configuration page shows incorrect message.
IP-4985 Remove remaining Struts references for the web.xml file.
IP-4986 When generating an Assure user report, the report contains undesired blank lines.
IP-4987 On WebSphere 8.5.5, clicking the Admin Console 'Cache Management' link throws a 500 error. This does not affect WebSphere 9.0 or Wildfly.
IP-5073 Sorting on the Permissions tab displays the progress indicator but does not close it when the task in completed, forcing the user to manually close the progress indicator.
IP-5148 Support packages contain datasources.properties passwords without suppression.
IP-5167 Import/export hangs in HTTP client after repeated execution in the Infogix ER Rich Client.
IP-5201 WildFly configuration logging missing from deploy log.