Oracle error creating review

[2011-01-25 00:02:46,430] WARN  fisheye.app
Rolled back transaction started from:
   -> com.cenqua.crucible.actions.BaseAction.beginTx(BaseAction.java:130)
   -> com.cenqua.crucible.actions.create.CreateReviewFromChangesetAjaxAction.execute(CreateReviewFromChangesetAjaxAction.java:469)
   -> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   -> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   -> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


[2011-01-25 00:02:46,445] ERROR org.mortbay.log
/crucible/json/cru/createDialog

org.hibernate.exception.SQLGrammarException: could not execute query
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
       at org.hibernate.loader.Loader.doList(Loader.java:2452)
       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
       at org.hibernate.loader.Loader.list(Loader.java:2187)
       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
       at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
       at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
       at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
       at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
       at com.cenqua.crucible.iterative.ReviewByChangeSetFinder.find(ReviewByChangeSetFinder.java:93)
       at com.cenqua.crucible.iterative.DefaultIterativeReviewHelper.getReviewsByRevisions(DefaultIterativeReviewHelper.java:60)
       at com.cenqua.crucible.iterative.DefaultIterativeReviewHelper.getReviewsByRevisions(DefaultIterativeReviewHelper.java:55)
       at com.cenqua.crucible.actions.create.CreateReviewFromChangesetAjaxAction.calculateSuggestions(CreateReviewFromChangesetAjaxAction.java:564)
       at com.cenqua.crucible.actions.create.CreateReviewFromChangesetAjaxAction.execute(CreateReviewFromChangesetAjaxAction.java:528)
       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)
       at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
       at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)
       at com.cenqua.crucible.interceptors.ReviewInterceptor.intercept(ReviewInterceptor.java:50)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.cenqua.crucible.interceptors.CruciblePermissionInterceptor.intercept(CruciblePermissionInterceptor.java:40)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.cenqua.crucible.interceptors.HasCrucibleInterceptor.intercept(HasCrucibleInterceptor.java:27)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186)
       at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
       at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
       at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
       at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
       at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1217)
       at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
       at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
       at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25)
       at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
       at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83)
       at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:141)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:248)
       at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
       at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
       at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
       at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
       at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
       at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
       at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
       at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
       at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:327)
       at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126)
       at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:165)
       at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
       at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
       at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
       at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
- Hide quoted text -
       at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
       at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69)
       at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
       at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:78)
       at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:131)
       at com.cenqua.fisheye.web.filters.CustomIncludableGzipFilter.doFilter(CustomIncludableGzipFilter.java:21)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.cenqua.fisheye.web.filters.ProductInfoFilter.doFilter(ProductInfoFilter.java:36)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
       at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.cenqua.fisheye.web.filters.UpfrontFilter.doFilter(UpfrontFilter.java:52)
       at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
       at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at com.atlassian.fecru.profiling.ProfilingServletFilter.doFilter(ProfilingServletFilter.java:72)
       at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
       at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
       at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1209)
       at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
       at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
       at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
       at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
       at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
       at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
       at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
       at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
       at org.mortbay.jetty.Server.handle(Server.java:326)
       at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
       at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
       at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
       at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
       at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
       at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
       at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451)
Caused by: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
       at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
       at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
       at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
       at org.hibernate.loader.Loader.getResultSet(Loader.java:1869)
       at org.hibernate.loader.Loader.doQuery(Loader.java:718)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
       at org.hibernate.loader.Loader.doList(Loader.java:2449)
       ... 133 more