Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,370,158
Community Members
 
Community Events
168
Community Groups

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

1 vote
Answer accepted

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.

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

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. 

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events