2 Replies Latest reply on Mar 8, 2018 7:45 AM by Angel Ramirez del Pino

    Smart Reporting append subquery issue on new report

    Angel Ramirez del Pino

      Hi all, i am trying to create an append full outer join subquery for a new report but it never return results just return error on results retrieve.

       

      This is the error that i am getting on bmcspartreporting-stdout.log:

      BMC:SR:2018-03-08 14:06:09:ERROR (DBAction:doSelect) - Error occured selecting data: java.sql.SQLException: FULL JOIN not supported

      java.sql.SQLException: FULL JOIN not supported

      at com.bmc.arsys.sql.parser.ANTLRParser.checkForInvalidConstruct(ANTLRParser.java:390)

      at com.bmc.arsys.sql.parser.ANTLRParser.preProcessQuery(ANTLRParser.java:319)

      at com.bmc.arsys.jdbc.framework.ARJDBCQueryManager.processSelectQuery(ARJDBCQueryManager.java:34)

      at com.bmc.arsys.jdbc.core.Connection.execSelectQuery(Connection.java:67)

      at com.bmc.arsys.jdbc.core.Statement.executeQuery(Statement.java:64)

      at com.bmc.arsys.jdbc.core.PreparedStatement.executeQuery(PreparedStatement.java:290)

      at com.hof.util.DBAction.doSelect(DBAction.java:831)

      at com.hof.util.DBAction.doSelect(DBAction.java:802)

      at com.hof.mi.process.MIReportGeneratorProcess.A(MIReportGeneratorProcess.java:15183)

      at com.hof.mi.process.ReportRunner.M(ReportRunner.java:1500)

      at com.hof.mi.process.ReportRunner.D(ReportRunner.java:1018)

      at com.hof.mi.process.ReportRunner.runReport(ReportRunner.java:293)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:131)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:103)

      at com.hof.mi.web.action.ReportDataAjaxAction.A(ReportDataAjaxAction.java:1231)

      at com.hof.mi.web.action.ReportDataAjaxAction.runAction(ReportDataAjaxAction.java:123)

      at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155)

      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.ClickJackFilter.doFilter(ClickJackFilter.java:88)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.HSTSFilter.doFilter(HSTSFilter.java:47)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.CSRFFilter.doFilter(CSRFFilter.java:191)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

      at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Unknown Source)

      BMC:SR:2018-03-08 14:06:09:ERROR (ReportRunner:M) - Error retrieving results: java.lang.Exception: Exception selecting data from database

      java.lang.Exception: Exception selecting data from database

      at com.hof.util.DBAction.doSelect(DBAction.java:888)

      at com.hof.util.DBAction.doSelect(DBAction.java:802)

      at com.hof.mi.process.MIReportGeneratorProcess.A(MIReportGeneratorProcess.java:15183)

      at com.hof.mi.process.ReportRunner.M(ReportRunner.java:1500)

      at com.hof.mi.process.ReportRunner.D(ReportRunner.java:1018)

      at com.hof.mi.process.ReportRunner.runReport(ReportRunner.java:293)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:131)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:103)

      at com.hof.mi.web.action.ReportDataAjaxAction.A(ReportDataAjaxAction.java:1231)

      at com.hof.mi.web.action.ReportDataAjaxAction.runAction(ReportDataAjaxAction.java:123)

      at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155)

      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.ClickJackFilter.doFilter(ClickJackFilter.java:88)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.HSTSFilter.doFilter(HSTSFilter.java:47)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.CSRFFilter.doFilter(CSRFFilter.java:191)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

      at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Unknown Source)

      Caused by: java.sql.SQLException: FULL JOIN not supported

      at com.bmc.arsys.sql.parser.ANTLRParser.checkForInvalidConstruct(ANTLRParser.java:390)

      at com.bmc.arsys.sql.parser.ANTLRParser.preProcessQuery(ANTLRParser.java:319)

      at com.bmc.arsys.jdbc.framework.ARJDBCQueryManager.processSelectQuery(ARJDBCQueryManager.java:34)

      at com.bmc.arsys.jdbc.core.Connection.execSelectQuery(Connection.java:67)

      at com.bmc.arsys.jdbc.core.Statement.executeQuery(Statement.java:64)

      at com.bmc.arsys.jdbc.core.PreparedStatement.executeQuery(PreparedStatement.java:290)

      at com.hof.util.DBAction.doSelect(DBAction.java:831)

      ... 47 more

      BMC:SR:2018-03-08 14:10:20:ERROR (DBAction:doSelect) - Error occured selecting data: java.sql.SQLException: FULL JOIN not supported

      java.sql.SQLException: FULL JOIN not supported

      at com.bmc.arsys.sql.parser.ANTLRParser.checkForInvalidConstruct(ANTLRParser.java:390)

      at com.bmc.arsys.sql.parser.ANTLRParser.preProcessQuery(ANTLRParser.java:319)

      at com.bmc.arsys.jdbc.framework.ARJDBCQueryManager.processSelectQuery(ARJDBCQueryManager.java:34)

      at com.bmc.arsys.jdbc.core.Connection.execSelectQuery(Connection.java:67)

      at com.bmc.arsys.jdbc.core.Statement.executeQuery(Statement.java:64)

      at com.bmc.arsys.jdbc.core.PreparedStatement.executeQuery(PreparedStatement.java:290)

      at com.hof.util.DBAction.doSelect(DBAction.java:831)

      at com.hof.util.DBAction.doSelect(DBAction.java:802)

      at com.hof.mi.process.MIReportGeneratorProcess.A(MIReportGeneratorProcess.java:15183)

      at com.hof.mi.process.ReportRunner.M(ReportRunner.java:1500)

      at com.hof.mi.process.ReportRunner.D(ReportRunner.java:1018)

      at com.hof.mi.process.ReportRunner.runReport(ReportRunner.java:293)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:131)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:103)

      at com.hof.mi.web.action.ReportDataAjaxAction.A(ReportDataAjaxAction.java:1231)

      at com.hof.mi.web.action.ReportDataAjaxAction.runAction(ReportDataAjaxAction.java:123)

      at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155)

      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.ClickJackFilter.doFilter(ClickJackFilter.java:88)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.HSTSFilter.doFilter(HSTSFilter.java:47)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.CSRFFilter.doFilter(CSRFFilter.java:191)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

      at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Unknown Source)

      BMC:SR:2018-03-08 14:10:20:ERROR (ReportRunner:M) - Error retrieving results: java.lang.Exception: Exception selecting data from database

      java.lang.Exception: Exception selecting data from database

      at com.hof.util.DBAction.doSelect(DBAction.java:888)

      at com.hof.util.DBAction.doSelect(DBAction.java:802)

      at com.hof.mi.process.MIReportGeneratorProcess.A(MIReportGeneratorProcess.java:15183)

      at com.hof.mi.process.ReportRunner.M(ReportRunner.java:1500)

      at com.hof.mi.process.ReportRunner.D(ReportRunner.java:1018)

      at com.hof.mi.process.ReportRunner.runReport(ReportRunner.java:293)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:131)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:103)

      at com.hof.mi.web.action.ReportDataAjaxAction.A(ReportDataAjaxAction.java:1231)

      at com.hof.mi.web.action.ReportDataAjaxAction.runAction(ReportDataAjaxAction.java:123)

      at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155)

      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.ClickJackFilter.doFilter(ClickJackFilter.java:88)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.HSTSFilter.doFilter(HSTSFilter.java:47)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.CSRFFilter.doFilter(CSRFFilter.java:191)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

      at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Unknown Source)

      Caused by: java.sql.SQLException: FULL JOIN not supported

      at com.bmc.arsys.sql.parser.ANTLRParser.checkForInvalidConstruct(ANTLRParser.java:390)

      at com.bmc.arsys.sql.parser.ANTLRParser.preProcessQuery(ANTLRParser.java:319)

      at com.bmc.arsys.jdbc.framework.ARJDBCQueryManager.processSelectQuery(ARJDBCQueryManager.java:34)

      at com.bmc.arsys.jdbc.core.Connection.execSelectQuery(Connection.java:67)

      at com.bmc.arsys.jdbc.core.Statement.executeQuery(Statement.java:64)

      at com.bmc.arsys.jdbc.core.PreparedStatement.executeQuery(PreparedStatement.java:290)

      at com.hof.util.DBAction.doSelect(DBAction.java:831)

      ... 47 more

      BMC:SR:2018-03-08 14:10:40:ERROR (DBAction:doSelect) - Error occured selecting data: java.sql.SQLException: FULL JOIN not supported

      java.sql.SQLException: FULL JOIN not supported

      at com.bmc.arsys.sql.parser.ANTLRParser.checkForInvalidConstruct(ANTLRParser.java:390)

      at com.bmc.arsys.sql.parser.ANTLRParser.preProcessQuery(ANTLRParser.java:319)

      at com.bmc.arsys.jdbc.framework.ARJDBCQueryManager.processSelectQuery(ARJDBCQueryManager.java:34)

      at com.bmc.arsys.jdbc.core.Connection.execSelectQuery(Connection.java:67)

      at com.bmc.arsys.jdbc.core.Statement.executeQuery(Statement.java:64)

      at com.bmc.arsys.jdbc.core.PreparedStatement.executeQuery(PreparedStatement.java:290)

      at com.hof.util.DBAction.doSelect(DBAction.java:831)

      at com.hof.util.DBAction.doSelect(DBAction.java:802)

      at com.hof.mi.process.MIReportGeneratorProcess.A(MIReportGeneratorProcess.java:15183)

      at com.hof.mi.process.ReportRunner.M(ReportRunner.java:1500)

      at com.hof.mi.process.ReportRunner.D(ReportRunner.java:1018)

      at com.hof.mi.process.ReportRunner.runReport(ReportRunner.java:293)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:131)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:103)

      at com.hof.mi.web.action.ReportDataAjaxAction.A(ReportDataAjaxAction.java:1231)

      at com.hof.mi.web.action.ReportDataAjaxAction.runAction(ReportDataAjaxAction.java:123)

      at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155)

      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.ClickJackFilter.doFilter(ClickJackFilter.java:88)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.HSTSFilter.doFilter(HSTSFilter.java:47)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.CSRFFilter.doFilter(CSRFFilter.java:191)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

      at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Unknown Source)

      BMC:SR:2018-03-08 14:10:40:ERROR (ReportRunner:M) - Error retrieving results: java.lang.Exception: Exception selecting data from database

      java.lang.Exception: Exception selecting data from database

      at com.hof.util.DBAction.doSelect(DBAction.java:888)

      at com.hof.util.DBAction.doSelect(DBAction.java:802)

      at com.hof.mi.process.MIReportGeneratorProcess.A(MIReportGeneratorProcess.java:15183)

      at com.hof.mi.process.ReportRunner.M(ReportRunner.java:1500)

      at com.hof.mi.process.ReportRunner.D(ReportRunner.java:1018)

      at com.hof.mi.process.ReportRunner.runReport(ReportRunner.java:293)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:131)

      at com.hof.mi.process.MIReportGeneratorProcess.runReport(MIReportGeneratorProcess.java:103)

      at com.hof.mi.web.action.ReportDataAjaxAction.A(ReportDataAjaxAction.java:1231)

      at com.hof.mi.web.action.ReportDataAjaxAction.runAction(ReportDataAjaxAction.java:123)

      at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155)

      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.ClickJackFilter.doFilter(ClickJackFilter.java:88)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.bmc.servlet.HSTSFilter.doFilter(HSTSFilter.java:47)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.CSRFFilter.doFilter(CSRFFilter.java:191)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

      at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190)

      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Unknown Source)

      Caused by: java.sql.SQLException: FULL JOIN not supported

      at com.bmc.arsys.sql.parser.ANTLRParser.checkForInvalidConstruct(ANTLRParser.java:390)

      at com.bmc.arsys.sql.parser.ANTLRParser.preProcessQuery(ANTLRParser.java:319)

      at com.bmc.arsys.jdbc.framework.ARJDBCQueryManager.processSelectQuery(ARJDBCQueryManager.java:34)

      at com.bmc.arsys.jdbc.core.Connection.execSelectQuery(Connection.java:67)

      at com.bmc.arsys.jdbc.core.Statement.executeQuery(Statement.java:64)

      at com.bmc.arsys.jdbc.core.PreparedStatement.executeQuery(PreparedStatement.java:290)

      at com.hof.util.DBAction.doSelect(DBAction.java:831)

      ... 47 more

       

      I Attach technical info below.

       

      Operating Environment

      System Properties

      Application Version:7.1
      java.version:1.8.0_121
      os.name:Windows Server 2012 R2
      os.arch:amd64
      os.version:6.3

       

      Available Processors:4
      Memory in Use:1,0 GB
      JVM current total memory:1,8 GB
      Free memory:826,4 MB
      JVM max memory:1,8 GB
      Application Server:Apache Tomcat/7.0.59
      Servlet API Version:3.0
      JSP API Version:2.2

      Application Details

      Current Schema Version:
      Original Code Version:20161021
      Current Code Version:20161021
      Import Version:4.39
      Build Type:FULLVERSION
      Current Session Count:1
      Current Session Timeout:5400 seconds
      Application Server Boot Time:8 de marzo de 2018 13:25:50 CET
      Current Server Time:8 de marzo de 2018 14:12:25 CET (Europe/Paris +0100)
      Request Listener:Initialised
      Request Count:1
      Configuration Database:Microsoft SQL Server 11.00.6567
      Encryption Functions:Ok
      BIRT Report Engine:Not available
      Task Schedule Enabled:true
      System Task Manager Enabled:true

      Locale Information

      JVM Locale:en_US (en)
      Request Locale:es_ES (es)
      RefCode languages:ES, EN
      Browser interface language:es

      JDBC Drivers:

       

      com.bmc.arsys.jdbc.core.Driverfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/arjdbc-SNAPSHOT.jar
      com.hof.mi.database.jdbc.ColumnarDriverfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/columnar.jar
      com.hof.mi.jdbc.driver.BigQueryJDBCfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/i4-mi.jar
      com.hof.mi.jdbc.driver.Hive2JDBCfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/i4-mi.jar
      com.hof.mi.jdbc.driver.HiveJDBCfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/i4-mi.jar
      com.microsoft.sqlserver.jdbc.SQLServerDriverfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/sqljdbc4.jar
      com.pb.spectrum.sdf.driver.SDFDriverfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/sdf-jdbc.jar
      net.sourceforge.jtds.jdbc.Driverfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/jtds-1.2.8_svn.jar
      oracle.jdbc.OracleDriverfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/ojdbc5.jar
      org.postgresql.Driverfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/postgresql-9.3-1101.jdbc4.jar
      org.teiid.jdbc.TeiidDriverfile:/D:/Program%20Files/BMC%20Software/ARSystem/SmartReporting/appserver/webapps/ROOT/WEB-INF/lib/sdf-jdbc.jar

       

      I was trying to search some information about that but nothing found, some idea?.