Hi Experts,
After upgradation from sap b1 pl 8.8 to 9.0 pl 08, i am getting attached error " Connection is busy with results for another command 'Production Order(OWOR'". And it is stopping user to post the Production Order, GRPO, A/R Invoice.
As per the sap note(1320969) i am running below query, finding triggers and deleting triggers.
SELECT T0.name 'trigger',
(select name from sysobjects T1 where T1.Id = T0.Parent_obj) 'table'
FROM sysobjects T0
WHERE type = 'TR'
But the issue is this triggers are automatically being creating in the database.
How to resolve this problem that triggers should be deleted permanently.
Note: Please find an attachment for error message.
If anybody faced this kind of situation, please suggest me to achieve the solution.
With Regards