Trigger Set No Count OFF error while inserting huge data into Epicor


(mahesh deore) #1

Dear All,

I am trying to integrate date from one application to Epicor using BO Methods. It is successfully integrated if transaction lines are less. But if I am trying to add thousands of lines in GLJrnDtlMnl then System throws an error some times as below.
It is failed in between for one or some of the line randomly, but for next iteration of failed line is successfully integrated.
A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active

Can anyone please help me to resolve this issue.

Thanks in Advanceā€¦
Mahesh