Babelfish Compass Assessment error: Cannot generate report based on these analysis files with incompatible attributes

yoni-yad2 commented 1 year ago

What happened?

I ran this command:

.\BabelfishCompass.bat PostgresMigrationAssessmentReport C:\temp\db.sql -replace

Got:

Run starting : 09-Aug-2023 10:16:21 (Windows) BabelfishFeatures.cfg file : v.3.2.0, Jun-2023 Target Babelfish version : v.3.2.0 (PG 15.3) ..... ..... ..... **Cannot generate report based on these analysis files with incompatible attributes. Analysis was performed for a different Babelfish version (v.) than targeted by this run (v.3.2.0):

Re-run analysis for all imported files with -analyze, or specify the corresponding Babelfish version with -babelfish-version.**

Version

BABEL_3_X_DEV (Default)

Extension

None

Which flavor of Linux are you using when you see the bug?

No response

Relevant log output

No response

Code of Conduct

[X] I agree to follow this project's Code of Conduct.

robverschoor commented 1 year ago

Are you , by any chance, using a Chinese locale ? And therefore having a date notation that uses CN characters for the month? Can you please look at https://github.com/babelfish-for-postgresql/babelfish_compass/issues/111 and see if it is the same issue?

yoni-yad2 commented 1 year ago

I use a Hebrew locale.

header of dat file:

Captured items for report [PostgresMigrationAssessmentReport] with targeted Babelfishversion [3.2.0] generated at 09-אוג-2023 16:47:53 with capture file format [1] user config file [BabelfishCompassUser.cfg]

yoni-yad2 commented 1 year ago

Update: Issue doesn't happen when Windows date is set to US format.

robverschoor commented 1 year ago

Thanks, this is indeed the same issue as https://github.com/babelfish-for-postgresql/babelfish_compass/issues/111 . A fix will be in the next Compass release.

robverschoor commented 1 year ago

This has been fixed in Compass v.2023-08

babelfish-for-postgresql / babelfish_compass