Issues fixed in Corticon 6.3

• [progress][Oracle JDBC Driver]Driver Version: 6.0.0.001776 (F003210.U002087)
• [progress][PostgreSQL JDBC Driver]Driver Version: 6.0.0.00185 (F003185.U002075)
• [progress][MySQL JDBC Driver]Driver Version: 5.1.4.000364 (F000633.U000372)
• [progress][SQLServer JDBC Driver]Driver Version: 6.0.0.001957 (F003175.U002068)

* [progress][SQLServer JDBC Driver]Driver Version: 6.0.0.001848 (F002859.U001849)

* [progress][Oracle JDBC Driver]Driver Version: 6.0.0.001574 (F002815.U001793)

* [progress][PostgreSQL JDBC Driver]Driver Version: 6.0.0.001733

(F002856.U001846) * [progress][DB2 JDBC Driver]Driver Version: 5.1.4.000455 (F000599.U000343)

* [progress][OpenEdge JDBC Driver]Driver Version: 5.1.4.000187

(F000605.U000352) * [progress][MySQL JDBC Driver]Driver Version: 5.1.4.000330 (F000614.U000359)

com.corticon.ccserver.allocation.disable.underutilization.algorithm =false

Default value: false

com.corticon.server.decisionservice.allocation.enabled=false

Updated multiple bundled Progress DataDirect Connect drivers. The updated driver versions are now:

* SQLServer JDBC Driver Version: 6.0.0.001525

* Oracle JDBC Driver Version: 6.0.0.001235

* PostgreSQL JDBC Driver Version: 6.0.0.001395

* MySQL JDBC Driver Version: 5.1.4.000266

* DB2 JDBC Driver Version: 5.1.4.000413

Consult the DataDirect Connect documentation for more information.

Adding a partial assignment expression to a rulesheet and later switching it to be a complete assignment expression could result in one or more corresponding rule cells for the action being corrupted. The Corticon Studio rulesheet editor would appear to show the correct value for the cells even though the underlying definition for the cells are incorrect. This could result in rule execution not matching what is shown in the rulesheet.

| Action         | 1 | 
---------------------- 
| Order.approved | T |

| Action             | 1 | 
--------------------------
| Order.approved = F |   |

Order.approved = F = T 

Corticon Studio now prevents this sequence of actions from causing the corruption of action rule cells.

This problem dates back to Corticon 5.6 or earlier. Running the Corticon upgrade wizard will check for this condition and correct any corrupted cells.

1. Three or more filters on root entities (entities without associations between them)
2. A filter that uses an association traversal to another entity
3. A rule that uses two or more entities in filter #1 and does not use the associated entity from #2

Updated the bundled Data Direct JDBC drivers PostgreSQL. The current bundled versions are:

* [Oracle JDBC Driver]Driver Version: 6.0.0.000707 (F001549.U000777)

* [SQLServer JDBC Driver]Driver Version: 6.0.0.000998 (F001590.U000791)

* [DB2 JDBC Driver]Driver Version: 5.1.4.000336 (F000525.U000273)

* [MySQL JDBC Driver]Driver Version: 5.1.4.000223 (F000438.U000209)

* [PostgreSQL JDBC Driver]Driver Version: 6.0.0.000318 (F001235.U000640)

* [OpenEdge JDBC Driver]Driver Version: 5.1.4.000161 (F000502.U000252)

COR-11457

Fixed a problem where user supplied database drivers could not be configured in Corticon Studio when using Java 11. User supplied drivers can now be specified as Corticon Extensions in the Studio Project Properties. Corticon Studio 6.3 bundles OpenJDK 11.

COR-11860

Updated the bundled jackson-databind library from version from 2.12.1 from 2.12.7 to address the potential vulnerability identified in CVE-2020-36518.

Updated the bundled Data Direct JDBC drivers for Oracle, SQLServer, and PostgreSQL. The current bundled versions are:

* [Oracle JDBC Driver]Driver Version: 6.0.0.000707 (F001549.U000777)

* [SQLServer JDBC Driver]Driver Version: 6.0.0.000998 (F001590.U000791)

* [DB2 JDBC Driver]Driver Version: 5.1.4.000336 (F000525.U000273)

* [MySQL JDBC Driver]Driver Version: 5.1.4.000223 (F000438.U000209)

* [PostgreSQL JDBC Driver]Driver Version: 5.1.4.000352 (F000548.U000290)

* [OpenEdge JDBC Driver]Driver Version: 5.1.4.000161 (F000502.U000252)

COR-11827

Updated the Corticon Web Console's LDAP authentication to support OpenLDAP. The Web Console supports both Microsoft Active Directory and OpenLDAP.

Modified Corticon Server to correctly reject the deployment of an .eds file produced with a version of Corticon prior to 5.6, while also logging an error message stating that the .eds needs to be regenerated. An .eds file produced with Corticon 5.6 or earlier must be regenerated for use with Corticon 6.1 and later. It is best practice to regenerate all .eds files whenever moving to a new Corticon major.minor version.

Fixed a problem in Corticon Server execution where the execution thread would not terminate after execution timeout. Execution would cease but the thread would not terminate. This would eliminate the thread from availability to Corticon Server, reducing the number of threads available for execution.

When using Corticon Server in-process, the ICcServer.execute methods now optionally throw as exceptions any runtime exception which occurs.

Previously any exception which occurred once rule execution began would be returned as a rule message with severity violation in the response payload. This is still the default behavior.

Setting the property:

com.corticon.server.execution.processing.throw.exceptions=true

will cause the exceptions to be thrown and not returned in the response payload. For in-process usage, this makes it easier to catch and handle runtime exceptions.

Fixed a problem where the files names generated for service contracts and reports created from Corticon Studio would have "%20" in the generated file names in place of any spaces in the rule flow name. The generated file names will now contain spaces.

COR-11615

Fixed a problem where Corticon Server would fail to process JSON input payloads if the following conditions were met:

1) an Entity or Association in the JSON payload had a defined #id value in the __metadata object,

2) the #id value contained "_id_", and

3) the value to the right of the "_id_" was not a number (Entity_id_1a).

Previously a "NumberFormatException" would be generated.

COR-11779

Improved the performance of rule sheet operators on Integer attributes. Previously Corticon used the Java BigInteger type for these operators, it now uses Long. Long is a 64 bit integer with a range of values from -2^63^ to 2^63^-1. The Long type provides substantially better performance than BigInteger. This change is internal to Corticon and will have no visible effect, other than improved performance.

Added the default brms.properties to PROGRESS_CORTICON_6.x.x.x_DOCKER.zip file.

The "DOCKER.zip" distribution is available on Progress ESD. It's a limited distribution of Corticon Server, providing just the components required for Docker deployment. Including brms.properties makes it easier to customize properties such as log settings when deploying Corticon Server with Docker.

Fixed a problem where Corticon Server would not accept JSON payloads with "null" entity definitions when executing a decision service. Passing a "null" entity definition would result in a JSONArray[n] is not a JSONObject exception. Any "null" entities are discarded when parsing the input payload and will be excluded from response payload.

COR-11524

Fixed the Corticon Studio and Corticon Server installers to support installation on Windows 11 systems. Previously installation would generate a "Flexeraaxd$aaa: Windows DLL failed to load" exception.

COR-11291

Improved Corticon Studio performance when validating ruleflows. Previously redundant validations could occur when using nested ruleflows. The performance improvement can have significant benefits when working on large rule projects in Corticon Studio.

Fixed a problem where rulesheet filters with EDC were not executed if the filtered entities were within a user defined domain in the vocabulary. When using EDC, rulesheet filters on a table are executed in the database for efficiency. Previously the filters would not run if the entity mapped to the table was in a user defined vocabulary domain.

Fixed a problem where rulesheet filters could produce incorrect results. If a rulesheet contains a collection operator and a filter that references the collection operator alias as well as an entity outside the collection alias scope, the filter would fail to correctly filter the collection content.

Fixed a problem where the Web Console would fail to delete and undeploy a decision service when authentication was enabled. This would occur both in the Web Console browser UI and the corticonWebConsole command line utility.

Incorrect results with Replace elements operator using XML payload in 5.7

Fixed a problem where a Corticon Server execution thread would be orphaned if a server execution timeout occurred. When  Corticon Server is servicing an execution request a timeout will occur if the execution time exceeds the server execution timeout. The timeout protects against execution requests hanging or dominating the server. The most frequent cause of timeouts is databases queries exceeding expected response times. When a server timeout occurs, the executing thread was not returned to the execution thread pool and thus would be unavailable to service future requests. This could reduce the overall throughput of the server.

Fixed a problem where Corticon could add a spurious duplicate entity at the root of the result payload. This would occur for associations where the XML/JSON mapping name for the association was overridden and the association was used in a filter. In processing the payload Corticon would erroneously add the associated entity to the root of the payload being processed causing the entity to be duplicated in the result payload, once on the association and once at the root.

Fixed a problem where Corticon Server would handle non vocabulary entities incorrectly. Corticon Server is designed to ignore entities, attributes, and associations not defined in the vocabulary. In some cases, a non vocabulary entity could cause Corticon Server to interpret the hierarchical relationship of an XML payload incorrectly.

Modified the Corticon Studio Rule Message View to persist column widths when changing views.

Updated the bundled Progress DataDirect Connect drivers. This delivers multiple driver level fixes. Consult the DataDirect Connect documentation for more details. The bundled Connect driver versions are now:
* \[progress]\[Oracle JDBC Driver]Driver Version: 6.0.0.000479 (F001351.U000677)
* \[progress]\[DB2 JDBC Driver]Driver Version: 5.1.4.000336 (F000525.U000273)
* \[progress]\[SQLServer JDBC Driver]Driver Version: 6.0.0.000694 (F001336.U000671)
* \[progress]\[MySQL JDBC Driver]Driver Version: 5.1.4.000223 (F000438.U000209)
* \[progress]\[PostgreSQL JDBC Driver]Driver Version: 5.1.4.000334 (F000530.U000278)
* \[DataDirect]\[OpenEdge JDBC Driver]Driver Version: 5.1.4.000161 (F000502.U000252)

Modified Corticon Studio to allow composite filters in a rulesheet where the filter performs a tabulation on a collection such as:      Order.total -> sum >100
Although Corticon Studio allows it,  when using EDC not all databases support such filters.

Modified Corticon Studio Tester to support updates to REST datasource configurations after a Tester window is opened. Previously, changing a REST datasource configuration would require a ruletest to be closed and reopened for the REST change to be recognized.

Fixed a rulesheet code generation error which would occur when using truncate and other extended operators in complex expressions where the operator was used following another operator in the expression. For example here truncate is in a complex expression and used after the toDecimal operator:
entity.decimal1 = (entity.int1 * 2).toDecimal.truncate

Corticon now supports deployment to JBoss 7.3. See the supported platform matrix for details.

Fixed a problem in executing corticonManagement.bat provided with Corticon Server. Previously it would generate an invalid .eds file when the output directory was specified as a relative path. Relative paths can now be used.

Fixed a problem in executing multipleCompilation.bat provided with Corticon Server. Previously it could generate a class not found error.

Fixed the deployment of decision services from Corticon Studio to the Corticon Web Console where the decision service contains one or more datasources. Previously the deployment would fail. Deployment to a Corticon Server was unaffected.

Updated the Corticon Studio operator tool tip for the Date.toDateTime operator to match the documentation.

Fixed a potential code generation problem which would result in a "toDecimal symbol not found" error when compiling a rulesheet . This problem could occur in rulesheets using Decimal attributes in complex expressions.

Fixed a problem where Corticon Server deployed to IIS would not self-register with the Corticon Web Console.