BizTalk Oracle WCF adapter error

See more:

biztalk

Hi,

While polling my oracle table i'm getting this error on both development and test environments:


The Messaging Engine failed to add a receive location "Receive Location1" with URL "oracledb://test/" to the adapter "WCF-OracleDB". Reason: "System.ArgumentException: Column 'PROVIDERTYPE' does not belong to table SchemaTable.

at System.Data.DataRow.GetDataColumn(String columnName)

at System.Data.DataRow.get_Item(String columnName)

at Microsoft.Adapters.OracleDB.OracleCommonMetadataResolverHandler.ResolvePollingStmtRecord(OracleStructuredTypeMetadata& typeMetadata, OracleCommonConnectionWrapper oracleConnection, OracleCommonExecutionHelper executionHelper)

at Microsoft.Adapters.OracleDB.OracleCommonMetadataResolverHandler.ResolveTypeMetadata(String nodeId, TimeSpan timeout, TypeMetadataCollection& extraTypeMetadataResolved)

at Microsoft.ServiceModel.Channels.Common.Design.MetadataCache.GetTypeMetadata(String uniqueId, Guid clientId, TimeSpan timeout)

at Microsoft.ServiceModel.Channels.Common.MetadataLookup.GetTypeDefinition(String typeId, TimeSpan timeout)

at Microsoft.Adapters.OracleCommon.OracleCommonTypeMetadataPreResolver.ResolveAll(MetadataLookup metadataLookup, OracleCommonExecutionHelper oracleCommonExecutionHelper)

at Microsoft.Adapters.OracleDB.OracleCommonMetadataResolverHandler.ResolveOperationMetadata(String operationId, TimeSpan timeout, TypeMetadataCollection& extraTypeMetadataResolved)

at Microsoft.ServiceModel.Channels.Common.Design.MetadataCache.GetOperationMetadata(String uniqueId, Guid clientId, TimeSpan timeout)

at Microsoft.Adapters.OracleDB.OracleDBInboundContract..ctor(OracleDBConnection connection, IOracleCommonUDTHelper oracleUdtHelper, MetadataLookup metadataLookup)

at Microsoft.Adapters.OracleDB.OracleDBConnection.Microsoft.ServiceModel.Channels.Common.IConnection.BuildHandler[TConnectionHandler](MetadataLookup metadataDictionary)

at Microsoft.ServiceModel.Channels.Common.Design.ConnectionPool.GetConnectionHandler[TConnectionHandler](Guid clientId, TimeSpan timeout, MetadataLookup metadataLookup, String& connectionId)

at Microsoft.ServiceModel.Channels.Common.Channels.AdapterChannelListener`1.OnOpen(TimeSpan timeout)

at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)

at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)

at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)

at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint.Enable()

at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint..ctor(BizTalkEndpointContext endpointContext, IBTTransportProxy transportProxy, ControlledTermination control)

at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiver`2.AddReceiveEndpoint(String url, IPropertyBag adapterConfig, IPropertyBag bizTalkConfig)".


My development environment is Windows 7, VS 2010, BizTalk 2010, MSSQL server 2008 SP1, Oracle Client 11g R1

Test environment: Windows 2008 server, BizTalk 2010, MSSQL server 2008 SP1, , Oracle Client 11g R1


Can you please let me know what is the problem and how can it be resolved?
Thanks.