[Logs Management] SQL error on fresh install for Java+Oracle stack 9.1.401

Steve Bramley

Question

Hi Carlos,
Great looking app. I'm excited to see what it can do, but I have an error happening from a clean install. Occurs in the SQL queries in GetLogTableTypes_Dates:
?(apologies for not posting the whole thing. this rich text editor doesn't work very well)
?
"ORA-00923: FROM keyword not found where expected"

29 Jun 2016

Steve Bramley

Just to update (I wasn't able to past the whole error previiously)
This is ocurring in JBoss Wildfly with Oracle
:
Error in advanced query GetLogTableTypeRecordCount in GetLogTableTypes_Dates in LogsManagement (WITH ranges ([range], fromDate, toDate) AS (      SELECT 1 AS [range], @MinDate AS fromDate, dateadd(@DatePart, @DateStep, @MinDate) AS toDate      UNION ALL      SELECT [range]+1, toDate, CASE WHEN dateadd(@DatePart, @DateStep, toDate) < dateadd(d, 1, @MaxDate) THEN dateadd(@DatePart, @DateStep, toDate) ELSE dateadd(d, 1, @MaxDate) END      FROM ranges      WHERE toDate < dateadd(d, 1, @MaxDate)      ), Log_All as ( SELECT * FROM dbo.oslog@LogTableCycle0      UNION      SELECT * FROM dbo.oslog@LogTableCycle1       UNION      SELECT * FROM dbo.oslog@LogTableCycle2       UNION      SELECT * FROM dbo.oslog@LogTableCycle3       UNION      SELECT * FROM dbo.oslog@LogTableCycle4       UNION      SELECT * FROM dbo.oslog@LogTableCycle5       UNION      SELECT * FROM dbo.oslog@LogTableCycle6       UNION      SELECT * FROM dbo.oslog@LogTableCycle7       UNION      SELECT * FROM dbo.oslog@LogTableCycle8       UNION      SELECT * FROM dbo.oslog@LogTableCycle9 ) SELECT r.fromDate,      w.[count] ...): ORA-00923: FROM keyword not found where expected

outsystems.hubedition.runtimeplatform.DataBaseException: Error in advanced query GetLogTableTypeRecordCount in GetLogTableTypes_Dates in LogsManagement (WITH ranges ([range], fromDate, toDate) AS (      SELECT 1 AS [range], @MinDate AS fromDate, dateadd(@DatePart, @DateStep, @MinDate) AS toDate      UNION ALL      SELECT [range]+1, toDate, CASE WHEN dateadd(@DatePart, @DateStep, toDate) < dateadd(d, 1, @MaxDate) THEN dateadd(@DatePart, @DateStep, toDate) ELSE dateadd(d, 1, @MaxDate) END      FROM ranges      WHERE toDate < dateadd(d, 1, @MaxDate)      ), Log_All as ( SELECT * FROM dbo.oslog@LogTableCycle0      UNION      SELECT * FROM dbo.oslog@LogTableCycle1       UNION      SELECT * FROM dbo.oslog@LogTableCycle2       UNION      SELECT * FROM dbo.oslog@LogTableCycle3       UNION      SELECT * FROM dbo.oslog@LogTableCycle4       UNION      SELECT * FROM dbo.oslog@LogTableCycle5       UNION      SELECT * FROM dbo.oslog@LogTableCycle6       UNION      SELECT * FROM dbo.oslog@LogTableCycle7       UNION      SELECT * FROM dbo.oslog@LogTableCycle8       UNION      SELECT * FROM dbo.oslog@LogTableCycle9 ) SELECT r.fromDate,      w.[count] ...): ORA-00923: FROM keyword not found where expected

   at oslogsmanagement.actions.ActGetLogTableTypes_Dates$FuncActGetLogTableTypes_Dates.queryGetLogTableTypeRecordCount(Unknown Source)
   at oslogsmanagement.actions.ActGetLogTableTypes_Dates.executeGetLogTableTypes_Dates(Unknown Source)
   at oslogsmanagement.managedbean.flowmainflow.ScrnDashboard.preparation(Unknown Source)
   at oslogsmanagement.managedbean.flowmainflow.ScrnDashboard.pageLoad(Unknown Source)
   at outsystems.hubedition.webwidgets.uicomponent.utils.ComponentUtils.invokeBeanPageLoad(Unknown Source)
   at outsystems.hubedition.webwidgets.uicomponent.os_controls.PageComponent.encodeBegin(Unknown Source)
   at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1854)
   at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1859)
   at com.sun.faces.application.view.JspViewHandlingStrategy.doRenderView(JspViewHandlingStrategy.java:431)
   at com.sun.faces.application.view.JspViewHandlingStrategy.renderView(JspViewHandlingStrategy.java:232)
   at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:133)
   at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
   at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:120)
   at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
   at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:219)
   at javax.faces.webapp.FacesServlet.service(FacesServlet.java:647)
   at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
   at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
   at outsystems.hubedition.webwidgets.BaseRequestStartupFilter.doFilter(Unknown Source)
   at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
   at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
   at outsystems.hubedition.webwidgets.filters.HttpContextFilter.doFilter(Unknown Source)
   at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
   at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
   at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
   at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)
   at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
   at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
   at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
   at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
   at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)
   at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
   at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
   at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63)
   at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
   at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
   at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
   at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
   at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
   at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
   at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
   at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)
   at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247)
   at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76)
   at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166)
   at io.undertow.server.Connectors.executeRootHandler(Connectors.java:197)
   at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   at java.lang.Thread.run(Thread.java:745)

29 Jun 2016

Alfaro

MVP

Hello Steve,

After a thorough check on all queries, and a few tests, I verified that many do not indeed work in an Oracle database. I was unable to test in a Java environment as I don't have access to one.

I changed the indication of support to only SQL Server and .NET.

I apologize for this, I will try to correct the queries and make sure it works in all platforms.

Thank you.

29 Jun 2016

1 reply

29 Jun 2016

Show thread

Hide thread

Steve Bramley

Carlos Alfaro wrote:

...I will try to correct the queries and make sure it works in all platforms.

Thanks Carlos. would you have any thoughts on when you might have an oracle compatible solution?

29 Jun 2016

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines