Hi,
I am planning to migrate our existing Sonatype Nexus OSS 3.70.3-01 from OrientDB to PostgreSQL database.
I have followed below link for database migration from OrientDB to PostgreSQL.
https://help.sonatype.com/en/migrating-to-a-new-database.html
While migrating database steps, I got below error
Migration to an external database requires Nexus Repository Manager Pro and is not supported for Nexus Repository Manager OSS instances. Hence, would like to know, cant we migrate Nexus Repository OSS from OrientDB to PostgreSQL. Do we need to have Nexus Repository Manager Prod version only?
Below is command output for reference.
########################################################################
java -Xmx4G -Xms4G -XX:+UseG1GC -XX:MaxDirectMemorySize=8192M -jar nexus-db-migrator-.jar --migration_type=postgres --db_url=“jdbc:postgresql://test:5432/nexus?user=nexus&password=test1234”
11:09:26 [main] WARN c.s.n.d.migrator.MigratorApplication - Please ensure any Nexus Repository instance has been gracefully shut down before proceeding.
11:09:26 [main] INFO c.s.n.d.migrator.MigratorApplication - Do you want to continue [y/n]?
y
11:09:29 [main] INFO c.s.n.d.migrator.MigratorApplication - --content_migration parameter is absent. Setting it to true.
11:09:29 [main] INFO c.s.n.d.migrator.MigratorApplication - Force parameter wasn’t found. Setting it to false by default.
11:09:29 [main] INFO c.s.n.d.migrator.MigratorApplication - ------------------------------------------------------------
11:09:29 [main] INFO c.s.n.d.migrator.MigratorApplication - Java version: Red Hat, Inc. 1.8.0_342
11:09:29 [main] INFO c.s.n.d.migrator.MigratorApplication - JVM arguments: -Xmx4G -Xms4G -XX:+UseG1GC -XX:MaxDirectMemorySize=8192M
11:09:29 [main] INFO c.s.n.d.migrator.MigratorApplication - Migrator arguments: --migration_type=postgres --db_url=jdbc:postgresql://test:5432/nexus?user=nexus&password=*** --content_migration=true --export_json=false --force=false
11:09:29 [main] INFO c.s.n.d.migrator.MigratorApplication - ------------------------------------------------------------
11:09:29 [main] INFO c.s.n.d.migrator.MigratorApplication - Starting MigratorApplication v3.70.3-01 using Java 1.8.0_342 on test.int.clsa.com with PID 101204 (/app/nexus/orentdb_backup/nexus-db-migrator-3.70.3-01.jar started by nexus in /app/nexus/orentdb_backup)
11:09:29 [main] INFO c.s.n.d.migrator.MigratorApplication - No active profile set, falling back to 1 default profile: “default”
11:09:31 [main] INFO o.s.b.c.r.s.JobRepositoryFactoryBean - No database type set, using meta data indicating: POSTGRES
11:09:31 [main] INFO c.s.n.d.migrator.MigratorApplication - Started MigratorApplication in 1.984 seconds (JVM running for 4.78)
11:09:31 [main] INFO o.s.b.a.b.JobLauncherApplicationRunner - Running default command line with: [–migration_type=postgres, --db_url=jdbc:postgresql://test:5432/nexus?user=nexus&password=test1234, --content_migration=true, --export_json=false, --force=false]
11:09:31 [main] INFO c.s.n.d.m.validator.PathValidator - Validating Orient directory contains .bak files: /app/nexus/orentdb_backup
11:09:31 [main] INFO c.s.n.d.m.validator.PathValidator - Validating Orient directory does not contain database files: /app/nexus/orentdb_backup
11:09:31 [main] INFO c.s.n.d.m.validator.PathValidator - Validating Orient directory contains .bak files: /app/nexus/orentdb_backup
11:09:31 [main] INFO c.s.n.d.m.validator.PathValidator - Validating Orient directory does not contain database files: /app/nexus/orentdb_backup
11:09:31 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Migration job started at Fri Feb 21 11:09:31 HKT 2025
11:09:31 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [startHealthCheckDeciderStep]
11:09:31 [main] INFO o.s.batch.core.step.AbstractStep - Step: [startHealthCheckDeciderStep] executed in 14ms
11:09:31 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [unzipArchivesStep]
11:09:31 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipping /app/nexus/orentdb_backup/component-2025-02-17-13-19-16-3.70.3-01.bak to /app/nexus/orentdb_backup/component
11:09:35 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipped /app/nexus/orentdb_backup/component-2025-02-17-13-19-16-3.70.3-01.bak successfully
11:09:35 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipping /app/nexus/orentdb_backup/config-2025-02-17-13-19-16-3.70.3-01.bak to /app/nexus/orentdb_backup/config
11:09:35 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipped /app/nexus/orentdb_backup/config-2025-02-17-13-19-16-3.70.3-01.bak successfully
11:09:35 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipping /app/nexus/orentdb_backup/security-2025-02-17-13-19-16-3.70.3-01.bak to /app/nexus/orentdb_backup/security
11:09:35 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipped /app/nexus/orentdb_backup/security-2025-02-17-13-19-16-3.70.3-01.bak successfully
11:09:35 [main] INFO o.s.batch.core.step.AbstractStep - Step: [unzipArchivesStep] executed in 4s346ms
11:09:35 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [checkModelVersionsStep]
11:09:36 [main] WARN c.s.n.d.m.c.SchemaVersionsValidator - Missing some schema configurations. Suspecting Nexus Repository Manager to be an OSS instance.
11:09:36 [main] ERROR o.s.batch.core.step.AbstractStep - Encountered an error executing step checkModelVersionsStep in job migrationFromOrientNoExportJSONJob
com.sonatype.nexus.db.migrator.exception.WrongNxrmEditionException: Migration to an external database requires Nexus Repository Manager Pro and is not supported for Nexus Repository Manager OSS instances.
11:09:36 [main] INFO o.s.batch.core.step.AbstractStep - Step: [checkModelVersionsStep] executed in 674ms
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Migration job finished at Fri Feb 21 11:09:36 HKT 2025
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Migration job took 5 seconds to execute
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - 0 records were processed
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - 0 records were filtered
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - 0 records were skipped
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - 0 records were migrated
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - ------------------------------------------------------------
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Migration job finished with status FAILED.
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Detailed message: com.sonatype.nexus.db.migrator.exception.WrongNxrmEditionException: Migration to an external database requires Nexus Repository Manager Pro and is not supported for Nexus Repository Manager OSS instances.
11:09:36 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - ------------------------------------------------------------
########################################################################