Monday, June 20, 2016

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 retrieving or generating the WSDL.Adapter message: Retrieval 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 :) 


No comments:

Post a Comment