Oracle Pipe Transport Error

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Oracle Pipe Transport Error

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Oracle Pipe Transport Error

Page: [1]

Message

<< Older Topic Newer Topic >>

Oracle Pipe Transport Error - 8 February 2007

tomtom

Posts: 13
Score: 0
Joined: 2 February 2007
Status: offline

Hi all:

Ref: BizTalk Server 2006/Oracle 10g/BizTalk Utilities Adapter for Databases 4.0.0

I am trying to setup a sample BizTalk application using the BizTalk Utilities Adapter for Databases Oracle Pipes Transport to retrieve data from an Oracle Pipe. However, I got this error when starting the application although the connection to Oracle database was successful when testing in the Receive Location setup:

BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to retrieve Messages from the Uri 'oraclepipe://Microsoft .NET Data Provider for Oracle Version 2.0.0/Receive/BTS_PIPE'
System.Exception
An Error occurred attempting to read a Message from 'BTS_PIPE'. Details are as follows:
System.InvalidOperationException: Invalid operation. The connection is closed.
at System.Data.OracleClient.OracleCommand.GetStatementHandle()
at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
at BTSUtils.Adapters.Databases.Oracle.Pipes.Client.Pipe.Read(String pipe)"
Exception InnerException = {
     String HelpLink = <null>
     String Message = "Invalid operation. The connection is closed."
     String Source = "System.Data.OracleClient"
     String StackTrace = "   at System.Data.OracleClient.OracleCommand.GetStatementHandle()
at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
at BTSUtils.Adapters.Databases.Oracle.Pipes.Client.Pipe.Read(String pipe)"
     String TargetSite = "System.Reflection.RuntimeMethodInfo.GetStatementHandle"
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 5664
String ProcessName = "C:\Program Files\Microsoft BizTalk Server 2006\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "TEST\USER1"
     String ProcessAccountName = "BUILTIN\Administrators"
}
ManagedSecurityInfo ManagedSecurity = {
     String IdentityName = ""
     String AuthenticationType = ""
     Boolean IsAuthenticated = False
}
String StackTrace = " at BTSUtils.Core.Adapters.EnterpriseInstrumentation.Helper.Error(EventSource EventSource, Exception Exception, String Message)
at BTSUtils.Adapters.Databases.Oracle.Pipes.Receive.EndPoint.Interval()
at BTSUtils.Core.Adapters.Receive.EndPoint.Base.Interval(Object State)
at System.Threading._TimerCallback.TimerCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._TimerCallback.PerformTimerCallback(Object state)"
String EventSourceInstance = "8dbe5640-4dc8-4e35-9dfe-b785cea7d4cb"
String EventSourceName = "BizTalk Utilities Adapter for Databases Oracle Pipes Receiver"
Int64 EventSequenceNumber = 5
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 2/7/2007 11:17:33 PM
String AppDomainName = "DefaultDomain"
String MachineName = "SERVER001"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}

Has someone seen this error? Please help.

Thanks,

Tom

Post #: 1

RE: Oracle Pipe Transport Error - 8 February 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

What is the version of your Adapter in Add/Remove Programs?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to tomtom)

Post #: 2

RE: Oracle Pipe Transport Error - 8 February 2007

tomtom

Posts: 13
Score: 0
Joined: 2 February 2007
Status: offline

The version we currently use is BizTalk Utilities Adapter for Databases Version 4.0.0.

Thanks,

Tom

(in reply to Pieter)

Post #: 3

RE: Oracle Pipe Transport Error - 8 February 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Can you download the latest version we have fixed issues with it n 4.0x upwards.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to tomtom)

Post #: 4