no issues.ĭEBUG info from Flyway 6.3.2 environment (/u01/flyway)ĭEBUG: Loading config file: /u01/flyway/conf/nfĭEBUG: Unable to load config file: /home/oracle/nfĭEBUG: Unable to load config file: /u01/flyway/nfĭEBUG: flyway.ignoreIgnoredMigrations -> trueĭEBUG: flyway.jarDirs -> /u01/flyway/jarsĭEBUG: flyway.licenseKey -> FL0135E3******41D4ĭEBUG: flyway.locations -> filesystem://u01/flyway/sqlĭEBUG: flyway.sqlMigrationSuffixes -> sql,trg,pckĭEBUG: flyway.table -> FLYWAY_SCHEMA_HISTORYĭEBUG: flyway.tablespace -> FLYWAY_DATA_SMALLĭEBUG: flyway.url -> er -> yvettecĭEBUG: Parsing afterMigrate_build_grants_for_merge.sql. Note: If I run afterMigrate_build_grants_for_merge.sql via SQLplus. Even if I create empty file to satisfy "unable to open file" - The error is suppressed and it steps thru the remaining script and runs as expected but the grants_for_merge.sql (I created) is still empty, telling me that SPOOL command is not working. See for more information: SP2-0310: unable to open file "grants_for_merge.sql"Ĭaused by: SP2-0310: unable to open file "grants_for_merge.sql"įile was not created.
#Oracle sql developer spool update
GRANT SELECT, UPDATE ON FDS_SOURCE.FDS_KBA_PERSON_20190215 TO peris_merge ĮRROR: Unable to parse statement in /u01/flyway-6.5.0/sql/afterMigrate_build_grants_for_merge.sql at line 16 col 1. GRANT SELECT, UPDATE ON FDS_SOURCE.FDS_FAILED_DECEA_20190215 TO peris_merge GRANT SELECT, UPDATE ON FDS_SOURCE.FDS_FAILED_DECEASED_LOGINS TO peris_merge GRANT SELECT, UPDATE ON FDS_SOURCE.FDS_FAILED_DECEASED20190102 TO peris_merge Which contents would look something like this: Grants_for_merge.sql should be created in /u01/flyway-6.5.0/sql
Prompt Finished building Merge Grants file.Įxec > Offending line of script according to Flyway error. Spool grants_for_merge.sql > spool not working as expected $ cat afterMigrate_build_grants_for_merge.sql Script: afterMigrate_build_grants_for_merge.sql Resulting in unable to open file.įlyway migrate info -enterprise -locations=filesystem:/u01/flyway-6.5.0/sql The spool file grants_for_merge.sql is not being created. Would like to use the SQL callback feature to build and run a grants script after migration. (Please include the content causing the issue, any relevant configuration settings, the SQL statement that failed (if relevant) and the command you ran.)
Oracle Linux Server release 6.10 What did you do? Oracle 12.1.16 Which operating system are you using?
Yes, in Flyway Enterprise Edition 6.5.0 by Redgate Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)Ĭommand-line Which database are you using (type & version)? (Many bugs are fixed in newer releases and upgrading will often resolve the issue) If this is not the latest version, can you reproduce the issue with the latest one as well? In searching I found this bug issue: unsupported SQL*Plus statement: SPOOL #2674 FYI but am running later version than what was documented. Which version and edition of Flyway are you using?įlyway Enterprise Edition 6.3.2 by Redgate
0 kommentar(er)
