Software Downloads

Go to https://software.datical.com to download files. See details for the release below.

Known Issues

Version 0 of stored logic objects is displayed in the DMC status view

In release 7.14 and later, we discovered that version 0 changesets for stored logic objects were displayed in the DMC status view. These changesets are only used for rollback operations and should not be included in the status view. Liquibase Enterprise & Business will include the fix in future releases. (DAT-8320)

Limited Forecast does not include `autoSynonymForObjects` changeset schemas in profiling

In release 7.13 and later, if you use Limited Forecast in Oracle multi-schema projects with auto synonyms, you might get errors about the schema targeted by an auto synonym change being for a schema that cannot be managed, even though that schema is included in the project definition. If you encounter such errors with version 7.17, use Full Forecast instead of Limited Forecast. (DAT-8757)

Missing SSH Preferences in Liquibase Enterprise & Business GUI

After upgrading Datical DB to later versions, you might have issues with the SSH feature being unavailable to generate the SSH key via the Eclipse GUI. To return SSH in Preferences, follow these steps:

In the Datical DB GUI, select Help > Install New Software.
In the Work with field of the Install dialog box, enter https://download.eclipse.org/releases/2018-12.
Select Git integration for Eclipse, and then select Next to install it.
Open Preferences. You should see SSH2 under Network Connections.

Liquibase Enterprise & Business cannot pick up SQLPATH environment variable on Windows

In release 7.6 and later, we updated the version of instantclient, which provides SQLPLUS 12.2.0.1.0. This version of SQLPLUS contains a bug: SQL PLUS 12.2 NOT OBSERVING SQLPATH IN REGISTRY OR ENV VARIABLE FOR LOGIN.SQL. As a workaround, use SQLPLUS 12.1 on Windows. (DAT-7598)

Documentation for v7.17

Documentation for the base release is available in the following forms:

Confluence space for Liquibase Enterprise/Datical DB - Datical Product Documentation Home
PDFs for Liquibase Enterprise on software.datical.com
Confluence space for Liquibase Business - Liquibase Business Portal
Deployment Monitoring Console (DMC) Documentation Site

Liquibase Enterprise & Business Clients (Datical DB)

Item	Path	File
Software	COMMON/Datical_DB_Software/Datical_DB_7.17.7272	Choose the Linux or Windows installation file for your system
Liquibase Enterprise Documentation	COMMON/Datical_Documentation/Datical_DB_Documentation	datical_db_docs_7.17.pdf
Composite Installation Repository	COMMON/Datical_DB_Software/Datical_DB_7.17.7272	DaticalDbCompositeRepo-7.17.7272.zip

Liquibase Deployment Monitoring Console (DMC)

Starting with release 7.0, Liquibase includes a web-based Deployment Monitoring Console (DMC) that provides a centralized location to view a pipeline status and reporting information for all your Liquibase Business & Enterprise projects.

Getting Started with the Deployment Monitoring Console

To get started with DMC, check out the following documentation resources:

Deployment Monitoring Console Software and Documentation

Liquibase Enterprise & Business Clients (Datical DB) and DMC Compatibility

Each DMC release only works with certain releases of Liquibase Enterprise & Business Clients (Datical DB). Consult the Datical DB and Deployment Monitoring Console Compatibility Matrix to ensure compatibility.

Item	Path	File
Software	COMMON/Datical_DMC_Software/Datical_DMC_7.17.243	datical-service-unix-7_17_243-master.sh
DMC Documentation	Online @ dmc.datical.com	<N/A>

Deployment Monitoring Console Update Instructions

The process of updating the Deployment Monitoring Console from version 7.0 or later to the latest version is similar to the installation process.

Expand for DMC update instructions

Go to software.datical.com, download and copy the datical-service-unix-7_17_243-master.sh file to your existing DMC server.
Run the installer with the following command and enter your existing OS user as the admin user and admin group:

/home/datical> sudo bash /datical-service-unix-7_17_243-master.sh

3. Enter the directory of the previous DMC installation when prompted for an install location.

The installer will update your installation and restart affected DMC services. You can begin using the new version of the DMC immediately.

If you have manually changed the java version used by DMC, you will need to restore DMC’s default version of Java (11.0.8) before any time that you upgrade DMC. Move or copy Java 11.0.8 from the /opt/datical/old_jre directory back to the /opt/datical/jre directory prior to starting your DMC upgrade. DMC expects Java version 11.0.8 to be in the /opt/datical/jre directory for the DMC upgrade process to be successful. After your DMC upgrade is complete, you can change to a different 11.x java version again. For more information, see How to Change the Java version for DMC.

Notable Changes

Consolidation and Expansion of Data in Forecast and Deploy Reports

Liquibase Enterprise & Business 7.17 removes redundant messaging in Deploy and Forecast reports by consolidating individual changes in a single section per changeset. For Liquibase Enterprise it also expands changeset metadata to include packaging attributes like the file path and filename of the originating script in the SQL repository.

Certified Support for New Versions of PostgreSQL in AWS Aurora & RDS

In this release, Liquibase Enterprise & Business add support for PostgreSQL versions 12 & 13 in AWS Aurora and AWS RDS. Liquibase Enterprise & Liquibase Business can be used in these platforms without limitation and with full support.

Issues Addressed

Liquibase Enterprise & Business Issues

Issue ID	Description
DAT-4344	Fixed the Packager report to show Contexts that are in a changeset
DAT-6884	Fixed the `Storedlogic` scripts for SQL Server to keep `SET QUOTED_IDENTIFIER` and `ANSI_NULL` values
DAT-7345	Updated `deployReport.html` and `forecastReport.html` to work with a new `changeSet` model rather than with `changeImpact`
DAT-7620	Fixed the SqlTool logging for the `daticaldb.log`
DAT-7689	Fixed the password missing exception in the `daticaldb.log` when using runtime credentials
DAT-8239	Placed `.log` files for packageMethod=convert in the Packager report folder (instead of Resources folder)
DAT-8537	Implemented additional logging for changesets in Forecast and Deploy operations: All files for Forecast and Deploy are listed in the proper order Added message about which script is starting to deploy (which can be helpful for troubleshooting if a script/changeset appears to be hanging)
DAT-9055	Fixed the `psql` change type to print command arguments in the log
DAT-9605	Fixed Oracle Backup and Restore “ORA-00972: identifier is too long” errors (this only happened with Datical version 7.16 with Oracle 12.1 or lower).

Datical v7.17 - Release Notes

Table of Contents