Importing a backup file from the import wizard results in "JIRA has already been set up."

Rich Scire July 20, 2015

We cleared the Oracle schema and restarted Jira. After Importing a backup file from the import wizard results in "JIRA has already been set up." While no other errors were reported, I was unable to log in which seems to indicate that the data was not successfully imported.

 

Any suggestions would be appreciated.

3 answers

1 vote
zhen zhang
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 20, 2015

Hi @Richard Scire, could you please paste the steps of clearing schema here, and make a screenshot for your problem? It seems the JIRA database has not been removed successfully.

0 votes
Rich Scire July 21, 2015

Here are the steps as provided by the DBA:

 

- SA Brought down Jira

- Took an export backup of the JIRAUSER schema

- Dropped the schema with all its objects:

    - drop user JIRAUSER cascade;

- Recreated the schema:

    - CREATE USER "JIRAUSER"

    - IDENTIFIED BY XXXXXXX

    - DEFAULT TABLESPACE "JIRA_DATA"

    - TEMPORARY TABLESPACE "TEMP"

    - ACCOUNT UNLOCK ;

- Gave the necessary grants and quota:

    - ALTER USER "JIRAUSER" QUOTA UNLIMITED ON JIRA_DATA;

    - grant connect to jirauser;

    - grant create table to jirauser;

    - grant create sequence to jirauser;

    - grant create trigger to jirauser;

 

 

0 votes
Sateesh Chandra
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 20, 2015

Also , you can try drop the database and recreate it, grant the needed permissions and then start the import from xml

Suggest an answer

Log in or Sign up to answer