Items Stuck in Work Queue.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ouaes Jamali (ojamali_at_comsoltx.com1)
Date: 06/05/04

  • Next message: Dave Girvitz: "Re: Question"
    Date: Sat, 5 Jun 2004 16:36:02 -0700
    
    

    When i drop a file to a folder designated as a pickup folder, the file is picked up BizTalk file receive function. After this the document is stuck in the Work Queue and this error is replicated in the application log every 2 seconds.

    Error Type: Error
    Source: BizTalk Server
    Category: Document Processing

    An error occurred in BizTalk Server.
     
     Details:
     ------------------------------
     [0x8004d00a] Unable to enlist in the transaction.

     [0x1705] There was a failure creating the internal work item. Make sure that SQL Server is running.

     [0x1705] There was a failure creating the internal work item. Make sure that SQL Server is running.

    The environment we have is Windows 2003, SQL Server 2000 with SP3a, Microsoft BizTalk Server 2002 with SP1.
    SQL Server and BizTalk server are installed on different servers. Both the servers are have the latest patches installed for the software and OS.
    DTC is enabled on both the servers and i have installed DTCPing utility from microsoft on both of these boxes to verify that DTC across the boxes is working.
    Any ideas to resolve this problem wil be greatly appreciated.

    Thanks


  • Next message: Dave Girvitz: "Re: Question"

    Relevant Pages

    • Re: Maximum Message Throughput
      ... I am using the standard BizTalk SQL Adapter at this point. ... one biztalk server. ... stay with the messaging engine ... I have a SQL Server database with 10 million records. ...
      (microsoft.public.biztalk.general)
    • Re: ENTSSO not starting when BizTalk Server boots
      ... Is the SSO service located on the SQL Server cluster or on the BizTalk machine? ... Failed to contact the SSO database: An error has occurred while establishing ...
      (microsoft.public.biztalk.general)
    • Re: BizTalk DB connectivity problems
      ... Has anyone experienced major SQL connectivity problems on their BizTalk ... Event Source: BizTalk Server 2006 ... see Help and Support Center at ... Event Source: ENTSSO ...
      (microsoft.public.biztalk.general)
    • Re: BizTalk DB connectivity problems
      ... Has anyone experienced major SQL connectivity problems on their BizTalk ... Event Source: BizTalk Server 2006 ... see Help and Support Center at ... Event Source: ENTSSO ...
      (microsoft.public.biztalk.general)
    • Re: BizTalk Orchestration SQL Adapter
      ... My short answer would be to use DTS intsead of BizTalk Server for this type ... > mirror image of SQL Server tables. ... > scheduler invoke BizTalk, scheduler writes a dummy file to a folder at ...
      (microsoft.public.biztalk.general)