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

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

  
Forge Component
(4)
Published on 11 May by Carlos Alfaro
4 votes
Published on 11 May by Carlos Alfaro
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"

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)

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.

CA


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?