URBANopt runs but read energy room and end use intensity cant rad the sql file

I am currently running a sensitivity analysis on a district so I run the simulation twice with the difference being the construction material, the first simulation runs fine along with the EUI and the read energy room results however the second simulation despite having result and sql files, cant be read by the EUI


I only get 1. Solution exception:index out of range: 0
the EUI can read the sql files of the first simulation however it cant read the results for the second inspite of them being the same file and only the construction material is different

Hey @Heba1 ,

Sorry for the late reply here. It is tough to know what is going on without the full error message, which you could get by double-clicking in the center of the component and then hitting “Test”.

It seems likely that the EnergyPlus simulation might not have finished or the SQLite files are somehow corrupt. If re-running the simulation does not give you valid SQL files that work for this case, please upload one of the SQL files and I will try to recreate the issue on my end.

I am also having trouble with an URBANOpt run on a mixed use structure composition. The component test output shows:

Program Version,EnergyPlus, Version 23.1.0-87ed9199d4, YMD=2024.01.31 20:57,
   ** Warning ** Timestep: Requested number (1) is less than the suggested minimum of 4.
   **   ~~~   ** Please see entry for Timestep in Input/Output Reference for discussion of considerations.
   ************* Beginning Zone Sizing Calculations
   ** Warning ** Weather file location will be used rather than entered (IDF) Location object.
   **   ~~~   ** ..Location object=SITE 1
   **   ~~~   ** ..Weather File Location=Boulder.Muni.AP CO USA SRC-TMYx WMO#=720533
   **   ~~~   ** ..due to location differences, Latitude difference=[40.03] degrees, Longitude difference=[105.22] degrees.
   **   ~~~   ** ..Time Zone difference=[7.0] hour(s), Elevation difference=[161200.00] percent, [1612.00] meters.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_INFILTRATION SCHEDULE_HOL_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_INFILTRATION SCHEDULE_HOL_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_INFILTRATION SCHEDULE_SMRDSN_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_INFILTRATION SCHEDULE_SMRDSN_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_INFILTRATION SCHEDULE_WNTRDSN_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_INFILTRATION SCHEDULE_WNTRDSN_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_LIGHTING SCHEDULE_HOL_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_LIGHTING SCHEDULE_HOL_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_LIGHTING SCHEDULE_MONDAY_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_LIGHTING SCHEDULE_MONDAY_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_LIGHTING SCHEDULE_SMRDSN_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_LIGHTING SCHEDULE_SMRDSN_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_LIGHTING SCHEDULE_WNTRDSN_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_LIGHTING SCHEDULE_WNTRDSN_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_SERVICE HOT WATER SCHEDULE_HOL_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_SERVICE HOT WATER SCHEDULE_HOL_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_SERVICE HOT WATER SCHEDULE_SMRDSN_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_SERVICE HOT WATER SCHEDULE_SMRDSN_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_SERVICE HOT WATER SCHEDULE_WNTRDSN_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="MIDRISEAPARTMENT BUILDING_SERVICE HOT WATER SCHEDULE_WNTRDSN_SHIFT_60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_HOL", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_HOL_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_MONDAY", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_MONDAY_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_SATURDAY", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_SATURDAY_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_SMRDSN", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_SMRDSN_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_WNTRDSN", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="RETAIL BUILDING_SERVICE HOT WATER SCHEDULE_WNTRDSN_SHIFT_-60MINS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="SCHEDULE DAY 40", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Day:Interval="SCHEDULE DAY 41", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Year="0.05 HOT WATER LATENT FRACTION", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Year="0.2 HOT WATER SENSIBLE FRACTION", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Constant="ALWAYS OFF DISCRETE", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** ProcessScheduleInput: Schedule:Constant="ALWAYS ON CONTINUOUS", Blank Schedule Type Limits Name input -- will not be validated.
   ** Warning ** GetHTSurfaceData: Surfaces with interface to Ground found but no "Ground Temperatures" were input.
   **   ~~~   ** Found first in surface=RES_COM_19_FLOOR1_ROOM1..FACE0
   **   ~~~   ** Defaults, constant throughout the year of (18.0) will be used.
   ** Warning ** CheckUsedConstructions: There are 20 nominally unused constructions in input.
   **   ~~~   ** For explicit details on each unused construction, use Output:Diagnostics,DisplayExtraWarnings;
   ** Warning ** DetermineShadowingCombinations: There are 1 surfaces which are receiving surfaces and are non-convex.
   **   ~~~   ** ...Shadowing values may be inaccurate. Check .shd report file for more surface shading details
   **   ~~~   ** ...Add Output:Diagnostics,DisplayExtraWarnings; to see individual warnings for each surface.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE1 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE10 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE11 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE12 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE13 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE2 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE3 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE4 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE5 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE6 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE7 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE8 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM1..FACE9 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM2..FACE1 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM2..FACE2 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.
   ** Warning ** Calculation of reflected solar onto surface=RES_COM_19_FLOOR1_ROOM2..FACE3 may be inaccurate
   **   ~~~   ** because it has one or more vertices below ground level.

Is there a quick way to make sure all the geometries are snapped to zero on z axis?

Oddly, this sql error was a geometry problem. The building passed all checks, it ran URBANOpt, but this error popped up. It was not true that the elevation was the problem. I had to resurface some of the faces in the X and Y direction, then it ran fine.