建立用來追蹤 EDI-AS2 訊息的 BAM 活動

發行項
07/21/2023

BizTalk Server包含已針對 EDI 和 AS2 狀態報表建立的 BAM 活動。這些活動會決定狀態報告中顯示的資料。本主題會描述 BAM 活動及其中所定義的欄位，並描述針對 BAM 活動內之特定欄位所定義的列舉值。

建立自訂 BAM 活動即可建立自訂狀態報告。自訂活動可根據其中一個標準活動。也可以藉由查詢 BizTalkDTADb 資料庫中的 EdiMessageContent 資料表，從自訂狀態報告顯示訊息的內容。如需詳細資訊，請參閱以下的「查詢 EdiMessageContent 資料表」一節。

警告

修改 BAM 活動可能會影響 BizTalk EDI 和 AS2 執行階段的處理 (視活動而定)。

用於狀態報告中的 BAM 活動

為了追蹤 EDI/AS2 訊息而建立的 BAM 活動，會包含於 BAMPrimaryImport 資料庫內做為檢視。下列資料表列出 BAM 活動及其中的資料行：

BAM 活動	欄位
AS2InterchangeActivity	RecordID ActivityID InterchangeControlNo ReceiverID SenderID ReceiverQ SenderQ InterchangeDateTime 方向 MessageID AS2From AS2To TimeCreated RowFlags LastModified
AS2MdnActivity	RecordID ActivityID AS2PartyRole AS2From AS2To MessageID MdnDateTime MdnDispositionType DispositionModifierExtType DispositionModifierExtDescription MdnEncryptionType MdnSignatureType MdnPayloadContentKey MdnWireContentKey MdnMicValue TimeCreated RowFlags LastModified
AS2MessageActivity	RecordID ActivityID ReceiverPartyName SenderPartyName AS2PartyRole AS2From AS2To MessageID MessageDateTime BTSInterchangeID BTSMessageID MdnProcessingStatus MessageEncryptionType IsMdnExpected MicAlgorithmType MessageSignatureType MessagePayloadContentKey MessageWireContentKey MessageMicValue TimeCreated RowFlags IsAS2MessageDuplicate DaysToCheckDuplicate FileName TrackingActivityID LastModified
BatchingActivity	RecordID ActivityID BatchStatus DestinationPartyID DestinationPartyName ActivationTime BatchOccurrenceCount EdiEncodingType BatchType TargetedBatchCount ScheduledReleaseTime BatchElementCount RejectedBatchElementCount BatchSize LastBatchAction CreationTime ReleaseTime BatchReleaseType BatchServiceID ActivationMessageID ReleaseMessageID TimeCreated RowFlags BatchCorrelationID BatchName BatchID LastModified
BatchInterchangeActivity	RecordID ActivityID InterchangeControlNo ReceiverPartyName SenderPartyName ReceiverID SenderID ReceiverQ SenderQ InterchangeDateTime 方向 TimeCreated RowFlags BatchCorrelationID LastModified
BusinessMessageJournal	RecordID ActivityID MessageTrackingID ActionType ContainerActivityID ContainerType BTSInterchangeID BTSMessageId BTSServiceInstanceId BTSHostName RoutedToPartyName LinkedMessageTrackingID TimeCreated LastModified
FunctionalAckActivity	RecordID ActivityID InterchangeActivityID GroupControlNo InterchangeControlNo ReceiverID SenderID ReceiverQ SenderQ InterchangeDateTime 方向 AckProcessingStatus AckStatusCode DeliveredTSCount AcceptedTSCount AckIcn AckIcnDate AckIcnTime ErrorCode1 ErrorCode2 ErrorCode3 ErrorCode4 ErrorCode5 TimeCreated RowFlags LastModified
FunctionalGroupInfo	RecordID ActivityID InterchangeActivityID GroupControlNo FunctionalIDCode TSCount LastModified
InterchangeAckActivity	RecordID ActivityID InterchangeControlNo ReceiverID SenderID ReceiverQ SenderQ InterchangeDateTime 方向 AckProcessingStatus AckStatusCode AckIcn AckIcnDate AckIcnTime AckNoteCode1 AckNoteCode2 TimeCreated RowFlags AckCorrelationId LastModified
InterchangeStatusActivity	RecordID ActivityID InterchangeControlNo ReceiverID SenderID ReceiverQ SenderQ ReceiverPartyName SenderPartyName InterchangeDateTime 方向 AckStatusCode GroupCount EdiMessageType PortID IsInterchangeAckExpected IsFunctionalAckExpected TimeCreated RowFlags AckCorrelationId TsCorrelationId LastModified
ResendJournalActivity	RecordID ActivityID TrackingActivityId ResendIndex ResendStatus BTSInterchangeID LastModified
ResendTrackingActivity	RecordID ActivityID CorrelationId AdapterPrefix ResendCount MaxResendCount ResendInterval MaxRetryCount RetryInterval MessageContentID ResendTimeout RetryTimeout BTSInterchangeID LastModified
TransactionSetActivity	RecordID ActivityID InterchangeControlNo ReceiverID SenderID ReceiverQ SenderQ InterchangeDateTime 方向 ReceiverPartyName SenderPartyName ApplicationSender ApplicationReceiver GroupDateTime GroupControlNo TransactionSetId DocType TransactionSetControlNo AckStatusCode BatchProcessing ProcessingDateTime GroupOrdinal TransactionSetOrdinal MessageContentKey TimeCreated RowFlags TsCorrelationId LastModified

BAMPrimaryImport 資料庫中的資料列舉

有些 EDI 和 AS2 資料會以列舉的方式儲存於 BAMPrimaryImport 資料庫的資料表內。資料會以文字的方式顯示於狀態報告。這些值如下所述：

欄位	列舉值
AckProcessingStatus	NotExpected = -1 必須是 = 0 Received = 1 Sent = 2 Generated = 3
AS2PartyRole	All = 0 Receiver = 1 Sender = 2
BatchAction	Creation = 0 Activation = 1 ElementReference = 2 Release = 3 Override = 4 Termination = 5 Sent = 6 ToBeReleased = 7
BatchStatus	全部 = -1 Defined = 0 使用中已發行已完成
BatchType	ScheduleBased = 0 MessagesCountInGroup = 1 MessagesCountIn 交換 = 2 CharacterCount = 3 ExternalTrigger = 4
方向	All = 0 Receive = 1 Send = 2
DisplayAckStatusCode	全部 = 100 Accepted = 0 PartiallyAccepted = 1 Rejected = -1 AckExpected = 500 AckNotExpected = 600
DispositionModifierExt Description	Not Valued = 1 Authentication Failed = 2 Decryption Failed = 3 訊息不足安全性 = 4 Integrity Check Failed = 5 未預期的處理錯誤 = 6
DispositionModifierExt 類型	Not Valued = 1 Error = 2 警告 = 3
EdiMessageType	X12, Edifact, Unknown
IsMdnExpected	MDN is not expected = 0 MDN is expected = 1
MdnDispositionType	Processed = 1 Failed = 2
MdnProcessingStatus	All = 0 Processed = 1 Failed = 2 Expected = 3 Not Expected = 4
MessageEncryptionType	Message is not encrypted = 0 Message is encrypted = 1
MessageSignatureType	Message is not signed = 0 Message is signed = 1
MicAlgorithmType	Unknown type = -1 SHA1 = 1 MD5 = 2

BusinessMessageJournal BAM 活動

BusinessMessageJournal BAM 活動可讓 BizTalk Server 將包含交易集的已接收 EDI 交換，與包含同一個交易集的外寄批次交換進行相互關聯。如需詳細資訊，請參閱將傳入交易集與傳出批次相互關聯。

查詢 EdiMessageContent 資料表

BizTalkDTADb 資料庫中的 EdiMessageContent 資料表，儲存了訊息內容以及訊息中繼資料。您也可以從自訂狀態報告，查詢 EdiMessageContent 資料表以顯示訊息的內容。這和產品中部分狀態報告讓您顯示訊息內容的方式類似，例如，AS2 訊息和相互關聯的 MDN 狀態報告可讓您顯示訊息電傳格式。

您使用對應至 EdiMessageContent 資料表中 ContentKey 資料行之 BAM 活動的索引鍵資料行，便可以從自訂 BAM 活動連結至 EdiMessageContent 資料表。例如，若要從 AS2MessageActivity BAM 活動連結至 EdiMessageContent 資料表，必須使用 MessagePayloadContentKey 資料行或 MessageWireContentKey 資料行連結至 ContentKey 資料行。

資料表	資料行
EdiMessageContent (在 BizTalkDTADb 資料庫中)	ContentKey MessageFormat ContentType Charset TimeCreated TimeInserted IsOrphaned ContentBinary

另請參閱

如何儲存 EDI 和 AS2 狀態報告的資料
 使內送交易集與外寄批次相互關聯

共用方式為