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' "
"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 :)
It's weird but sometimes such things happens :)
If you have questions or suggestions, feel free to do in comments section below !!!
Do share if you find this helpful .......
Knowledge Sharing is Caring !!!!!!