cancel
Showing results for 
Search instead for 
Did you mean: 

Why we were unable to download excel sheet from local Hybris(hsql db) ?

0 Kudos
242

SEVERE: Servlet.service() for servlet [DispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: SQL search error - enable the property 'flexible.search.exception.show.query.details' for more details] with root cause

org.hsqldb.HsqlException: user lacks privilege or object not found: ROWNUM

at org.hsqldb.error.Error.error(Unknown Source)

at org.hsqldb.error.Error.error(Unknown Source)

at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)

at org.hsqldb.QueryExpression.resolve(Unknown Source)

at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)

at org.hsqldb.ParserCommand.compilePart(Unknown Source)

at org.hsqldb.ParserCommand.compileStatement(Unknown Source)

at org.hsqldb.Session.compileStatement(Unknown Source)

at org.hsqldb.StatementManager.compile(Unknown Source)

at org.hsqldb.Session.execute(Unknown Source)

at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)

at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)

at de.hybris.platform.jdbcwrapper.interceptor.ConnectionWithJDBCInterceptor.lambda$prepareStatement$3(ConnectionWithJDBCInterceptor.java:64)

at de.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler.passThrough(SQLRecoverableExceptionHandler.java:93)

at de.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler.get(SQLRecoverableExceptionHandler.java:51)

at de.hybris.platform.jdbcwrapper.interceptor.JDBCInterceptor.get(JDBCInterceptor.java:61)

at de.hybris.platform.jdbcwrapper.interceptor.ConnectionWithJDBCInterceptor.prepareStatement(ConnectionWithJDBCInterceptor.java:64)

at de.hybris.platform.jdbcwrapper.ConnectionImpl.prepareStatement(ConnectionImpl.java:648)

at de.hybris.platform.jalo.flexiblesearch.internal.FlexibleSearchExecutor.execute(FlexibleSearchExecutor.java:227)

at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearch(FlexibleSearch.java:2187)

at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearch(FlexibleSearch.java:2207)

at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.compute(FlexibleSearchCacheUnit.java:71)

at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:297)

at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:270)

at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:172)

at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.myGet(FlexibleSearchCacheUnit.java:158)

at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearchUsingFlexibleSearchDialect(FlexibleSearch.java:1735)

at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1462)

at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1453)

at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$3.execute(DefaultFlexibleSearchService.java:533)

Accepted Solutions (0)

Answers (1)

Answers (1)

adambadura
Participant
0 Kudos