Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Biztalk
|
Biztalk General discussion about Biztalk server.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 20th, 2004, 10:47 AM
Authorized User
 
Join Date: Oct 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default BTS 2002 Adapter for SQL issue

I'm having a problem returning multiple records in the adapter for sql using the disassemble result set. It will return 110 records but not 115. (see error below) I ran a trace but did not come to any conclusions with it. I also set the timeout value to 90 which didn't seem to change anything. Is there another setting in the component or elsewhere I can change to get this to work for a couple thousand records?

- - - - - - - - - - -
ERROR MSG
- - - - - - - - - - -
Event Type: Error
Event Source: RFSQL
Event Category: None
Event ID: 10
Date: 7/19/2004
Time: 10:05:58 AM
User: N/A
Computer: BIZ
Description:
A worker thread reported a failure: [Error:] An error occurred in BizTalk Server.

 Details:
 ------------------------------
 Unable to enlist in the transaction.

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


  [Source:] [HelpFile:] [HelpContext:] 0

Note: The Disassemble result set feature can not be used if the target SQL Server is the same one that BizTalk uses. In this case you must unselect the Disassemble Rresult Set feature.
The error code is shown in the data area below.
The operation was: ISQLWorker->Execute


**
thanks,
Phil
**
__________________
**
thanks,
Phil
**
 
Old July 23rd, 2004, 10:07 AM
Authorized User
 
Join Date: Oct 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What I ended up doing was creating a separate specification for the envelope using Editor. In this spec, I set the envelope property in the Reference tab to 'yes' and checked the Document Container Node in the Dictionary tab on the root element.

I have the envelope specified in the Routing properties for the SQL Adapter job. My test of 1000 records produced 1000 documents just like I wanted and validated successfully against my original spec.

**
thanks,
Phil
**





Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL table Adapter kalas Visual Basic 2005 Basics 5 September 18th, 2008 04:21 AM
Access 2002 & Windows Print Services issue voyeur Access VBA 1 August 6th, 2008 06:56 AM
BTS 2002 - business rule in Orchestration pjconrad Biztalk 0 August 3rd, 2004 09:04 AM
Adapter for SQL erisa Biztalk 3 February 25th, 2004 09:28 AM
SQL Data Adapter jbenson001 ASP.NET 1.x and 2.0 Application Design 6 December 18th, 2003 12:13 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.