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.
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.
OS:OutputControl:Files,
{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
Asked: 2021-10-26 13:50:37 -0500
Seen: 312 times
Last updated: Nov 18 '21
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?
I saw the eplousout.html file in the "run" folder but I cannot find a SQL file.
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.
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.
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 unmethours@bigladdersoftware.com?