> For the complete documentation index, see [llms.txt](https://docs.collibra.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.collibra.com/data-quality-self-hosted/release-notes/data-quality-observability-self-hosted-release-archive/release-2022-06.md).

# Release 2022.06

#### Fixes / Enhancements

* DQ Job
  * Fixed an issue with the Learning Phase in the Behavior feature. (ticket #82907)
    * Once CDQ has the minimum number of completed successful scans, the learning status now changes to PASSING or BREAKING based on the results.
* Outliers
  * Fixed an issue where file lookback did not identify expected outliers. (#87967)
* Alerts
  * When configuring email alerts, SMTP Username and SMTP password fields are still required fields. (#86033)
    * Validation relaxation is planned for the 2022.07 release.
* Rules
  * Fixed an issue which caused rule breaks to report the opposite of what was defined when a [Generic Rule utilizing regex/rlike](https://collibra.zendesk.com/knowledge/articles/6572100149143/en-us?brand_id=1497556) was created. (#86977)
  * Fixed an issue where Data Classes with Date column types selected did not detect timestamps. (#83000)
  * Fixed an issue where Data Classes using the operators `<`, `>` or `=` caused the inverse rule created from this process to throw exceptions. (#83000)
  * When switching a data class from a regex to expression and then editing again, the regex checkbox is now correctly checked.
* Agent
  * The Explorer page and Scheduler modal now display the same agents. (#86175)
* Security
  * Vulnerabilities identified by Jfrog
    * Vulns 0, criticals 0, high severity 8
    * For a visual readout, see the DQ Security Metrics section below.
  * General advisory:
    * There is a critical CVE `CVE-2016-1000027` that shows up in the image scan due to Spring version. This is a false positive and should be added to the exception list of the customer scan tools. We don’t use `HttpInvokerServiceExporter` anywhere in the application and are not impacted by it.
      * [There is no fix version available for it from Spring. More details are available at Sonatype vulnerability CVE-2016-1000027 in Spring-web project · Issue #24434 · spring-projects/spring-framework](https://github.com/spring-projects/spring-framework/issues/24434)
  * Major vulnerabilities related to Spring, ESAPI, and Swagger have been addressed.
  * No cross DB reference is allowed in explorer while accessing SQL database connections.
  * Sensitive UI fields such as username no longer allow autocomplete.
  * If configured, the ENV variable `XSS_CANONICALIZE_INPUT_ENABLED` should be removed from configmap or owl-env.sh.
  * When dataset security is turned on, you can now add role based authorization for editing existing datasets. (#87720)
  * You can now override the following mail settings from the App Config page within the Configuration section of the Admin Console:
    * "mail.transport.protocol" -- default = smtp
    * "mail.smtp.auth" -- default = true: If true, attempt to authenticate the user using the AUTH command
    * "mail.smtp.auth.login.disable" -- default = false: If true, prevents use of the AUTH LOGIN command
    * "mail.smtp.starttls.enable" -- default = true: If true, enables the use of the STARTTLS command (if supported by the server) to switch the connection to a TLS-protected connection before issuing any login commands.
    * "mail.smtp.ssl.enable" -- default = false: If set to true, use SSL to connect and use the SSL port by default. Defaults to false for the "smtp" protocol and true for the "smtps" protocol.
    * "mail.smtp.ehlo" -- default = true
    * "mail.debug" -- default = true
    * "mail.smtp.ssl.trust" -- default = : If set, and a socket factory hasn't been specified, enables use of a MailSSLSocketFactory. If set to "\*", all hosts are trusted. If set to a whitespace separated list of hosts, those hosts are trusted. Otherwise, trust depends on the certificate the server presents. (#76775, 88089)
* Profile
  * Mean value is now rounded appropriately within the Profile page.
    * For example: The value 2.4334334343345 is now rounded to 2.434.
* Connections
  * From the Athena driver, you can now use `MetadataRetrievalMethod=Query` for database queries from the Connection URL. (#86139)
  * Fixed an issue where error messages on failed connections did not display informational text. (#85527)
  * Fixed an issue where NFS file connections under Remote File connections caused jobs to fail. (#88156)
    * Added File protocol for Spark load for NFS file system.
    * Added nfs\:// prefix wile adding a NFS connection.
      * This will prepend the URI with the file:// protocol when an NFS file connection is loaded via Spark.
* Catalog
  * The Graph option is no longer available in Quick links.
* Admin
  * The Pendo integration is now active by default.
    * No sensitive information is collected; only high-level usage stats are collected.
    * All new customers starting with 2022.06 onward will receive a new license.
    * If you install a standalone environment, modify the \<install-dir>/config/owl-env.sh file by adding your license name`export DQ_INTEGRATION_PENDO_ACCOUNTID=<your-license-name>`
    * This new integration will not block or impair the functionality of the app in any way.
    * For more information on Collibra's subprocessors, please review [Collibra's Subprocessors page](https://www.collibra.com/us/en/collibra-subprocessors).
  * The Agent Group (H/A) and its associated endpoints are now deprecated. (#83086)
  * Fixed an issue where the "Add Data Category" button was missing without required permissions. (#86625)
  * When a session expires on an Admin page, you are now redirected to the login page.
  * The Admin Limits page now displays informational text indicating that only limits of Tenant - Admin type are displayed on the page.
  * Fixed an issue when editing an existing data category which caused the 'Add new' modal to open instead of the 'Edit' modal. (#89617)
  * From Configuration Settings, DB Limits is now called Data Retention Policy.
* Explorer
  * You can now view calculated views for SAP HANA when creating a DQ Job on the Explorer page. (#83147, 84328)
  * Fixed an issue which caused the Date range condition to incorrectly display results when using an Oracle connection. (#85802)
  * Fixed an issue which threw an error message when Transform was checked with Date Range condition when using a Postgres connection. (#85802)
  * Fixed an issue where an equals sign `=` used in a `-transform` expression from Run CMD caused jobs to fail. (#71547)
  * Fixed an issue where schema and table names containing underscores `_` were not accepted.
  * Fixed an issue that allowed jobs to run with a row limit of less than 1.
  * Fixed an issue where incorrect files loaded for preview from BLOB containers with Livy enabled.
  * CLOB data types are unsupported. (#86902)
  * Improved performance and logic when drilling into a database and schema from the Explorer page.
* API
  * You can now access API quick links page from the Admin Console React page.
  * When using Swagger, UI text now indicates when a field is case sensitive.
* Reporting
  * \*Tech Preview\* \[TP] Rule Summary page enhancements
    * You can now filter rule breaks by most frequent violations, most severe violations, and least violations.
    * You can now view interactive pie charts with rules and dimension summaries.
* UI
  * The styling of the expandable legacy navigation pane and the react menu are now updated.
* Legal
  * Added a disclaimer to the DQ login page with a link to the Collibra Evaluation Agreement.

#### Known Limitations

* Validate Source
  * When comparing JDBC (target) to remote files such as S3 (source), there is a known Spark bug for "Recursive view detected".
    * This validate source combination is not possible in 2022.06 using Spark 3.2.
  * When using Bigquery as the source, the -libsrc needs to be manually modified to include the core (Spark Bigquery connector) directory.
    * For example, /home/centos/owl/drivers/bigquery\*\*/core\*\*
* Profile
  * Spark does not currently support varchar data types. All varchar data types are converted to String. Other unsupported data types may also be converted incorrectly.
* Security
  * Permissions on the Export task have not yet been addressed when dataset security is turned on and you add a role based authorization for editing existing datasets. (#87720)

#### DQ Security Metrics

{% hint style="danger" %}
There is a critical CVE `CVE-2016-1000027` that shows up in the image scan due to Spring version. This is a false positive and should be added to the exception list of the customer scan tools. We don’t use `HttpInvokerServiceExporter` anywhere in the application and are not impacted by it.There is no fix version available for it from Spring. More details are available at [Sonatype vulnerability CVE-2016-1000027 in Spring-web project · Issue #24434 · spring-projects/spring-framework](https://github.com/spring-projects/spring-framework/issues/24434)
{% endhint %}

![Vulns over time](https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-56334df0d1bfcb9fa51211673f0a1d141e5aa602%2Fvulns-over-time-2022-06.png?alt=media)

![Criticals table](https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-91ddaccd11f2244069fd6787b8029e1c57ca0bfb%2Fcritical-table-2022-06.png?alt=media)
