Hi,
After upgrading my knowage from version 6.2 to version 6.4 basing on the guide, everything is fine except for the dataset. It's the first time that I have encountered this kind of Error. Please refer to the information below and please advise us if you can help. Thank you in advance.
Upon Clicking on the Dataset, this Error occurs :
ErrorEvery derived table must have its own alias Query is: select * from ( select sbidataset0_.DS_ID as DS1_54_, sbidataset0_.VERSION_NUM as VERSION2_54_, sbidataset0_.ORGANIZATION as ORGANIZA3_54_, sbidataset0_.CATEGORY_ID as CATEGORY4_54_, sbidataset0_.TRANSFORMER_ID as TRANSFOR5_54_, sbidataset0_.SCOPE_ID as SCOPE6_54_, sbidataset0_.ACTIVE as ACTIVE54_, sbidataset0_.NAME as NAME54_, sbidataset0_.DESCR as DESCR54_, sbidataset0_.LABEL as LABEL54_, sbidataset0_.OBJECT_TYPE as OBJECT11_54_, sbidataset0_.PARAMS as PARAMS54_, sbidataset0_.DS_METADATA as DS13_54_, sbidataset0_.PIVOT_COLUMN as PIVOT14_54_, sbidataset0_.PIVOT_ROW as PIVOT15_54_, sbidataset0_.PIVOT_VALUE as PIVOT16_54_, sbidataset0_.NUM_ROWS as NUM17_54_, sbidataset0_.IS_PERSISTED as IS18_54_, sbidataset0_.IS_PERSISTED_HDFS as IS19_54_, sbidataset0_.PERSIST_TABLE_NAME as PERSIST20_54_, sbidataset0_.CONFIGURATION as CONFIGU21_54_, sbidataset0_.OWNER as OWNER54_, sbidataset0_.FEDERATION_ID as FEDERATION23_54_, sbidataset0_.USER_IN as USER24_54_, sbidataset0_.USER_UP as USER25_54_, sbidataset0_.USER_DE as U...
And this is what we found in the logs :
[localhost-startStop-2] 23 May 2019 08:29:09,340 ERROR it.eng.spagobi.tools.scheduler.init.RestEventQuartzInitializer.initRestEventsForTenant:99 - Error while initializing scheduler
it.eng.spagobi.commons.dao.SpagoBIDAOException: An unexpected error occured while inserting trigger[Trigger [name=schedule_rest_events, groupName=null]]
at it.eng.spagobi.tools.scheduler.dao.quartz.QuarzSchedulerDAOImpl.insertTrigger(QuarzSchedulerDAOImpl.java:540)
at it.eng.spagobi.tools.scheduler.init.RestEventQuartzInitializer.initRestEventsForTenant(RestEventQuartzInitializer.java:94)
at it.eng.spagobi.tools.scheduler.init.RestEventQuartzInitializer.init(RestEventQuartzInitializer.java:54
... 43 more
Caused by: java.sql.SQLException: Every derived table must have its own alias
Query is: select * from ( select sbidataset0_.DS_ID as DS1_54_, sbidataset0_.VERSION_NUM as VERSION2_54_, sbidataset0_.ORGANIZATION as ORGANIZA3_54_, sbidataset0_.CATEGORY_ID as CATEGORY4_54_, sbidataset0_.TRANSFORMER_ID as TRANSFOR5_54_, sbidataset0_.SCOPE_ID as SCOPE6_54_, sbidataset0_.ACTIVE as ACTIVE54_, sbidataset0_.NAME as NAME54_, sbidataset0_.DESCR as DESCR54_, sbidataset0_.LABEL as LABEL54_, sbidataset0_.OBJECT_TYPE as OBJECT11_54_, sbidataset0_.PARAMS as PARAMS54_, sbidataset0_.DS_METADATA as DS13_54_, sbidataset0_.PIVOT_COLUMN as PIVOT14_54_, sbidataset0_.PIVOT_ROW as PIVOT15_54_, sbidataset0_.PIVOT_VALUE as PIVOT16_54_, sbidataset0_.NUM_ROWS as NUM17_54_, sbidataset0_.IS_PERSISTED as IS18_54_, sbidataset0_.IS_PERSISTED_HDFS as IS19_54_, sbidataset0_.PERSIST_TABLE_NAME as PERSIST20_54_, sbidataset0_.CONFIGURATION as CONFIGU21_54_, sbidataset0_.OWNER as OWNER54_, sbidataset0_.FEDERATION_ID as FEDERATION23_54_, sbidataset0_.USER_IN as USER24_54_, sbidataset0_.USER_UP as USER25_54_, sbidataset0_.USER_DE as U...
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:153)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:254)
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:209)
... 50 more
[http-bio-8080-exec-8] 23 May 2019 08:32:32,316 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - (conn=49) Every derived table must have its own alias
[http-bio-8080-exec-8] 23 May 2019 08:32:32,316 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - (conn=49) Every derived table must have its own alias
[http-bio-8080-exec-8] 23 May 2019 08:32:32,317 ERROR it.eng.spagobi.rest.interceptors.RestExceptionMapper.toResponse:59 - Catched service error:
it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: An unexpected error occured while executing service
at it.eng.spagobi.api.DataSetResource.getDataSetsPaginationOption(DataSetResource.java:306)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)