Error un web chart Orion 9.1 SP1

charly_DF

HI

I upgrade my OrionNPM 8.5.0 to 9.0 SP1. After the upgrade my users detected an issue in all the charts.

I guess the problem is a buffer overflow because the first line of the error (when I set a custom period of time) talk about a datetime value out of range

Attach an image of the issue.

---

Orion Website Error

An error has occurred with the Orion website.
Additional Information
System.Data.SqlClient.SqlException: La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
en System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
en System.Data.SqlClient.SqlDataReader.HasMoreRows()
en System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
en System.Data.SqlClient.SqlDataReader.Read()
en System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
en System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
en System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
en System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
en SolarWinds.Orion.Common.SqlHelper.ExecuteDataTable(SqlCommand command, DataTable dataTable)
en SolarWinds.Orion.Common.SqlHelper.ExecuteDataTable(SqlCommand command)
en SolarWinds.Orion.Web.Charting.NPMChartInfo.LoadData()
en SolarWinds.Orion.Web.GraphResource.CreateChart(CustomPoller poller, String rows, String title, String subTitle, String subTitle2, String chartName, String period, String sampleSize, Int32 width, Int32 height, Int32 fontSize, Control parentControl)
en NPMChart.OnLoad(EventArgs e)
en System.Web.UI.Control.LoadRecursive()
en System.Web.UI.Control.LoadRecursive()
en System.Web.UI.Control.LoadRecursive()
en System.Web.UI.Control.LoadRecursive()
en System.Web.UI.Control.LoadRecursive()
en System.Web.UI.Control.LoadRecursive()
en System.Web.UI.Control.LoadRecursive()
en System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

SolarWinds Orion Network Performance Monitor 9.0 SP1 1995-2008 All Rights Reserved

chart error.jpg

tdanner

It's not a buffer overflow in the "security problem" sense, but it does look like we are trying to query the database using a date format it isn't expecting. I'm guessing we're either sending it month/day/year when it expects day/month/year or vice versa.