Hi,
I'm trying to consume a web service for the first time. I've managed to create a connection, create synonym from the wsdl file that our .Net developer gave us. I am trying to get sample data using that synonym and I am getting this error:

(FOC44540) SOAP Request got error. Response Status : 500 ; Reason: Internal Server Error
(FOC44541) Faultcode : a:InternalServiceFault
(FOC44542) Faultstring: The server was unable to process the request due to an internal
(FOC44542) Faultstring: error. For more information about the error, either turn on
(FOC44542) Faultstring: IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute
(FOC44542) Faultstring: or from the configuration behavior) on the server in
(FOC44542) Faultstring: order to send the exception information back to the client, or turn
(FOC44542) Faultstring: on tracing as per the Microsoft .NET Framework 3.0 SDK documentation
(FOC44542) Faultstring: and inspect the server trace logs.

I have set the traces on on our WF server including the trace for the web service but no trace files were created.
The servlet and server log files were not helpful at all. The .Net developer does not or could not get a trace on his server.

Then I went to edit the master file in the synonym editor and from there I can drill down to the STARTDATE and ENDDATE.
From there I provided the dates in HYYMDm format like this: 2010/01/01 00:00:00.000000 and 2010/09/15 23:59:59.000000.
Then I click the Sample Data button and I get back the error: (FOC44523) Special field can not be referenced : RESPONSE
I have tried fudging the USAGE=YYMD or HYYMDS in the master file but to no avail. Get the same error above.

Here is the access and master file descriptions I am using:

getproductordersummary.acx

SEGNAME=GETPRODUCTORDERSUMMARY, CONNECTION=CON01, VERSION=1.1,
OBJECT=GetProductOrderSummary,
ACTION=
http://Ops.Mto.Rus.Pris.Servic...tProductOrderSummary
, EMPTYTAGS=ON, TARGETNS=http://Ops.Mto.Rus.Pris.ServiceContract,
STYLE=DOCUMENT, ELEMFORM=qualified, ATTRFORM=unqualified, $


getproductordersummary.mas

FILENAME=M6ILO, SUFFIX=SOAP , $
SEGMENT=GETPRODUCTORDERSUMMARY, SEGTYPE=S0, $
GROUP=GETPRODUCTORDERSUMMARY, ALIAS=GetProductOrderSummary, ELEMENTS=2, $
FIELDNAME=STARTDATE, ALIAS=StartDate, USAGE=HYYMDm, ACTUAL=A35, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=ENDDATE, ALIAS=EndDate, USAGE=HYYMDm, ACTUAL=A35, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=__RESPONSE, USAGE=TX80L, ACTUAL=TX, ACCESS_PROPERTY=(INTERNAL), $
SEGMENT=RESPONSE, SEGTYPE=S0, SEGSUF=XML , PARENT=GETPRODUCTORDERSUMMARY, POSITION=__RESPONSE, $
FIELDNAME=RESPONSE, ALIAS=GetProductOrderSummaryResponse, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), $
FIELDNAME=GETPRODUCTORDERSUMMARYRESULT, ALIAS=GetProductOrderSummaryResult, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL),
REFERENCE=RESPONSE, PROPERTY=ELEMENT, $
FIELDNAME=ISNEW, ALIAS=IsNew, USAGE=A5, ACTUAL=A5,
REFERENCE=GETPRODUCTORDERSUMMARYRESULT, PROPERTY=ELEMENT, $
FIELDNAME=ISDIRTY, ALIAS=IsDirty, USAGE=A5, ACTUAL=A5,
REFERENCE=GETPRODUCTORDERSUMMARYRESULT, PROPERTY=ELEMENT, $
FIELDNAME=ISDELETED, ALIAS=IsDeleted, USAGE=A5, ACTUAL=A5,
REFERENCE=GETPRODUCTORDERSUMMARYRESULT, PROPERTY=ELEMENT, $
FIELDNAME=CVORLEVEL2ABSTRACT, ALIAS=CVORLevel2Abstract, USAGE=I11, ACTUAL=A11,
REFERENCE=GETPRODUCTORDERSUMMARYRESULT, PROPERTY=ELEMENT, $
FIELDNAME=CVORLEVEL1ABSTRACT, ALIAS=CVORLevel1Abstract, USAGE=I11, ACTUAL=A11,
REFERENCE=GETPRODUCTORDERSUMMARYRESULT, PROPERTY=ELEMENT, $
FIELDNAME=CVORDRIVERABSTRACT, ALIAS=CVORDriverAbstract, USAGE=I11, ACTUAL=A11,
REFERENCE=GETPRODUCTORDERSUMMARYRESULT, PROPERTY=ELEMENT, $
FIELDNAME=CARRIERSAFETYRATING, ALIAS=CarrierSafetyRating, USAGE=I11, ACTUAL=A11,
REFERENCE=GETPRODUCTORDERSUMMARYRESULT, PROPERTY=ELEMENT, $
FIELDNAME=EXTENSIONDATA, ALIAS=ExtensionData, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL),
REFERENCE=GETPRODUCTORDERSUMMARYRESULT, PROPERTY=ELEMENT, $

Can someone shed some light on this problem? Is it the RESPONSE in the master file that is incorrectly defined?
Thank you.

Sorry, here is the wsdl file that was used to create connection and synonym. You can see it in a browser. Thanks.

 
  <?xml version="1.0" encoding="utf-8" ?> 
- <wsdl:definitions name="WebFocusReportingService" targetNamespace="http://Ops.Mto.Rus.Pris.ServiceContract" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:wsa10="http://www.w3.org/2005/08/addressing" xmlns:wsx="http://schemas.xmlsoap.org/ws/2004/09/mex" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wsap="http://schemas.xmlsoap.org/ws/2004/08/addressing/policy" xmlns:msc="http://schemas.microsoft.com/ws/2005/12/wsdl/contract" xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:wsam="http://www.w3.org/2007/05/addressing/metadata" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl" xmlns:tns="http://Ops.Mto.Rus.Pris.ServiceContract" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
- <wsdl:types>
- <xsd:schema elementFormDefault="qualified" targetNamespace="http://Ops.Mto.Rus.Pris.ServiceContract">
- <xsd:element name="GetProductOrderSummary">
- <xsd:complexType>
- <xsd:sequence>
  <xsd:element minOccurs="1" maxOccurs="1" name="StartDate" type="xsd:dateTime" /> 
  <xsd:element minOccurs="1" maxOccurs="1" name="EndDate" type="xsd:dateTime" /> 
  </xsd:sequence>
  </xsd:complexType>
  </xsd:element>
- <xsd:element name="GetProductOrderSummaryResponse">
- <xsd:complexType>
- <xsd:sequence>
  <xsd:element minOccurs="0" maxOccurs="1" name="GetProductOrderSummaryResult" type="tns:ProductOrderSummary" /> 
  </xsd:sequence>
  </xsd:complexType>
  </xsd:element>
- <xsd:complexType name="ProductOrderSummary">
- <xsd:complexContent mixed="false">
- <xsd:extension base="tns:BusinessEntityBase">
- <xsd:sequence>
  <xsd:element minOccurs="1" maxOccurs="1" name="CVORLevel2Abstract" type="xsd:int" /> 
  <xsd:element minOccurs="1" maxOccurs="1" name="CVORLevel1Abstract" type="xsd:int" /> 
  <xsd:element minOccurs="1" maxOccurs="1" name="CVORDriverAbstract" type="xsd:int" /> 
  <xsd:element minOccurs="1" maxOccurs="1" name="CarrierSafetyRating" type="xsd:int" /> 
  <xsd:element minOccurs="0" maxOccurs="1" name="ExtensionData" type="tns:ExtensionDataObject" /> 
  </xsd:sequence>
  </xsd:extension>
  </xsd:complexContent>
  </xsd:complexType>
- <xsd:complexType name="BusinessEntityBase" abstract="true">
- <xsd:complexContent mixed="false">
  <xsd:extension base="tns:PersistanceControl" /> 
  </xsd:complexContent>
  </xsd:complexType>
- <xsd:complexType name="PersistanceControl">
- <xsd:sequence>
  <xsd:element minOccurs="1" maxOccurs="1" name="IsNew" type="xsd:boolean" /> 
  <xsd:element minOccurs="1" maxOccurs="1" name="IsDirty" type="xsd:boolean" /> 
  <xsd:element minOccurs="1" maxOccurs="1" name="IsDeleted" type="xsd:boolean" /> 
  </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="ExtensionDataObject" /> 
  </xsd:schema>
- <xsd:schema elementFormDefault="qualified" targetNamespace="http://schemas.datacontract.org/2004/07/Ops.Mto.Rus.Pris.Common.PrisException" xmlns:tns="http://schemas.datacontract.org/2004/07/Ops.Mto.Rus.Pris.Common.PrisException">
- <xsd:complexType name="PrisValidationFault">
- <xsd:complexContent mixed="false">
- <xsd:extension base="tns:PrisBusinessFault">
- <xsd:sequence>
  <xsd:element minOccurs="0" name="ValidationResults" nillable="true" type="q1:ValidationResults" xmlns:q1="http://schemas.datacontract.org/2004/07/Microsoft.Practices.EnterpriseLibrary.Validation" /> 
  </xsd:sequence>
  </xsd:extension>
  </xsd:complexContent>
  </xsd:complexType>
  <xsd:element name="PrisValidationFault" nillable="true" type="tns:PrisValidationFault" /> 
- <xsd:complexType name="PrisBusinessFault">
- <xsd:complexContent mixed="false">
- <xsd:extension base="tns:PrisBaseFault">
- <xsd:sequence>
  <xsd:element minOccurs="0" name="ExtensionData" nillable="true" type="q2:ArrayOfKeyValueOfstringanyType" xmlns:q2="http://schemas.microsoft.com/2003/10/Serialization/Arrays" /> 
  </xsd:sequence>
  </xsd:extension>
  </xsd:complexContent>
  </xsd:complexType>
  <xsd:element name="PrisBusinessFault" nillable="true" type="tns:PrisBusinessFault" /> 
- <xsd:complexType name="PrisBaseFault">
- <xsd:sequence>
  <xsd:element minOccurs="0" name="ErrorCode" nillable="true" type="xsd:string" /> 
  <xsd:element minOccurs="0" name="Message" nillable="true" type="xsd:string" /> 
  </xsd:sequence>
  </xsd:complexType>
  <xsd:element name="PrisBaseFault" nillable="true" type="tns:PrisBaseFault" /> 
- <xsd:complexType name="PrisTechnicalFault">
- <xsd:complexContent mixed="false">
- <xsd:extension base="tns:PrisBaseFault">
  <xsd:sequence /> 
  </xsd:extension>
  </xsd:complexContent>
  </xsd:complexType>
  <xsd:element name="PrisTechnicalFault" nillable="true" type="tns:PrisTechnicalFault" /> 
  </xsd:schema>
- <xsd:schema elementFormDefault="qualified" targetNamespace="http://schemas.datacontract.org/2004/07/Microsoft.Practices.EnterpriseLibrary.Validation" xmlns:tns="http://schemas.datacontract.org/2004/07/Microsoft.Practices.EnterpriseLibrary.Validation">
- <xsd:complexType name="ValidationResults">
- <xsd:sequence>
  <xsd:element name="validationResults" nillable="true" type="tns:ArrayOfValidationResult" /> 
  </xsd:sequence>
  </xsd:complexType>
  <xsd:element name="ValidationResults" nillable="true" type="tns:ValidationResults" /> 
- <xsd:complexType name="ArrayOfValidationResult">
- <xsd:sequence>
  <xsd:element minOccurs="0" maxOccurs="unbounded" name="ValidationResult" nillable="true" type="tns:ValidationResult" /> 
  </xsd:sequence>
  </xsd:complexType>
  <xsd:element name="ArrayOfValidationResult" nillable="true" type="tns:ArrayOfValidationResult" /> 
- <xsd:complexType name="ValidationResult">
- <xsd:sequence>
  <xsd:element name="key" nillable="true" type="xsd:string" /> 
  <xsd:element name="message" nillable="true" type="xsd:string" /> 
  <xsd:element name="nestedValidationResults" nillable="true" type="tns:ArrayOfValidationResult" /> 
  <xsd:element name="tag" nillable="true" type="xsd:string" /> 
  </xsd:sequence>
  </xsd:complexType>
  <xsd:element name="ValidationResult" nillable="true" type="tns:ValidationResult" /> 
  </xsd:schema>
- <xsd:schema elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:tns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
- <xsd:complexType name="ArrayOfKeyValueOfstringanyType">
- <xsd:annotation>
- <xsd:appinfo>
  <IsDictionary xmlns="http://schemas.microsoft.com/2003/10/Serialization/">true</IsDictionary> 
  </xsd:appinfo>
  </xsd:annotation>
- <xsd:sequence>
- <xsd:element minOccurs="0" maxOccurs="unbounded" name="KeyValueOfstringanyType">
- <xsd:complexType>
- <xsd:sequence>
  <xsd:element name="Key" nillable="true" type="xsd:string" /> 
  <xsd:element name="Value" nillable="true" type="xsd:anyType" /> 
  </xsd:sequence>
  </xsd:complexType>
  </xsd:element>
  </xsd:sequence>
  </xsd:complexType>
  <xsd:element name="ArrayOfKeyValueOfstringanyType" nillable="true" type="tns:ArrayOfKeyValueOfstringanyType" /> 
  </xsd:schema>
- <xs:schema attributeFormDefault="qualified" elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/2003/10/Serialization/" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://schemas.microsoft.com/2003/10/Serialization/">
  <xs:element name="anyType" nillable="true" type="xs:anyType" /> 
  <xs:element name="anyURI" nillable="true" type="xs:anyURI" /> 
  <xs:element name="base64Binary" nillable="true" type="xs:base64Binary" /> 
  <xs:element name="boolean" nillable="true" type="xs:boolean" /> 
  <xs:element name="byte" nillable="true" type="xs:byte" /> 
  <xs:element name="dateTime" nillable="true" type="xs:dateTime" /> 
  <xs:element name="decimal" nillable="true" type="xs:decimal" /> 
  <xs:element name="double" nillable="true" type="xs:double" /> 
  <xs:element name="float" nillable="true" type="xs:float" /> 
  <xs:element name="int" nillable="true" type="xs:int" /> 
  <xs:element name="long" nillable="true" type="xs:long" /> 
  <xs:element name="QName" nillable="true" type="xs:QName" /> 
  <xs:element name="short" nillable="true" type="xs:short" /> 
  <xs:element name="string" nillable="true" type="xs:string" /> 
  <xs:element name="unsignedByte" nillable="true" type="xs:unsignedByte" /> 
  <xs:element name="unsignedInt" nillable="true" type="xs:unsignedInt" /> 
  <xs:element name="unsignedLong" nillable="true" type="xs:unsignedLong" /> 
  <xs:element name="unsignedShort" nillable="true" type="xs:unsignedShort" /> 
  <xs:element name="char" nillable="true" type="tns:char" /> 
- <xs:simpleType name="char">
  <xs:restriction base="xs:int" /> 
  </xs:simpleType>
  <xs:element name="duration" nillable="true" type="tns:duration" /> 
- <xs:simpleType name="duration">
- <xs:restriction base="xs:duration">
  <xs:pattern value="\-?P(\d*D)?(T(\d*H)?(\d*M)?(\d*(\.\d*)?S)?)?" /> 
  <xs:minInclusive value="-P10675199DT2H48M5.4775808S" /> 
  <xs:maxInclusive value="P10675199DT2H48M5.4775807S" /> 
  </xs:restriction>
  </xs:simpleType>
  <xs:element name="guid" nillable="true" type="tns:guid" /> 
- <xs:simpleType name="guid">
- <xs:restriction base="xs:string">
  <xs:pattern value="[\da-fA-F]{8}-[\da-fA-F]{4}-[\da-fA-F]{4}-[\da-fA-F]{4}-[\da-fA-F]{12}" /> 
  </xs:restriction>
  </xs:simpleType>
  <xs:attribute name="FactoryType" type="xs:QName" /> 
  <xs:attribute name="Id" type="xs:ID" /> 
  <xs:attribute name="Ref" type="xs:IDREF" /> 
  </xs:schema>
  </wsdl:types>
- <wsdl:message name="IWebFocusReportingService_GetProductOrderSummary_InputMessage">
  <wsdl:part name="parameters" element="tns:GetProductOrderSummary" /> 
  </wsdl:message>
- <wsdl:message name="IWebFocusReportingService_GetProductOrderSummary_OutputMessage">
  <wsdl:part name="parameters" element="tns:GetProductOrderSummaryResponse" /> 
  </wsdl:message>
- <wsdl:message name="IWebFocusReportingService_GetProductOrderSummary_PrisValidationFaultFault_FaultMessage">
  <wsdl:part name="detail" element="q3:PrisValidationFault" xmlns:q3="http://schemas.datacontract.org/2004/07/Ops.Mto.Rus.Pris.Common.PrisException" /> 
  </wsdl:message>
- <wsdl:message name="IWebFocusReportingService_GetProductOrderSummary_PrisBusinessFaultFault_FaultMessage">
  <wsdl:part name="detail" element="q4:PrisBusinessFault" xmlns:q4="http://schemas.datacontract.org/2004/07/Ops.Mto.Rus.Pris.Common.PrisException" /> 
  </wsdl:message>
- <wsdl:message name="IWebFocusReportingService_GetProductOrderSummary_PrisTechnicalFaultFault_FaultMessage">
  <wsdl:part name="detail" element="q5:PrisTechnicalFault" xmlns:q5="http://schemas.datacontract.org/2004/07/Ops.Mto.Rus.Pris.Common.PrisException" /> 
  </wsdl:message>
- <wsdl:portType name="IWebFocusReportingService">
- <wsdl:operation name="GetProductOrderSummary">
  <wsdl:input wsaw:Action="http://Ops.Mto.Rus.Pris.ServiceContract/IWebFocusReportingService/GetProductOrderSummary" message="tns:IWebFocusReportingService_GetProductOrderSummary_InputMessage" /> 
  <wsdl:output wsaw:Action="http://Ops.Mto.Rus.Pris.ServiceContract/IWebFocusReportingService/GetProductOrderSummaryResponse" message="tns:IWebFocusReportingService_GetProductOrderSummary_OutputMessage" /> 
  <wsdl:fault wsaw:Action="http://Ops.Mto.Rus.Pris.ServiceContract/IWebFocusReportingService/GetProductOrderSummaryPrisValidationFaultFault" name="PrisValidationFaultFault" message="tns:IWebFocusReportingService_GetProductOrderSummary_PrisValidationFaultFault_FaultMessage" /> 
  <wsdl:fault wsaw:Action="http://Ops.Mto.Rus.Pris.ServiceContract/IWebFocusReportingService/GetProductOrderSummaryPrisBusinessFaultFault" name="PrisBusinessFaultFault" message="tns:IWebFocusReportingService_GetProductOrderSummary_PrisBusinessFaultFault_FaultMessage" /> 
  <wsdl:fault wsaw:Action="http://Ops.Mto.Rus.Pris.ServiceContract/IWebFocusReportingService/GetProductOrderSummaryPrisTechnicalFaultFault" name="PrisTechnicalFaultFault" message="tns:IWebFocusReportingService_GetProductOrderSummary_PrisTechnicalFaultFault_FaultMessage" /> 
  </wsdl:operation>
  </wsdl:portType>
- <wsdl:binding name="Ops.Mto.Rus.Pris.WCFService.WebFocusReportingService" type="tns:IWebFocusReportingService">
  <soap:binding transport="http://schemas.xmlsoap.org/soap/http" /> 
- <wsdl:operation name="GetProductOrderSummary">
  <soap:operation soapAction="http://Ops.Mto.Rus.Pris.ServiceContract/IWebFocusReportingService/GetProductOrderSummary" style="document" /> 
- <wsdl:input>
  <soap:body use="literal" /> 
  </wsdl:input>
- <wsdl:output>
  <soap:body use="literal" /> 
  </wsdl:output>
- <wsdl:fault name="PrisValidationFaultFault">
  <soap:fault name="PrisValidationFaultFault" use="literal" /> 
  </wsdl:fault>
- <wsdl:fault name="PrisBusinessFaultFault">
  <soap:fault name="PrisBusinessFaultFault" use="literal" /> 
  </wsdl:fault>
- <wsdl:fault name="PrisTechnicalFaultFault">
  <soap:fault name="PrisTechnicalFaultFault" use="literal" /> 
  </wsdl:fault>
  </wsdl:operation>
  </wsdl:binding>
- <wsdl:service name="WebFocusReportingService">
- <wsdl:port name="Ops.Mto.Rus.Pris.WCFService.WebFocusReportingService" binding="tns:Ops.Mto.Rus.Pris.WCFService.WebFocusReportingService">
  <soap:address location="http://etcbitdcapmdw41.cihs.ad.gov.on.ca:7080/WebFocusReportService.svc" /> 
  </wsdl:port>
  </wsdl:service>
  </wsdl:definitions>

This message has been edited. Last edited by: Kerry,

Hi all,

FYI, Adrian already has a case opened regarding this issue and is currently in research.

Adrian, when you have an update/progress from the case, can you kindly post it here? This way we can keep the info for future reference. Thank you in advance for sharing with all.

Cheers,

Kerry

Hi Kerry,
Can you please remove my posting from the website? I have been asked to remove it immediately by my manager because it does not meet the guidelines for publishing government information. I have deleted what I could except for this last part.
Thank you.

Dear All, have you solved this issue? I am getting error
FOC44523) Special field can not be referenced : RESPONSE
when try to read webservice.

Thank you for your update

ok. I understood what is a problem. Reading webservice I was doing

TABLE FILE WEBSERVICENAME
PRINT *
WHERE PARAM='lll'
END
-RUN


As result all 'internal' fields where asked to be printed. When I wrote real names instead of * then my procedure start to work fine.

Now I will go to look how to make correct mas file. Because now all my data are in one column (STRING)