|
tomtom -> Oracle Pipe Transport Error (8 February 2007)
|
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
|
|
|
|
