Can't import users from JIRA using SQL Server database

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

When importing users from JIRA, the following error appears in the atlassian-crowd.log

Cause :
javax.servlet.ServletException: StatementCallback; bad SQL grammar [SELECT groupname from groupbase order by groupname]; nested exception is java.sql.SQLException: Invalid object name 'groupbase'.

The following also can appear in the atlassian-crowd.log

2016-03-30 14:17:43,311 http-bio-8443-exec-10 ERROR [console.action.dataimport.AtlassianImporter] Import configuration test failed
com.atlassian.crowd.importer.exceptions.ImporterConfigurationException: Could not load database connection: Login failed for user '<JIRA-DB-USER>'.

Cause

In the JIRA guide , we recommend creating a database schema for JIRA.

If JIRA database user account does not have this schema set as the account's default schema, you will receive the error above.

Resolution

Change the JIRA database user account's default schema to the schema you created for the JIRA database.

 

 

 

 

 

 

 

 

 

 

 

 

 

   

 

 

 

 

 

 

 

 

 

 

 

 

 

Last modified on Apr 1, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.