I'm consuming a web service through assemblies in a Sql Server 2005 database. The client was made with VB.net 2005. Everything was fine in the deploy phase but once I compile the assembly generated in my sql server database and try to execute
the CLR stored procedure defined in the assembly it crashes throwing the following error:
Error: There was an error generating the XML document.
Inner Exception: Item has already been added. Key in dictionary: 'SqlCifin.InfoComercial.ParametrosConsultaDTO' Key being added: 'SqlCifin.InfoComercial.ParametrosConsultaDTO'
Where SqlCifin is the name of the assembly, InfoComercial is the web reference namespace and ParametrosConsultaDTO is a complex type defined in the WSDL to encapsulate the request parameters.
I tried almost everything but nothing seems to work: Already checked the enviroment variables and .
I would appreciate any help you can provide me.
PD: I'm using WSE 3.0.
View Complete Post