Question-and-Answer Resource for the Building Energy Modeling Community
 | 1 | initial version |
This is a case where it might pay to look at the source code directly. Here is the code that implements that function:
https://github.com/NREL/OpenStudio/blob/755fdc8e74974b136c915a136529924c67ce2c98/openstudiocore/src/utilities/sql/SqlFile_Impl.cpp#L850
To diagnose this, I would try to recreate the SQLite queries in a third party tool (like SQLiteMan or one of the many SQLite browser plugins). With these tools you can see the data in the database directly and figure out what is going on. My guess is that you may need to request all of the Output:Table:Monthly reports that are added by the EnergyPlusPreProcess job. You can either run this job with RunManager or duplicate its content in your own scripts:
https://github.com/NREL/OpenStudio/blob/develop/openstudiocore/src/runmanager/lib/EnergyPlusPreProcessJob.cpp#L202
HTH, Dan
