1

The error occurs in the measure "TimeseriesObjectiveFunction"

Hello.

I am using the measure TimeSeriesObjectiveFunction in OpenStudio.

But, after updating OS to the newest, it seems to have errors when using this measure.

Error comments are like:

Warn: CSV DateTime 2009-Feb-07 01:00:00 is not in SQL Timeseries Dates

However, in my csv, dates are written like "02/07/19 01:00" as recommended.

(And actually OS shows the message below after the comment above

Info: CSV Time format is correct: 02/07/19 01:00 mm:dd:yy hh:mm

)

Here, I don't know why it can't run though it ran in the last winter.

Can anyone point something wrong with the error?

The whole error message is added:

Applying TimeseriesObjectiveFunction

Result: Fail

Error: comparison of Float with NaN failed

C:/Users/Ryota Tsuchiya/AppData/Local/Temp/OpenStudioApp.UU2728/resources/measures/TimeseriesObjectiveFunction 1 1/measure.rb:635:in `each'

C:/Users/Ryota Tsuchiya/AppData/Local/Temp/OpenStudioApp.UU2728/resources/measures/TimeseriesObjectiveFunction 1 1/measure.rb:635:in `max'

C:/Users/Ryota Tsuchiya/AppData/Local/Temp/OpenStudioApp.UU2728/resources/measures/TimeseriesObjectiveFunction 1 1/measure.rb:635:in `block in run'

C:/Users/Ryota Tsuchiya/AppData/Local/Temp/OpenStudioApp.UU2728/resources/measures/TimeseriesObjectiveFunction 1 1/measure.rb:438:in `each'

C:/Users/Ryota Tsuchiya/AppData/Local/Temp/OpenStudioApp.UU2728/resources/measures/TimeseriesObjectiveFunction 1 1/measure.rb:438:in `run'

  :/ruby/2.2.0/gems/openstudio-workflow-1.3.3/lib/openstudio/workflow/util/measure.rb:471:in `apply_measure'

:/ruby/2.2.0/gems/openstudio-workflow-1.3.3/lib/openstudio/workflow/util/measure.rb:74:in `block in apply_measures'

:/ruby/2.2.0/gems/openstudio-workflow-1.3.3/lib/openstudio/workflow/util/measure.rb:32:in `each_index'

:/ruby/2.2.0/gems/openstudio-workflow-1.3.3/lib/openstudio/workflow/util/measure.rb:32:in `apply_measures'

:/ruby/2.2.0/gems/openstudio-workflow-1.3.3/lib/openstudio/workflow/jobs/run_reporting_measures.rb:85:in `perform'

:/ruby/2.2.0/gems/openstudio-workflow-1.3.3/lib/openstudio/workflow/run.rb:269:in `step'

:/ruby/2.2.0/gems/openstudio-workflow-1.3.3/lib/openstudio/workflow/run.rb:216:in `run'

:/openstudio_cli.rb:937:in `execute'

:/openstudio_cli.rb:726:in `execute'

:/openstudio_cli.rb:1703:in `<main>'

eval:110:in `eval'

eval:110:in `require_embedded_absolute'

eval:95:in `block in require'

eval:89:in `each'

eval:89:in `require'

eval:2:in `<main>'

Warn: CSV DateTime 2009-Feb-07 01:00:00 is not in SQL Timeseries Dates

Warn: CSV DateTime 2009-Feb-07 02:00:00 is not in SQL Timeseries Dates

Warn: CSV DateTime 2009-Feb-07 03:00:00 is not in SQL Timeseries Dates

====OMITTED====

Warn: CSV DateTime 2009-Feb-13 22:00:00 is not in SQL Timeseries Dates

Warn: CSV DateTime 2009-Feb-13 23:00:00 is not in SQL Timeseries Dates

Warn: CSV DateTime 2009-Feb-14 00:00:00 is not in SQL Timeseries Dates

Info: csv_name: C:/OSPAT/ForPAT/hr.csv

Info: environment_period: RUN PERIOD 1

Info: environment_periods: ["RUN PERIOD 1"]

Info: map: {"InsideGH HRatio"=>{:key=>"THERMAL ZONE 1", :var=>"Zone Air Humidity Ratio", :index=>0}}

Info:

Info: available timeseries: ["Site Outdoor ...

(more)
rtsuchiya's avatar
335
rtsuchiya
asked 2019-06-05 05:34:26 -0500, updated 2019-06-06 21:47:24 -0500
edit flag offensive 0 remove flag close merge delete

Comments

Can you post the complete error log? Are you running a full-year simulation?

Luis Lara's avatar Luis Lara (2019-06-05 14:24:10 -0500) edit

Thank you for your reply.

At first, my simulation is between Feb. 7 to Feb.13 in 2019. Error comment is added to the main text.

rtsuchiya's avatar rtsuchiya (2019-06-06 21:39:41 -0500) edit
add a comment see more comments

1 Answer

0

Yes, this measure broke with the upgrade to OS 2.8 and E+ 9.1. This has to do with the addition of 'year' into the sql file.

I've updated the measure here to reflect those changes. Let me know if this fixes your issue.

BrianLBall's avatar
2k
BrianLBall
answered 2019-06-18 16:20:00 -0500
edit flag offensive 0 remove flag delete link

Comments

Thank you for your information!

I copied and pasted your code, and it seems that it works now!

rtsuchiya's avatar rtsuchiya (2019-06-19 20:11:03 -0500) edit
add a comment see more comments