Liquibase Enterprise was formerly known as Datical DB.

Liquibase Enterprise v7.16 - 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 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 doesn’t 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 may 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.16, 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:

  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.

Oracle Backup and Restore “ORA-00972: identifier is too long“ errors

This error only happened in Datical version 7.16 with Oracle 12.1 or lower. This is fixed in versions 7.17 and higher. (DAT-9605)

Deprecation of the Oracle Accelerator JDBC Driver

Because of a change in deployment trends and continued improvement of the performance of Datical DB, the Oracle Accelerator JDBC Driver (compression driver) was removed from our driver repository in versions 7.16 and higher.  The driver was previously available with versions 7.15 and lower.

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

Documentation for v7.16

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.16.7223

Choose the Linux or Windows installation file for your system

Liquibase Enterprise Documentation

COMMON/Datical_Documentation/Datical_DB_Documentation

datical_db_docs_7.16.pdf

Composite Installation Repository

COMMON/Datical_DB_Software/Datical_DB_7.16.7223

DaticalDbCompositeRepo-7.16.7223.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.16.242

datical-service-unix-7_16_242-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_16_242-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_16_242-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

Certified Support for RHEL 8 in Liquibase Enterprise & Business and DMC

In version 7.16, we completed certification of Red Hat Enterprise Linux 8 for use with the Liquibase Enterprise Client and as a host operating system for the Deployment Monitoring console.­­

Issues Addressed

Liquibase Enterprise & Business Issues

Issue ID

Description

Issue ID

Description

DAT-5695

Added Rows Affected for the sqlfile packaging method (JDBC) results in the Deploy Report

DAT-7630

Fixed SQL Parser forecast errors with duplicate materialized view if script drops and creates materialized view

DAT-7826

Fixed the Numeric Overflow Query error in forecast when using the enableRowCount=approximate attribute for Oracle

DAT-7832

Fixed cross-schema grants and cross-schema foreign keys missing after schema level backup and restore for Deploy Packager and Oracle databases

DAT-7882

Fixed the hammer runRules <list_of_files> command to handle the SQL extension correctly

DAT-8003

Fixed the Stored Logic Validity Check section marked as ERROR when Deploy report has ERROR unrelated to Stored Logic Validity Check

DAT-8061

Fixed Deploy Packager error with packageMethod=STOREDLOGIC when the schemaName value in the metadata.properties file has a dot character (".")

DAT-8237

Added missing project settings to the Project settings section of the daticaldb.log and packager.log files:

  • storedLogicValidityAction

  • storageOptionsScope

  • autoGenSQL

  • dbSchemaDefinition

  • requireOptions

  • rowsPerBatch

  • enableCompression

  • enableDdlLockTimeout

  • ddlLockTimeoutValue

  • schemaSelectionStep

  • markDropsUnused

DAT-8761

Fixed the Deploy report indicating success when the Deploy operation captures the SqlPlus SP2-0341 error (line overflow during variable substitution)

 

Copyright © Liquibase 2012-2022 - Proprietary and Confidential