Click here to Skip to main content
15,944,837 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900