11-04-04 10:48 PM
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/defaul...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/defaul...msdn/nospam.asp
| &SD=msdn
| --------------------
| | Thread-Topic: Tracking database BiztalkDTADb
| | thread-index: AcS8M9HfJrcgiDWPTUuwKRevdUuaWQ==
| | X-WBNR-Posting-Host: 192.165.56.253
| | From: "examnotes" <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/defaul...msdn/nospam.asp
| | > &SD=msdn
| | > --------------------
| | > | Thread-Topic: Tracking database BiztalkDTADb
| | > | thread-index: AcS3UPVDeaWluUKsQce/gZTeUqCiOg==
| | > | X-WBNR-Posting-Host: 193.13.72.2
| | > | From: "examnotes" <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/defaul...msdn/nospam.asp
| | > | > &SD=msdn
| | > | > --------------------
| | > | > | Thread-Topic: Tracking database BiztalkDTADb
| | > | > | thread-index: AcS1NOU7KNGgPdEuS9esoQhUqQ4QSw==
| | > | > | X-WBNR-Posting-Host: 193.13.72.2
| | > | > | From: "examnotes" <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
| | > | > |
| | > | >
| | > | >
| | > |
| | >
| | >
| |
|
|
[ Post a follow-up to this message ]
| 
