It appears that runQuery doesn’t work in a Calculated Roster script. If I comment out the line, the script runs and I get a roster. When remove the comment and cause an alarm to occur, it looks like it fails and then the script cannot return a roster.
I guess that is the answer because it worked, but why? runQuery should use the default database when not specified. The default database is set correctly
Your intuition is correct, it should work that way. That it doesn’t seems like a bug in 8.0. They are executing in the context of the gateway ScriptManager instead of the project ScriptManager
In 7.9, though, you would have needed so specify the datasource regardless, because these would have been “global” resources, and I don’t think there was a default database for globally scoped resources.