Search 85,947 posts and 653 resources contributed by 43,569 members or post a topic.

Already Joined? Sign in
Error un web chart Orion 9.1 SP1

Page 1 of 1 (9 items) | RSS

rated by 0 users
Answered (Not Verified) This post has 0 verified answers | 8 Replies | 8 Followers | 2,070 Views


75 Posts
Points 208
SolarWinds Certified Professional
charly_DF posted on Mon, Aug 4 2008 5:15 PM
rated by 0 users
chart error.jpg

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


  • | Post Points: 3

All Replies


651 Posts
Points 2,557
SolarWinds Employee
tdanner replied on Mon, Aug 4 2008 9:15 PM
rated by 0 users

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.

Tim Danner
SolarWinds Development Team

  • | Post Points: 3

344 Posts
Points 1,086
SolarWinds Employee
casey.schmit replied on Tue, Aug 5 2008 2:35 AM
rated by 0 users

 Tim is correct.  We're not handling the date/time formatting properly in the string for this chart.  Please open a support ticket(if you haven't already) describing the problem and referencing this post.  That will get it into our tracking system.

 

Casey Schmit - Principal Developer

  • | Post Points: 3

14 Posts
Points 34
onEOFsix replied on Tue, Jan 27 2009 2:48 PM
rated by 0 users

Any update on this, I'm having the same issue when ever I try to click on a chart:

System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime

 

Thanks

  • | Post Points: 3

2,601 Posts
Points 11,172
Moderator
SolarWinds Employee
bshopp replied on Tue, Jan 27 2009 2:51 PM
rated by 0 users

You need to upgrade to SP3 to resolve that error

Brandon Shopp - Product Manager Orion NPM, Network Atlas and LANSurveyor

  • | Post Points: 5

14 Posts
Points 34
onEOFsix replied on Tue, Jan 27 2009 2:59 PM
rated by 0 users

Ok, thanks for the fast reply!

  • | Post Points: 1

2 Posts
Points 4
jrwoodman replied on Thu, Jan 29 2009 9:48 AM
rated by 0 users

Still getting this error after upgrading to SP3.

  • | Post Points: 3

4,028 Posts
Points 17,690
Moderator
SolarWinds Employee
Answered (Not Verified) denny.lecompte replied on Thu, Jan 29 2009 10:04 AM
rated by 0 users
Suggested by Elisabeth Zakes

Try re-running the configuration wizard.  That fixes the problem for a lot of people.

Denny LeCompte
Director of Product Management
SolarWinds
Austin, TX

follow me on Twitter

  • Post Points: 3

2 Posts
Points 4
jrwoodman replied on Thu, Jan 29 2009 11:24 AM
rated by 0 users

Fixed the problem for me as well. Thanks for the tip.

  • | Post Points: 1
Page 1 of 1 (9 items) | RSS

© 2003 - 2010 SolarWinds, Inc. All Rights Reserved.

Who is SolarWinds?

SolarWinds is rewriting the rules for how companies manage their networks. Guided by a global community of network engineers, SolarWinds develops simple and powerful network management software and network monitoring software for networks of all sizes. SolarWinds also offers a network certification program to become a SolarWinds Certified Professional (SCP).

What is thwack?

thwack, SolarWinds online community site, was designed by network engineers, for network engineers. thwack is a vibrant, growing community of more than 30,000 IT pros who share a passion for technology.

Explore Resources, Answers, Templates, and Advice

Download Free Networking Tools

Learn More About SolarWinds Products