Error while trying to import JIRA users into Crowd

[meena radhakrishnan]

Got the following while trying to import JIRA users into Crowd

System Error

A system error has occurred please contact your administrator.

If this problem continues to occur please contact Atlassian by opening a support request with the following information:

- A description of your problem and what you were doing at the time it occurred

- Cut & paste the error and system information found below

- Attach the application server log file (if possible).

Cause :

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar SELECT groupname from groupbase order by groupname ; nested exception is java.sql.SQLException: Invalid object name 'groupbase'.

Stack Trace :

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar SELECT groupname from groupbase order by groupname ; nested exception is java.sql.SQLException: Invalid object name 'groupbase'.

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:220)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)

at com.atlassian.crowd.importer.importers.JdbcImporter.findGroups(JdbcImporter.java:56)

at com.atlassian.crowd.importer.importers.BaseImporter.importUsersGroupsAndMemberships(BaseImporter.java:230)

at com.atlassian.crowd.importer.importers.BaseDelegatingJdbcImporter.importUsersGroupsAndMemberships(BaseDelegatingJdbcImporter.java:74)

at com.atlassian.crowd.importer.importers.JiraImporter.importUsersGroupsAndMemberships(JiraImporter.java:10)

at com.atlassian.crowd.importer.manager.ImporterManagerImpl.performImport(ImporterManagerImpl.java:36)

at com.atlassian.crowd.console.action.dataimport.AtlassianImporter.doImport(AtlassianImporter.java:56)

at com.atlassian.crowd.console.action.dataimport.AtlassianImporter.doCheckAdditionalParamsRequired(AtlassianImporter.java:120)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)


... 137 more

Referer : http://localhost:8095/crowd/console/secure/dataimport/importatlassian!default.action

Build Information :

Version : 2.4.0 (Build:#562 - 02-01-2012)

Memory Information :

Total Memory : 127 MB

Free Memory : 80 MB

Used Memory : 46 MB

Request Information :

- Request URL : http://localhost:8095/crowd/console/500.jsp

- Scheme : http

- Server : localhost

- Port : 8095

- URI : /crowd/console/500.jsp

- Context Path : /crowd

- - Servlet Path : /console/500.jsp

- - Path Info : null

- - Query String :

Request Attributes :

- javax.servlet.forward.request_uri : /crowd/console/secure/dataimport/importatlassian!checkAdditionalParamsRequired.action

- javax.servlet.forward.context_path : /crowd

- javax.servlet.forward.servlet_path : /console/secure/dataimport/importatlassian!checkAdditionalParamsRequired.action

- javax.servlet.forward.path_info : /console/500.jsp

- javax.servlet.error.status_code : 500

- javax.servlet.error.servlet_name : default

- __cleanup_counter : 0

- com.atlassian.gzipfilter.GzipFilter_already_filtered : true

- com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true

- gzipMimeTypes : text/.*,application/x-javascript,application/javascript,application/xml,application/xhtml +xml

- com.atlassian.crowd.integration.http.HttpAuthenticator.REQUEST_SSO_COOKIE_COMMITTED : true

- javax.servlet.error.message :

- webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@9548c3

- com.atlassian.gzipfilter.org.tuckey.web.filters.urlrewrite.RuleMatched : true

- __sitemesh__filterapplied : true

- javax.servlet.error.exception : javax.servlet.ServletException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar SELECT groupname from groupbase order by groupname ; nested exception is java.sql.SQLException: Invalid object name 'groupbase'.

- __spring_security_filterSecurityInterceptor_filterApplied : true

- javax.servlet.error.request_uri : /crowd/console/secure/dataimport/importatlassian!checkAdditionalParamsRequired.action

- crowd.token_key : M0DXVkyePEoaZZ8FPNS59A00

Request Parameters:

- configuration.password : xxxxxxx

- configuration.directoryID : 327681

- configuration.databaseDriver : net.sourceforge.jtds.jdbc.Driver

- configuration.username : xxxxxxxx

- configuration.importPasswords : true

- configuration.application : jira

- configuration.databaseURL : jdbc:jtds:sqlserver://localhost:1433/jiradb

[meena radhakrishnan · Accepted solution]

This has been resolved by setting default schema for the JIRA database user account.

http://confluence.atlassian.com/display/CROWDKB/Can%27t+Import+Users+From+JIRA+Using+SQL+Server+Database

CWDSUP-6442

[Jianan Wang]

Is there any detailed steps on how to change the default schema?