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 ` '

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 ` '

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 Air Drybulb Temperature", "Site Outdoor Air Wetbulb Temperature", "Surface Inside Face Solar Radiation Heat Gain Rate per Area", "Zone Air Humidity Ratio", "Zone Air Relative Humidity", "Zone Air Temperature", "Zone Outdoor Air Drybulb Temperature"]

Info:

Info: available EnvPeriod: RUN PERIOD 1, available ReportingFrequencies: ["Daily", "Hourly", "Monthly", "Zone Timestep"]

Info: available variable names: ["Zone Air Relative Humidity"]

Info: variable names: Zone Air Relative Humidity

Info: available key value: ["THERMAL ZONE 1"]

Info: available variable names: ["Surface Inside Face Solar Radiation Heat Gain Rate per Area", "Zone Air Humidity Ratio", "Zone Air Relative Humidity", "Zone Air Temperature", "Zone Outdoor Air Drybulb Temperature"]

Info: variable names: Surface Inside Face Solar Radiation Heat Gain Rate per Area

Info: available key value: ["FLOOR"]

Info: variable names: Zone Air Humidity Ratio

Info: available key value: ["THERMAL ZONE 1"]

Info: variable names: Zone Air Relative Humidity

Info: available key value: ["THERMAL ZONE 1"]

Info: variable names: Zone Air Temperature

Info: available key value: ["THERMAL ZONE 1"]

Info: variable names: Zone Outdoor Air Drybulb Temperature

Info: available key value: ["THERMAL ZONE 1"]

Info: available variable names: ["Site Outdoor Air Drybulb Temperature"]

Info: variable names: Site Outdoor Air Drybulb Temperature

Info: available key value: ["Environment"]

Info: available variable names: ["Site Outdoor Air Wetbulb Temperature"]

Info: variable names: Site Outdoor Air Wetbulb Temperature

Info: available key value: ["Environment"]

Info: year: true

Info: seconds: false

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

Info: Begin timeseries parsing

Info: timezone = 9.0

Info: timezone = +09:00

Info: Found Time Header: Date/Time

Info: hdr is: InsideGH HRatio

Info: csv_var is: InsideGH HRatio

Info: var: Zone Air Humidity Ratio

Info: key: THERMAL ZONE 1

Info: sqlcall: RUN PERIOD 1,Hourly,Zone Air Humidity Ratio,THERMAL ZONE 1

Failed.