Query recipients while it is still loading?

[ogonzalesdiaz]

Hi, I want to be sure there will be no issues when other users try to query the recipients tables if it's main workflow (where it gets updated is still running).

From this link, the locking happens when other processes (workflows) try to do changes in the tables (e.g. recipients):

The example below illustrates the most common and logical form of transactional locking. In this case, we have 3 transactions that are all attempting to make changes to a single row in Table

However, in my case, the other workflows will not attemp to do any changes to recipients, only query it to use it's data to sent some deliveries. 

Could any kind of locking still happen? 

I set my recipients update workflow running over night, but it is still running the update activity, and want to make sure everything will run smoothly for the other users, when they start their labor today.

Maybe it is better to try contact adobe support to abort that update activity?

[Craig_Thonis · Accepted solution]

Hi ogonzalesdiaz.

You are correct. A select statement should not lock the table, and your other workflows and users should be able to use the system without issue, even if the main recipient table is being updated.

That said, if your update workflow is still running hours later, that could indicate a problem and long-running workflows can eat up system resources and cause performance degradation.

So it may make sense to reach out to Campaign Support regardless just to make sure.

Regards,

Craig