Experiencing an error with EAI solution with Oracle 11g XE

Question

Hi I am working on demo leveraging EAI tutorial, but instead using SQL Server I am trying to do it using Oracle 11g XE. In end when I deploy the solution and test it using the MessageSender.exe I get following error:

The server was unable to process the request due to an internal error.  For more information about the error, either turn on  IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior)
on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation
and inspect the server trace logs.

My experiences so far with building this demo is up on my blog: Azure Service Bus EAI/EDI December 2011 CTP – EAI Oracle

Looking forward to any hints/tips to tackle this problem and find root cause.

Steef-Jan Wiggers

Ordina ICT B.V. | MVP & MCTS BizTalk Server 2010

http://soa-thoughts.blogspot.com/ | @SteefJan

 

 

---

BizTalk

Answer 1

That is a standard WCF error when the exception information is not being output. It sounds like this must be one of the backend services that does not have debug enabled.

This brings up an interesting question, if the debug on the backend services could be dynamically exposed based on metadata in our solution configuration.

Thanks,

---

If this answers your question, please use the "Answer" button to say so | Ben Cline

Answer 2

Hi,

   can you confirm that you have installed oracle client on the machine were your sbconnent service is running.

otherwise you can enable wcf traces in web.config of sbconnect service and see the exact issue.

---

If this answers your question, please mark it as "Answered".

Answer 3

Hi,

There is an oracle client present on same machine. I can connect to Oracle, Schema gets created. I enabled wcf traces, but there inclusive. Only output I get beside the error that keeps popping up is in Microsoft Service Trace Viewer is:

Cached EDM connection string not found. Trying to load the connection string from WebConfiguration manager, followed by Found connection string named 'AFConnectManagement' in the WebConfigurationManager. in next line and that's it. 

I tried it with a new solution from scratch (system account that has full rights in database), but still in the end:

The server was unable to process the request due to an internal error.  For more information about the error, either turn on  IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior)
on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation
and inspect the server trace logs.

Steef-Jan Wiggers

Ordina ICT B.V. | MVP & MCTS BizTalk Server 2010

http://soa-thoughts.blogspot.com/ | @SteefJan

 

---

BizTalk

Answer 4

Hi,

  can you send your project at gyprakas at microsoft dor com .. We can look into it..

 

Thanks

Gyan

---

If this answers your question, please mark it as "Answered".

Answer 5

Hi,

So there are multiple places from where the problem could be happening. To check if it;s ServiceBus Connect, can you please enable WCF tracing on the ServiceBus Connect runtime service? Add the following section to c:\program files\Microsoft ServiceBus Connect\SBConnectRuntime\web.config.

  <system.diagnostics>
    <sources>
      <source name="Microsoft.ApplicationServer.Integration.AFConnect.Runtime" switchValue="Verbose">
        <listeners>
          <add name="xmlTrace" />
        </listeners>
      </source>
    </sources>
    <sharedListeners>
      <add initializeData="C:\SBConnect.svclog" type="System.Diagnostics.XmlWriterTraceListener" name="xmlTrace">
        <filter type="" />
      </add>
    </sharedListeners>
    <trace autoflush="true" />
  </system.diagnostics>

Thanks,

sandeep

Answer 6

You can add the following section - in the web.config of runtime application to enable servciedebug behaviour -

 

<system.serviceModel> 

<behaviors>
         
  <serviceBehaviors>
       
  <behavior name="">
         
   <serviceDebug includeExceptionDetailInFaults="True">
  
      </behavior>
   
        </serviceBehaviors>
   
    </behaviors>
 
</system.serviceModel>

 

In the next CTP, it can be added as a property of the LobRelay to easily turn it on/off.

---

Rohit Singh

Answer 7

Rohit, nice! This is what I was looking for. I was just not sure if the current CTP service was running as a config file service or a dynamic service host.

Thanks,

---

If this answers your question, please use the "Answer" button to say so | Ben Cline

Answer 8

I't actually a dynamic servcie host.

But, if you add any behaviour with empty name. It gets applied to all the services associated with that config file.

 

---

Rohit Singh

Answer 9

Hi,

The behaviour xml you posted shoud be:

<behaviors>
<serviceBehaviors>
<behavior name="">
<serviceDebug includeExceptionDetailInFaults="True"/>
</behavior>
</serviceBehaviors>
</behaviors>

You forgot closing tag of the serviceDebug element.

Steef-Jan Wiggers

Ordina ICT B.V. | MVP & MCTS BizTalk Server 2010

http://soa-thoughts.blogspot.com/ | @SteefJan

---

BizTalk

Answer 10

Thanks Steef!

Did it help in resolving the issue ?

---

Rohit Singh

Answer 11

Hi Rohit,

I will have to try that out on my new environment.

Steef-Jan Wiggers

Ordina ICT B.V. | MVP & MCTS BizTalk Server 2010

http://soa-thoughts.blogspot.com/ |@SteefJan

 

---

BizTalk

Answer 12

Hi,

Issue is now that message is send, but nothing is inserted in Oracle. I am getting no information at all. Not from eventviewer, or WCF TraceViewer. I send the project now to Gyan as requested.

Steef-Jan Wiggers

Ordina ICT B.V. | MVP & MCTS BizTalk Server 2010

http://soa-thoughts.blogspot.com/ |@SteefJan

---

BizTalk

Answer 13

Hi Steef,

            I have tesed your project targetting our Oracle servers and works fine. I have sent you mine project to verify this. Please let me know if that resolves the issue.

 

Thanks

Gyan

---

If this answers your question, please mark it as "Answered".

Answer 14

Hi Gyan,

I found out that the problem lies with the Oracle client. Oracle 11g R2 client is not supported as solution specifically asks for 2.111.7.0 version of Oracle.DataAccess.dll. This version of the dll is not part of the 11g R2 client, but the Oracle 11g R1 client.Thanks for all the help so far. I think you will have explicitly put in the documentation of Adapter Pack what Oracle clients are supported.

Steef-Jan Wiggers

MVP & MCTS BizTalk Server 2010

http://soa-thoughts.blogspot.com/ |@SteefJan

---

BizTalk