January 22, 2009
After running Biztalk MessageBoxViewer (MBV) http://blogs.technet.com/jpierauc/default.aspx You recieve the following error Control Message Check Missing Restart Msg in Spool table (can prevent some svc instances to be resumed, terminated or suspended) Navigate to <drive>:<BizTalk 200x Folder>\Schema, Open “MsgBoxSchema.sql” Find INSERT INTO Spool (uidMessageID… copy the statment into query analyser and run. Below are the ones [...]
January 15, 2009
After applying Biztalk SP2 you may receive the following error Event Type: Error Event Source: BAM EventBus Service Event Category: None Event ID: 6 Date: 13/01/2009 Time: 17:12:55 User: N/A Computer: JDW54 Description: Execute event error. Error(s) occurred while executing events, see TDDS_FailedTrackingData table for more details. SQLServer: SQL1, Database: BizTalkDTADb You return the data [...]
January 13, 2009
If need to purge your messages in BizTalk 2004 that can’t be removed from HAT run through the following (note this will remove everything) — Stop Receive Locations — Stop BizTalk Service (all Nodes) — Make Sure HAT is cleared of all messages (apart from the stuck messages) — Drop BTS views use biztalkdtadb exec [...]
