Hi Stanley,
Did you ever resolve this (appreciate it was 2+ years ago....).
I'm hitting a similar issue, I have an Azure SQL database which goes to pause state after 1 hour of inactivity. I want to check it is awake with a simple aggregate. If it is;t awake, one query to it brings it back online.
My current approach (which doesn't work):
On login I have a server action with a timeout of 30 seconds & within that server action I have an aggregate with a timeout of 5 seconds. I expected the aggregate to timeout first, but I can never seem to trigger the timeout exception of the aggregate using a Communication Exception or even All Exceptions in the server action. Instead a communication exception is trigger on timeout of the server action after 30 seconds.
My intended application was that if a Communication Exception is triggered the server action should respond success=false, wait for 5 seconds, the try again. Sat in a loop for 5 attempts, after which it triggers a higher level exception.
How could I go about this?