none
Error while retrieving or generating the WSDL RRS feed

  • Question

  • Why would I be getting this error message? It is a very straight forward select on a set of Oracle tables. I cannot even generate the schema from my query:

    Error while retrieving or generating the WSDL. Adapter message: Retrieval of Operation Metadata has failed while building WSDL at 'http://Microsoft.LobServices.OracleDB/2007/03/POLLINGSTMT'

    Monday, February 27, 2012 1:47 PM

All replies

  • Are you sure that there is not more to the error description than what you have posted?

    Are you doing this by Chosing "Add->Add Generated Items->Add Adapter MetaData->WCF OrableDb?" in a BizTalk project in VS?


    Morten la Cour

    Monday, February 27, 2012 1:52 PM
  • I guess it could be a Oracle.DataAccess.dll issue. Can you check which version of dataAccess dll installed. Also let us know your environment detatils (os, biztalk version ) if this not related to DataAccess.dll issue.

    ___________________________________________________________
    If this is helpful or answers your question - please mark as answer and vote as helpful.

    Raj,

    http://rajwebjunky.blogspot.com



    • Edited by rajwebjunky Tuesday, February 28, 2012 3:04 PM
    • Proposed as answer by rajwebjunky Tuesday, February 28, 2012 3:04 PM
    Monday, February 27, 2012 3:50 PM
  • Are you sure that there is not more to the error description than what you have posted?

    Are you doing this by Chosing "Add->Add Generated Items->Add Adapter MetaData->WCF OrableDb?" in a BizTalk project in VS?


    Morten la Cour

    Correct.
    Friday, March 2, 2012 12:39 PM
  • I guess it could be a Oracle.DataAccess.dll issue. Can you check which version of dataAccess dll installed. Also let us know your environment detatils (os, biztalk version ) if this not related to DataAccess.dll issue.

    ___________________________________________________________
    If this is helpful or answers your question - please mark as answer and vote as helpful.

    Raj,

    http://rajwebjunky.blogspot.com



    Can't be. I have an several existing BT projects that connect to Oracle from my machine just fine with no issues.
    Friday, March 2, 2012 12:39 PM
  • I have the same issue.

    After click OK. vs2010 throw an error.

    Generate IDoc Schema

    System.Xml.Schema.XmlSchemaException: 已经声明了 complexType“http://Microsoft.LobServices.Sap/2007/03/Types/Idoc/3/ZT077X//711:ZT077X”。

    Server stack trace: 
    在 System.Xml.Schema.XmlSchemaSet.InternalValidationCallback(Object sender, ValidationEventArgs e)
    在 System.Xml.Schema.BaseProcessor.SendValidationEvent(XmlSchemaException e, XmlSeverityType severity)
    在 System.Xml.Schema.BaseProcessor.AddToTable(XmlSchemaObjectTable table, XmlQualifiedName qname, XmlSchemaObject item)
    在 System.Xml.Schema.Preprocessor.Preprocess(XmlSchema schema, String targetNamespace, ArrayList imports)
    在 System.Xml.Schema.Preprocessor.Execute(XmlSchema schema, String targetNamespace, Boolean loadExternals)
    在 System.Xml.Schema.XmlSchemaSet.PreprocessSchema(XmlSchema& schema, String targetNamespace)
    在 System.Xml.Schema.XmlSchemaSet.Reprocess(XmlSchema schema)
    在 Microsoft.ServiceModel.Channels.Common.Design.WsdlBuilderHelper.GetServiceDescription()
    在 Microsoft.ServiceModel.Channels.Common.Design.WsdlBuilder.GetWsdl(MetadataRetrievalNode[] nodes, Uri uri, TimeSpan timeout)
    在 Microsoft.Adapters.SAP.SapCustomWsdlRetrieval.GetWsdl(MetadataRetrievalNode[] nodes, Uri uri, TimeSpan timeout)
    在 Microsoft.ServiceModel.Channels.Common.Design.MetadataExchanger.ProcessMetadataGet(Message message, Uri target, TimeSpan timeout, MetadataLookup metadataLookup)
    在 Microsoft.ServiceModel.Channels.Common.Design.MetadataExchanger.ProcessMetadataMessage(Message message, Uri target, TimeSpan timeout, MetadataLookup metadataLookup, Message& replyMessage)
    在 Microsoft.ServiceModel.Channels.Common.Channels.AdapterRequestChannel.Request(Message message, TimeSpan timeout)
    在 System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
    在 System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
    在 System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
    在 System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

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


    MOSS2007,BizTalk2006

    Saturday, December 8, 2012 2:25 AM
  • You probably get this error if something the stored procedure that you are trying to generate data from needs compilation. 
    • Edited by Peter Tji Tuesday, August 13, 2019 1:05 PM
    Tuesday, August 13, 2019 1:00 PM