Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Response problem with Oracle-adapter
- This topic has 4 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
April 29, 2009 at 6:10 AM #22253
Hello from The Netherlands,
We use the BizTalk Oracle adapter in BizTalk Production/Oracle Production and BizTalk Acceptation/Oracle Acceptation environment.
Both Query and Insert did work in both environments and gave a QueryResponse and InsertResponse.
Oracle Acceptation environment is a clone of the Oracle Production environment, wich is cloned almost every night.
Since a short time we do not get back the QueryResponse or InsertResponse.
We can see in the HAT that the Query- or Insert-message have been send by BizTalk to Oracle, and that BizTalk is waiting for the Response.
And it seems to stop after the Production Database has been cloned to the Acceptation Database.As far as we (Oracle DBA, System Management and BizTalk Server Management) know, nothing (except some server updates) has changed, wich could be the reason of this problem.
Is there someone who has ever got the same problem?
Or someone with an idea what to do or where to look to resolve it?Thanks in advance,
Robbish.
-
April 29, 2009 at 1:39 PM #22261
Hello,
You’ve wrote: “We can see in the HAT that the Query- or Insert-message have been send by BizTalk to Oracle”
1. The insert/update succeeds?
2. Your aplications just stays in dehydrated mode?
The server updates you’ve wrote about – can they be some security updates? Did you check, that MSDTC configuration on both sides is the same as it was before? Anything interesting in event vewier?
-
May 6, 2009 at 1:04 AM #22303
Hello Yonathan, and other readers,
Thanks for your reply. I did have some holidays, therefor this reply took some time.
Strangely enough everything worked the past days like it is supposed to! So I could not check all of the options you wrote about.
Have checked MSDTC. It is configured the way it schould be.
Wil check other options as soon as something goes wrong!
Robbish.
-
June 16, 2009 at 2:28 PM #22670
Hello Robbish,
I face exactly the same issue you faced, in our DEV enviroment every thing works fine.
But when connected to UAT environment integrated with same Oracle Database, we find there is huge time the orchestration waits and we dont get the insert response, but same works in DEV. It is JUST the BizTalk Server differs in both.
Could you please help in resolving this.
-Pon
-
June 19, 2009 at 2:50 AM #22688
Hello Pon,
Seems to me that there are two different problems:
You: Having problems with the UAT Database and not with the DEV Database.
We: Having NO problems with the UAT Database but with the DEV Database after it has been cloned from the UAT Database.
Robbish.
-
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.