SQLcl 23.1 Liquibase Update Checksum Changeset Validation Failed (Doc ID 2954944.1)

Last updated on JANUARY 11, 2024

Applies to:

Symptoms

Environment
==============
SQLcl 23.1
Liquibase
Oracle Linux 7

Problem
--------------
SQLcl 23.1 - lb update checksum changeset validation failed.  Having an issue trying to do an upgrade in our CICD pipeline from SQLcl 22.4 to SQLcl 23.1 version.
SQLcl seems to be calculating checksum differently.

Testcase
----------------
SQL> version
Oracle SQLDeveloper Command-Line (SQLcl) version: 22.4.0.0 build: 22.4.0.342.1215
SQL> CREATE OR REPLACE PROCEDURE "USER_TEST_1"."P_PROCEDURE" AS
  2 BEGIN
  3
  4 DBMS_OUTPUT.PUT_LINE('PROCEDURE');
  5
  6 END;
  7* /

Procedure P_PROCEDURE compiled

SQL> set serveroutput on;
SQL> exec P_PROCEDURE;
PROCEDURE


PL/SQL procedure successfully completed.

SQL> lb generate-schema
--Starting Liquibase at 12:05:09 (version 4.17.0 #0 built at 2022-11-02 21:48+0000)


Export Flags Used:

Export Grants false
Export Synonyms false

[Method loadCaptureTable]:
  [Type - TYPE_SPEC]: 72 ms
  [Type - TYPE_BODY]: 59 ms
  [Type - SEQUENCE]: 25 ms
  [Type - DIRECTORY]: 62 ms
  [Type - CLUSTER]: 125 ms
  [Type - TABLE]: 273 ms
  [Type - MATERIALIZED_VIEW_LOG]: 34 ms
  [Type - MATERIALIZED_VIEW]: 21 ms
  [Type - VIEW]: 36 ms
  [Type - REF_CONSTRAINT]: 41 ms
  [Type - DIMENSION]: 32 ms
  [Type - FUNCTION]: 69 ms
  [Type - PROCEDURE]: 173 ms
  [Type - PACKAGE_SPEC]: 53 ms
  [Type - DB_LINK]: 28 ms
  [Type - SYNONYM]: 39 ms
  [Type - INDEX]: 62 ms
  [Type - TRIGGER]: 17 ms
  [Type - PACKAGE_BODY]: 35 ms
  [Type - JOB]: 25 ms

[Method loadCaptureTable]: 1282 ms
[Method processCaptureTable]: 82 ms
[Method sortCaptureTable]: 68 ms
[Method cleanupCaptureTable]: 18 ms
[Method writeChangeLogs]: 12 ms



Operation completed successfully.

SQL> DROP PROCEDURE "USER_TEST_1"."P_PROCEDURE";

Procedure "USER_TEST_1"."P_PROCEDURE" dropped.

SQL> lb update -changelog-file controller.xml
--Starting Liquibase at 12:06:49 (version 4.17.0 #0 built at 2022-11-02 21:48+0000)

-- Loaded 1 change(s)
Running Changeset: p_procedure_procedure.xml::56f05ecc3a4cc2cf697cf6a2161ac645da32c468::(USER_TEST_1)-Generated
Procedure P_PROCEDURE compiled


Operation completed successfully.

SQL> lb update -changelog-file controller.xml
--Starting Liquibase at 12:07:13 (version 4.17.0 #0 built at 2022-11-02 21:48+0000)

-- Loaded 1 change(s)


Operation completed successfully.

SQL> exit


Now change to 23.1 version

SQLcl: Release 23.1 Production on Tue Jun 06 12:07:50 2023

Copyright (c) 1982, 2023, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0

SQL> lb update -changelog-file controller.xml
--Starting Liquibase at 12:08:02 (version 4.17.0 #0 built at 2022-11-02 21:48+0000)


-- Loaded 1 change(s)
Validation Failed:
  1 changesets check sum
  p_procedure_procedure.xml::56f05ecc3a4cc2cf697cf6a2161ac645da32c468::(USER_TEST_1)-Generated was: 8:5e2c74ca8a9748f6a05e9872eeaef1e6 but is now: 8:4f790f7e6a0cb1b706c18a08e416f187

SQL>

Error
--------------
Validation Failed:
  1 changesets check sum
  p_procedure_procedure.xml::56f05ecc3a4cc2cf697cf6a2161ac645da32c468::(USER_TEST_1)-Generated was: 8:5e2c74ca8a9748f6a05e9872eeaef1e6 but is now: 8:4f790f7e6a0cb1b706c18a08e416f187

Changes

 Upgraded to SQLcl 23.1

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.