Liquibase Enterprise was formerly known as Datical DB.

Liquibase Enterprise 7.17 Release Notes

Owned by Former user (Deleted)
Last updated: Nov 03, 2022 by Former user (Deleted)
4 min read

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 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:

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

  2. In the Work with field of the Install dialog box, paste in this link: https://download.eclipse.org/releases/2018-12 then hit enter.

  3. Expand open the Collaboration category.

  4. Enable the checkbox to select Git integration for Eclipse, and then select Next to install it.

  5. When it finishes installing, you will be prompted to restart.

  6. Open File > Preferences > General > Network Connections. You should now have a new SSH2 option under Network Connections.

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

Documentation for v7.17

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

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

  1. Go to software.datical.com, download and copy the datical-service-unix-7_17_243-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_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).

Copyright © Liquibase 2012-2022 - Proprietary and Confidential