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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.