It's all about the answers!

Ask a question

Problem to import SAFe report on Report Builder 6.0.2


Mathieu Defianas (15932337) | asked May 30 '16, 10:47 a.m.
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



permanent link
Robert Wen (690111) | answered May 31 '16, 8:56 a.m.
 It looks like you set up your data warehouse for Derby.  The documentation for the SAFe documentation doesn't recommend Derby.

Your answer


Register or to post your answer.