Error on clicking Save & Migrate when connecting to Database (Here be Dragons - Dragons- Stage 5)

[Pankaj Batra]

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.

[LeonardoL · Accepted solution]

Hi Pankaj,

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:

https://confluence.atlassian.com/display/FISHEYE/Migrating+to+PostgreSQL

Cheers,

Leonardo.

[Felipe Kraemer]

Hi,

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.

[Pankaj Batra]

Leonardo Macedo and Felipe Kraemer - Thanks. My problem is resolved. It seemed to be an issue with the PostgreSQL that was already installed. I re-installed it and it worked.

[APEGA Helpdesk]

I am having this problem on SQL Server 2012. Has anybody found a solution?

[RL Prasad]

Hi,

I am getting same error for Oracle DB. Its a fresh install, and once installed with default DB, i am trying to migrate to Oracle DB, but it is failing with error -Database must be in NO_TABLES state, currently NO_DB

Any help on this please??

[Robin Gauß]

Have you been able to resolve your issue? I have the exact same behavior.

[Laurent DENIS]

Same issue with Oracle when using the web GUI.

Doing the import on command-line succeeded.

$ ./fisheyectl.sh restore --sql \
        --file /path/to/backup.zip \
        --dbtype oracle \
        --jdbcurl jdbc:oracle:thin:@hostname:port:dbname \
        --username crucible \
        --password password

[Robin Gauß]

Have you tried to use new syntax for the jdbcurl?

 jdbc:oracle:thin:@hostname:port:dbname

-> jdbc:oracle:thin:@//hostname:port/dbname

I think that fixed the issue for me.