liquibase.exception.DatabaseException: ORA-00911: ��Ч�ַ�

wangrensai · 2023 年12 月 19 日 02:10

运行环境
java11
oracle 10g
jmix 1.5.3

Unexpected error running Liquibase: Migration failed for change set om/liquibase/changelog/2023/12/002-eng-om-data-dev.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ORA-00911: ��Ч�ַ�
 [Failed SQL: (911) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'AirFrance', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000');]
For more information, please use the --logLevel flag
[2023-12-19 10:01:48] ���� [liquibase.integration] Unexpected error running Liquibase: Migration failed for change set om/liquibase/changelog/2023/12/002-eng-om-data-dev.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ORA-00911: ��Ч�ַ�
 [Failed SQL: (911) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'AirFrance', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000');]
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set om/liquibase/changelog/2023/12/002-eng-om-data-dev.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ORA-00911: ��Ч�ַ�
 [Failed SQL: (911) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'AirFrance', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000');]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:126)
	at liquibase.Liquibase.lambda$null$0(Liquibase.java:265)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Scope.child(Scope.java:243)
	at liquibase.Liquibase.lambda$update$1(Liquibase.java:264)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Liquibase.runInScope(Liquibase.java:2405)
	at liquibase.Liquibase.update(Liquibase.java:211)
	at liquibase.Liquibase.update(Liquibase.java:197)
	at liquibase.integration.commandline.Main.doMigration(Main.java:1869)
	at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:398)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.integration.commandline.Main$1.run(Main.java:397)
	at liquibase.integration.commandline.Main$1.run(Main.java:221)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:165)
	at liquibase.integration.commandline.Main.run(Main.java:221)
	at liquibase.integration.commandline.Main.main(Main.java:164)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set om/liquibase/changelog/2023/12/002-eng-om-data-dev.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ORA-00911: ��Ч�ַ�
 [Failed SQL: (911) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'AirFrance', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000');]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:696)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:56)
	at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:113)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:112)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Scope.child(Scope.java:243)
	at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:93)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Scope.child(Scope.java:243)
	at liquibase.Scope.child(Scope.java:247)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:65)
	... 26 more
Caused by: liquibase.exception.DatabaseException: ORA-00911: ��Ч�ַ�
 [Failed SQL: (911) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'AirFrance', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000');]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:397)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:151)
	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1279)
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1261)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:661)
	... 46 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00911: ��Ч�ַ�

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1231)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:772)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:512)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:123)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1200)
	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1820)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1472)
	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2505)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2460)
	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:393)
	... 51 more
Caused by: Error : 911, Position : 599, Sql = INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'AirFrance', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000');, OriginalSql = INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'AirFrance', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000');, Error Msg = ORA-00911: ��Ч�ַ�

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
	... 64 more

liren.xu · 2023 年12 月 19 日 07:08

这个问题可以搜一下 ORA-00911 这个错误码。然后把你那个 insert 语句直接通过客户端在Oracle数据库运行，看看有没有问题

wangrensai · 2023 年12 月 19 日 07:14

insert 语句在Oracle数据库客户端运行过来了，是可以的，没有问题的，从数据库中导出来的sql语句也会报这个错误

Ray.Lv · 2023 年12 月 19 日 07:21

检查一下 sql 文件的编码，应该 utf-8 编码。

另外参考这个帖子 Jmix Studio 编译时控制台乱码问题 - #4，来自 Ray.Lv - Jmix - jmix.cn ，处理一下控制台乱码，这样方便排错

wangrensai · 2023 年12 月 19 日 07:28

sql文件编码是utf-8编码，项目运行时，控制台是没有乱码的，只有在执行liquibase的时候才乱码的

Ray.Lv · 2023 年12 月 19 日 07:35

去掉 sql 语句后面后 ; 试试

wangrensai · 2023 年12 月 19 日 07:44

单条sql语句可以执行成功，多条的话就不行了，会报这个错误信息Error Msg = ORA-00933: SQL ��δ��ȷ��

Ray.Lv · 2023 年12 月 19 日 07:46

贴上完整的错误 log看看

wangrensai · 2023 年12 月 19 日 07:48

[2023-12-19 15:48:45] ��Ϣ [liquibase.changelog] ChangeSet om/liquibase/changelog/2023/12/001-eng-om-table.xml::9::om ran successfully in 6ms
Running Changeset: om/liquibase/changelog/2023/12/002-eng-om-data-dev.sql::raw::includeAll
[2023-12-19 15:48:45] ��Ϣ [liquibase.lockservice] Successfully released change log lock
Unexpected error running Liquibase: Migration failed for change set om/liquibase/changelog/2023/12/002-eng-om-data-dev.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ORA-00933: SQL ����δ��ȷ����
 [Failed SQL: (933) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'Air France', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('2a3a1a9d7f12c5354c915c6da8df4fd9', '892639', DATE '2023-08-21', 'Air France', 'B2', 'B0002', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('efcd83a9cce7564dd54f22ff48883bf4', '038491', DATE '2023-08-21', 'Ameco', 'C2', 'C003', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')]
For more information, please use the --logLevel flag
[2023-12-19 15:48:45] ���� [liquibase.integration] Unexpected error running Liquibase: Migration failed for change set om/liquibase/changelog/2023/12/002-eng-om-data-dev.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ORA-00933: SQL ����δ��ȷ����
 [Failed SQL: (933) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'Air France', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('2a3a1a9d7f12c5354c915c6da8df4fd9', '892639', DATE '2023-08-21', 'Air France', 'B2', 'B0002', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('efcd83a9cce7564dd54f22ff48883bf4', '038491', DATE '2023-08-21', 'Ameco', 'C2', 'C003', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')]
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set om/liquibase/changelog/2023/12/002-eng-om-data-dev.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ORA-00933: SQL ����δ��ȷ����
 [Failed SQL: (933) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'Air France', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('2a3a1a9d7f12c5354c915c6da8df4fd9', '892639', DATE '2023-08-21', 'Air France', 'B2', 'B0002', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('efcd83a9cce7564dd54f22ff48883bf4', '038491', DATE '2023-08-21', 'Ameco', 'C2', 'C003', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:126)
	at liquibase.Liquibase.lambda$null$0(Liquibase.java:265)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Scope.child(Scope.java:243)
	at liquibase.Liquibase.lambda$update$1(Liquibase.java:264)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Liquibase.runInScope(Liquibase.java:2405)
	at liquibase.Liquibase.update(Liquibase.java:211)
	at liquibase.Liquibase.update(Liquibase.java:197)
	at liquibase.integration.commandline.Main.doMigration(Main.java:1869)
	at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:398)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.integration.commandline.Main$1.run(Main.java:397)
	at liquibase.integration.commandline.Main$1.run(Main.java:221)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:165)
	at liquibase.integration.commandline.Main.run(Main.java:221)
	at liquibase.integration.commandline.Main.main(Main.java:164)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set om/liquibase/changelog/2023/12/002-eng-om-data-dev.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ORA-00933: SQL ����δ��ȷ����
 [Failed SQL: (933) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'Air France', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('2a3a1a9d7f12c5354c915c6da8df4fd9', '892639', DATE '2023-08-21', 'Air France', 'B2', 'B0002', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('efcd83a9cce7564dd54f22ff48883bf4', '038491', DATE '2023-08-21', 'Ameco', 'C2', 'C003', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:696)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:56)
	at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:113)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:112)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Scope.child(Scope.java:243)
	at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:93)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Scope.child(Scope.java:243)
	at liquibase.Scope.child(Scope.java:247)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:65)
	... 26 more
Caused by: liquibase.exception.DatabaseException: ORA-00933: SQL ����δ��ȷ����
 [Failed SQL: (933) INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'Air France', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('2a3a1a9d7f12c5354c915c6da8df4fd9', '892639', DATE '2023-08-21', 'Air France', 'B2', 'B0002', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('efcd83a9cce7564dd54f22ff48883bf4', '038491', DATE '2023-08-21', 'Ameco', 'C2', 'C003', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:397)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:151)
	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1279)
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1261)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:661)
	... 46 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL ����δ��ȷ����

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1231)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:772)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:512)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:123)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1200)
	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1820)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1472)
	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2505)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2460)
	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:393)
	... 51 more
Caused by: Error : 933, Position : 601, Sql = INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'Air France', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('2a3a1a9d7f12c5354c915c6da8df4fd9', '892639', DATE '2023-08-21', 'Air France', 'B2', 'B0002', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('efcd83a9cce7564dd54f22ff48883bf4', '038491', DATE '2023-08-21', 'Ameco', 'C2', 'C003', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000'), OriginalSql = INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('07e6571f359740dbb32c81d55d16c6e9', '856630*', DATE '2023-08-21', 'Air France', 'A1', 'A001', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('2a3a1a9d7f12c5354c915c6da8df4fd9', '892639', DATE '2023-08-21', 'Air France', 'B2', 'B0002', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000')
INSERT INTO IOM_ENG_OM_ENG_RPR_PRT_RPL (ID, ESN, SND_FOR_RPR_TIME, SND_FOR_RPR_MFR, PART_NAME, PART_SEQ_NO, WHETHER_LLP, INSTALL_PART_TSN, INSTALL_PART_CSN, INSTALL_PART_TSR, INSTALL_PART_CSR, APPRO_OPN_DESC_ONE, APPRO_OPN_DESC_TWO, APPRO_OPN_DESC_THREE, ANNEX, NOTE, VERSION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE) VALUES ('efcd83a9cce7564dd54f22ff48883bf4', '038491', DATE '2023-08-21', 'Ameco', 'C2', 'C003', 0, null, null, null, null, null, null, null, null, null, 2, 'admin', TIMESTAMP '2023-08-23 14:32:07.057000', 'admin', TIMESTAMP '2023-08-23 14:32:07.057000'), Error Msg = ORA-00933: SQL ����δ��ȷ����

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
	... 64 more

Ray.Lv · 2023 年12 月 19 日 08:00

liquibase 对 sql 文件有格式要求，像这样：

--liquibase formatted sql 
--changeset stone:insert-initial-data-for-native-palce
INSERT INTO RS_NATIVE_PLACE (ID, NAME, UUID, CREATED_BY, CREATED_DATE, DELETED_BY, DELETED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE, VERSION) VALUES ('110000', '北京市', 'b3c59c3813c2b57038fdc2cd42c87fb0', 'admin', '2022-04-23 02:46:46', null, null, null, '2022-04-23 02:46:46', 1);

前两行是 liquibase 需要的
参考这里：
Example Changelogs: SQL Format (liquibase.com)

Ray.Lv · 2023 年12 月 19 日 08:11

加了 --liquibase formatted sql 的话，语句之间默认是使用 ; 分隔的，所以再加上 ;号

wangrensai · 2023 年12 月 19 日 08:26

可以了，多谢