Liquibase Enterprise was formerly known as Datical DB.

Liquibase Enterprise v7.14 - Release Notes

Table of Contents

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, we discovered that version 0 changesets for stored logic objects were being 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 not profiling all schemas impacted by some change set types

When using Limited Forecast in multi-schema projects you may get errors about the schema targeted by a change being for a schema that is unmanaged by the product even through the schema is included in the project definition (DAT-8329). If you encounter these errors with 7.14, the workaround is to use Full Forecast instead of Limited Forecast. This is fixed in 7.15 and higher.

Limited Forecast doesn’t include autoSynonymForObjects change set schemas in profiling

When using Limited Forecast in Oracle multi-schema projects, if you use Auto Synonyms you may get errors about the schema targeted by an autoSynonym change being for a schema that cannot be managed, even though that schema is included in the project definition (DAT-8757). If you encounter these errors with 7.14, the workaround is to use Full Forecast instead of Limited Forecast.

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:

  1. In the Datical DB GUI, select Help > Install New Software.

  2. In the Work with field of the Install dialog box, enter https://download.eclipse.org/releases/2018-12.

  3. Select Git integration for Eclipse, and then select Next to install it.

  4. 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 higher, 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 (DAT-7598). As a workaround, you can use SQLPLUS 12.1 on Windows.

Documentation for v7.14

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

Liquibase Enterprise & Business Clients (Datical DB)

Item

Path

File

Item

Path

File

Software

COMMON/Datical_DB_Software/Datical_DB_7.14.7131

Choose the Linux or Windows installation file for your system

Liquibase Enterprise Documentation

COMMON/Datical_Documentation/Datical_DB_Documentation

datical_db_docs_7.14.7131.pdf

Composite Installation Repository

COMMON/Datical_DB_Software/Datical_DB_7.14.7131

DaticalDbCompositeRepo-7.14.7131.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.

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

Item

Path

File

Software

COMMON/Datical_DMC_Software/Datical_DMC_7.14.232

datical-service-unix-7.14.232-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.

  1. Go to software.datical.com, download and copy the datical-service-unix-7.14.232-master.sh file to your existing DMC server.

  2. 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.14.232-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.

Notable Changes

Forecast performance improvements

In release 7.14, we discovered the profiler synchronization issue causing profiling slowdown for multischema projects. We fixed the issue and enhanced the forecast profiling performance for tables, columns, and views.

Issue ID

Description

Issue ID

Description

DAT-7313

Views and materialized views take a long time to profile during forecast.

DAT-7558

Enhance forecast profiling performance for tables, сolumns, views in multischema projects.

DAT-8161

Use multiple connections to profile Oracle multischema projects (maximum of 10 connections). Note that with 7.14 and higher, in Oracle projects with multiple schemas, you may notice higher CPU utilization due to multiple connections being used for Oracle forecast profiling.

DMC enhancements

Starting from release 7.14, Liquibase Enterprise & Business provides significant improvements for DMC usability. The main fixes are related to columns and to displaying packaged changes in DMC (even if they haven’t been deployed). See the following table with the issues addressed for more details.

Issue ID

Description

Issue ID

Description

DAT-3077

Make table view settings persistent so that views persist across sessions and instances of the same view type.

DAT-6176

Reflect changeset labels and contexts that are removed in the DMC pipeline view.

DAT-6395

Display packaged scripts in DMC before they are deployed to a database.

DAT-6790

Make status column dividing lines visible on the project, dbdef operation report, and pipeline dbdef status views so it is easier to resize them. From now on, you can see visible dividers between the columns.

DAT-6791

Fit more columns on the status page.

DMC includes the option to collapse and expand the left navigation.

DAT-6793

Make the title of the Date column on the left of the status page more descriptive.

DAT-6990

Add tooltips to the icons on the upper right side of the report view.

Issues Addressed

Liquibase Enterprise & Business Issues

Issue ID

Description

Issue ID

Description

DAT-6994

The COMMENT ON COLUMN statements fail when being  packaged using CONVERT.

DAT-7037

packager.log has incorrect values for the multiSchema and multiCatalog (multi-database) project settings.

DAT-7409

Liquibase Enterprise with SQL Server: ConvertSQL cannot change the column type and NOT NULL at the same time.

The fix contains:

  • DAT-7559 - Updates for the ConvertSQL logic to add the additional addNotNullContraint change when DiffChangelog generates the modifyDataType change and the table column before and after deployment is not nullable.

  • DAT-7560 - Updates to prevent the forecast and deploy error when deploying the addNotNullContraint change and when the constraint already exists in DBModel.

DAT-7733

The PostgreSQL driver update caused the regression with partitioned tables for the snapshot functionality.

DAT-7451

Multi-catalog (multi-database) and Multi-schema values are switched in Console/DaticalDB log's Project settings output

DAT-7851

Fixed the issue with Azure MI Active Directory Password authentication that happened due to the MSSQL driver upgrade in the 7.13 release.

DAT-8200

The Limited Forecast issue with Foreign Key constraints in 7.13 “ERROR - Columns VLA_PK do not exist”. This issue with Limited Forecast only occurred in version 7.13. It is now fixed in version 7.14.

 

Copyright © Liquibase 2012-2022 - Proprietary and Confidential