![]() ![]() They located at separate line as first characters of the line.I verified that all GO statements are exactly the same: ![]() So, it looks like the problem is in splitting the original file by GO. The previous parts of the same file were successfully split and executed as separate parts by SQL Server. the statements that passed to SQL Server contain GO lines. I started SQL Profiler and I see that this part of. GRANT EXECUTE ON dbo.My_Procedure TO AS dboĪt (CommandScope.java:179)Īt .call(CommandRunner.java:51)Īt .call(CommandRunner.java:21)Īt (CommandLine.java:1953)Īt $1300(CommandLine.java:145)Īt picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2358)Īt picocli.CommandLine$RunLast.handle(CommandLine.java:2352)Īt picocli.CommandLine$RunLast.handle(CommandLine.java:2314)Īt picocli.CommandLine$AbstractParseLastResultHandler.execute(CommandLine.java:2179)Īt picocli.CommandLine$RunLast.execute(CommandLine.java:2316)Īt (CommandLine.java:2078)Īt .lambda$execute$1(LiquibaseCommandLine.java:353)Īt .execute(LiquibaseCommandLine.java:318)Īt .main(LiquibaseCommandLine.java:84)Īt java.base/.invoke0(Native Method)Īt java.base/.invoke(NativeMethodAccessorImpl.java:62)Īt java.base/.invoke(DelegatingMethodAccessorImpl.java:43)Īt java.base/.invoke(Method.java:566)Īt .main(LiquibaseLauncher.java:107) **Reason: : Incorrect syntax near 'GO'.** [Failed SQL: (102) /*ĪLTER PROCEDURE varchar(255) = NULL output I want to read data from this dump file and make a sqlite (offline) database. Most of the files with the same structure work well, but there are several files that fail with error: SEVERE Migration failed for changeset. Modified 1 year, 1 month ago Viewed 517 times 0 I'm trying to execute a SQL script dump file which have multiple tables. sql file contains several GO lines after USE, SET, IF, ALTER PROCEDURE, and GRANT statements. changeset mycompany:1 **endDelimiter:\nGO** stripComments:false runonchange:true I add the following liquibase header to my. Liquibase is running on Teamcity Linux agent installed on RHEL 7. I have Liquibase 4.16.1 with JDBC driver and MS SQL 2016 as the target database. I am trying to implement the CI/CD process with Teamcity. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |