Honeybee: Read Energy Result (sql file doesnt work)

grasshopper honeybee
, , ,
1

Hello,
I am simulating a building energy model, especially for thermal comfort and I am having these errors although the sql link works for EUI:

HB Read Room Comfort Result component:
1. Solution exception:Extra data: line 1 column 20499793 - line 4 column 1 (char 20499792 - 20499977)

HB Read Face Result component:
1. Solution exception:Extra data: line 1 column 79913049 - line 4 column 1 (char 79913048 - 79913233)

HB Read Room Energy Result component:
1. Solution exception:Extra data: line 1 column 33581282 - line 4 column 1 (char 33581281 - 33581466)

I would appreciate the help, thanks a lot!
Best,

image
image757×704 69.5 KB

2

I solved it, just keeping the post in case someone has the same issue. Idk why but when I disconnect the simulation parameter on the left, the red components started to work!!

3

Hi @asezel ,

This is probably a bug. If you are able to send a screenshot of what Simulation Parameters you are using, I’ll hopefully be able to recreate it and fix it.

4

Hello @chris,

Thank you so much, here are the parameters:

image
image1748×697 100 KB

It was super strange to solve the problem when simply not connecting this…

5

Just a note to add, the default north vector is Y, there is no need to add that in.
Or you can, both work!
Best
-trevor

6

Hi @asezel ,

I can’t find anything particularly wrong about those simulation parameters that would cause the error except that maybe the fact that you are requesting almost all of the outputs on an hourly basis is causing the SQL file to be really large. If you had several hundred rooms in the model, for example, this could trigger some errors related to memory usage when loading data from the SQL. Can I ask how many rooms you have in this model that you are simulating? If it is a large number, can you try requesting these outputs on a Monthly basis rather than the default Hourly?

The other thing that I notice is that your component versions are a little old and I imagine that this also means you’re using an older version of EnergyPlus. I recommend upgrading to the latest version of Ladybug Tools with EnergyPlus 25.1 and seeing if you ca recreate the error.