Forums (Obsolete)

Member

merete-grape - 6/19/2013 4:27:40 AM

Problem with reports

Subscribing to Visits - Daily report

Getting this in the Eventlog:

Message: [DataConnection.HandleError]: Query: SET @FromDate =dbo.Func_Analytics_DateTrim(@FromDate,'day');

SELECT [Date] AS StartTime ,T1.Hits FROM
dbo.Func_Analytics_EnsureDates (@FromDate,@ToDate,'day') AS Dates
LEFT JOIN
(SELECT HitsStartTime AS StartTime,SUM(HitsCount) AS hits
FROM Analytics_Statistics
INNER JOIN Analytics_DayHits ON Analytics_DayHits.HitsStatisticsID = Analytics_Statistics.StatisticsID
WHERE (StatisticsSiteID = @CMSContextCurrentSiteID)
AND((StatisticsCode = @FirstCategory) OR (StatisticsCode = @SecondCategory))
GROUP BY HitsStartTime) AS T1
ON T1.StartTime = [Date]: caused exception: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
Stack Trace:
at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, SqlException ex)
at CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
at CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(QueryParameters query)
at CMS.Reporting.AbstractReportControl.LoadData()
at CMSModules_Reporting_Controls_ReportGraph.GetReportGraph(ReportGraphInfo reportGraph)
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)

There is only a blank mail comming to me.

Kentico Consulting

Kentico_RichardS - 6/22/2013 12:44:41 AM

RE:Problem with reports

Hello,

Could you please check the Tools -> Reporting -> Web Analytics -> Visits -> Visits -> Daily report -> General tab and check the Layout? Can you copy and paste the layout or send us a screenshot? Have you somehow changed something in this report? Can you check Hourly report if its working correctly?

Thank you for your cooperation.

Kind regards,
Richard Sustek

Member

merete-grape - 6/24/2013 2:15:02 AM

RE:Problem with reports

%%control:ReportGraph?GraphDayVisitors%%
%%control:ReportGraph?GraphDayNewReturnVisitors%%

{$reports_general.created$} {%CMSContextCurrentTime%} {$reports_general.by$} {%CMSContextCurrentUserName%}

It all looks well on web, but the subscription mail is empty.

Have not intentionally made any changes

No problems with the hourly report :)

Thx for all help!

Kentico Consulting

Kentico_RichardS - 6/24/2013 2:43:46 AM

RE:Problem with reports

Hello,

Thank you for the information.

That seems to be ok. Its quite strange - so you are saying that Hourly reports work fine all the time, the Daily reports are displaying correctly (with correct values) on the webpage but when the system tries to send an e-mail it generates the error above and the e-mail returns blank.. Would it be possible for you to send me an e-mail to support@kentico.com with the credentials to your site so I can take a look at it and test it?

Kind regards,
Richard Sustek