[Performance CSI] [Performance CSI] Errors

[Performance CSI] [Performance CSI] Errors

  
Forge Component
(10)
Published on 2015-07-13 by Francisco Menezes
10 votes
Published on 2015-07-13 by Francisco Menezes
Just a new topic so not each error will need a new topic.

Was to curious, installed it but when going to the screen details I'm getting this error:

Error in advanced query GetPivotLogsSQL in Screen_PivotLogsCollapsed in Screen in PerformanceCSI (/*************************/  /* Get screen logs first */  /*************************/  WITH ScreenLogs AS (  SELECT os@ScreenLogTable.[Instant], os@ScreenLogTable.[Duration], os@ScreenLogTable.[Access_Mode], os@ScreenLogTable.[Session_Id]  FROM os@ScreenLogTable   WHERE os@ScreenLogTable.[Espace_Id] = @eSpaceId  AND os@ScreenLogTable.[Screen] = @Screen  AND (@SelectedDay = @NullDate OR ( os@ScreenLogTable.[Instant]>=@SelectedDay AND os@ScreenLogTable.[Instant] < @NextDay ))  AND (@Treshhold_ms=0 OR os@ScreenLogTable.[Duration]<=@Treshhold_ms)  AND (@Frontend = ' ' or os@ScreenLogTable.[Executed_By]=@Frontend )  AND os@SnapshotConditionScr @SnapshotId  ),    /*Prepare General logs */  GeneralLogs AS (  SELECT ScreenLogs.Access_Mode,  os@GeneralLogTable.[Message_Type]+'-'+os@GeneralLogTable.[Module_Name] as Type,  case when PATINDEX( '% took %' , os@GeneralLogTable.[Message])>0 then LEFT(os@GeneralLogTable.[Message],PATINDEX( '% took %' , os@GeneralLogTable.[Message])-1) else os@GeneralL ...): Invalid column name 'IS_EXPOSE'.
Invalid column name 'DURATION'.

Kind regards,
Evert
Hi. I got almost the same error:
Error in advanced query GetPivotLogsOracle in Screen_PivotLogsCollapsed in Screen in PerformanceCSI (/*************************/  /* Get screen logs first */  /*************************/  WITH ScreenLogs AS (  SELECT os@ScreenLogTable.[Instant], os@ScreenLogTable.[Duration], os@ScreenLogTable.[Access_Mode], os@ScreenLogTable.[Session_Id]  FROM os@ScreenLogTable   WHERE os@ScreenLogTable.[Espace_Id] = @eSpaceId  AND os@ScreenLogTable.[Screen] = @Screen  AND (@SelectedDay = @NullDate OR ( os@ScreenLogTable.[Instant]>=@SelectedDay AND os@ScreenLogTable.[Instant] < @NextDay ))  AND (@Treshhold_ms=0 OR os@ScreenLogTable.[Duration]<=@Treshhold_ms)  AND (@Frontend = ' ' or os@ScreenLogTable.[Executed_By]=@Frontend )  AND os@SnapshotConditionScr @SnapshotId  ),    /*Prepare General logs */  GeneralLogs AS (  SELECT ScreenLogs.Access_Mode,  concat(concat(os@GeneralLogTable.[Message_Type],'-'),os@GeneralLogTable.[Module_Name]) as Type,  case when instr(os@GeneralLogTable.[Message],' took ')>0 then substr(os@GeneralLogTable.[Message],0,instr(os@GeneralLogTable.[Message],' took ')-1) else os@Gene ...): ORA-00904: "OSLOG_EXTENSION_4"."IS_EXPOSE": invalid identifier
Hi Evert and Mario,

The last version of Performanec CSI is for OutSystems Platform 9.0.1.X and will producce that type of error if you are running OutSystems Platform 9.0.0.X

If that is the case, just download the last version for 8.X and publish it. It is compatible with 9.0.0.X and it will be automatically upgraded. 
Hello Francisco,

Thanks for that reaction, were gonne check this out.

Kind regards,
Evert