Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why isn my @DbLookup background macro running properly?

April 26, 2017background macro properly running

0

Posted

Why isn my @DbLookup background macro running properly?

1 Answer

0

Posted

For any @DbLookup or @DbColumn that is run from a backgound macro, you need to put the ReplicaID of the database where the macro is being run into the ACL of the database which is being used for the source of the lookup. A background macro is executed by $Chronos which doesn’t have an ID by itself. That’s why it uses the replica ID of the database containing the macro for authentication.