| Author |
Suspended entries relation to submitted docs
|
|
| Rudolf Henning 2004-02-08, 8:39 am |
| I have a situation where some documents have ended up in
the suspended queue (due to some system/hardware problems)
and the documents cannot be resubmitted. These are a few
out of thousand of documents processed per day. The
problem is trying to figure out which documents 'failed'
so we can have to source have them resubmitted.
The question is: what relation is there between entries of
the InterchangeSQ.dbo.cs_SuspendedQ table and
dta_indoc_details or dta_interchange_details?
Is there any programmatic way (write a sql query) to get
the related document from the tracking database?
I realize this is not (suppose to be) a public interface
but this info is critical and it happens often that we
need to link documents.
thanks
Rudolf
| |
| Jan Eliasen 2004-02-08, 8:39 am |
| On Mon, 12 Jan 2004 22:24:20 -0800, "Rudolf Henning"
<anonymous@discussions.microsoft.com> wrote:
Without having checked it thouroughly (spelling?), I would say that
uidTrackingGUID corresponds to uidGUID in SQ-table
>I have a situation where some documents have ended up in
>the suspended queue (due to some system/hardware problems)
>and the documents cannot be resubmitted. These are a few
>out of thousand of documents processed per day. The
>problem is trying to figure out which documents 'failed'
>so we can have to source have them resubmitted.
>
>The question is: what relation is there between entries of
>the InterchangeSQ.dbo.cs_SuspendedQ table and
>dta_indoc_details or dta_interchange_details?
>Is there any programmatic way (write a sql query) to get
>the related document from the tracking database?
>
>I realize this is not (suppose to be) a public interface
>but this info is critical and it happens often that we
>need to link documents.
>
>thanks
>
>Rudolf
--
Jan Eliasen, representing himself and not the company he works for.
MCP in Microsoft BizTalk Server
| |
| Rudolf 2004-02-08, 8:39 am |
| That was my initial idea but when querying the dta
database with the guid obtained in the suspend queue the
result is no corresponding record. Puzzling...
Rudolf
>-----Original Message-----
>On Mon, 12 Jan 2004 22:24:20 -0800, "Rudolf Henning"
><anonymous@discussions.microsoft.com> wrote:
>
>Without having checked it thouroughly (spelling?), I
would say that
>uidTrackingGUID corresponds to uidGUID in SQ-table
>
problems)[color=blue]
of[color=blue]
>
>--
>Jan Eliasen, representing himself and not the company he
works for.
> MCP in Microsoft BizTalk Server
>.
>
| |
| Jan Eliasen 2004-02-08, 8:39 am |
| On Tue, 13 Jan 2004 05:41:10 -0800, "Rudolf"
<anonymous@discussions.microsoft.com> wrote:
Did the code posted in another newsgroup help you?
[color=blue]
>That was my initial idea but when querying the dta
>database with the guid obtained in the suspend queue the
>result is no corresponding record. Puzzling...
>
>Rudolf
>
>would say that
>problems)
>of
>works for.
--
Jan Eliasen, representing himself and not the company he works for.
MCP in Microsoft BizTalk Server
| |
| DeWayne Filppi 2004-02-08, 8:39 am |
| I'm having a similar problem. Actually the uidGUID field in my
cs_SuspendedQ table has no entry in the dta_indoc_details table. Any
ideas why this would be the case? A clue: I'm attempting to track an
error using the RosettaNet accelerator.
Jan Eliasen <spam@eliasen.dk> wrote in message news:<dlhc009cf706r4mpsohoh3ej5u565ufmih@4ax.com>...[color=blue]
> On Tue, 13 Jan 2004 05:41:10 -0800, "Rudolf"
> <anonymous@discussions.microsoft.com> wrote:
>
> Did the code posted in another newsgroup help you?
>
> would say that
> problems)
> of
> works for.
| |
| Jan Eliasen 2004-02-08, 8:39 am |
| On 5 Feb 2004 13:43:44 -0800, filppi@sbcglobal.net (DeWayne Filppi)
wrote:
The only idea I hae is that the channel the document was going through
wasn't set up to log the inbound document?
[color=blue]
>I'm having a similar problem. Actually the uidGUID field in my
>cs_SuspendedQ table has no entry in the dta_indoc_details table. Any
>ideas why this would be the case? A clue: I'm attempting to track an
>error using the RosettaNet accelerator.
>
>Jan Eliasen <spam@eliasen.dk> wrote in message news:<dlhc009cf706r4mpsohoh3ej5u565ufmih@4ax.com>...
--
Jan Eliasen, representing himself and not the company he works for.
MCP in Microsoft BizTalk Server
| |
| DeWayne Filppi 2004-02-08, 8:39 am |
| You're a life saver. I should have thought of that, although I'm
pretty much a novice. Thanks. BTW, the tracking fields are only
saved when a document is sent? So if I set tracking (and select
fields to track) on an inbound document, they don't get tracked unless
the document is sent? I say this because only the dta_outdoc_details
table appears to have tracking fields (and I don't see the fields
getting tracked anywhere else).
Jan Eliasen <spam@eliasen.dk> wrote in message news:<5eh620pmpau1fnmat99t3ges8abkrjm8jp@4ax.com>...[color=blue]
> On 5 Feb 2004 13:43:44 -0800, filppi@sbcglobal.net (DeWayne Filppi)
> wrote:
>
> The only idea I hae is that the channel the document was going through
> wasn't set up to log the inbound document?
>
> would say that
> problems)
> of
> works for.
| |
| DeWayne Filppi 2004-02-08, 8:39 am |
| I was mistaken in my previous post. The uidGUID was not in the
dta_indoc_details, it was in the dta_interchange_details table under
the "uidInterchangeGUID" column. Unfortunately, the
"uidInterchageGUID" doesn't appear anywhere else in the system that I
can find.
Jan Eliasen <spam@eliasen.dk> wrote in message news:<5eh620pmpau1fnmat99t3ges8abkrjm8jp@4ax.com>...[color=blue]
> On 5 Feb 2004 13:43:44 -0800, filppi@sbcglobal.net (DeWayne Filppi)
> wrote:
>
> The only idea I hae is that the channel the document was going through
> wasn't set up to log the inbound document?
>
> would say that
> problems)
> of
> works for.
|
|
|
|