"message": "Version may only contain 0..9 and . (dot). Invalid version: \"20200500013258249705\""
chinmoy87
Posts: 2 New member
I am getting below error while setting up the baseline version as we are implementing flyway to existing repository.
"message": "Version may only contain 0..9 and . (dot). Invalid version: \"20200500013258249705\""
I have setup flyway properties like below:
flywayProperties: locations=filesystem:postgres/md/md_wrk,outOfOrder=true,schemas=md_wrk,loggers=console,baselineOnMigrate=true,setBaselineMigrationPrefix="V",baselineVersion="20200500013258249705"
Existing repository scripts naming convention looks like : V20230519104950190616_00__ddl_md_stg_<>.sql
"message": "Version may only contain 0..9 and . (dot). Invalid version: \"20200500013258249705\""
I have setup flyway properties like below:
flywayProperties: locations=filesystem:postgres/md/md_wrk,outOfOrder=true,schemas=md_wrk,loggers=console,baselineOnMigrate=true,setBaselineMigrationPrefix="V",baselineVersion="20200500013258249705"
Existing repository scripts naming convention looks like : V20230519104950190616_00__ddl_md_stg_<>.sql
Answers
I anticipate your issue is that you're attempting to redefine a baseline migration as a version migration which is liable to cause some confusion.
Additionally what flyway version are you using please? I've only ever seen that command as 'baselineMigrationPrefix'.
As shown, that baseline approach you've taken is perfectly valid by itself.
If I remove BaselineMigrationPrefix, still I am having the same issue. Not sure what wrong I am doing here.
Is it related with flyway version ?
Are you supplying any other versions parameters beyond what you listed earlier please? The are multiple factors it could be, Target for instance.
To be certain, the full console input would be useful, with debug output. Since that could contain sensitive information, I can raise a support ticket for you and contact you directly to give you a secure means to provide the information, if you like?