Question-and-Answer Resource for the Building Energy Modeling Community
Get s tarted with the Help page
Ask Your Question

OpenStudio simulation error showing "cannot find last sql file"

asked 2021-10-26 13:50:37 -0600

Lin C gravatar image

updated 2021-10-27 07:40:16 -0600

Hi, I am running a model in OpenStudio which gave me the message "Error: cannot find last sql file." on the simulation tab. In the .err file, there are no severe errors besides several warning about unused schedules and unused construction materials. What can I do to tackle this issue? Any information is appreciated.

edit retag flag offensive close merge delete



OpenStudio Results measure requests the SQL file, which is usually found unless the simulation failed. Was the eplousout.html file found and do you see a SQL file next to that?

David Goldwasser gravatar image David Goldwasser  ( 2021-10-26 15:21:28 -0600 )edit

I saw the eplousout.html file in the "run" folder but I cannot find a SQL file.

Lin C gravatar image Lin C  ( 2021-10-26 16:04:02 -0600 )edit

I have the same problem. I'm running one of the ORNL AutoBEM models. It says the model successfully ran, but then won't generate the SQL file. I can view the html output in the reports tab. This is what I see at the end of the run: .... Continuing Simulation at 12/27/2006 for RUN PERIOD 1 Writing tabular output file results using HTML format. Computing Life Cycle Costs and Reporting EnergyPlus Run Time=00hr 00min 3.40sec EnergyPlus Completed Successfully. Processing Reporting Measures. Applying CalibrationReports Result: Fail Error: Cannot find last sql file. Gathering Reports. Failed.

dprahl gravatar image dprahl  ( 2021-11-02 16:45:26 -0600 )edit

For reach of you what happens if you remove all reporting measures from the workflow and run again. OpenStudio Results and other reporting measures may be adding out output requests. like hourly zone temperature. I want to see if the sql file is generated without any additional output requests. If it does, I wonder if there are special characters that might cause an issue, although generally that is less of an issue than it has been in th past. If you can share the OSM or IDF I can try and replicate it.

David Goldwasser gravatar image David Goldwasser  ( 2021-11-03 01:34:03 -0600 )edit

I've removed all measures (OS, E+ and Reporting) and it runs fine, but no sql file in the reports folder. I can't upload a file here, can I email it to

dprahl gravatar image dprahl  ( 2021-11-03 08:45:46 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2021-11-17 22:47:36 -0600

The problem seems to be with the OS:OutputControl:Files object in the OSM. This is not in the model when a new model is generated, so I'd be interested in the history of the file. It is a valid OpenStudio object, I'm just not used to seeing it. It isn't exposed in the OpenStudio Application but could be added via a measure.

You can either delete the entire object below or leave it in and change the value for Output SQLite to yes. Both were successful for me.

{f0a01e99-67a4-4cf9-baed-9fc2370a2bb9}, !- Handle
Yes,                                    !- Output CSV
No,                                     !- Output MTR
No,                                     !- Output ESO
No,                                     !- Output EIO
Yes,                                    !- Output Tabular
No,                                     !- Output SQLite
No,                                     !- Output JSON
No,                                     !- Output AUDIT
No,                                     !- Output Zone Sizing
No,                                     !- Output System Sizing
No,                                     !- Output DXF
No,                                     !- Output BND
No,                                     !- Output RDD
No,                                     !- Output MDD
No,                                     !- Output MTD
No,                                     !- Output SHD
No,                                     !- Output DFS
No,                                     !- Output GLHE
No,                                     !- Output DelightIn
No,                                     !- Output DelightELdmp
No,                                     !- Output DelightDFdmp
No,                                     !- Output EDD
No,                                     !- Output DBG
No,                                     !- Output PerfLog
No,                                     !- Output SLN
No,                                     !- Output SCI
No,                                     !- Output WRL
No,                                     !- Output Screen
No,                                     !- Output ExtShd
No;                                     !- Output Tarcog
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer


Question Tools

1 follower


Asked: 2021-10-26 13:50:37 -0600

Seen: 200 times

Last updated: Nov 18