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
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