Error OAI identify Dspace 6.2

[christian criollo]

Hi all

Recently EBSCO report a error to harvest our repository when i try access to the url harvest it shown this error

Estado HTTP 500 - Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

---

type Informe de Excepción

mensaje Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

descripción El servidor encontró un error interno que hizo que no pudiera rellenar este requerimiento.

excepción

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:963)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:842)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

causa raíz

org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
	org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
	org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88)
	org.hibernate.loader.Loader.getResultSet(Loader.java:2062)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
	org.hibernate.loader.Loader.doQuery(Loader.java:906)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
	org.hibernate.loader.Loader.doList(Loader.java:2550)
	org.hibernate.loader.Loader.doList(Loader.java:2536)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
	org.hibernate.loader.Loader.list(Loader.java:2361)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
	org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
	org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)
	org.hibernate.internal.SessionImpl.list(SessionImpl.java:1230)
	org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
	org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:909)
	org.dspace.content.dao.impl.MetadataValueDAOImpl.getMinimum(MetadataValueDAOImpl.java:78)
	org.dspace.content.MetadataValueServiceImpl.getMinimum(MetadataValueServiceImpl.java:115)
	org.dspace.xoai.services.impl.DSpaceEarliestDateResolver.getEarliestDate(DSpaceEarliestDateResolver.java:36)
	org.dspace.xoai.services.impl.xoai.DSpaceRepositoryConfiguration.getEarliestDate(DSpaceRepositoryConfiguration.java:99)
	com.lyncode.xoai.dataprovider.handlers.IdentifyHandler.handle(IdentifyHandler.java:44)
	com.lyncode.xoai.dataprovider.OAIDataProvider.handle(OAIDataProvider.java:198)
	org.dspace.xoai.controller.DSpaceOAIDataProvider.contextAction(DSpaceOAIDataProvider.java:104)
	sun.reflect.GeneratedMethodAccessor729.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:842)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

causa raíz

java.sql.SQLSyntaxErrorException: ORA-00932: tipos de dato inconsistentes: se esperaba - se ha obtenido CLOB

	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
	oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
	oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
	oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
	oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
	oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
	org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
	org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
	org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
	org.hibernate.loader.Loader.getResultSet(Loader.java:2062)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
	org.hibernate.loader.Loader.doQuery(Loader.java:906)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
	org.hibernate.loader.Loader.doList(Loader.java:2550)
	org.hibernate.loader.Loader.doList(Loader.java:2536)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
	org.hibernate.loader.Loader.list(Loader.java:2361)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
	org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
	org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)
	org.hibernate.internal.SessionImpl.list(SessionImpl.java:1230)
	org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
	org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:909)
	org.dspace.content.dao.impl.MetadataValueDAOImpl.getMinimum(MetadataValueDAOImpl.java:78)
	org.dspace.content.MetadataValueServiceImpl.getMinimum(MetadataValueServiceImpl.java:115)
	org.dspace.xoai.services.impl.DSpaceEarliestDateResolver.getEarliestDate(DSpaceEarliestDateResolver.java:36)
	org.dspace.xoai.services.impl.xoai.DSpaceRepositoryConfiguration.getEarliestDate(DSpaceRepositoryConfiguration.java:99)
	com.lyncode.xoai.dataprovider.handlers.IdentifyHandler.handle(IdentifyHandler.java:44)
	com.lyncode.xoai.dataprovider.OAIDataProvider.handle(OAIDataProvider.java:198)
	org.dspace.xoai.controller.DSpaceOAIDataProvider.contextAction(DSpaceOAIDataProvider.java:104)
	sun.reflect.GeneratedMethodAccessor729.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:842)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

nota La traza completa de la causa de este error se encuentra en los archivos de diario de Apache Tomcat/7.0.50.

I like paritcular this line 

java.sql.SQLSyntaxErrorException: ORA-00932: tipos de dato inconsistentes: se esperaba - se ha obtenido CLOB

I dont know if this a bug of the application I using a database Oracle


thank you for the help

[Simeon Warner]

Hi Christian,

This looks like an internal problem with your DSpace installation, I
suggest trying a DSpace email list, see:
https://wiki.duraspace.org/display/DSPACE/Mailing+Lists

When properly configured DSpace should support OAI-PMH just fine.

Cheers,
Simeon

On 9/20/18 4:04 PM, christian criollo wrote:
> Hi all
>
>
> Recently EBSCO report a error to harvest our repository when i try
> access to the url harvest it shown this error
>
>
> Estado HTTP 500 - Request processing failed; nested exception is
> org.hibernate.exception.SQLGrammarException: could not extract ResultSet
>

> ------------------------------------------------------------------------
>
> *type* Informe de Excepción
>
> *mensaje* _Request processing failed; nested exception is

> org.hibernate.exception.SQLGrammarException: could not extract ResultSet_
>

> *descripción* _El servidor encontró un error interno que hizo que no
> pudiera rellenar este requerimiento._
>
> *excepción*

>
> org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:963)
> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:842)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
>

> *causa raíz*

> *causa raíz*

> *nota* _La traza completa de la causa de este error se encuentra en los
> archivos de diario de Apache Tomcat/7.0.50. <http://7.0.50.>_
>
> _
> _
>
> _
> _
>
> _I like paritcular this line
> _
>
> _
> _

>
>
> java.sql.SQLSyntaxErrorException: ORA-00932: tipos de dato inconsistentes: se esperaba - se ha obtenido CLOB
>
> I dont know if this a bug of the application I using a database Oracle
>
>
> thank you for the help
>

> --
>
> ---
> You received this message because you are subscribed to the Google
> Groups "OAI-PMH" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to oai-pmh+u...@googlegroups.com
> <mailto:oai-pmh+u...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.

[christian criollo]

Hi Simeon

investigating  apparently it is a bug of hibernate with Oracle