Thanks to some extra detective work from Chirayu, we have traced the source of my problems with the transformation feature. In the process, the failure detection code was improved considerably, but ultimately I had a permissions problem that was silently causing the upgrade to fail.
Thanks for your thoughts, especially Hugues for the extra insight in to multi query error reporting.