I have the same problem can u tell me the solution
The following stored procedure call failed: ” { call adm_SendPort_get_subscription_details( ?)}”. SQL Server returned error string: “Transaction (Process ID 144) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.”.
Its very urgent , actually what i m doing i have a method to create send port and i call this method in an orchestration but when i put 4 or more than 4 input 4 instances are generated and they all try to create send port and dead lock occur.
please help me to solve this problem