Collaboration with other software
About model and data exchange with 3rd party solutions: Revit, Solibri, dRofus, Bluebeam, structural analysis solutions, and IFC, BCF and DXF/DWG-based exchange, etc.

Runaway SQL Query

Anonymous
Not applicable
I'm told there's no graceful way to kill a runaway SQL query in ArchiCAD. Does anyone know of a workaround that will kill the query without killing (or hurting) ArchiCAD too? The application becomes unresponsive, but does NOT indicate "Not Responding" as sometimes applications don't. I have let it run for up to 4 hours without it hanging. That wastes time, but not as much as trashing the database might.
1 REPLY 1
Karl Ottenstein
Moderator
Don't know of any way to kill just the query, Didrik. Since the query process is 100% read-only, no damage to the database can happen by killing the process. The only issue would be if there are unsaved changes in the project before you start the query.... they would most likely be lost unless you are prompted for an auto-recovery file when you relaunch AC. Well, there might be some temporary files left hanging about from the query somewhere, too. But, no harm to the project itself.

Cheers,
Karl
One of the forum moderators
AC 27 USA and earlier   •   macOS Ventura 13.6.6, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB