Can async business rules trigger business rules on Target Table?

[tahnalos]

We are currently using an async business rule on insert of a staging table due to circumstances of a database update from an integration.

The Staging table pushes the information obtained from the integration into our target table.  We have several other tables that are supposed to receive information from our target table and are triggered by After Business rules.  We just found out that those business rules are not triggering when the Async business rule is run.  Changing these business rules to Async business rules also does not solve this problem.

So the question is, how can we trigger a business rule to run in this scenario?

[tahnalos]

I should clarify.  There is already an import table that is processed by a transform map.  That transform map sends data to my staging table to be processed into my target table.

Before you say that there should not be a staging table and that everything should be handled by a single transform map in the import table, that import table and transform map is not controlled by my group, and was created, sold, and maintained by a ServiceNow partner.  We are not allowed to change it so upon discussion with ServiceNow support, this was the approach that was taken.

[Ankur Bawiskar]

@tahnalos 

then I believe only way is to use After BR instead of Async

[tahnalos]

Upon further discussion with the developers responsible for the import table, the reason why the async business rule was done was because certain fields on the transform map between the import table and staging table was not properly transferring when this BR was set to After Mode, according to them, the BR was executing too early before the staging table could be properly populated.  Which is why the BR was set to Async, so that the staging table could capture all info and transfer to the target table.

We could set to after, but this exposes us to that problem where certain data won't be in the Staging table when the After BR is run.  A delay line doesn't appear to work, the developers have determined that the staging table record is being blocked by the business rule preventing full update from the transform map.

Ideas to address this conundrum would be appreciated.

[Bert_c1]

Is there a '.setWorkflow(false)' in your BR script? that prevents other BRs from running.

[tahnalos]

Not that I can see.