none
Find agreement Name based on ISA06 value RRS feed

  • Question

  • Where in BizTalkMgmtDb  can I find, what particular agreement contains a specific ISA06 value?

    for example, I want to know which agreement among several agreements has ISA06 = '123456'

    Reason: I am getting an errror saying this ISA06 is already used, so want to find out where is it used.

    Thanks in advance!

    Wednesday, December 2, 2015 8:35 PM

Answers

  • How strange, I was just looking at this earlier in the week.

    You can find the Identifiers in the tpm.BusinessIdentity.

    ProfileId matches to tpm.BusinessProfile which stores the Business Profile name.

    • Marked as answer by Prabhdeep Gill Thursday, December 3, 2015 4:11 PM
    Wednesday, December 2, 2015 9:52 PM

All replies

  • How strange, I was just looking at this earlier in the week.

    You can find the Identifiers in the tpm.BusinessIdentity.

    ProfileId matches to tpm.BusinessProfile which stores the Business Profile name.

    • Marked as answer by Prabhdeep Gill Thursday, December 3, 2015 4:11 PM
    Wednesday, December 2, 2015 9:52 PM
  • More stranger! I figured same thing after doing couple joins and digging through all tables :)

    Thanks for help!

    Thursday, December 3, 2015 4:11 PM