Versions Compared

Old Version 7

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Roderick Bowser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Expand
titleExpand for Table of Contents
Table of Contents

Software Downloads

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

Known Issues

Limited Forecast issue with Foreign Key Constraints

If you use the Limited Forecast functionality, please do not upgrade to version 7.13. An issue with Limited Forecast (DAT-8200) was discovered in Liquibase Enterprise & Business 7.13.

This issue is fixed in version 7.14 (and higher).

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 though the schema is included in the project definition (DAT-8329). If you encounter these errors with 7.13, 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.13, 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, 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.

Documentation for v7.13

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

Liquibase Enterprise & Business Clients (Datical DB)

Item

Path

File

Software

COMMON/Datical_DB_Software/Datical_DB_7.13.7069

Choose the Linux or Windows installation file for your system

Liquibase Enterprise Documentation

COMMON/Datical_Documentation/Datical_DB_Documentation

datical_db_docs_v7.13.pdf

Composite Installation Repository

COMMON/Datical_DB_Software/Datical_DB_7.13.7069

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

Expand
titleGetting 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.12.216

datical-service-unix-7_12_216-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
titleExpand for DMC update instructions

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

Code Block
/home/datical> sudo bash /datical-service-unix-7_12_216-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.

New Features

Certificate Authentication for the Azure REST API

Starting from release 7.13, you can use a certificate-based method to authenticate with the Azure REST API. Liquibase Enterprise uses the Azure REST API to perform a point-in-time restore during packaging for Azure SQL Managed Instances. To get started, refer to the Azure REST API for the Ephemeral Deploy Packager Process documentation.

Issue ID

Description

DAT-7119

Add Active Directory Certificate Authentication to DBDef Wizard/Editor

DAT-7120

Add a Client Certificate option to the utility scripts and CLI

DAT-7124

Use Client Certificate Authentication in Backup and Restore for Azure SQL Managed Instance

Notable Changes

Limited Forecast usability improvements

In release 7.13, we enhanced the Limited Forecast usability and significantly reduced the time you may spend on the forecast and deploy processes. The main fixes include table and schema profiling. Starting from version 7.13, Limited Forecast will only profile tables and schemas relevant for a specific deployment to eliminate a profiling time for your project. See the Limited Forecast documentation and the following table with the issues addressed for more details.

Issue ID

Description

DAT-6432

Limited Forecast is slow

DAT-7021

Limited Forecast should only profile the schema impacted by the changesets to be forecasted or deployed

DAT-7022

Limited Forecast should only profile tables impacted by the changesets to be forecasted or deployed

Issues Addressed

Liquibase Enterprise & Business Issues

Issue ID

Description

DAT-6431

The String index out of range errors when stored logic ends with -----.

DAT-6973

Liquibase Enterprise and Liquibase Business (versions 7.6 and later) SQLPLUS issue.

In release 7.6, we updated SQLPLUS 12.1 to SQLPLUS 12.2, which contains a bug: SQL PLUS 12.2 NOT OBSERVING SQLPATH IN REGISTRY OR ENV VARIABLE FOR LOGIN.SQL. For Windows, Liquibase Enterprise & Business (versions 7.6 and later) cannot pick up SQLPATH environment variable, and you may use SQLPLUS 12.1 as a workaround.

For Linux, you need to use ORACLE_PATH for Liquibase Enterprise and Liquibase Business 7.6 and later because SQLPATH is a Windows environment variable only.

DAT-7049

Packager: The Resources file for a -rollback script is not reflected correctly when using autoSubstitution=true.

DAT-7387

When packaging scripts that set objects to VALID with storedLogicValidityAction=fail, and there are other pre-existing INVALID objects, the result should be Warning.

...