Monday, 15 July 2013

Microsoft.ServiceModel.Channels.Common.ConnectionException: Due to an Oracle Client limitation, the adapter failed to open a connection.

BizTalk Custom WCF Adapter Error :

Microsoft.ServiceModel.Channels.Common.ConnectionException: Due to an Oracle Client limitation, the adapter failed to open a connection. This is because either (a) ambient transaction is present and the TNS alias is longer than 39 characters, or (b) ambient transaction is present and a non-TNS based URI was used. To resolve this, use a TNS alias to connect to Oracle and make sure it is not more than 39 characters.


Solution :

In the Send Port configuration adapter I used a WCF-Custom transport type and used oracleDBbinding as binding type.
In the oracleDBbinding I changed the following propertys:

"enableBizTalkCompatibilityMode" = True (For some reasons this i set to false per default)
"useAmbientTransaction" = False

Jumped to the Message tab and uncheck the "Use Transaction" box under Transactions.

No comments:

Post a Comment