Live Head Geek Video Chat: Virtualization Trends & Best Practices. Register Now >>
Search 100,860 posts and 877 resources contributed by 61,822 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,225 Views


98 Posts
Points 263
SolarWinds Certified Professional
charly_DF replied 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


661 Posts
Points 2,704
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

361 Posts
Points 1,193
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 38
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

3,415 Posts
Points 15,700
Moderator
SolarWinds Certified Professional
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
SolarWinds SCP Certified 

  • | Post Points: 5

14 Posts
Points 38
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,067 Posts
Points 18,201
Moderator
SolarWinds Certified Professional
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

  • 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