Openstudio 1.11.0 model.sqlfile Method Returns 0

asked 2016-07-22 09:54:08 -0500

robianson
103 ●6

updated 2017-08-05 07:45:00 -0500

__AmirRoth__

4436 ●5 ●17 http://bleedinggreenna...

Let me start by saying I'm pretty new to Openstudio. I've been having an issue that keeps cropping up - when running simulations and measures, it seems that I frequently get warnings or errors whenever the script I'm running attempts to look up data that's supposed to be passed back from energyplus either from the current run or a previous run (mostly zone or other equipment sizing data). It seems that the root of the issue is that in every model I've created, the "model.sqlfile" method returns 0, and so there's no database from which to look up information. When running simulations, the software seems to recover from this by calculating whatever it's looking for on its own, but some measures (specifically the "Create Performance Rating Method Baseline Building" measure from the standards library) fail without that sql file. Any tips on what to do here? Is there some setting that I'm missing?

answered 2016-07-25 10:35:48 -0500

aparker

8107 ●4 ●18 http://www.openstudio.net/

A lot of the methods in the openstudio-standards library require equipment capacities and flow rates to determine efficiencies, required control strategies, etc. If you are using the methods from this library directly in your own Measure you'll need to make sure your Measure runs a sizing run before calling them.

The "Create Performance Rating Method Baseline Building" Measure works by making a bunch of changes to your model (applying baseline HVAC systems, constructions, etc.), running a sizing run, then using the resulting capacities and flow rates to determine efficiencies. Sometimes after all these changes the sizing run fails, in which case the Measure can't proceed because it can't look up efficiencies.

This Measure is still under very active development and hasn't actually been released yet, so I'm assuming you are pulling straight from GitHub. We merged a bunch of significant changes on 7/20 and 7/21, so I'd suggest pulling that code and retrying. If you do that and run into problems that seem like issues in the code, we'd appreciate you reporting them here so we can check them out and fix them.

edit flag offensive delete link

Comments

I am having this same issue with OpenStudio telling me my "Model has no sql file containing results, cannot lookup data." I am running through a sizing run and even deleted all my systems and put in generic ones to no avail. The error log seems to indicate something about not being able to identify the VLT for my glazing, but it doesn't seem to matter what type of glass I use. I am trying to run a 2010 PRM. Any ideas?

Tim Johnson ( 2016-10-27 19:06:02 -0500 )edit

@Tim Johnson are you using 1.13.1? If so, email me your model and I'll investigate. For the 2010 PRM, I have to run a sizing run to get E+ to calculate the VLTs for the layer-by-layer fenestration before doing the daylighting area calculations, so if the sizing run fails for some reason it stops the process.