[Performance CSI] [Performance CSI] Errors

Back to Forums

Evert van der Zalm

MVP

Question

Forge

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

17 Jul 2015

Mário Pereira

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

11 Aug 2015

Francisco Menezes

Staff

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.

11 Sep 2015

Evert van der Zalm

MVP

Hello Francisco,

Thanks for that reaction, were gonne check this out.

Kind regards,
Evert

11 Sep 2015

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

See the full guidelines