SQLcl Lb Changelogsync Not Working (Doc ID 2895137.1)

Last updated on OCTOBER 10, 2022

Applies to:

Symptoms

Environment
--------------------
SQLcl 22.2.1
Liquibase version: 4.9.1 #0 built at 2022-05-03 17:23+2221
Windows 10

Problem Description
---------------------------------------------------

SQLcl lb changelogsync not working

Using "lb changelogsync" in order to set up SQLcl(Liquibase) with an existing database but it is not populating the DATABASECHANGELOG tracking table.

If DATABASECHANGELOG exists, SQLcl doesn't insert any data on it and if DATABASECHANGELOG doesn't exist, SQLcl doesn't creates it.

Doing the following throws an error:

SQL> select * from DATABASECHANGELOG;

Error
-----------

Error starting at line : 1 in command -
select * from DATABASECHANGELOG
Error at Command Line : 1 Column : 15
Error report -
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
SQL>

Works
-------------
Works if using Liquibase directly.

Does Not Work
----------------------
If using SQLcl integrated with the Liquibase Version: 4.15.0

Cause

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