Transaction Ended in Trigger - Trying to Change AS2 Agreement AS2-From ID RRS feed

  • Question

  • What is the get-around for this confusing and unhelpful error?  Other than running SQL profiler, is there anyway to actually understand what the error is complaining about? 

    I had similar problem with EDI agreements, and I ended up using T-SQL to a delete row (or two) from the BusinessIdentity table, which was a little scary. 

    When you click the down arrow to show the available items to select from, where is that being populated from?  


    Neal Walters 

    Friday, June 16, 2017 6:33 PM

All replies

  • Hi Neal

    It should be in the [BizTalkMgmtDb].[tpm].[Agreement] table.

    Thanks Arindam

    Saturday, June 17, 2017 2:28 AM
  • But isn't this a bug - the tool shouldn't end with trigger errors. 

    Is it safe to delete rows from these tables? 


    Monday, June 19, 2017 2:01 PM
  • Hi Neal

    Probably in a dev environment - but can't be sure.

    Did you get a chance to run SQL Profiler to see what is actually happening?

    Thanks Arindam

    Tuesday, June 20, 2017 1:12 PM