Concurrently running operations in Sync plugins

(0) Share

Report

Posted on by Priyesh

7,396 User Group Leader

Hi,

I had a query on the below scenario where my plugins at times fail ending up in 2-min timeouts. Here's what I'm imagining but I need a valid answer to back my claim-

1. I'm using PSA, so my synchronous plugins are doing some CRUD operations, usually this process runs for more than a minute but under 2mins in most cases.

2. At times, the same plugin is called on different records by different users. At this time, the success rate of the plugin drops significantly giving me an impressing this is happening due to internal database locks.

Anyone having any articles/theories that confirm my assumptions?

Are concurrent sync operations on same tables affecting performance of other calls? Do they wait until an operation is completed?

Please advise

I have the same question (0)

All responses (2)

Answers (0)

Denny Deng on at

Like (0)

Report

if operation on different records concurrently it shouldn't have lock issue, so I don't think the slowness is caused by the lock, but I would suggest you raise a support ticket to MS so they could help to pin point the issue

Was this reply helpful? Yes No
Priyesh 7,396 User Group Leader on at

Like (0)

Report

I think so. Could it be possible that Microsoft's background updates might be affecting this??

I think the failure rate in my case (2min timeout) has gone up sharply. I'm worried MS's Project Service Automation plugins are failing.

Was this reply helpful? Yes No