Revision history [back]

I an having problems with a measure that use to worki fine in openstudio app 2.9 but now sometimes is failing in 3.4.

the problem appears when I call the uFactor method of a subsurface object from a measure. For example, when i call

window.uFactor

I get the the following error:

Result: Fail
Error: Error creating prepared statement: SELECT Value from TabularDataWithStrings
WHERE ReportName = 'EnvelopeSummary'
AND ReportForString = 'Entire Facility'
AND TableName = 'Exterior Fenestration
AND ColumnName = 'Glass U-Factor'
AND Units='W/m2-K'
AND RowId = ?; with error code 1, extended code 1, errmsg: near "Glass": syntax error
C:/Users/EFINOV~1/AppData/Local/Temp/osmodel-1662883600-0/resources/measures/verificacion_ctehe1_2019/measure.rb:1370:in `uFactor'

There are a few funny things: - It never fails in a ruby script inside sketchup - In an openstudio measure fails in some cases. I guess it depends on the glass construction name or the construction set name, but after several tries with different names I couldn't reach any conclution.

Any ideas?

Thanks

I an having problems with a measure that use used to worki work fine in openstudio app 2.9 but now sometimes in some cases is failing in 3.4.

the problem appears when I call the uFactor method of a subsurface object from a measure. For example, when i call

window.uFactor

I get the the following error:

Result: Fail
Error: Error creating prepared statement: SELECT Value from TabularDataWithStrings
WHERE ReportName = 'EnvelopeSummary'
AND ReportForString = 'Entire Facility'
AND TableName = 'Exterior Fenestration
AND ColumnName = 'Glass U-Factor'
AND Units='W/m2-K'
AND RowId = ?; with error code 1, extended code 1, errmsg: near "Glass": syntax error
C:/Users/EFINOV~1/AppData/Local/Temp/osmodel-1662883600-0/resources/measures/verificacion_ctehe1_2019/measure.rb:1370:in `uFactor'

There are a few funny things: - It never fails in a ruby script inside sketchup - In an openstudio measure fails in some cases. I guess it depends on the glass construction name or the construction set name, but after several tries with different names I couldn't reach any conclution.

Any ideas?

Thanks

I an having problems with a measure that used to work fine in openstudio app 2.9 but now in some cases is failing in 3.4.

the problem appears when I call the uFactor method of a subsurface object from a measure. For example, when i call

window.uFactor

I get the the following error:

Result: Fail
Error: Error creating prepared statement: SELECT Value from TabularDataWithStrings
WHERE ReportName = 'EnvelopeSummary'
AND ReportForString = 'Entire Facility'
AND TableName = 'Exterior Fenestration
AND ColumnName = 'Glass U-Factor'
AND Units='W/m2-K'
AND RowId = ?; with error code 1, extended code 1, errmsg: near "Glass": syntax error
C:/Users/EFINOV~1/AppData/Local/Temp/osmodel-1662883600-0/resources/measures/verificacion_ctehe1_2019/measure.rb:1370:in `uFactor'

There are a few funny things: - It never fails in a ruby script inside sketchup - In an openstudio measure fails in some cases. I guess it depends on the glass construction name or the construction set name, but after several tries with different names I couldn't reach any conclution.

Any ideas?

Thanks