Error while retrieving or generating the WSDL.Adapter message: Retrieval of Operation Metadata has failed while building WSDL at TypedProcedure/dbo/SPXXXX


I was to generate schema from Stored procedure, thus used Consume Adapter Service wizard -- selected the SP and while the process got below error

 "Error while re07ieving or generating the WSDL.Adapter message: Re07ieval of Operation Metadata has failed while building WSDL at 'TypedProcedure/dbo/SPName' "


Why it happened

From the error details it was clear that there was permission issue, but how can that be -- I had generated schemas against same database. So checked the permissions of the account which I was using -- and found I have all rights.

What to do

In Actual the solution to this error is to provide the required permission on database level. But I already had it. My  colleague suggested to remove all the access, save it and reassign all the access - did as suggested and it worked.
It's weird but sometimes such things happens :) 


ServerLess360



Comments

Post a Comment

Popular posts from this blog

The request has both SAS authentication scheme and 'Bearer' authorization scheme. Only one scheme should be used

Image
While doing testing after doing a POC on Securing Logic App with Azure Active Directory authentication , where I have put logic app behind APIM and before passing the request to logic app, apim does validation of the token.  I was encountered with an error "The request has both SAS authentication scheme and 'Bearer' authorization  scheme.  Only one scheme should be used." Why it happened After validating the token which is part of the header i.e. Authorization, APIM forwards the request as it is to backend. As  Logic app is configured as  back end , it's url already consist of SAS signature plus the request also has Authorization section and this is the problem. By default every request endpoint on a logic app has a Shared Access Signature (SAS) in the endpoint's URL, which follows this format: https://<request-endpoint-URI>sp=<permissions>sv...
Read more

Run Android emulator and Android Studio on Azure VM using Hyper V

Image
14 min to read. Abs07act Due to Corona outbreak, times are hard! Please take care everyone! I wish good health for all! Stay safe! There is another outbreak I am seeing – Making Development environment available on Azure to enable Work from home. Almost in every customer call I hear about requirement to enable Development Environment on Azure and accessing it from Home laptop/ PC and continue the business. In the era of “Mobile first” almost every big enterprise, every Small and Medium Business (SMB), every Start up company have mobile development teams. They use variety of tools and one of the important IDE used for Mobile development is “Android Studio”. Installing and running Android studio is smooth; however Android emulator installation fails on Azure VM. It is not s07aight forward. In this blog we will see “how to enable Android emulator with Android Studio on Azure VM”. Let’s go! Concept - Android Emulator and VM Acceleration Without a virtualiza...
Read more

Getting Started with Logic Apps - AS2

Image
What is AS2? Every enterprise requires some kind of product, service or counselling from another enterprises thus there happens a B2B(business to business) communications, some of the communication is unique whereas most of the communications are common for most of the enterprises e.g., Purchase Order. But every enterprise has there own way(format) of sending the messages, leading to difficult management when number of partners increased.  Considering this the Enterprise leaders decided to have some standards/rules defined across the communication leading to B2B protocol standards which provide guidelines for trading partners to follow when conducting business between enterprises. EDI X12, EDIFACT, TRADACOM etc. AS2 stands for Applicability Statement 2 and is a B2B messaging protocol used to transmit Electronic Data Interchange (EDI)/Business documents from one organization to another. So EDI standards define how to format data and AS2 specifies how to securely transport...
Read more