Hi
we are using nexus Pro 3.68.1 and try to migraton to PostgreSQL with the latest database migration tool.
The Migration Fails with the following error:
10:09:42 [main] ERROR o.s.batch.core.step.AbstractStep - Encountered an error executing step processComponentStep in job migrationFromOrientJob
org.springframework.retry.ExhaustedRetryException: Retry exhausted after last attempt in recovery path, but exception is not skippable.; nested exception is org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO npm_asset (asset_id, repository_id, path, kind, component_id, asset_blob_id, created, last_updated, last_downloaded, attributes)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, (?::jsonb));
]; ERROR: insert or update on table "npm_asset" violates foreign key constraint "fk_npm_asset_repository"
Detail: Key (repository_id)=(14) is not present in table "npm_content_repository".; nested exception is org.postgresql.util.PSQLException: ERROR: insert or update on table "npm_asset" violates foreign key constraint "fk_npm_asset_repository"
Detail: Key (repository_id)=(14) is not present in table "npm_content_repository".
Key (repository_id)=(14) is not present in table "npm_content_repository".
I have also checked the orient component database with the orient client and the CHECK DATABASE Command. No issues where found there. Any ideas how to fix this?
I also did the HealthCheck with the DB Migration tool.
14:00:48 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Health-Check job started at Thu Jun 20 14:00:48 CEST 2024
14:00:48 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [startHealthCheckDeciderStep]
14:00:48 [main] INFO o.s.batch.core.step.AbstractStep - Step: [startHealthCheckDeciderStep] executed in 12ms
14:00:48 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [startHealthCheckStep]
14:03:13 [main] INFO o.s.batch.core.step.AbstractStep - Step: [startHealthCheckStep] executed in 2m25s350ms
14:03:13 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - ------------------------------------------------------------
14:03:13 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Database integrity: OK
14:03:13 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - ------------------------------------------------------------
14:03:13 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Please see health-check logs for more details.