Error using Radiance with Openstudio [closed]
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:in
writeTimeSeriesToSql'
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:in
each'
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:in
each'
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:in
run'
:/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:in
block 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:in
apply_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:in
step'
:/ruby/2.2.0/gems/openstudio-workflow-1.3.4/lib/openstudio/workflow/run.rb:232:in run'
:/openstudio_cli.rb:975:in
execute'
:/openstudio_cli.rb:763:in execute'
:/openstudio_cli.rb:1746:in
<main>'
eval:116:in eval'
eval:116:in
require_embedded_absolute'
eval:101:in block in require'
eval:95:in
each'
eval:95:in require'
eval:3:in
<main>'
Any ideas on how i could fix this?
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.
Thank you that made it run!