It's all about the answers!

Ask a question

Problem to import SAFe report on Report Builder 6.0.2


Mathieu Defianas (15952938) | 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 (690412) | 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.


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.