Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Updating remote database on failover member from a reporting async

Question
Dan Pahnke · Aug 12, 2020

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

#ECP #Mirroring #Caché

Source URL:https://community.intersystems.com/post/updating-remote-database-failover-member-reporting-async