nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

LeonardoL

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.

All comments

LeonardoL

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.

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.

apegadev

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

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

-> <code class="java plain">jdbc:oracle:thin:@//hostname:port/dbname<br><br>I think that fixed the issue for me. 

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

fisheye-crucible