Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-6024

Errors when starting with MSSQL 2008 R2

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Major
    • None
    • 2.7
    • Storage
    • Windows Server 2008 R2 Enterprise (x64), Microsoft SQL Server 2008 R2, Tomcat 7.0.8
    • Errors,Log,MSSQL,Tomcat
    • Unknown
    • N/A
    • N/A

    Description

      I noticed that I get some error logging when starting Tomcat.

      2011-02-21 10:46:06,385 [http://de-s-0xxxxxx.de.abb.com/bin/view/Sandbox/lalala] INFO  .AbstractXWikiMigrationManager  - No storage migration required since current version is [15429] 
      2011-02-21 10:46:20,026 [http://de-s-0xxxxxx.de.abb.com/bin/view/Sandbox/lalala] WARN  util.JDBCExceptionReporter      - SQL Error: 402, SQLState: S0001 
      2011-02-21 10:46:20,026 [http://de-s-0xxxxxx.de.abb.com/bin/view/Sandbox/lalala] ERROR util.JDBCExceptionReporter      - The data types text and nvarchar(max) are incompatible in the equal to operator. 
      2011-02-21 10:46:20,029 [http://de-s-0xxxxxx.de.abb.com/bin/view/Sandbox/lalala] ERROR impl.StatsUtil                  - Failed to search visit object in the database from cookie 
      org.xwiki.query.QueryException: Exception while execute query. Query statement = [from VisitStats as obj where obj.cookie=:fieldValue and obj.endDate > :date order by obj.endDate desc]
      	at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:99)
      	at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:65)
      	at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:236)
      	at com.xpn.xwiki.stats.impl.StatsUtil.findVisitByField(StatsUtil.java:581)
      	at com.xpn.xwiki.stats.impl.StatsUtil.findVisitByCookie(StatsUtil.java:606)
      	at com.xpn.xwiki.stats.impl.StatsUtil.findVisitByCookieOrIPUA(StatsUtil.java:441)
      	at com.xpn.xwiki.stats.impl.StatsUtil.findVisit(StatsUtil.java:385)
      	at com.xpn.xwiki.stats.impl.xwiki.XWikiStatsStoreService.addStats(XWikiStatsStoreService.java:198)
      	at com.xpn.xwiki.stats.impl.XWikiStatsServiceImpl.onEvent(XWikiStatsServiceImpl.java:202)
      	at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:278)
      	at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:247)
      	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:316)
      	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:117)
      	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
      	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
      	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
      	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      	at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      	at com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      	at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      	at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      	at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
      	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:383)
      	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
      	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
      	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:166)
      	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:288)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      	at java.lang.Thread.run(Unknown Source)
      Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
      Wrapped Exception: could not execute query
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1087)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1117)
      	at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:88)
      	... 49 more
      

      Note that I just set up the instance. In order to do that I exported the entire wiki from it's temporary installation which was also Tomcat but along with postgreSQL 9. I used the large import snippet from the extensions wiki to import the large .xar into the new instance.

      Attachments

        Activity

          People

            mleduc Manuel Leduc
            jstoldt Johannes Stoldt
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: