Liquibase Enterprise was formerly known as Datical DB.

Liquibase Enterprise 8.1 Release Notes

Software Downloads

Go to https://software.datical.com to download files.

Notifications

Database Driver Updates in v8.0

New database drivers are available for Liquibase Enterprise starting in version 8.0. It is important to note that the Liquibase Enterprise version needs to match the driver version to operate successfully.

If using the Composite Repo to install drivers, ensure that the Composite Repo matches the version of Liquibase Enterprise Client you are installing drivers on.

If using the Software Update Site (http://update.datical.com) to install drivers, ensure that the URL matches the version of Liquibase Enterprise Client you are installing drivers on.

Here are some examples of appropriate driver locations using the Software Update Site:

Many customers have reported issues using http://update.datical.com/latest/thirdparty/ to install drivers

  • This is not a best practice behavior, and should only be done when simultaneously installing the latest version of Liquibase Enterprise along with the drivers.

  • Using this URL to install drivers on an older version of Liquibase Enterprise may cause unexpected issues.

Notable Changes

DMC: Support for LDAP Groups

Liquibase Enterprise DMC 8.1 now supports synching of LDAP groups.

This allows you to add project permissions to groups rather than or in addition to individual users.

Click here to access documentation on how to configure Keycloak to import your LDAP groups once you upgrade to 8.1

DMC: Keycloak Server Update

Liquibase Enterprise DMC 8.1 now uses Keycloak 19. This is a major upgrade from Keycloak 8 used in previous releases.

Benefits to this update:

  • Addresses vulnerabilities discovered in previous Keycloak versions

  • Streamlines configuration with a simpler interface

  • Added support for various connection adapter options

DMC Issues Addressed

Issue ID

Description

DAT-6341

 

Fixed the “Data integrity check failed” error that prevented the deletion of projects in a DMC training instance.

DAT-9373

DAT-9371

Fixed the Troubleshoot command so it notifies you when there are problems with the proxy server.

DAT-11454

The save button on the Permissions page was not in a user friendly location. Autosave functionality is available now to circumnavigate the save button issue.

DAT-11212

The error associated with foreign key constraint violations is resolved. Users can register projects successfully.

DAT-11152

Resizing DMC columns is more intuitive for users. A line now appears between column headers which changes the cursor style to indicate the column can be resized.

DAT-8320

Fixed the issue that caused version 0 of the stored procedure to appear when it was the same as version 1. Version 1 appears as expected.

DAT-11424

The Project Settings Permissions tab allows you to filter for users so they can be found quickly.

DAT-3909

Fixed the issue that caused disabled users to appear as valid users on Admin or Project pages.

SQL Parser Issues Addressed

Issue ID

Description

DAT-10797

Fixed the Forecast failure that occurred when comments were made on modified views.

DAT-10852

DAT-9517

Fixed the Forecast failure that occurred when the NOT NULL constraint was dropped on a column added in a previous Changeset.

Desktop Client and CLI Issues Addressed

Issue ID

Description

DAT-9810

Fixed the slow query retrieval of constraint info for cross schema foreign keys.

DAT-9245

Fixed the issue that prevented sqlfile / JDBC rowcount output when a comment was located before the insert statement.

DAT-8424

 

Fixed the issue that caused the Auto-Synonym changeset fail error. Users can use CREATE OR REPLACE as a synonym that was previously created for autoSynonymForObjects.

DAT-11748

DAT-2458

DAT-2457

You can now manually create a DATICAL_SPERRORLOG table to capture output for scripts executed using sqlplus during deployment.

DAT-11453

Fixed the issue that caused rollback to fail if it contained both rerunnable and non-rerunnable Changesets, but the non-re-runnable Changesets were complete.

DAT-11384

Fixed the deploy failure that occurred when attempting to deploy CREATE or ALTER SQL statements using createFunction.

DAT-11383

Fixed the forecast error that occurred when createFunction DDL had CREATE OR ALTER SQL statements.

DAT-11318

Fixed the issue that caused rollback SQL to not be empty when it should have been.

DAT-10709

Fixed the DefaultSchemaName issue that caused rollback to fail.

DAT-10056

The warning that appears during packaging when the two new backup files are not found is updated to state: There are no privileges to be restored in this step.

DAT-9246

Fixed the issue that caused the rowcount for sqlfile / JDBC to not appear in MERGE statements.

DAT-8238

Fixed the out of memory error that occurred with large scripts.

DAT-11828

Restored the MSVCR120.dll in the instantclient directory.

DAT-11637

The full stack trace that occurs when connection to the DMC DB is not available is suppressed for Packager and Rollback. This indicates to the user that both Packager and Rollback executed successfully.

Documentation for v8.1

Documentation is available in the following locations:

Liquibase Enterprise & Business Clients (Desktop & CLI)

Item

Path

File

Item

Path

File

Software

COMMON/Datical_DB_Software/Datical_DB_8.1.7474

Choose the Linux or Windows installation file for your system

Composite Installation Repository

COMMON/Datical_DB_Software/Datical_DB_8.1.7474

DaticalDbCompositeRepo-8.1.7474.zip

Liquibase Enterprise Deployment Monitoring Console (DMC)

Item

Path

File

Item

Path

File

Software

COMMON/Datical_DMC_Software/Datical_DMC_8.1.317

datical-service-unix-8_1_317-master.sh

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.

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

Each DMC release only works with certain releases of Liquibase Enterprise Desktop. Consult the Deployment Monitoring Console Compatibility Matrix to ensure compatibility.

 

DMC 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-8_1_317-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-8_1_317-master.sh
  1. 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.

 

 

Copyright © Liquibase 2012-2022 - Proprietary and Confidential