Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-651

Confluence importer error with MySQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • High
    • 1.2.1
    • 1.2
    • Import & Export
    • None

    Description

      First reported by this forum post http://forums.atlassian.com/thread.jspa?messageID=257259020&#257259020

      *************************************************************************
      Cause :
      javax.servlet.ServletException: StatementCallback; bad SQL grammar [SELECT username, passwd, (SELECT pe.string_val FROM os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'email') AS email, (SELECT pe.string_val FROM os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'fullName') AS fullname FROM os_user osu]; nested exception is java.sql.SQLException: Table 'confluence.os_propertyentry' doesn't exist
      
      Stack Trace :
      
      javax.servlet.ServletException: StatementCallback; bad SQL grammar [SELECT username, passwd, (SELECT pe.string_val FROM os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'email') AS email, (SELECT pe.string_val FROM os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'fullName') AS fullname FROM os_user osu]; nested exception is java.sql.SQLException: Table 'confluence.os_propertyentry' doesn't exist
      at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:284)
      at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:152)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:55)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
      at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      at java.lang.Thread.run(Thread.java:595)
      

      Attachments

        Activity

          People

            justen.stepka@atlassian.com Justen Stepka [Atlassian]
            justen.stepka@atlassian.com Justen Stepka [Atlassian]
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: