Again, depends. I have used Antari X310s where they swore the alarm was going to go off and didn't because they are water based, and they had used dry ice or DF-50s before with problems. Theatres should never be an issue. Arenas also will never be an issue, because they are built with the intention of using them just not for sports, but for live entertainment. After that, its room to room, but your safest and best bet is water based. Also gets you out of the using fog/haze during the show clause, because it is just water. Trust me, I have had people complain about it, until you tell them it is nothing but water and the cough goes away as mysteriously as it came.
I did a show once for a church in their bingo hall. No problems until the room filled up with enough haze about a few hours in or so once the hazer started, then alarms went off. Turned them off, called fire company, etc. Turned off the X310 and they went off again, because the haze was still in the room. Then we fixed it so they wouldn't go off and no issues then for the show.