Rouan Serik

I have a serious problem with TDDS under BizTalk Server 2006:

Context: We are tracking message other than Msg Bodies.

The tracking runs between the orchestration and the MsgBox so the tracking table:

TrackingData_1_0

TrackingData_1_1

TrackingData_1_2

TrackingData_1_3

Contain Data.

Logically, TDDS service must:

Move data from tracking tables of the MsgBox to those of the DTA

This latest task is not executed. Consequently the TrackingData tables growth enormously in the MsgBox and affects BizTalk Performance!

What happen for TDDS

Thanks in advance !



Re: BizTalk R2 General TDDS problem in BizTalk Server 2006

Richard Hallgren

Hi,

Is your SQL Server Agent runnig in SQL Server What's your history on the TrackedMessage_Copy_BizTalkMsgBoxDb job Do see any errors on this job when viewing it's history

Richard Hallgren

http://www.richardhalggren.com






Re: BizTalk R2 General TDDS problem in BizTalk Server 2006

Rouan Serik

Hi

SQL Server Agent is running

TrackedMessage_Copy_BizTalkMsgBoxDb job is running correctly

I understand that this Job is responsible to copy data (just Msg Bodies) from spool table of the message box to the DTA.

Other messages are moved with TDDS infrastructure.

http://msdn2.microsoft.com/en-us/library/aa559554.aspx





Re: BizTalk R2 General TDDS problem in BizTalk Server 2006

Richard Hallgren

Yes, that's correct. Do you see anything in the application log Checked this

Richard Hallgren

http://www.richardhallgren.com






Re: BizTalk R2 General TDDS problem in BizTalk Server 2006

Rouan Serik

Hi,

Anything in the Event Log





Re: BizTalk R2 General TDDS problem in BizTalk Server 2006

Leonid Ganeline

Did you check all tasks from the "Archiving and Purging the BizTalk Tracking Database" article/subarticles in the Help





Re: BizTalk R2 General TDDS problem in BizTalk Server 2006

Rouan Serik

HI,

Now, the tracking cycle runs correctly (TDDS moves the DATA between the MsgBox and the DTA).

We have not determined what stop dramatically TDDS.

Our actions were:

Purge manually the tracking Table (

TrackingData_1_0, TrackingData_1_1, TrackingData_1_2, TrackingData_1_3) in the MsgBox.

ReCreate the SQL schema [Domain \Biztalk Host Users Group] with AUTHORIZATION [Domain\Biztalk Host Users Group]

This schema is created at BizTalk Configuration Step !!

Thanks for your Helps