This project is read-only.

Importing webservices that return datasets

Aug 31, 2009 at 9:59 AM

Hi,

I'm trying to import various types of web services into the MSE. 

When I try to import a webservice that returns a dataset I get this error:

"The 'http://www.w3.org/2001/XMLSchema:schema' element is not declared"

Does MSE not support datasets?  Is this a known issue?

Thanks,
Bragi

Aug 31, 2009 at 5:29 PM

We have been able to pinpoint the cause of the problem and it is related to the use of Datasets as the input/return parameters for a web service. Please stay tuned and we will keep you posted once a fix is available.

Aug 19, 2010 at 5:21 PM

Has this issue been resolved?

I am having trouble importing a web service that uses datasets.  This is in MSE 7.5 (x86).

Thanks.

Aug 20, 2010 at 11:11 PM

This issue shodul have been resolved. Can you please post the error log?

Aug 24, 2010 at 2:37 PM

When importing using the URL I get this error.

Event Type:    Error
Event Source:    MSE Service Catalog
Event Category:    None
Event ID:    0
Date:        8/24/2010
Time:        9:12:56 AM
User:        N/A
Computer:    DEV2-TEST
Description:
An unexpected error occurred in Catalog Service Operation [GetIDFromName]. Error Detail [Exception Information Type[SqlException] Source[.Net SqlClient Data Provider] Message[Procedure or function 'GetIDFromName' expects parameter '@EntityName', which was not supplied.] StackTrace[   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.MSE.Catalog.Module.Data.Entity.GetIDFromName(String entityName, EntityClass entityClass, SqlTransaction txn, SqlConnection conn)
   at Microsoft.MSE.Catalog.Module.Business.EntityManager.GetIDFromName(String entityName, EntityClass entityClass, SqlTransaction txn, SqlConnection conn)
   at Microsoft.MSE.Catalog.Module.Services.ServiceModel.GetIDFromName(GetIDFromNameRequest request)]]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

When importing from an XML file, I get these errors....

Event Type:    Warning
Event Source:    MSE Model Viewer
Event Category:    None
Event ID:    0
Date:        8/24/2010
Time:        9:16:36 AM
User:        N/A
Computer:    DEV2-TEST
Description:
Zero EndPoints imported from this service metadata

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

-------------------------

Event Type:    Warning
Event Source:    MSE Model Viewer
Event Category:    None
Event ID:    0
Date:        8/24/2010
Time:        9:16:36 AM
User:        N/A
Computer:    DEV2-TEST
Description:
There are zero operations found in the service metadata

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

------------------------

Event Type:    Error
Event Source:    MSE Model Viewer
Event Category:    None
Event ID:    0
Date:        8/24/2010
Time:        9:16:41 AM
User:        N/A
Computer:    DEV2-TEST
Description:
Failed to import service due to Error [Exception Information Type[ArgumentNullException] Source[Microsoft.MSE.Tools.MetadataLoader.Module] Message[ServiceOperation collection is either null or empty
Parameter name: serviceOperations] StackTrace[   at Microsoft.MSE.Tools.MetadataLoader.Module.ServiceImporter.ImportService(List`1 serviceOperations, ImportLevelType levelType)]]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

WSDL

<?xml version="1.0" encoding="utf-8"?>
<wsdl:definitions name="Service1" targetNamespace="http://tempuri.org/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:wsam="http://www.w3.org/2007/05/addressing/metadata" xmlns:tns="http://tempuri.org/" xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wsap="http://schemas.xmlsoap.org/ws/2004/08/addressing/policy" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msc="http://schemas.microsoft.com/ws/2005/12/wsdl/contract" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:wsa10="http://www.w3.org/2005/08/addressing" xmlns:wsx="http://schemas.xmlsoap.org/ws/2004/09/mex">
    <wsdl:types>
        <xsd:schema targetNamespace="http://tempuri.org/Imports">
            <xsd:import schemaLocation="http://dev2-test/PeteService/Service1.svc?xsd=xsd0" namespace="http://tempuri.org/" />
            <xsd:import schemaLocation="http://dev2-test/PeteService/Service1.svc?xsd=xsd1" namespace="http://schemas.microsoft.com/2003/10/Serialization/" />
            <xsd:import schemaLocation="http://dev2-test/PeteService/Service1.svc?xsd=xsd2" />
        </xsd:schema>
    </wsdl:types>
    <wsdl:message name="IService1_Test_InputMessage">
        <wsdl:part name="parameters" element="tns:Test" />
    </wsdl:message>
    <wsdl:message name="IService1_Test_OutputMessage">
        <wsdl:part name="parameters" element="tns:TestResponse" />
    </wsdl:message>
    <wsdl:portType name="IService1">
        <wsdl:operation name="Test">
            <wsdl:input wsaw:Action="http://tempuri.org/IService1/Test" message="tns:IService1_Test_InputMessage" />
            <wsdl:output wsaw:Action="http://tempuri.org/IService1/TestResponse" message="tns:IService1_Test_OutputMessage" />
        </wsdl:operation>
    </wsdl:portType>
    <wsdl:binding name="BasicHttpBinding_IService1" type="tns:IService1">
        <soap:binding transport="http://schemas.xmlsoap.org/soap/http" />
        <wsdl:operation name="Test">
            <soap:operation soapAction="http://tempuri.org/IService1/Test" style="document" />
            <wsdl:input>
                <soap:body use="literal" />
            </wsdl:input>
            <wsdl:output>
                <soap:body use="literal" />
            </wsdl:output>
        </wsdl:operation>
    </wsdl:binding>
    <wsdl:service name="Service1">
        <wsdl:port name="BasicHttpBinding_IService1" binding="tns:BasicHttpBinding_IService1">
            <soap:address location="http://dev2-test/PeteService/Service1.svc" />
        </wsdl:port>
    </wsdl:service>
</wsdl:definitions>

Aug 24, 2010 at 9:39 PM

Taking it offline.