Hi Don, This stacktrace tells me that the issue you are having is *not* the same as the issue that Francis is happening (despite the similar error messages).
Based on the error stack below, the error you see is coming from the "EPerson.searchResultCount()" method, specifically the SQL on this line: https://github.com/DSpace/DSpace/blob/dspace-5_x/dspace-api/src/main/java/org/dspace/eperson/EPerson.java#L438 However, the error reported by Francis (and described in DS-3649: https://jira.duraspace.org/browse/DS-3649), was coming from the "EPerson.findAll()" method on this line: https://github.com/DSpace/DSpace/blob/dspace-5_x/dspace-api/src/main/java/org/dspace/eperson/EPerson.java#L518 So, I'm not surprised that the fix Tom provided won't work on your system. As it is fixing the latter method, and not the former one. It looks to me like your error is resulting from a similar/related problem though, that a CLOB data type cannot be used in "comparison conditions" [1], and the SQL in that "searchResultCount()" method uses LOWER() on a CLOB data type. So, I think, based on Tom's previous recommendation, you'd need to replace the "text_value" fields with "dbms_lob.substr(text_value, 0, 4000)" on these two lines: * Select statement here: https://github.com/DSpace/DSpace/blob/dspace-5.5/dspace-api/src/main/java/org/dspace/eperson/EPerson.java#L441 * And select statement here: https://github.com/DSpace/DSpace/blob/dspace-5.5/dspace-api/src/main/java/org/dspace/eperson/EPerson.java#L442 That's my best guess here. It sounds to me like we need to take a closer look at *all* the methods in this EPerson class, and ensure they are updated similarly. - Tim [1] https://docs.oracle.com/cd/B19306_01/server.102/b14200/conditions002.htm On Fri, Jan 26, 2018 at 1:05 PM Donald Bynum <[email protected]> wrote: > I made the change as suggested. Did a rebuild. That resulted in a new > additions-5.5.jar (which makes sense since the updated java module was in > additions. Same error. Here is the log entry (sorry it so lengthy): > > 2018-01-26 13:55:13,555 ERROR org.dspace.storage.rdbms.DatabaseManager @ > SQL query single Error - > java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: > expected - got CLOB > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:295) > at > org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:342) > at org.dspace.eperson.EPerson.searchResultCount(EPerson.java:438) > at > org.dspace.app.xmlui.aspect.administrative.eperson.ManageEPeopleMain.addBody(ManageEPeopleMain.java:118) > at > org.dspace.app.xmlui.wing.AbstractWingTransformer.startElement(AbstractWingTransformer.java:223) > at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy110.startElement(Unknown Source) > at > org.apache.cocoon.components.sax.XMLTeePipe.startElement(XMLTeePipe.java:87) > at > org.apache.cocoon.xml.AbstractXMLPipe.startElement(AbstractXMLPipe.java:94) > at > org.dspace.app.xmlui.wing.AbstractWingTransformer.startElement(AbstractWingTransformer.java:240) > at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy104.startElement(Unknown Source) > at > org.apache.cocoon.xml.AbstractXMLPipe.startElement(AbstractXMLPipe.java:94) > at > org.dspace.app.xmlui.wing.AbstractWingTransformer.startElement(AbstractWingTransformer.java:240) > at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy104.startElement(Unknown Source) > at > org.apache.cocoon.environment.internal.EnvironmentChanger.startElement(EnvironmentStack.java:140) > at > org.apache.cocoon.components.sax.XMLTeePipe.startElement(XMLTeePipe.java:87) > at > org.apache.cocoon.xml.AbstractXMLPipe.startElement(AbstractXMLPipe.java:94) > at > org.dspace.app.xmlui.wing.AbstractWingTransformer.startElement(AbstractWingTransformer.java:240) > at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy104.startElement(Unknown Source) > at > org.apache.cocoon.environment.internal.EnvironmentChanger.startElement(EnvironmentStack.java:140) > at > org.apache.cocoon.components.sax.XMLTeePipe.startElement(XMLTeePipe.java:87) > at > org.apache.cocoon.xml.AbstractXMLPipe.startElement(AbstractXMLPipe.java:94) > at > org.dspace.app.xmlui.wing.AbstractWingTransformer.startElement(AbstractWingTransformer.java:240) > at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy104.startElement(Unknown Source) > at > org.apache.cocoon.environment.internal.EnvironmentChanger.startElement(EnvironmentStack.java:140) > at > org.apache.cocoon.components.sax.XMLTeePipe.startElement(XMLTeePipe.java:87) > at > org.apache.cocoon.xml.AbstractXMLPipe.startElement(AbstractXMLPipe.java:94) > at > org.dspace.app.xmlui.wing.AbstractWingTransformer.startElement(AbstractWingTransformer.java:240) > at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy104.startElement(Unknown Source) > at > org.apache.cocoon.environment.internal.EnvironmentChanger.startElement(EnvironmentStack.java:140) > at > org.apache.cocoon.components.sax.XMLTeePipe.startElement(XMLTeePipe.java:87) > at > org.apache.cocoon.components.sax.AbstractXMLByteStreamInterpreter.parse(AbstractXMLByteStreamInterpreter.java:117) > at > org.apache.cocoon.components.sax.XMLByteStreamInterpreter.deserialize(XMLByteStreamInterpreter.java:44) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:324) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:326) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:326) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:326) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:326) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:544) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:273) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:544) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:273) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:544) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:273) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:544) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:273) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:544) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:273) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:750) > at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:362) > at > org.apache.cocoon.components.source.util.SourceUtil.toSAX(SourceUtil.java:111) > at > org.apache.cocoon.components.source.util.SourceUtil.parse(SourceUtil.java:294) > at > org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:136) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy100.generate(Unknown Source) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:544) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:273) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:439) > at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:71) > at com.sun.proxy.$Proxy99.process(Unknown Source) > at > org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:147) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:55) > at > org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNode.java:87) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:78) > at > org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:143) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:78) > at > org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:81) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:239) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:171) > at > org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:247) > at > org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNode.java:117) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:55) > at > org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNode.java:87) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:78) > at > org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:143) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:78) > at > org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:81) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:239) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:171) > at > org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:247) > at > org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNode.java:117) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:78) > at > org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:143) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:78) > at > org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:81) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:239) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:171) > at > org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:247) > at > org.apache.cocoon.servlet.RequestProcessor.process(RequestProcessor.java:351) > at > org.apache.cocoon.servlet.RequestProcessor.service(RequestProcessor.java:169) > at > org.apache.cocoon.sitemap.SitemapServlet.service(SitemapServlet.java:84) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) > at > org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:468) > at > org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:443) > at > org.apache.cocoon.servletservice.spring.ServletFactoryBean$ServiceInterceptor.invoke(ServletFactoryBean.java:264) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) > at com.sun.proxy.$Proxy96.service(Unknown Source) > at org.dspace.springmvc.CocoonView.render(CocoonView.java:113) > at > org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1180) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:950) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) > at > org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) > at > org.dspace.app.xmlui.cocoon.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) > at > org.dspace.app.xmlui.cocoon.DSpaceCocoonServletFilter.doFilter(DSpaceCocoonServletFilter.java:274) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) > at > org.dspace.app.xmlui.cocoon.servlet.multipart.DSpaceMultipartFilter.doFilter(DSpaceMultipartFilter.java:119) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) > at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) > at > org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:522) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) > at > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) > at > org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:1110) > at > org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) > at > org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:785) > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1425) > at > org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:748) > > -Don > > > On Friday, January 26, 2018 at 9:53:36 AM UTC-5, Tim Donohue wrote: > >> Hi Don, Tom & Francis, >> >> I notice the code that Tom mentions patching in EPerson.java didn't >> appear until DSpace 5.6. It was applied in this PR: >> https://github.com/DSpace/DSpace/pull/1229 >> >> Don, you mentioned you are running DSpace 5.5. So, this has got me >> wondering if the problem you are seeing is actually the same one as >> Francis, or something different (but similar in nature)? >> >> That might explain why this patch works for Francis (who is running 5.6), >> but not for Don. >> >> Don, could you perhaps share a more complete error stacktrace (from the >> logs) for the "ORA-00932: inconsistent datatypes: expected - got CLOB >> " message you are seeing? It's always possible this is happening in >> different scenarios in DSpace 5.5 vs 5.6. >> >> - Tim >> >> On Thu, Jan 25, 2018 at 2:28 PM Donald Bynum <[email protected]> wrote: >> > I copied the EPerson.java to >>> dspace\modules\additions\src\main\java\org\dspace\eperson (I had ti create >>> the additions folder) and rebuilt. Still not good. How can I be sure that >>> the new java class exists? meaning, where can I look to make sure that the >>> newly compiled class is in place? I am going to try one other thing. But >>> would appreciate any further guidance you can give me. >>> >>> -Don >>> >>> >>> On Wednesday, January 24, 2018 at 5:29:44 AM UTC-5, Tom Desair (Atmire) >>> wrote: >>> >>>> Hi Francis, >>>> >>>> That's good news! Thanks for testing and your feedback. I hope that >>>> this workaround then also works for Don. >>>> >>>> Best regards, >>>> Tom >>>> >>>> [image: logo] Tom Desair >>>> 250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586 >>>> <https://maps.google.com/?q=3A,+Lucius+Gordon+Drive,+West+Henrietta,+NY+14586&entry=gmail&source=g> >>>> Gaston Geenslaan 14, Leuven 3001, Belgium >>>> <https://maps.google.com/?q=Gaston+Geenslaan+14,+Leuven+3001,+Belgium&entry=gmail&source=g> >>>> www.atmire.com >>>> <http://atmire.com/website/?q=services&utm_source=emailfooter&utm_medium=email&utm_campaign=tomdesair> >>>> >>>> On Wednesday, January 24, 2018 at 11:22:40 AM UTC+1, Francis Brouns >>>> wrote: >>>>> >>>>> Dear Tom, >>>>> >>>>> this workaround seems to work by changing m.text_value in line 502 and >>>>> line 510 in EPerson.java for Dspace release 5.6. The error no longer >>>>> occurs >>>>> when selecting epersons or trying to add epersons to a group. >>>>> >>>>> case LANGUAGE: >>>>> s = "m.text_value"; >>>>> t = "language"; >>>>> break; >>>>> >>>>> >>>>> default: >>>>> s = "m.text_value"; >>>>> t = "lastname"; >>>>> >>>>> >>>>> 2018-01-24 11:14:49,448 DEBUG org.dspace.storage.rdbms.DatabaseManager >>>>> @ Running query "SELECT * FROM eperson e LEFT JOIN metadatavalue m on >>>>> (m.resource_id = e.eperson_id and m.resource_type_id = ? and >>>>> m.metadata_field_id = ?) ORDER BY dbms_lob.substr(m.text_value,0,4000)" >>>>> with parameters: 7,125 >>>>> >>>>> I'll try this in release 5.8 as well and see if we can proceed with >>>>> the upgrade. >>>>> >>>>> Thanks for now. >>>>> Francis Brouns >>>>> Open Universiteit >>>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "DSpace Technical Support" group. >>> >> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >> >> >>> Visit this group at https://groups.google.com/group/dspace-tech. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> Tim Donohue >> Technical Lead for DSpace & DSpaceDirect >> DuraSpace.org | DSpace.org | DSpaceDirect.org >> > -- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- Tim Donohue Technical Lead for DSpace & DSpaceDirect DuraSpace.org | DSpace.org | DSpaceDirect.org -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
