Forum Stats

  • 3,824,917 Users
  • 2,260,439 Discussions
  • 7,896,346 Comments

Discussions

sqlcl (22.1.1.131.0820) SEVERE liquibase.parser Invalid byte 1 of 1-byte UTF-8 sequence

Robert__H
Robert__H Member Posts: 6 Green Ribbon
edited May 30, 2022 10:53AM in SQLcl

Oracle SQLDeveloper Command-Line (SQLcl) version: 22.1.1.0 build: 22.1.1.131.0820

Liquibase at 11:53:51 (version 4.9.1 #0 built at 2022-05-03 17:23+0000)

openjdk version "11.0.14" 2022-01-18 LTS

Hi,

I get the following error when running a changelog:

SQL> lb update -changelog controller.xml

--Starting Liquibase at 12:05:46 (version 4.9.1 #0 built at 2022-05-03 17:23+0000)

2022-05-30 12:05:49.302 SEVERE liquibase.parser Invalid byte 1 of 1-byte UTF-8 sequence.

Invalid byte 1 of 1-byte UTF-8 sequence.


Any ideas what the root cause might be?

Comments

  • Robert__H
    Robert__H Member Posts: 6 Green Ribbon

    Hi everyone,

    I was able to solve this puzzle myself.

    Please find the mistakes I made which led to the error.

    1st: I created a scheduler job using SQL Developer and used the standard NLS setting which was set to German. This led to one attribute becoming a €-value which was not supported. I changed NLS settings in SQL developer to American and this issue was gone.

    2nd: there was a comment line including a German letter ü which also led to the error. When I replaced that it worked fine.

    One more thin I would like to point out.

    I think in an earlier version (21.4.1) the error message was more conclusive:

    SQL> lb updatesql -changelog controller.xml

    2022-04-04 14:05:30.141 SEVERE liquibase.parser Invalid byte 1 of 1-byte UTF-8 sequence.

     Processing has failed for your request.

    liquibase.exception.SetupException: Error parsing line 23 column 138 of job/job_p_fill_t_cicd_user3_job.xml: Invalid byte 1 of 1-byte UTF-8 sequence.


    I think this topic could be closed.