Error using Radiance with Openstudio [closed]

asked 2020-02-16 07:14:25 -0600

m.habib gravatar image

updated 2020-02-17 13:58:46 -0600

I'm relatively new to using OpenStudio and this is my first time using Radiance. I followed the steps given in the nrel website to setup the radiance model however I still seem to be getting errors. My model is complicated with almost 14 thermal zones however I only setup 1 zone for daylight analysis. I added the illuminance map, daylighting control and shading control and assigned all these aspects to their corresponding locations.

This is the error I'm currently getting:

Error: Error executing SQL statement: insert into reportdatadictionary (ReportDataDictionaryIndex, IsMeter, Type, IndexGroup, TimestepType, KeyValue, Name, ReportingFrequency, ScheduleName, Units) values (1, '0','Average', 'Zone', 'Zone', 'zahran's_office', 'Direct Normal Illuminance', 'Hourly', null, 'lux'); near "s_office": syntax error C:/Users/User/AppData/Local/Temp/OpenStudioApp.A24376/resources/measures/RadianceMeasure/measure.rb:1428:in insertTimeSeriesData' C:/Users/User/AppData/Local/Temp/OpenStudioApp.A24376/resources/measures/RadianceMeasure/measure.rb:1428:inwriteTimeSeriesToSql' C:/Users/User/AppData/Local/Temp/OpenStudioApp.A24376/resources/measures/RadianceMeasure/measure.rb:1603:in block (2 levels) in annualSimulation' C:/Users/User/AppData/Local/Temp/OpenStudioApp.A24376/resources/measures/RadianceMeasure/measure.rb:1466:ineach' C:/Users/User/AppData/Local/Temp/OpenStudioApp.A24376/resources/measures/RadianceMeasure/measure.rb:1466:in block in annualSimulation' C:/Users/User/AppData/Local/Temp/OpenStudioApp.A24376/resources/measures/RadianceMeasure/measure.rb:1444:ineach' C:/Users/User/AppData/Local/Temp/OpenStudioApp.A24376/resources/measures/RadianceMeasure/measure.rb:1444:in annualSimulation' C:/Users/User/AppData/Local/Temp/OpenStudioApp.A24376/resources/measures/RadianceMeasure/measure.rb:2476:inrun' :/ruby/2.2.0/gems/openstudio-workflow-1.3.4/lib/openstudio/workflow/util/measure.rb:502:in apply_measure' :/ruby/2.2.0/gems/openstudio-workflow-1.3.4/lib/openstudio/workflow/util/measure.rb:109:inblock in apply_measures' :/ruby/2.2.0/gems/openstudio-workflow-1.3.4/lib/openstudio/workflow/util/measure.rb:67:in each_index' :/ruby/2.2.0/gems/openstudio-workflow-1.3.4/lib/openstudio/workflow/util/measure.rb:67:inapply_measures' :/ruby/2.2.0/gems/openstudio-workflow-1.3.4/lib/openstudio/workflow/jobs/run_os_measures.rb:68:in perform' :/ruby/2.2.0/gems/openstudio-workflow-1.3.4/lib/openstudio/workflow/run.rb:285:instep' :/ruby/2.2.0/gems/openstudio-workflow-1.3.4/lib/openstudio/workflow/run.rb:232:in run' :/openstudio_cli.rb:975:inexecute' :/openstudio_cli.rb:763:in execute' :/openstudio_cli.rb:1746:in<main>' eval:116:in eval' eval:116:inrequire_embedded_absolute' eval:101:in block in require' eval:95:ineach' eval:95:in require' eval:3:in<main>'

Any ideas on how i could fix this?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by m.habib
close date 2020-05-10 04:46:10.793113

Comments

2

Try removing special characters from zone names. Zone 'zahran's office' contains the ' character, which is a restricted character for SQL statements. Use only numbers, lowercase, and uppercase letters a-z in zone names.

mdahlhausen gravatar image mdahlhausen  ( 2020-02-17 16:19:34 -0600 )edit

Thank you that made it run!

m.habib gravatar image m.habib  ( 2020-02-20 06:12:07 -0600 )edit