Tim, That was it. Just made those two updates and rebuilt. All looks good again.
Thank you for your assistance with this. Very much appreciated. -Don. On Monday, January 29, 2018 at 3:15:21 PM UTC-5, Tim Donohue wrote: > > 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 <byn...@gmail.com > <javascript:>> 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 <byn...@gmail.com> 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 dspace-tech...@googlegroups.com. >>>> To post to this group, send email to dspac...@googlegroups.com. >>> >>> >>>> 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 dspace-tech...@googlegroups.com <javascript:>. >> To post to this group, send email to dspac...@googlegroups.com >> <javascript:>. >> 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
