Wrox Programmer Forums
|
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 October 8th, 2003, 07:14 AM
Authorized User
 
Join Date: Oct 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error in BTS

I'm getting this error and I'm not sure how to trouble shoot. I have BTS 2002 getting data from SQL Server on a separate machine. I tested my connection with Windows authentication on my job successfully but for some reason get this error. Can anyone help?
* *
Event Type: Error
Event Source: RFSQL
Event Category: None
Event ID: 10
Date: 10/8/2003
Time: 6:42:48 AM
User: N/A
Computer: BTS1
Description:
A worker thread reported a failure: [OLE/DB provider returned message: Neither the isolation level nor a strengthening of it is supported.]
The error code is shown in the data area below.
The operation was: ISQLWorker->Execute
The worker thread was working on:
 Job Name: LateShipmentJob
 SQL Script: select distinct (number), cust, status
from mytable1
where status <> 'D' for xml auto

Error code: 80004005

**
thanks,
Phil
**
__________________
**
thanks,
Phil
**
 
Old October 8th, 2003, 11:22 AM
Authorized User
 
Join Date: Oct 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've determined that the issue may be with the query in BizTalk trying to extract a result set from a view that is set up via a linked server in SQL Server 2000 to a FoxPro Database.

I am also not able to set the job up using a stored procedure. An error tells me that "Streaming not supported over multiple column result."

I'm still not sure what's wrong exactly.

**
thanks,
Phil
**
 
Old October 22nd, 2003, 12:22 AM
Registered User
 
Join Date: Oct 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I get the same error with BTS (Win2k3) & SQL server (W2k) on a separate machine
It's look like a security/identity problem

Did find the solution ?

Thanks
Eric

 
Old October 22nd, 2003, 08:26 AM
Authorized User
 
Join Date: Oct 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I resolved it by setting the isolation level. My view is created using a linked server. Some of the data I get is on a FoxPro db. However, I still get an ODBC error related to FoxPro.

hth! - Phil

CREATE PROCEDURE sp_spname
AS

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

BEGIN TRANSACTION

SELECT distinct (idnumber), city , st, cdate, ctime
FROM vw_myView
WHERE status = 'Y'
AND cdate > GETDATE()-2 for xml auto

COMMIT TRANSACTION
GO





Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Query Error & Run-Time Error 3022 DavidWE Access 1 July 31st, 2008 11:17 AM
Ch 4: Parse error: syntax error, unexpected T_SL hanizar77 BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 June 23rd, 2008 09:17 PM
hi i got runtime error 13 Type Mismatch error sriharsha345 Access VBA 2 February 21st, 2008 09:30 AM
BTS 2002 - business rule in Orchestration pjconrad Biztalk 0 August 3rd, 2004 09:04 AM
BTS 2002 Adapter for SQL issue pjconrad Biztalk 1 July 23rd, 2004 10:07 AM





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