Charles Hewitt
Rank: #7351
22Views
2Comments
Error on installation
Question
Forge
Traditional Web
Application Type
Traditional Web
Platform Version
11.0.614

I am trying to run this on Oracle.

I get a SQL error when I try and load the Lifetime Feature Toggle Management view at: ssFeatureToggle_Mng.ScreenServices.FeatureToggle_Mng_MainFlow_FeatureToggleManagement_ScreenModel.FuncDataActionGetFeatureToggleListForAllEnvironments.QueryCountFeatureToggleConfigurationWithTags 

and this SQL error returns every 30 minutes in the client app:

Message:

Error executing query. Error in advanced query GetLogErrors in EV_FeatureToggle_GetErrors in FeatureToggleAPI in FeatureToggle_Lib (WITH LogAll AS (  /* Current Week */  SELECT {Log_General}.[Instant], {Log_General}.[Message]   FROM {Log_General} WITH (NOLOCK)  WHERE {Log_General}.[Module_Name] = @ModuleName      AND {Log_General}.[Instant] > @FromDateTime      AND {Log_General}.[Instant] <= @ToDateTime    UNION    /* Previous Week */  SELECT {Log_General_Previous}.[Instant], {Log_General_Previous}.[Message]   FROM {Log_General_Previous} WITH (NOLOCK)  WHERE {Log_General_Previous}.[Module_Name] = @ModuleName      AND {Log_General_Previous}.[Instant] > @FromDateTime      AND {Log_General_Previous}.[Instant] <= @ToDateTime  )    SELECT TOP (@MaxRecords) LogAll.[Instant], LogAll.[Message]   FROM LogAll  ORDER BY LogAll.[Instant]  ): ORA-00905: missing keyword

Environment InformationeSpaceVer: Id=3809, PubId=0, CompiledWith=11.0.614.0
RequestUrl: https://e3qww-dv4yls.outsystemsenterprise.com/FeatureToggle_Lib/rest/FeatureToggleAPI/EV_FeatureToggle_GetErrors?FromDateTime=1900-01-01T00%3a00%3a00Z (Method: GET)
AppDomain: /LM/W3SVC/1/ROOT/FeatureToggle_Lib-75-132569568167029233
FilePath: D:\OutSystems\Platform Server\running\FeatureToggle_Lib.792127646\
ClientIp: 10.14.32.72
Locale: en-US
DateFormat: yyyy-MM-dd
PID: 7220 ('w3wp', Started='2/4/2021 12:55:23 PM', Priv=1115Mb, Virt=2107976Mb)
TID: 22
Thread Name:
.NET: 4.0.30319.42000

Stack:

[1] Error executing query.
at ssFeatureToggle_Lib.CsRESTExpose.CsFeatureToggleAPI.CsFeatureToggleAPIControllerFlows.FuncFlowFeatureToggleAPIActionEV_FeatureToggle_GetErrors.QueryGetLogErrors(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, DateTime qpdaFromDateTime, DateTime qpdaToDateTime, String qpstModuleName, Int32 qpinMaxRecords)
at ssFeatureToggle_Lib.CsRESTExpose.CsFeatureToggleAPI.CsFeatureToggleAPIControllerFlows.FlowFeatureToggleAPIActionEV_FeatureToggle_GetErrors(HeContext heContext, DateTime inParamFromDateTime, STFeatureToggleAPIErrorsResponseStructure& outParamFeatureToggleAPIErrorsResponse)

[2] Error in advanced query GetLogErrors in EV_FeatureToggle_GetErrors in FeatureToggleAPI in FeatureToggle_Lib (WITH LogAll AS ( /* Current Week */ SELECT {Log_General}.[Instant], {Log_General}.[Message] FROM {Log_General} WITH (NOLOCK) WHERE {Log_General}.[Module_Name] = @ModuleName AND {Log_General}.[Instant] > @FromDateTime AND {Log_General}.[Instant] <= @ToDateTime UNION /* Previous Week */ SELECT {Log_General_Previous}.[Instant], {Log_General_Previous}.[Message] FROM {Log_General_Previous} WITH (NOLOCK) WHERE {Log_General_Previous}.[Module_Name] = @ModuleName AND {Log_General_Previous}.[Instant] > @FromDateTime AND {Log_General_Previous}.[Instant] <= @ToDateTime ) SELECT TOP (@MaxRecords) LogAll.[Instant], LogAll.[Message] FROM LogAll ORDER BY LogAll.[Instant] ): ORA-00905: missing keyword

0
0
on 5th Feb
Copy link to comment
Kadu Borges
Rank: #493

Hi Charles,

One thing I can tell you about the query is that Oracle does not support TOP keyword. So "... SELECT TOP (@MaxRecords) ..." will not work. You must use ROWNUM on the WHERE clause to get the same result:

SELECT LogAll.[Instant], LogAll.[Message] FROM LogAll WHERE rownum <= (@MaxRecords) ORDER BY LogAll.[Instant]

Hope it helps

Kind regards

0
0
on 5th Feb
Copy link to comment
Hans
Rank: #360

Hi Charles, 

Those queries are indeed not compatible with Oracle. 

Have you installed Version 1.0.1 ? If so, I would recommend to open a discussion on https://www.outsystems.com/forge/component-discussions/9663/Feature+Toggle+Library.

Kind regards, Hans


0
0
on 5th Feb
Copy link to comment