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

Question

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.

Rich Scire_3nuhio · Answer

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;

Sateesh Chandra1 · Answer

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

zhen zhang2 · Answer

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.