作者:手机用户2602927443 | 来源:互联网 | 2023-10-12 16:34
我们的BizTalk应用程序中有一些暂停的消息。我们需要从这些消息中获取XML进行更正,并在更正后重播。有没有一种方法可以获取这些已暂停消息的XML。
我们在BizTalkMsgBoxDB中有InstancesSuspended表。但是它不包含XML。我在这里还有其他桌子吗?
SELECT
nvcName as ApplicationName,DATEADD(hh,-6,dtSuspendTimeStamp) as DateSuspended,-- Subtract the appropriate hours for your timezone
nvcAdapter as Adapter,nvcURI as URI,nvcErrorDescription as ErrorDescription
FROM InstancesSuspended (NOLOCK)
LEFT OUTER JOIN [Services] (NOLOCK)
on InstancesSuspended.uidServiceID = [Services].uidServiceID
LEFT OUTER JOIN Modules (NOLOCK)
on Modules.nmoduleID = [Services].nmoduleID
WHERE DtCreated between DATEADD(dd,-7,GETUTCDATE()) and GETUTCDATE()
and nErrorCategory=0
ORDER BY dtCreated desc