BizTalk Server - Tracking database BiztalkDTADb

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server > November 2004 > Tracking database BiztalkDTADb





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Tracking database BiztalkDTADb
DW

2004-10-18, 5:48 pm

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
larry franks

2004-10-19, 5:48 pm

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: "=?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
|

DW

2004-10-21, 7:47 am

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: "=?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
> |
>
>

larry franks

2004-10-26, 5:48 pm

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: "=?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/defaul...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
| > |
| >
| >
|

DW

2004-10-27, 5:49 pm

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: "=?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/defaul...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
> | > |
> | >
> | >
> |
>
>

larry franks

2004-11-03, 5:48 pm

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: "=?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/defaul...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/defaul...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
| > | > |
| > | >
| > | >
| > |
| >
| >
|

larry franks

2004-11-04, 5: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: "=?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/defaul...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/defaul...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
| | > | > |
| | > | >
| | > | >
| | > |
| | >
| | >
| |
|
|

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com