Resolved Issues

BIX filter failure alert added

A warning has been added to issue an alert when filters are not being added while generating a BIX query.

Resolved startup error related to business calendar object

An error recorded in the log file when the server started was traced to a cache update that removed the old business calendar object and added the new business calendar object to the business cal list. This has been resolved by updating the system to replace the business calendar object instead of removing the old one from the cache first.

Trimmed BIX logging unless debug enabled

In order to improve performance, the statement "Node level information will not be added to the manifest when getAllProperties is selected in the extract rule form for XML extraction" (previously logged every time the XML output format has Include Manifest and Get All Properties checked) will only be printed in the logs if debug mode is enabled for ExtractImpl .

Busy icon shows properly when clicking Save/Refresh

The Busy indicator has been updated to ensure it appears as expected after clicking the Save/Refresh button of any harness.

Managed unique constraint violation error for BIX

When running multiple extracts using agents and pxExtractDataWithArgs at the same time, a unique constraint violation error was produced in the logs. This occurred when the extracts had the same time stamp down to the millisecond and an entry is added to the pr_log table when each extract starts. The pzInsKey for two extracts that run at the same time was identical, thus leading to this error. To resolve this, the thread name will be appended when the extract is run from an activity.

Error message for BIX DDL schema updated

Attempting to create BIX DDL through the Designer Studio led to the error message 'No Instance found in the database' when an invalid schema path was used. This error message has been modified to more specifically identify the problem to assist in troubleshooting.

Improved BIX extract handling for multiple active agents

When multiple agents were scheduled to run extracts at the same time by utilizing pxExtractDataWithArgs, there was intermittent failure in creating the manifest files. The BIX log would not contain an entry for the files being created, no error was displayed, and agents sometimes needed to be restarted. This was an issue with incomplete extraction of the output data and manifest files due to the PAL timer overriding the current thread context as it handled each of the multiple calls. To resolve this, the previous static variables used to store thread and requester instances have been made private to ensure reliability when handling parallel extracts and simultaneous runs.

Improved BIX extract handling for multiple active agents

When multiple agents were scheduled to run extracts at the same time by utilizing pxExtractDataWithArgs, there was intermittent failure in creating the manifest files. The BIX log would not contain an entry for the files being created, no error was displayed, and agents sometimes needed to be restarted. This was an issue with incomplete extraction of the output data and manifest files due to the PAL timer overriding the current thread context as it handled each of the multiple calls. To resolve this, the previous static variables used to store thread and requester instances have been made private to ensure reliability when handling parallel extracts and simultaneous runs.

BIX user guide clarifications on child/parent extracts

The below changes have been made in the BIX user guide for 7.2.1 in order to clarify the process for creating a BIX extract:

* The description of –c in “Setting optional command-line BIX parameters” in page-30 has been updated to  "Include children classes.
Use this parameter to extract the data for each sibling class of the class (classgroup/non class group) on which the extract is defined."

* “About Extract rules  / More about Extract rules / Rule operation” in page-16 has been updated to "If the class of the extract rule is a class group then the query on the source database will get all WorkObject instances of all classes within the class group. If the class of the extract rule is not a class group the query on the source database will only get instances of the particular class."

Handling added for large BIX Postgres data sets

BIX extracts were causing timeouts or JVM out of memory errors. This was traced to the Postgres JDBC driver ignoring fetch size in auto-commit transaction mode, which led to everything being loaded into memory at once. To resolve this, changes have been added to support fetch size for large results when using PostgreSQL database for BIX Extraction.