Skip to Content
0
Former Member
Apr 15, 2014 at 04:52 AM

After upgrade triggers issue

105 Views

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

Attachments

error image.png (115.2 kB)