RE: Tracking database BiztalkDTADb

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: larry franks (larryfr_at_online.microsoft.com)
Date: 11/04/04 

Date: Thu, 04 Nov 2004 15:53:06 GMT

Update, can you try enabling the trackingspool_cleanup_biztalkmsgboxdb
agent job? This should purt the tracking spool database on a weekly
schedule.

Larry Franks

This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn
--------------------
| X-Tomcat-ID: 478025004
| References: <8568168D-C5B2-483E-B167-7936686397EF@microsoft.com>
<VdNolZhtEHA.768@cpmsftngxa10.phx.gbl>
<720C4AFD-06BE-4A9F-86CE-1A2E96A576F4@microsoft.com>
<MwpjwV5uEHA.1884@cpmsftngxa10.phx.gbl>
<835DCE61-76C8-4041-A5BB-70BD9C7E270E@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: larryfr@online.microsoft.com ("larry franks")
| Organization: Microsoft
| Date: Wed, 03 Nov 2004 18:22:00 GMT
| Subject: RE: Tracking database BiztalkDTADb
| X-Tomcat-NG: microsoft.public.biztalk.server
| Message-ID: <MHorFIdwEHA.768@cpmsftngxa10.phx.gbl>
| Newsgroups: microsoft.public.biztalk.server
| Lines: 159
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.server:10480
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Sorry for the late update, I've been out of the office for a few days. I
| am still researching into this, I've sent out mail for ideas on why this
| might be happening but no suggestions yet.
|
| Larry Franks
|
| This posting is provided "AS IS" with no warranties,and confers no
rights.
| Subscribe at
|
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
| &SD=msdn
| --------------------
| | Thread-Topic: Tracking database BiztalkDTADb
| | thread-index: AcS8M9HfJrcgiDWPTUuwKRevdUuaWQ==
| | X-WBNR-Posting-Host: 192.165.56.253
| | From: "=?Utf-8?B?RFc=?=" <danielwilen@online.nospam>
| | References: <8568168D-C5B2-483E-B167-7936686397EF@microsoft.com>
| <VdNolZhtEHA.768@cpmsftngxa10.phx.gbl>
| <720C4AFD-06BE-4A9F-86CE-1A2E96A576F4@microsoft.com>
| <MwpjwV5uEHA.1884@cpmsftngxa10.phx.gbl>
| | Subject: RE: Tracking database BiztalkDTADb
| | Date: Wed, 27 Oct 2004 07:47:02 -0700
| | Lines: 123
| | Message-ID: <835DCE61-76C8-4041-A5BB-70BD9C7E270E@microsoft.com>
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | Newsgroups: microsoft.public.biztalk.server
| | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| | Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.server:10454
| | X-Tomcat-NG: microsoft.public.biztalk.server
| |
| | I have used HAT and searched. I can find my messageinformation. But all
| | messages remain in the spool table in the messagebox database. I
thought
| the
| | messages would be moved to the trackingdatabase.
| | We want to write an application that seaches the trackingdatabase for
one
| or
| | more messages. Theese messages are we going to retrive from the
database
| and
| | put on an msmq or msmqt que for redelivery. We must put it on a que
| because
| | it's importent for us to keep the sequence on the messages.
| |
| | I'm searching the [dbo].[dtav_MessageFacts] view in the
trackingdatabase.
| |
| | Regards
| | DW
| |
| |
| |
| |
| | ""larry franks"" wrote:
| |
| | > Nothing in HAT either? I'll check and see if I can find anything on
| this.
| | >
| | > Larry Franks
| | >
| | > This posting is provided "AS IS" with no warranties,and confers no
| rights.
| | > Subscribe at
| | >
|
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
| | > &SD=msdn
| | > --------------------
| | > | Thread-Topic: Tracking database BiztalkDTADb
| | > | thread-index: AcS3UPVDeaWluUKsQce/gZTeUqCiOg==
| | > | X-WBNR-Posting-Host: 193.13.72.2
| | > | From: "=?Utf-8?B?RFc=?=" <danielwilen@online.nospam>
| | > | References: <8568168D-C5B2-483E-B167-7936686397EF@microsoft.com>
| | > <VdNolZhtEHA.768@cpmsftngxa10.phx.gbl>
| | > | Subject: RE: Tracking database BiztalkDTADb
| | > | Date: Thu, 21 Oct 2004 02:33:01 -0700
| | > | Lines: 63
| | > | Message-ID: <720C4AFD-06BE-4A9F-86CE-1A2E96A576F4@microsoft.com>
| | > | MIME-Version: 1.0
| | > | Content-Type: text/plain;
| | > | charset="Utf-8"
| | > | Content-Transfer-Encoding: 7bit
| | > | X-Newsreader: Microsoft CDO for Windows 2000
| | > | Content-Class: urn:content-classes:message
| | > | Importance: normal
| | > | Priority: normal
| | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | > | Newsgroups: microsoft.public.biztalk.server
| | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| | > | Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.server:10434
| | > | X-Tomcat-NG: microsoft.public.biztalk.server
| | > |
| | > | The messgaes are subscribed and not logges as suspended.
| | > |
| | > | If I run Select Count(*) from dbo.Tracking_Spool1 in the
| | > messageboxdatabase
| | > | it consists of many messages. The same query in the tracking
database
| is
| | > | empty.
| | > |
| | > | There is a job in SQLAgent with the name
| | > | TrackedMessages_Copy_BizTalkMsgBoxDb. This job runs (no errors).
| | > | If I look in the table TrackingMessageReferences its empty in my
| | > | messageboxdatabase.
| | > |
| | > | So something does not move my messages.
| | > |
| | > | Kristian
| | > |
| | > | ""larry franks"" wrote:
| | > |
| | > | > Are you seeing any errors in the application event log? If a
| message
| | > stays
| | > | > in the message box we should at least have an error that there
was
| no
| | > | > subscription for it.
| | > | >
| | > | > Larry Franks
| | > | >
| | > | > This posting is provided "AS IS" with no warranties,and confers
no
| | > rights.
| | > | > Subscribe at
| | > | >
| | >
|
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
| | > | > &SD=msdn
| | > | > --------------------
| | > | > | Thread-Topic: Tracking database BiztalkDTADb
| | > | > | thread-index: AcS1NOU7KNGgPdEuS9esoQhUqQ4QSw==
| | > | > | X-WBNR-Posting-Host: 193.13.72.2
| | > | > | From: "=?Utf-8?B?RFc=?=" <danielwilen@online.nospam>
| | > | > | Subject: Tracking database BiztalkDTADb
| | > | > | Date: Mon, 18 Oct 2004 10:07:06 -0700
| | > | > | Lines: 8
| | > | > | Message-ID: <8568168D-C5B2-483E-B167-7936686397EF@microsoft.com>
| | > | > | MIME-Version: 1.0
| | > | > | Content-Type: text/plain;
| | > | > | charset="Utf-8"
| | > | > | Content-Transfer-Encoding: 7bit
| | > | > | X-Newsreader: Microsoft CDO for Windows 2000
| | > | > | Content-Class: urn:content-classes:message
| | > | > | Importance: normal
| | > | > | Priority: normal
| | > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | > | > | Newsgroups: microsoft.public.biztalk.server
| | > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| | > | > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| | > | > | Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.server:10379
| | > | > | X-Tomcat-NG: microsoft.public.biztalk.server
| | > | > |
| | > | > | I don't get any messages i the tracking database.
| | > | > | All my job tasks i sql-agent is runnig but the messages stays
in
| the
| | > | > | MessageBox database.
| | > | > | All events are logged nice in tha database but the
Tracking_Spool
| | > tables
| | > | > are
| | > | > | empty.
| | > | > | Any ideas?
| | > | > |
| | > | > | Kristian
| | > | > |
| | > | >
| | > | >
| | > |
| | >
| | >
| |
|
|

Relevant Pages

  • Re: Apple respond to the "Why are you tracking me?" question
    ... and all of a sudden it pulled out this database," Vance said. ... the database collects location data on iOS devices by ... tracking connections to cell towers. ... Yes, they can say that between the dates of april 2010 and april 2011 I was within 20 miles of birmingham, cardiff, bristol, exeter and southampton. ...
    (uk.comp.sys.mac)
  • Re: IS size increases by 4-6GB in a day
    ... Database suddenly shoots up by 4-6GB in a single day and it reaches to its ... maximum limit. ... we have to shutdown our Exchange Server and do Offline ... The best way to troubleshoot sudden DB growth is with message tracking. ...
    (microsoft.public.exchange2000.information.store)
  • RE: BizTalk 2004, DTA-error
    ... maintenance done on the MessageBox and DTA databases. ... BizTalk 2004 Database Maintenance (BizTalkMsgBoxDB and BizTalkDTADB) ... The tracking host will ...
    (microsoft.public.biztalk.general)
  • Re: Can Access create a tracking?
    ... Is like tracking every step the user is doing in my database. ... a program that can help me keep track of who's entering the database. ... If ctl.Name Like "cmd*" Then GoTo Skip ...
    (microsoft.public.access.security)
  • Re: Tracking Users in an Access 2000 database
    ... http://www.mvps.org/access/api/api0008.htm at "The Access Web" to retrieve ... > You must implement User Level Security. ... > database before tackling your production database. ... >>tracking I not only mean when they are signed on, ...
    (microsoft.public.access.security)