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

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.

5 answers

1 accepted

Accepted Answer
1 vote

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.

2 votes

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.

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.

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??

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

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

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. 

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Monday in Jira Ops

Jira Ops Early Access Program Update #1: Announcing our next feature and a new integration

Thanks for signing up for Jira Ops! I’m Matt Ryall, leader for the Jira Ops product team at Atlassian. Since this is a brand new product, we’ll be delivering improvements quickly and sharing updates...

477 views 0 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you