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

This widget could not be displayed.

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.

This widget could not be displayed.

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.

This widget could not be displayed.

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.

This widget could not be displayed.

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. 

This widget could not be displayed.

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

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in Statuspage

What are your best incident management tips and stories? #HugOps

 👋Community members! Downtime happens. And great incident response takes a village. Teams like Support, Dev, SRE, Ops, IT, and Marketing have to come together to resolve the problem while keep...

71 views 2 3
Join discussion

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