Unable to reconnect to Oracle

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

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

Unable to reconnect to Oracle

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 >> Unable to reconnect to Oracle

Page: [1]

Message

<< Older Topic Newer Topic >>

Unable to reconnect to Oracle - 18 January 2007

sunedh

Posts: 9
Score: 0
Joined: 29 August 2006
Status: offline

I have set up a receive location to poll and Oracle procedure for new messages every 5 minuts. This all works fine, however, if the location at some point looses connection to the Oracle server, and the connection after a while is re-established the port no longer receives messages. Instead I keep getting error messages every 5 minuts in the Event Log.

I then have to restart my host instance or disable and the enable the receive location. Either way I have to do some manual interaction which is not a good solution.

Can I awoid this and get the Adapter to poll messages automatically after the connection is re-established?

Best regards,
Sune

Post #: 1

RE: Unable to reconnect to Oracle - 18 January 2007

Pieter

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

What Provider are you currently using?

_____________________________

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

(in reply to sunedh)

Post #: 2

RE: Unable to reconnect to Oracle - 19 January 2007

sunedh

Posts: 9
Score: 0
Joined: 29 August 2006
Status: offline

I have been using two different:

Microsoft .NET Data Provider for Oracle Version 2.0.0

and

Oracle Data Provider for .NET Version 10.1.0.400

Regards,
Sune

(in reply to Pieter)

Post #: 3

RE: Unable to reconnect to Oracle - 19 January 2007

Pieter

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

What is the version of the Oracle Client you have installed?

_____________________________

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

(in reply to sunedh)

Post #: 4

RE: Unable to reconnect to Oracle - 19 January 2007

sunedh

Posts: 9
Score: 0
Joined: 29 August 2006
Status: offline

It is version 10.2.0

Regards,
Sune

(in reply to Pieter)

Post #: 5

RE: Unable to reconnect to Oracle - 19 January 2007

Pieter

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

Have a look at the ConnectionLifeTime Property when configuring the connection string.

By default it is 0, which means that the connection is never recycled. You can set this to say 60 seconds which means that the connection will be recycled after 60 seconds.

The other alternative is to disable connection pooling, but this could cause a performance issue.

_____________________________

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

(in reply to sunedh)

Post #: 6

RE: Unable to reconnect to Oracle - 19 January 2007

sunedh

Posts: 9
Score: 0
Joined: 29 August 2006
Status: offline

Thanks a lot Pieter

Just to be 100% sure: the connection can not be recycled during a call to Oralce?

Regards,
Sune

(in reply to Pieter)

Post #: 7

RE: Unable to reconnect to Oracle - 19 January 2007

Pieter

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

No the check is only performed once the connection is returned to the pool.

_____________________________

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

(in reply to sunedh)

Post #: 8

RE: Unable to reconnect to Oracle - 26 January 2007

sunedh

Posts: 9
Score: 0
Joined: 29 August 2006
Status: offline

It seems I still get the error unfortunately. I have set the ConnectionLifetime to 300, but after connection is lost I keep getting the following two entries in the Event Log when Oracle is polled:

Event Type: Warning
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5740
Date:  26-01-2007
Time:  08:58:25
User:  N/A
Computer: BRNBIZA31
Description:
The adapter "BizTalk Utilities Adapter for Databases Transport" raised an error message. Details "An Exception Occurred attempting to retrieve Messages from the Uri 'database://Microsoft .NET Data Provider for Oracle Version 2.0.0/DistributionRequests/DistributionRequest'".
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Receiver
Event Category: None
Event ID: 0
Date:  26-01-2007
Time:  08:58:25
User:  N/A
Computer: BRNBIZA31
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception Occurred attempting to retrieve Messages from the Uri 'database://Microsoft .NET Data Provider for Oracle Version 2.0.0/DistributionRequests/DistributionRequest'
System.Data.OracleClient.OracleException
ORA-03114: not connected to ORACLE
"
Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 4316
String ProcessName = "C:\Program Files (x86)\Microsoft BizTalk Server 2006\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "BESTCORP\bizsvc01"
     String ProcessAccountName = "BESTCORP\bizsvc01"
}
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.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.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._TimerCallback.PerformTimerCallback(Object state)"
String EventSourceInstance = "b66cf67e-30f6-4270-a036-cc4df54a7799"
String EventSourceName = "BizTalk Utilities Adapter for Databases Receiver"
Int64 EventSequenceNumber = 1195
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 26-01-2007 08:58:25
String AppDomainName = "DefaultDomain"
String MachineName = "BRNBIZA31"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

(in reply to Pieter)

Post #: 9

RE: Unable to reconnect to Oracle - 30 January 2007

Pieter

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

We have picked this up during testing, it seems that is has something to do with the internals of the Oracle Client and not ADO.NET. The only solution so far was to restart the host.

What happens when you set connection pooling off?

_____________________________

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

(in reply to sunedh)

Post #: 10

RE: Unable to reconnect to Oracle - 5 April 2007

bennean

Posts: 17
Score: 0
Joined: 23 November 2006
Status: offline

Is there any update to this? We have the same issue, whereby manual intervention is required - which is not great!

(in reply to Pieter)

Post #: 11

RE: Unable to reconnect to Oracle - 23 April 2007

Pieter

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

Nothing yet, will be looking at an updated driver or something.

_____________________________

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

(in reply to bennean)

Post #: 12

RE: Unable to reconnect to Oracle - 23 April 2007

Pieter

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

Another option would be to switch off Connection Pooling, but this could have a performance impact.

_____________________________

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

(in reply to Pieter)

Post #: 13