| Derek Tan [MSFT] 2004-09-02, 6:18 pm |
| For this error:
Either another TDDS is processing the same data or there is an orphaned
session in SQL server holding TDDS lock.Either another TDDS is processing
the same data or there is an orphaned session in SQL server holding TDDS
lock. SQLServer: BTBIZTALK2, Database: BAMPrimaryImport.
Do this:
Verify that the tracking host user is a member of BizTalk Application Users
group in the server with the BTBIZTALK2 database. You also need to verify that
there is no other BizTalk servers processing the same tracking data from
the same biztalkmsgbox database.
Thanks,
Derek [MSFT]
--------------------
>From: "rjt" <rjt@intersis.net>
>Subject: TDDS lock.EXECUTE permission denied
>Date: Thu, 2 Sep 2004 13:45:57 -0700
>Lines: 20
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
>Message-ID: <Or7wc3SkEHA.632@TK2MSFTNGP12.phx.gbl>
>Newsgroups: microsoft.public.biztalk.server
>NNTP-Posting-Host: 207-215-214-1.ded.pacbell.net 207.215.214.1
>Path: cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.server:10210
>X-Tomcat-NG: microsoft.public.biztalk.server
>
>The Biztalk 2004 server is posting the following message to the Eventlog
>about every 15 minutes 24/7.
>
>Source : BAM Event Bus Service
>EventID : 25
>
>
>Either another TDDS is processing the same data or there is an orphaned
>session in SQL server holding TDDS lock.Either another TDDS is processing
>the same data or there is an orphaned session in SQL server holding TDDS
>lock. SQLServer: BTBIZTALK2, Database: BAMPrimaryImport.
>
>I cannot find anything that is processing or procedures that are running.
>Any suggestions in regards to places to look or change to make.
>
>Thanks
>
>rjt
>
>
>
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the
terms specified at http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread
from which they originated.
|