So, now I am more confused/concerned. I ran the raw query in SQLPlus, much as Francis did, and it worked just fine. It failed with the same error without the dbms_lob conversion, but worked with the fix. So, now I am concerned that my EPerson.java is not being picked up in the compilation/build. is there a way to determine if that is in fact the case?
-Don On Friday, January 26, 2018 at 2:05:06 PM UTC-5, Donald Bynum 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.
