It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×7,383
×4,692

question asked: Jul 20 '17, 11:16 p.m.
question was seen: 900 times
last updated: Jul 21 '17, 12:00 a.m.

Related questions

FAQ - How this Forum works

error in SPARQL Code while copy from production(DB2) to Test Server (Oracle)

0
Neeraj Malik (23●1●19) | asked Jul 20 '17, 11:16 p.m.

Hi team,

We are facing issue with a report in JRS. when we copy the code from Production to Test Server it's showing the below error while validate the query in JRS. while for other DB2 server it's working fine.

com.ibm.team.integration.reporting.model.exceptions.SqlParseException: CRRGW5628E An java.sql.SQLSyntaxErrorException error occurred when validating the input SQL string, caused by ORA-00904: "DAYS": invalid identifier
.
    at com.ibm.team.integration.reporting.model.utils.DbUtils.validateSQLQuery(DbUtils.java:149)
    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.replaceQuery(TDBResourceStore.java:1182)
    at com.ibm.team.integration.reporting.ui.services.QueryReportDefinition.doPut(QueryReportDefinition.java:404)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:598)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1227)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:776)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:458)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1385)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:194)
    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.doPut(Front.java:90)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:598)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1227)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:776)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:458)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
    at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:90)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:909)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
    at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "DAYS": invalid identifier

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kenji Sarai (960●2●9) | answered Jul 21 '17, 12:00 a.m.

Hi Neeraj,

Firstly, this problem is happening when you copy SQL (not SPARQL) query from DB2 to Oracle, right?

Basically DB2 and Oracle have same database schema structure, so it is possible to run the same query. For your case, the error "ORA-00904: "DAYS": invalid identifier" is self explanatory. The column "DAYS" is missing in the target table. Please check what table suppose to have DAYS column, and why it is missing in Oracle only... Any customization made in DB2 schema? What query are you running?

https://docs.oracle.com/cd/B10501_01/server.920/a96525/e900.htm

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.