0 Replies Latest reply on Feb 6, 2020 11:46 AM by dherzhau

    sqlcl NullPointerException with liquibase

    dherzhau

      I tried to deploy a some tables with sqlcl (Version 19.4) against a ORACLE 12.2 database from a redHat linux box.

      The changelog is working fine with a vanilla liquibase (3.8.5 )

       

      After I connected to the database and started the deployment I received immediately the NUllpointer exception. In case you might wonder we have connectetd changelog and therefore he started with the initial file: 2.24.5

       

      SQL> lb update db.changelog-3.29.0.xml

      Feb 06, 2020 12:09:15 PM liquibase.logging.core.Slf4jLogger severe

      SEVERE: Change Set xxxxxx-2.24.5/createdb.sql::liquibase-2.24.5-1::herzhd failed.  Error: null

      Liquibase konnte die Anforderung derzeit nicht verarbeiten (allgemeiner Fehler).

       

      Migration failed for change set xxxxxx/createdb.sql::liquibase-2.24.5-1::herzhd:

           Reason: java.lang.NullPointerException

       

       

      The changelog:

       

      <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

       

          <!-- initial Versions: -->

              <include file="db.changelog-3.28.0.xml"             relativeToChangelogFile="true"/>

          <!-- new with this version: -->

              <include file="./xxxxxx-3.29.0/1_Sprint29_US2654_ddl.sql"             relativeToChangelogFile="true"/>

              <include file="./xxxxxx-3.29.0/2_Sprint29_US2652_ddl.sql"             relativeToChangelogFile="true"/>

      </databaseChangeLog>

       

      Initial changeset excerpt:

       

      --liquibase formatted sql

       

      --changeset herzhd:liquibase-2.24.5-1 splitStatements:false endDelimiter="\n/"

      --preconditions onFail:MARK_RAN onError:HALT

      --precondition-sql-check expectedResult:0 SELECT COUNT(*) tab_count FROM user_tables where table_name = 'HISTORY'

      Begin

       

      for c in (select sequence_name from user_sequences) loop

       

      execute immediate ('drop sequence '||c.sequence_name);

      ....

       

      So any Idea what is wrong?