hi,
I tried to create new reports of [queries performance],
>> ServiceCenter/Reports_List.aspx > Analytics > Reports > Create New Report ,
The report is created successfully, but it is empty.
Is there something I need to configure for create reports of [queries performance] ?
Hi,
Make you sure you have a large interval set, so between dates.
Furthermore, only queries that will take longer than 200ms (default) will be logged and thus reported.
Hi J.
I had select [Today, Yestoday, Current week],
they are all empty report.
I search slow sql in [Genernal Log], there are many slow sql in [Genernal Log].
I found error in Error log.
<Message>Invalid length parameter passed to the LEFT or SUBSTRING function.
<Stack>Invalid length parameter passed to the LEFT or SUBSTRING function. 場所 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 場所 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 場所 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 場所 System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) 場所 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) 場所 System.Data.SqlClient.SqlDataReader.Read() 場所 OutSystems.Internal.Db.DatabaseAccess.ExecuteWithoutRequestTimeout[T](Func`1 action) 場所 OutSystems.HubEdition.RuntimePlatform.Db.OSList`1.Advance() 場所 ssServiceCenter.Actions.ActionReport_Fill_SlowSql(HeContext heContext, Int32 inParamReportId, DateTime inParamStartDate, DateTime inParamEndDate) 場所 ssServiceCenter.Actions.ActionReport_Fill(HeContext heContext, Int32 inParamReportId, String inParamReportType, DateTime inParamStartDate, DateTime inParamEndDate, String inParamIntegrationType) 場所 ssServiceCenter.Actions.ActionTimer_ReportFill(HeContext heContext)
※We are use outsystems on premium.