Hi All,
I created a function with output collumns. When I preview the function the output collumns does not appear on the dataset. The same happens when i add the function to a table. Can someone help? version 8.1.9
log:
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while executing statement: SELECT DISTINCT FROM sbicachebed9c8aafdf211ed89f023
at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:148) ~[knowage-utils-8.1.9.jar:8.1.9]
Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM sbicachebed9c8aafdf211ed89f023' at line 1
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1681) ~[mariadb-java-client-2.7.2.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1543) ~[mariadb-java-client-2.7.2.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1506) ~[mariadb-java-client-2.7.2.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:254) ~[mariadb-java-client-2.7.2.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ~[mariadb-java-client-2.7.2.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:612) ~[mariadb-java-client-2.7.2.jar:?]
at sun.reflect.GeneratedMethodAccessor668.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_371]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_371]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118) ~[tomcat-jdbc.jar:?]
at com.sun.proxy.$Proxy294.executeQuery(Unknown Source) ~[?:?]
at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:140) ~[knowage-utils-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.bo.ConfigurableDataSet.loadData(ConfigurableDataSet.java:152) ~[knowage-utils-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement(DataSource.java:592) ~[knowage-utils-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement(DataSource.java:579) ~[knowage-utils-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.strategy.AbstractJdbcEvaluationStrategy.execute(AbstractJdbcEvaluationStrategy.java:55) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.strategy.AbstractEvaluationStrategy.executeQuery(AbstractEvaluationStrategy.java:96) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.strategy.TimeMonitoringEvaluationStrategyWrapper.executeQuery(TimeMonitoringEvaluationStrategyWrapper.java:27) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.queryStandardCachedDataset(SQLDBCache.java:310) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.getInternal(SQLDBCache.java:264) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.get(SQLDBCache.java:245) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.strategy.CachedEvaluationStrategy.execute(CachedEvaluationStrategy.java:67) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.strategy.AbstractEvaluationStrategy.executeQuery(AbstractEvaluationStrategy.java:96) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.strategy.TimeMonitoringEvaluationStrategyWrapper.executeQuery(TimeMonitoringEvaluationStrategyWrapper.java:27) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:296) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.api.common.AbstractDataSetResource.getDataStore(AbstractDataSetResource.java:287) ~[knowage-core-8.1.9.jar:8.1.9]
at it.eng.spagobi.api.v2.DataSetResource.getDataStorePostWithJsonInBody(DataSetResource.java:743) ~[knowage-core-8.1.9.jar:8.1.9]
... 89 more
