Server Error when running timeseries

British Astronomical Association, Variable Star Section (BAA-VSS)
Wed, 07/05/2023 - 14:04

I am running a timeseries analysis I keep getting Server Error at the very last step, just after frames are processed:

Server Error in '/app' Application.

Unknown column 'NaN' in 'field list'

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: MySql.Data.MySqlClient.MySqlException: Unknown column 'NaN' in 'field list'

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[MySqlException (0x80004005): Unknown column 'NaN' in 'field list'] MySql.Data.MySqlClient.MySqlStream.ReadPacket() +309 MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +67 MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) +17 MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +110 MySql.Data.MySqlClient.MySqlDataReader.NextResult() +867 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1690 MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar() +112 DB.ExecuteGetID(String psSQL) +89 Restricted_TimeseriesDone.SaveTS(Single aperture, Single factor, Single useFactor) +4157 Restricted_TimeseriesDone.Page_Load(Object sender, EventArgs e) +744 System.Web.UI.Control.OnLoad(EventArgs e) +97 System.Web.UI.Control.LoadRecursive() +61 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4110.0

anything i can do to make this go away?

i am running a number of V images. i tried both fixed and automatic apertures. Also tried different search radii and different min SNRs.
Sequence was created by me but it works fine on single images.



American Association of Variable Star Observers (AAVSO)
VPhot timeseriews fault

You bumped into a bit of unguarded code that was generating a NaN (sqrt(1/0) will do that).

Problem should be fixed: try again.

And thanks for the detailed error report



British Astronomical Association, Variable Star Section (BAA-VSS)
Fixed but was there a glitch?

Thanks George!

I can confirm that i can now run timeseries!

Glad the error report helped and everyone loves divide by zeros :D 

There was a glitch for a while with single image photometry page producing zero mags for target and check stars and the limiting magnitude being reported as 0.000. This now appears to have sorted itself, which is great.

Thank you again!