84
Views
2
Comments
create new reports queries performance
Platform Version
11.10.4 (Build 29616)

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] ?


2016-04-21 20-09-55
J.
 
MVP

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.


UserImage.jpg
shake mountain

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.


  

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