Response problem with Oracle-adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Response problem with Oracle-adapter

Viewing 1 reply thread
  • Author
    Posts
    • #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. 

    • #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?

      • #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.

        • #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

          • #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.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.