Problem to import SAFe report on Report Builder 6.0.2
![]()
Hello,
I have installed the last RTC version 6.0.2. I would like to use SAFe template and I try to install the SAFe report on report builder. The import is pending ... and never successfully ... On the log, I have this error : 2016-05-30 15:40:06,052 [ Default Executor-thread-3073] ERROR ibm.team.integration.reporting.model.utils.DbUtils - CRRGW5628E An java.sql.SQLSyntaxErrorException error occurred when validating the input SQL string, caused by Column 'VAL' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'VAL' is not a column in the target table.. java.sql.SQLSyntaxErrorException: Column 'VAL' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'VAL' is not a column in the target table. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source) at com.ibm.team.integration.reporting.db.connection.wrapper.DbConnection.prepareStatement(DbConnection.java:349) at com.ibm.team.integration.reporting.model.utils.DbUtils.validateSQLQuery(DbUtils.java:158) at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.validateQueryString(TDBResourceStore.java:1508) at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.validateQuery(TDBResourceStore.java:1390) at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.createQuery(TDBResourceStore.java:1520) at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.createQuery(TDBResourceStore.java:1175) at com.ibm.team.integration.reporting.model.exportimport.ImportActionHandler.importQuery(ImportActionHandler.java:919) at com.ibm.team.integration.reporting.model.exportimport.ImportActionHandler.importFile(ImportActionHandler.java:696) at com.ibm.team.integration.reporting.model.exportimport.ImportActionHandler.importFiles(ImportActionHandler.java:600) at com.ibm.team.integration.reporting.model.exportimport.ImportActionHandler.importFiles(ImportActionHandler.java:565) at com.ibm.team.integration.reporting.model.exportimport.ImportActionHandler.executeImport(ImportActionHandler.java:380) at com.ibm.team.integration.reporting.model.exportimport.ImportActionHandler.execute_(ImportActionHandler.java:202) at com.ibm.team.integration.reporting.model.exportimport.ImportActionHandler.execute(ImportActionHandler.java:192) at com.ibm.team.integration.reporting.model.services.ReportDefinition.doPost(ReportDefinition.java:498) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1287) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:778) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:150) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:78) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1020) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1142) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1378) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:186) at com.ibm.team.integration.reporting.gatewayservices.Front.forwardRequest(Front.java:221) at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:202) at com.ibm.team.integration.reporting.gatewayservices.Front.doPost(Front.java:76) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1287) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:778) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:150) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:93) at com.ibm.team.integration.reporting.common.services.ClickjackFilter.doFilter(ClickjackFilter.java:47) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:207) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:90) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:207) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1020) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1142) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4867) at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.handleRequest(DynamicVirtualHost.java:297) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:997) at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:262) at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:955) at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:341) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:470) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:404) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:284) at com.ibm.ws.http.channel.internal.inbound.HttpICLReadCallback.complete(HttpICLReadCallback.java:66) at com.ibm.ws.channel.ssl.internal.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1766) at com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:504) at com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:574) at com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:929) at com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1018) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627) at java.lang.Thread.run(Thread.java:809) Caused by: org.apache.derby.client.am.SqlException: Column 'VAL' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'VAL' is not a column in the target table. at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source) at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source) at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source) ... 62 more 2016-05-30 15:40:06,052 [ Default Executor-thread-3073] ERROR ibm.team.integration.reporting.model.utils.DbUtils - The query that caused the exception is: SELECT DISTINCT T1.NAME AS URL1_title, T1.URL AS URL1, VAL, VAL1, VAL2, VAL3, T2.FULL_NAME FROM RIDW.VW_REQUIREMENT T1 LEFT OUTER JOIN RIDW.VW_RESOURCE T2 ON T2.RESOURCE_ID=T1.OWNER_ID WHERE T1.PROJECT_ID = 6 AND ( T1.REQUIREMENT_TYPE = '[SAFe] Strategic Theme' ) AND (T1.ISSOFTDELETED = 0) AND (T1.REQUIREMENT_ID <> -1 AND T1.REQUIREMENT_ID IS NOT NULL) 2016-05-30 15:40:06,052 [ Default Executor-thread-3073] ERROR n.reporting.model.exportimport.ImportActionHandler - Import failed for file Allocated_Capacity_by_Strategic_Theme.ttl Une exception SQL est survenue lors de la validation du SQL généré à partir du rapport (voir le fichier journal pour identifier la chaîne de requête à l'origine de l'exception). I use on my test platform derby. Please confirm me that SAFe report can be used on derby ... Have you got an idea about my issue ? Thanks for your help Mathieu |
One answer
![]()
It looks like you set up your data warehouse for Derby. The documentation for the SAFe documentation doesn't recommend Derby.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.