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

[Rich Scire]

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.

[zhen zhang]

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.

[Rich Scire]

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 Chandra]

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