Details
-
Bug
-
Resolution: Won't Fix
-
Major
-
None
-
2.7
-
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.