none
Generate schema for oracle procedure with return type xmltype fails in biztalk 2013 RRS feed

  • Question

  • Hi,

    I am trying to generate schema for oracle procedure in Biztalk 2013 and procedure is returning XMLTYPE.I am using Service (Inbound Operation) but it is failing with error :

    Microsoft.ServiceModel.Channels.Common.MetadataException: Retrieval of Operation Metadata has failed while building WSDL at 'http://Microsoft.LobServices.OracleDB/2007/03/PollingPackage/Package/TestXMLType' ---> System.NotSupportedException: Specified method is not supported.
       at Microsoft.Adapters.OracleDB.OracleCommonMetadataResolverHandler.CreateQualifiedType(OracleCommonConnectionWrapper connection, DataRow row, String dataType, String typeName, String typeOwner, String direction, String& dataLength, Boolean& isArray, Boolean& isOptional, String& elementType, OracleCommonExecutionHelper executionHelper, OracleCommonTypeMetadataPreResolver preResolver)
       at Microsoft.Adapters.OracleDB.OracleCommonMetadataResolverHandler.CreateProcedureParameter(OracleCommonConnectionWrapper connection, DataTable metadataTable, Int32 i, DataRow row, String dataType, ProcedureMetadata operation, OracleCommonExecutionHelper executionHelper, OracleCommonTypeMetadataPreResolver preResolver)
       at Microsoft.Adapters.OracleDB.OracleCommonMetadataResolverHandler.ResolveProcedureMetadata(OracleCommonConnectionWrapper connection, DataTable metadataTable, ProcedureMetadata operation, OracleCommonExecutionHelper executionHelper, OracleCommonTypeMetadataPreResolver preResolver)
       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.ServiceModel.Channels.Common.Design.WsdlBuilder.SearchBrowseNodes(MetadataRetrievalNode[] nodes, WsdlBuilderHelper helper, TimeoutHelper timeoutHelper)
       --- End of inner exception stack trace ---

    Server stack trace: 
       at Microsoft.ServiceModel.Channels.Common.Design.AdapterExceptions.ThrowMetadataException(String errorMessage, Object arg, Object source, Exception innerException)
       at Microsoft.ServiceModel.Channels.Common.Design.WsdlBuilder.SearchBrowseNodes(MetadataRetrievalNode[] nodes, WsdlBuilderHelper helper, TimeoutHelper timeoutHelper)
       at Microsoft.ServiceModel.Channels.Common.Design.WsdlBuilder.GenerateOperationSchemas(WsdlBuilderHelper helper, MetadataRetrievalNode[] nodes, TimeSpan timeout)
       at Microsoft.ServiceModel.Channels.Common.Design.WsdlBuilder.GetWsdl(MetadataRetrievalNode[] nodes, Uri uri, TimeSpan timeout)
       at Microsoft.Adapters.OracleCommon.OracleCommonWsdlRetrieval.Microsoft.ServiceModel.Channels.Common.IWsdlRetrieval.GetWsdl(MetadataRetrievalNode[] nodes, Uri uri, TimeSpan timeout)
       at Microsoft.ServiceModel.Channels.Common.Design.MetadataExchanger.ProcessMetadataGet(Message message, Uri target, TimeSpan timeout, MetadataLookup metadataLookup)
       at Microsoft.ServiceModel.Channels.Common.Design.MetadataExchanger.ProcessMetadataMessage(Message message, Uri target, TimeSpan timeout, MetadataLookup metadataLookup, Message& replyMessage)
       at Microsoft.ServiceModel.Channels.Common.Channels.AdapterRequestChannel.Request(Message message, TimeSpan timeout)
       at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
       at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
       at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
       at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

    Exception rethrown at [0]: 
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       at Microsoft.ServiceModel.Channels.IMetadataRetrievalContract.GetMetadata(MetadataRetrievalNode[] nodes)
       at Microsoft.ServiceModel.Channels.Tools.MetadataSearchBrowse.MetadataPanel.GetWsdl(MetadataRetrievalNode[] nodes)
       at Microsoft.ServiceModel.Channels.Tools.MetadataSearchBrowse.MetadataUserControl.GetWsdl()



    Friday, December 2, 2016 5:11 PM

Answers

All replies