Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question
1

The error occurs in the measure "TimeseriesObjectiveFunction"

asked 2019-06-05 05:34:26 -0600

rtsuchiya's avatar

updated 2019-06-06 21:47:24 -0600

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)
edit retag flag offensive 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 -0600 )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 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-06-18 16:20:00 -0600

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.

edit flag offensive delete link more

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 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops

Careers

Question Tools

1 follower

Stats

Asked: 2019-06-05 05:34:26 -0600

Seen: 130 times

Last updated: Jun 18 '19