Strange error when importing service

Topics: Technical Questions
Jul 31, 2009 at 12:47 PM

What could be the problem when importing a service ("Virtualize Service Operations")?

---------------------------
Import Service
---------------------------
An error occurred while loading the wizard page [Procedure or function 'GetIDFromName' expects parameter '@EntityName', which was not supplied.]
---------------------------
OK   
---------------------------

 

Thanks.

Jul 31, 2009 at 1:21 PM

Hi,

I think you could try tracing the SQL traffic (and look for a call with a missing parameter), as GetIDFromName is one of the stored procedures MSE uses to access the database. Pasting the stored proc below.

 

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [ServiceEngine].[GetIDFromName]
@EntityName NVARCHAR (400), @EntityTypeID INT, @EntityID UNIQUEIDENTIFIER OUTPUT
AS
BEGIN
SET NOCOUNT ON

SELECT @EntityID = N.EntityID
FROM ServiceEngine.Names N
WHERE N.EntityTypeID = @EntityTypeID
AND N.EntityName = @EntityName
END

 

Best regards,

Henrik Gundersen

 

Developer
Aug 4, 2009 at 10:34 PM

Can you see the log for more detailed error and post those to the forum? This seems to be a mismatch between the DB and the code. What version of MSE are you using?

Thanks

Aug 27, 2009 at 5:51 PM

We are having the same problem here on MSE 7.0. Model Viewer shows 7.1.33.0. And here is the event log. Thanks

Event Type: Error
Event Source: MSE Service Catalog
Event Category: None
Event ID: 0
Date:  8/27/2009
Time:  10:33:31 AM
User:  N/A
Computer: xxxxxxx
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.

Developer
Aug 27, 2009 at 6:09 PM

Will it be possible to post your WSDL to the DL?

Aug 27, 2009 at 6:38 PM

DL is complaining it is too long, it is a fairly large wsdl. Is there other way I can send it to you?

Aug 27, 2009 at 6:46 PM

This one is a bit smaller, same error, see if it goes. Thanks

<?xml version="1.0" encoding="utf-8"?>
<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:i0="http://focus.ca/EI_JobService" xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:wsap="http://schemas.xmlsoap.org/ws/2004/08/addressing/policy" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msc="http://schemas.microsoft.com/ws/2005/12/wsdl/contract" xmlns:tns="http://tempuri.org/" 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:wsam="http://www.w3.org/2007/05/addressing/metadata" name="JobService" targetNamespace="http://tempuri.org/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
  <wsp:Policy wsu:Id="NetTcpBinding_IJobService_policy">
    <wsp:ExactlyOne>
      <wsp:All>
        <msb:BinaryEncoding xmlns:msb="http://schemas.microsoft.com/ws/06/2004/mspolicy/netbinary1">
        </msb:BinaryEncoding>
        <wsaw:UsingAddressing>
        </wsaw:UsingAddressing>
      </wsp:All>
    </wsp:ExactlyOne>
  </wsp:Policy>
  <wsdl:import namespace="http://focus.ca/EI_JobService" location="" />
  <wsdl:types />
  <wsdl:binding name="NetTcpBinding_IJobService" type="i0:IJobService">
    <wsp:PolicyReference URI="#NetTcpBinding_IJobService_policy">
    </wsp:PolicyReference>
    <soap12:binding transport="http://schemas.microsoft.com/soap/tcp" />
    <wsdl:operation name="GetDrawings">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetDrawings" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="SaveDrawing">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/SaveDrawing" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetTitleBlockJobInfo">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetTitleBlockJobInfo" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetLegacyJobNumberByJobId">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetLegacyJobNumberByJobId" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetMaxBulkAddByUserName">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetMaxBulkAddByUserName" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetHomesiteJobs">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetHomesiteJobs" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetLegalPlansByJobNumber">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetLegalPlansByJobNumber" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetLegalPlanStatusHistory">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetLegalPlanStatusHistory" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetLegalPlanCommentHistory">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetLegalPlanCommentHistory" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobInformationHeaderByJobId">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobInformationHeaderByJobId" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="SaveLegalPlans">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/SaveLegalPlans" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetWhiteboardResultsFor">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetWhiteboardResultsFor" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobInformationByJobNumber">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobInformationByJobNumber" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetLockedJobs">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetLockedJobs" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="SaveJobsWhiteBoardComments">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/SaveJobsWhiteBoardComments" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetWhiteBoardSearchTemplatesFor">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetWhiteBoardSearchTemplatesFor" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="SaveWhiteBoardTemplate">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/SaveWhiteBoardTemplate" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="DeleteWhiteBoardTemplate">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/DeleteWhiteBoardTemplate" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="IsJobLocked">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/IsJobLocked" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetPerformanceResultsFor">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetPerformanceResultsFor" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="DrafterDailyLogExists">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/DrafterDailyLogExists" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetDrafterDailyLog">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetDrafterDailyLog" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="InsertDrafterDailyLog">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/InsertDrafterDailyLog" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="DeleteDrawing">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/DeleteDrawing" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetLookUpListByType">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetLookUpListByType" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobSubTypeListByJobType">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobSubTypeListByJobType" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetActivityListByJobType">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetActivityListByJobType" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobTypes">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobTypes" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetTopClientsByOrganizationCode">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetTopClientsByOrganizationCode" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetLegalFormatByJobTypeAndLocation">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetLegalFormatByJobTypeAndLocation" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetLegalTypeByJobSubType">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetLegalTypeByJobSubType" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetOtherContactsByJob">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetOtherContactsByJob" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="SaveJob">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/SaveJob" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJob">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJob" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobIdByNumbers">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobIdByNumbers" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetRevisionsByNumber">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetRevisionsByNumber" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="AddDataMartJob">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/AddDataMartJob" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="AddDataMartJobHistoryEvent">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/AddDataMartJobHistoryEvent" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="AppendJobNumber">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/AppendJobNumber" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="IsValidLookupValue">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/IsValidLookupValue" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="UnlockJob">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/UnlockJob" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="TransalateToBSTCode">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/TransalateToBSTCode" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="TranslateMarketSegmentCode">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/TranslateMarketSegmentCode" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="SearchJobsBy">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/SearchJobsBy" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobIdListFor">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobIdListFor" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetSearchResultsFor">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetSearchResultsFor" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetLegalReportFormat">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetLegalReportFormat" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobHistoryEventTypeList">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobHistoryEventTypeList" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobBookRoles">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobBookRoles" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetPermissionsByRole">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetPermissionsByRole" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobStatusByJobId">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobStatusByJobId" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetConsolidatedJobViewJobByJobId">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetConsolidatedJobViewJobByJobId" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetConsolidatedLegalDescriptionsViewJobByJobId">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetConsolidatedLegalDescriptionsViewJobByJobId" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetConsolidatedContactsViewJobByJobId">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetConsolidatedContactsViewJobByJobId" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="AddJobHistoryEvent">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/AddJobHistoryEvent" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
    <wsdl:operation name="GetJobRevisions">
      <soap12:operation soapAction="http://focus.ca/EI_JobService/IJobService/GetJobRevisions" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
      <wsdl:fault name="DefaultFaultContractFault">
        <soap12:fault use="literal" name="DefaultFaultContractFault" namespace="" />
      </wsdl:fault>
    </wsdl:operation>
  </wsdl:binding>
  <wsdl:service name="JobService">
    <wsdl:port name="NetTcpBinding_IJobService" binding="tns:NetTcpBinding_IJobService">
      <soap12:address location="net.tcp://localhost:8880/Design_Time_Addresses/EI_JobService/" />
      <wsa10:EndpointReference>
        <wsa10:Address>net.tcp://localhost:8880/Design_Time_Addresses/EI_JobService/</wsa10:Address>
        <Identity xmlns="http://schemas.xmlsoap.org/ws/2006/02/addressingidentity">
          <Dns>localhost</Dns>
        </Identity>
      </wsa10:EndpointReference>
    </wsdl:port>
  </wsdl:service>
</wsdl:definitions>

Developer
Aug 27, 2009 at 7:30 PM

Can you provide soem information:

How did you build this web service? Is it one of the BizTalk ESB related service?

Aug 27, 2009 at 8:04 PM

It is a WCF service library we built using Visual Studio 2008, on .NET Framework 3.5. It is hosted on netTcpBinding, (although wsHttpBinding causes same error, I tried, it seems not related).

Error occurs when clicking Next button after selecting any one of the three options on Select Metadata screen.

I typical interface looks like this:

<OperationContract(), FaultContract(GetType(DefaultFaultContract))> _
Function GetJob(ByVal JobId As Integer) As JobDTO

And the operation looks like this:

Public Function GetJob(ByVal JobId As Integer) As DTO.JobDTO Implements IJobService.GetJob
        Try
            Return _daJobService.GetJob(JobId)
        Catch ex As Exception
            Throw New FaultException(Of DefaultFaultContract)(New DefaultFaultContract(ex), ex.Message)
        End Try
End Function

Data Contract: (data contracts contain dataset and simple data types)

<DataContract()> _
Public Class JobDTO
    Inherits BaseDTO

End Class

Developer
Aug 31, 2009 at 5:28 PM

Thanks a lot for working with us in troubleshooting this issue. 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.

Oct 13, 2009 at 1:24 AM

I have the same issue. How is that fix coming along?

Dec 2, 2009 at 11:05 PM

It has been nearly 2 months since I last posted asking for an update. Have you made any progress with this?

Coordinator
Dec 21, 2009 at 4:32 PM

Yes, this issue has been addressed in the December release which just went live.  Let us know if for some reason you are still having this issue.

Jan 13, 2010 at 9:40 PM

I just ran into this problem (and one of our service methods returns an object derived from a DataSet).  And I'm using the December release.

Let me know what further information you might need....

 

-Mark-

Coordinator
Jan 27, 2010 at 5:22 PM

Can you provide the WSDL for your service?

Jan 29, 2010 at 4:43 PM

Sure, here's a link to a zip file containing the results from the disco command:

http://markjh-public.s3.amazonaws.com/BatchExportService.zip

Another interesting problem I've run into that maybe you could help me with.....

We're having an issue exposing another entity (an EDM entity) - MSE is giving the following error:

MseEndpointResolver: Cannot import wsdl:portType
Detail: An exception was thrown while running a WSDL import extension: System.ServiceModel.Description.XmlSerializerMessageContractImporter
Error: Member OrganizationApplicationAttribute.Id of type System.Int32 hides base class member StructuralObject.Id of type System.String. Use XmlElementAttribute or XmlAttributeAttribute to specify a new name.
XPath to Error Source: //wsdl:definitions[@targetNamespace='http://services.microsoft.com/MSE/svc_AvidXchange.Services']/wsdl:portType[@name='svc_AvidXchange.Services'] for endpoint net.tcp://dataservices/AvidXchange.Services/NetTCPInternal

It appears as though there's an inheritance issue of some sort, of course, but MSE seems to be the only thing that has a problem with it.  Both a C# client and BizTalk don't have a problem with it (for what that's worth).  The WSDL for that service is available at:

http://markjh-public.s3.amazonaws.com/BuyerService.zip

 

Thanks for your help!

Jan 29, 2010 at 4:44 PM

By the way, let me know when you get those files so I can take them offline at some point :)

Thanks!

 

Developer
Jan 31, 2010 at 6:11 PM

I have downloaed both the WSDLs. You can take those offline.

Feb 10, 2010 at 3:58 PM

Any update on this, by chance?

 

-Mark-

Developer
Feb 10, 2010 at 10:02 PM

Hi Mark,

Here is the update:

BuyerService: I was able to import the WSDL without any issue.

BatchExportService: I was unable to import the WSDL at first but then I was to find a workaround. It seems that schema file 'BatchExportService3.xsd' which contains xsd:any is an issue. So if you do a file-based import and ignore this schema file, then the import should work fine.

Please let me know if you do see otherwise.

Nvaeed

Feb 10, 2010 at 10:18 PM

In regards to the BuyerService... I forgot to mention an important point.  MSE actually imports it fine - only when I try to expose an endpoint that makes use of that entity does it have problems.  At that point, the runtime gives an error when it tries to start that it couldn't create the endpoint.

We'll try the BatchExportService workaround and see how it goes.

Thanks for your help!

 

-Mark-

Developer
Feb 10, 2010 at 10:50 PM

For the BuyerServer, please do the following:

1. Go to the ModelViewer

2. Go to Endpoint pane and select the Endpoint that you are exposing this service to browse the details

3. Uncheck the Wrap Message checkbox

This should fix the issue.

Feb 11, 2010 at 8:44 PM

I haven't tried the workaround for the DataSet yet.

However, the "Wrap Message" checkbox is already unchecked on the endpoint that is triyng to expose the BuyerProfile entity.  And I'm still getting that error....

 

-Mark-

 

Developer
Feb 12, 2010 at 4:50 AM

Just to confirm, is BuyerProfile th eonly service operation hosted at that Endpoint. If that is the case, can you remove other operations and see if the problem goes away?

Naveed

Feb 12, 2010 at 3:48 PM

I moved the operation to its own endpoint and it is still giving me problems.  The state of the Wrap Message checkbox doesn't seem to make any difference...

 

-Mark-

 

Feb 12, 2010 at 8:55 PM

Ok, back to the batching service that uses the DataSet....

I got the schemas imported and started creating all the operations and endpoints.  Unfortunately, when it comes to the endpoint that returns the DataSet, I've run into problems.  MSE throws this error:

Error in Broker delegate: The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.stack trace:
Server stack trace:
   at System.ServiceModel.AsyncResult.End[TAsyncResult](IAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.EndRequest(IAsyncResult result)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at System.ServiceModel.Channels.IRequestChannel.EndRequest(IAsyncResult result)
   at Microsoft.MSE.Runtime.Services.Broker.BrokerServiceInstance.<>c__DisplayClass3`1.<InnerProcessMessage>b__0(IAsyncResult result)

Everything looks to be set up correctly - the request and response contracts on the operation and the resource are correct.  And everything is associated correctly from end to end.

 

-Mark-

Feb 12, 2010 at 9:02 PM

Oh, I was wrong - this is the "FetchBatch" operation, which returns a serialized object....

 

-Mark-

 

Feb 12, 2010 at 9:58 PM

Ok, one last update - turns out the previous error was due to message sizes being wrong - I had to increase the maxReceivedMessageSize on the various bindings and that fixed the problem.

So far so good on the whole Batching service now!  Thanks a lot for your help!

 

-Mark-

 

Feb 25, 2010 at 7:57 PM

It is still an issue. Any updates on how to fix it.

Once again, here is the error:

MseEndpointResolver: Cannot import wsdl:portType

Detail: An exception was thrown while running a WSDL import extension: System.ServiceModel.Description.XmlSerializerMessageContractImporter

Error: Member ContactProfile.Id of type System.Int32 hides base class member StructuralObject.Id of type System.String. Use XmlElementAttribute or XmlAttributeAttribute to specify a new name.

XPath to Error Source: //wsdl:definitions[@targetNamespace='http://services.microsoft.com/MSE/svc_BuyerService']/wsdl:portType[@name='svc_BuyerService'] for endpoint http://localhost:88/BuyerService

The Id member its refering to defined on the Complex Type "StructuralObject" as

<xs:complexType>
    <xs:sequence>
    </xs:sequence>
   <xs:attribute ref="q1:Id" xmlns:q1="http://schemas.microsoft.com/2003/10/Serialization/">
    </xs:attribute>
    <xs:attribute ref="q2:Ref" xmlns:q2="http://schemas.microsoft.com/2003/10/Serialization/">
    </xs:attribute>
  </xs:complexType>

I have the same set of schemas loaded in BizTalk and the endpoints are working fine.

Developer
Mar 16, 2010 at 2:15 PM

I have tried the archive file that you sent but unfortunatley, I am unable to repro your issue.

Can you please make sure that:

For the BuyerServer, please do the following:

1. Go to the ModelViewer

2. Go to Endpoint pane and select the Endpoint that you are exposing this service to browse the details

3. Uncheck the Wrap Message checkbox

4. Click on Apply to save changes

5. Try to restart the mSE Runtime Service just to ensure that chanegs have taken effect

This should fix the issue

Mar 16, 2010 at 8:17 PM

The Wrap Message checkbox is already unchecked. Do you want me to send the files again?