Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

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.

Notifications

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

Upgrade Instructions For This Release

A fresh install is required for Liquibase Enterprise & Business 8.0 to function successfully. Upgrading from 7.18 to 8.0 using the Install New Software feature is not recommended. If installing to the same location, you will need to first uninstall the previous installation.

Installation still requires a minimum of Java 8 to be installed on the operating system beforehand.

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

Coming Soon:

New Location for

Revamped Liquibase Enterprise Docs!

All Liquibase Enterprise Documentation documentation will be available on docs.liquibase.com within the coming weeks! This new format will allow users to quickly find the documentation that caters directly to their user persona.

All relevant content from the existing Liquibase Enterprise Documentation in Confluence and DMC Documentation sites will be migrated.

Notable Changes

Tip
The upgrade to Java 11 is here!

Java JRE & Eclipse Upgrades

Liquibase Enterprise v8& Business 8.0 and forward ships with and requires a Java 11 runtime environment. Previous versions used Java 8.

If your installation uses a different JRE than the one bundled with Liquibase Enterprise, you will need to update this to Java 11 prior to installing future versions.

Upgrade Instructions

A fresh install is required for running Liquibase Enterprise 8.0 to function successfully. Upgrading from 7.18 to .

Also in version 8.0 is using the Install New Software feature is not recommended. If installing to the same location, you will need to first uninstall the previous installationwe have upgraded the underlying Eclipse framework to the latest version. This enables us to use the latest libraries and maintain defenses against security vulnerabilities.

See the Notifications section for upgrade instructions.

Tip

EDBPlus Upgraded to Java 11 Compatible Version

EDBPlus v14 is available in Liquibase Enterprise & BUsiness 8.0. This version is compatible with Java 11. EnterpriseDB customers should select this option during installation.

Tip

DMC

Libraries Updated

Security Enhancements

Several dependent libraries used in DMC are upgraded. This resolves many recent vulnerabilities that were detected using vulnerability scanning software.

Tip

Rebrand from DaticalDB to Liquibase Enterprise

Liquibase Enterprise v88.0 is rebranded in most places to remove the previous Datical branding. This phase of rebranding is primarily cosmetic, while future releases may also rebrand filenames and the default workspace location. Users will be notified in advance of any functional changes.

Tip

Liquibase Enterprise Driver Update

New Drivers are available for Liquibase Enterprise 8.0. It is important to note that the Enterprise version needs to match the driver version to operate successfully. Do not use the latest drivers until you are ready to upgrade to 8.0. Find all driver versions here.

DMC Issues Addressed

Issue ID

Description

DAT-10192

Fixed unique constraint violation that kept users from registering new projects in DMC that had the same DbDef names and Pipeline names as other projects.

DAT-10857
DAT-10856
DAT-10855
DAT-10854

Fixed DMC security vulnerabilities associated with SSL Strength, Cookie attributes, Content Security Policy Header, and the Browser Cache directive.

...

DAT-9507

DAT-9289

Issue ID

Description

DAT-9160

DAT-

DAT-

Fixed the issue that prevented psql change types from handling custom arguments. Psql change types can pass custom arguments successfullyFor Postgres :: Allow custom psql arguments to be used in <appdba:psql> change types.

DAT-88848757

Fixed the out of memory issue that occurred when packager ran with too large SQL files.

Fixed the SqlServer eror that occurred when statements existed prior to CREATE OR ALTER PROCEDURE.

DAT-8757

Fixed the forecast failure that occurred when Limited Forecast did not include autoSynonymForObjects changeset schemas in profilesFor Oracle :: Fixed the forecast failure occurring with Auto-Synonym changesets in limited forecast mode. The workaround of switching to full forecast mode is no longer necessary.

DAT-11251

Fixed the For Azure SQL Database packaging issue that caused packaging to fail:: Accommodate dashes in database names that caused failure during backup / restore.

DAT-1052010518

Rollback :: Fixed issue where stored logic was not being included in generated SQL when using the --onlysql rollback option so users can produce a SQL script for rollback as intendedgensql option on the rollback command.

DAT-1051810524

Rollback :: Fixed the storedlogic rollback issue that did not provide a generated SQL when --gensql, --onlysql, or --genrollbacksql were ran. These commands work as expected.issued where rolled back changesets were not shown in the console output when rolling back to a <tagDatabase> change.

DAT-11139

Fixed the Oracle DATAPUMP issue so the optimization backup and restore method for packaging successfully works on Oracle 11g databasesFor Oracle :: Fixed issue with backup/restore on Oracle 11g databases when using BackupRestoreOracleDatapump.

DAT-10663

For Oracle :: Fixed issue in forecast with sql parser enabled when using indexes on materialized views.

DAT-10142

For Oracle :: Fixed issue in forecast with sql parser enabled to allow reserved keyword PERIOD as a valid column name.

Known Issues

Stored Logic State

In release 7.13 and later, we discovered that existing stored logic was in an UNKNOWN state on a Deploy report, which caused deployment to fail. We have reviewed desired behavior and will implement a storedLogicValidityAction to warn, not error, when pre-existing objects that are not part of the deployment show changes from Valid to Invalid. (DAT-9156)

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

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

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

Liquibase Enterprise & Business Clients (

...

Desktop & CLI)

Item

Path

File

Software

COMMON/Datical_DB_Software/Datical_DB_78.180.73367416

Choose the Linux or Windows installation file for your system

Composite Installation Repository

COMMON/Datical_DB_Software/Datical_DB_78.180.73367416

DaticalDbCompositeRepo-78.180.73367416.zip

Liquibase Deployment Monitoring Console (DMC)

Item

Path

File

Software

COMMON/Datical_DMC_Software/Datical_DMC_78.180.247267

datical-service-unix-78_180_247267-master.sh

DMC Documentation

Online @ dmc.datical.com

<N/A>

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.

...

Each DMC release only works with certain releases of Liquibase Enterprise & Business Clients (Datical DB)Desktop. Consult the Datical DB and Deployment Monitoring Console Compatibility Matrix to ensure compatibility.

...

Expand
titleExpand for DMC update instructions

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

Info

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. This link is especially important if you are using v7.18 or later.