I have biztalk 2004 developer edition up and running on my machine
very much configured properly cause i'm able to do a small application
with 2 messages 1 map,1 orhestration(has 1 block to call c# Library) I
used file adaptor and everything seems fine (complition,deployment
wise)but at runtime when I put my message in the input directory (I
specified that during the configuration of the recieve port) the
message disappeared which is a healthy thing but nothing happen after
that this C# Library (which I called from orhestration) should open txt
file and write something in it) and when i checked the event
application log I found this database error I checked the health and
activity tool but nothing useful.

"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: SAMER-C9MZG2F97, Database:
BAMPrimaryImport. "

and another one

"Either another TDDS is processing the same data or there is an
orphaned session in SQL server holding TDDS lock.EXECUTE permission
denied on object 'TDDS_Lock', database 'BizTalkDTADb', owner 'dbo'.
SQLServer: SAMER-C9MZG2F97, Database: BizTalkDTADb. "
if any one has a clue of what is the cause of that I really appreciate
thank you in advance

[ Post a follow-up to this message ]