Archiver | Error 'database is not found' when trying to attach an SQL database

Summary

no database is found when trying to attach in the UI

Overview

When trying to attach a valid SQL database, it is not found:

Cause

There are a few scenarios:

1. The Database selected is SQL with File Storage and the database is without File Storage or vice-versa.
2. The Database is corrupt.
3. The Database doesn't have the gfi_marc_dle_db_version, doesn't have a correct value for id column or the version column is empty.

Here is how a valid table would look like:

Workaround

None.

Resolution

Ensure that the correct DB format is selected from the web interface (with File Storage or without File Storage):​

• Ensure database is not corrupt, has all the tables and holds information in the arc table
• Ensure the respective db has the gfi_marc_dle_db_version table and holds values for id and version

Defect ID

GFIA-2986

Defect URL

https://jira.devfactory.com/browse/GFIA-2986