As part of Stage 5 of the excercise, completed the following steps as described in the documentation to connect Fisheye to the Database:
1. Click Edit and enter the following details:
2. Type: PostgreSQL
Driver Location: Bundled URL: jdbc:postgresql://localhost:5432/fisheye – Note that this value is different from the default value.
User Name: fishuser – This is the user you created in step 2 (above).
Password – Enter the password you defined in step 2 (above).
Click Test Connection to verify that FishEye/Crucible can log in to the database.
Click Save & Migrate.
On clicking Save and Migrate, the following error messages is displayed:
Creating table definitions...
Database must be in NO_TABLES state, currently NO_DB
Database migration failed: java.lang.IllegalStateException: Database must be in NO_TABLES state, currently NO_DB
How do we get over this problem? Please advise.
Could you please verify if you're using a fisheye supported version of PostgreSQL acording to this documentation https://confluence.atlassian.com/display/FISHEYE/Supported+Platforms
Also could you please redo your steps by using document below:
Could you please make sure that the database 'fisheye' really exists, if it's an empty database, and if the PosgreSQL driver can be found at FISHEYE_INST/lib directory?
If the database does not exist, could you please try to create it following the Stage 5, Step 2?
If the driver cannot be found at FISHEYE_INST/lib, please copy it from FISHEYE_INST/lib/dbdrivers/postgresql to FISHEYE_INST/lib.