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

Robert__H

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?

Robert__H

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.

Robert__H

here an interesting older entry with similar issue

https://community.oracle.com/tech/developers/discussion/4284265/liquibase-issues-in-sqlcl-19-2