Can't import users from JIRA using SQL Server database

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

問題

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>'.

原因

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.

ソリューション

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

 

 

 

 

 

 

 

 

 

 

 

 

 

   

 

 

 

 

 

 

 

 

 

 

 

 

 

最終更新日 2016 年 4 月 1 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.