Updating remote database on failover member from a reporting async
I have a Read-Only Reporting Async with a Remote Database defined to a non-mirrored database on the primary failover member. I would like to update the non-mirrored database on the primary from the async; so far all my attempts fail with *protect* errors.
I found this page
https://community.intersystems.com/post/execute-method-failover-member-m...
and tried the SqlProc method. The procedure executed, no errors, but the change to the global was never made (or least not retained) either directly or through a JOBbed process. I wonder if I'm missing something in my configuration. If not, then I'm torn between using REST (simple but extra overhead, moving parts, etc.) and using non-DB storage (just "ugh"). I also tried it with a Read-Write Reporting Async with the same lack of desired results.
My lab is running IRIS for Windows (x86-64) 2019.1.1 however it has to run on Cache for Windows (x86-64) 2018.1.3 also.
Can anyone offer advice?
Thanks,
Dan