HTTP/1.1 500 Internal Server Error
Connection: close
Date: Fri, 03 Sep 2010 07:15:04 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
X-AspNet-Version: 2.0.50727
Cache-Control: private
Content-Type: text/xml; charset=utf-8
Content-Length: 2337
soap:ServerSystem.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Aff_tbAffiliateCreative_Aff_tbCreative". The conflict occurred in database "gwages", table "dbo.Aff_tbCreative", column 'ctvId'.
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
The statement has been terminated.
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.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at GWWebServices.affiliate.AffiliateTracking(String AffId, String CtvId) in D:\www\GWWebServices\GWWebServices\GWWebServices\affiliate.asmx.vb:line 122
--- End of inner exception stack trace ---2010-09-02 20:12:25.680798 nusoap_client: ctor wsdl=WSDL timeout=0 response_timeout=30
endpoint=string(57) "http://www.gamblingwages.com/services/affiliate.asmx?WSDL"
2010-09-02 20:12:25.680993 nusoap_client: will use lazy evaluation of wsdl from http://www.gamblingwages.com/services/affiliate.asmx?WSDL
2010-09-02 20:12:25.681083 nusoap_client: call: operation=AffiliateTracking, namespace=http://tempuri.org, soapAction=, rpcParams=, style=rpc, use=encoded, endpointType=wsdl
params=array(2) {
["AffId"]=>
string(4) "7767"
["CtvId"]=>
string(4) "7767"
}
headers=bool(false)
2010-09-02 20:12:25.681197 nusoap_client: instantiating wsdl class with doc: http://www.gamblingwages.com/services/affiliate.asmx?WSDL
2010-09-02 20:12:25.681303 wsdl: ctor wsdl= timeout=0 response_timeout=30
2010-09-02 20:12:25.681381 wsdl: parse and process WSDL path=
2010-09-02 20:12:25.681466 wsdl: setCredentials username= authtype= certRequest=
array(0) {
}
2010-09-02 20:12:25.681565 wsdl: parse and process WSDL path=http://www.gamblingwages.com/services/affiliate.asmx?WSDL
2010-09-02 20:12:25.681642 wsdl: parse WSDL at path=http://www.gamblingwages.com/services/affiliate.asmx?WSDL
2010-09-02 20:12:25.681719 wsdl: getting WSDL http(s) URL http://www.gamblingwages.com/services/affiliate.asmx?WSDL
2010-09-02 20:12:25.681821 soap_transport_http: ctor url=http://www.gamblingwages.com/services/affiliate.asmx?WSDL use_curl= curl_options:
array(0) {
}
2010-09-02 20:12:25.681921 soap_transport_http: parsed URL scheme = http
2010-09-02 20:12:25.681993 soap_transport_http: parsed URL host = www.gamblingwages.com
2010-09-02 20:12:25.682062 soap_transport_http: parsed URL path = /services/affiliate.asmx
2010-09-02 20:12:25.682131 soap_transport_http: parsed URL query = WSDL
2010-09-02 20:12:25.682223 soap_transport_http: set header Host: www.gamblingwages.com
2010-09-02 20:12:25.682352 soap_transport_http: set header User-Agent: NuSOAP/0.7.3 (1.114)
2010-09-02 20:12:25.682431 soap_transport_http: set header Accept-Encoding: gzip, deflate
2010-09-02 20:12:25.682521 soap_transport_http: set header Connection: close
2010-09-02 20:12:25.682611 soap_transport_http: entered send() with data of length: 0
2010-09-02 20:12:25.682687 soap_transport_http: connect connection_timeout 0, response_timeout 30, scheme http, host www.gamblingwages.com, port 80
2010-09-02 20:12:25.682767 soap_transport_http: calling fsockopen with host www.gamblingwages.com connection_timeout 0
2010-09-02 20:12:25.715140 soap_transport_http: set response timeout to 30
2010-09-02 20:12:25.715239 soap_transport_http: socket connected
2010-09-02 20:12:25.715324 soap_transport_http: set header Content-Length: 0
2010-09-02 20:12:25.715399 soap_transport_http: HTTP request: GET /services/affiliate.asmx?WSDL HTTP/1.1
2010-09-02 20:12:25.715488 soap_transport_http: HTTP header: Host: www.gamblingwages.com
2010-09-02 20:12:25.715561 soap_transport_http: HTTP header: User-Agent: NuSOAP/0.7.3 (1.114)
2010-09-02 20:12:25.715636 soap_transport_http: HTTP header: Accept-Encoding: gzip, deflate
2010-09-02 20:12:25.715719 soap_transport_http: HTTP header: Connection: close
2010-09-02 20:12:25.715789 soap_transport_http: HTTP header: Content-Length: 0
2010-09-02 20:12:25.715884 soap_transport_http: wrote data to socket, length = 179
2010-09-02 20:12:25.722758 soap_transport_http: read line of 17 bytes: HTTP/1.1 200 OK
2010-09-02 20:12:25.722858 soap_transport_http: read line of 19 bytes: Connection: close
2010-09-02 20:12:25.722935 soap_transport_http: read line of 37 bytes: Date: Fri, 03 Sep 2010 07:15:04 GMT
2010-09-02 20:12:25.723025 soap_transport_http: read line of 27 bytes: Server: Microsoft-IIS/6.0
2010-09-02 20:12:25.723103 soap_transport_http: read line of 23 bytes: X-Powered-By: ASP.NET
2010-09-02 20:12:25.723193 soap_transport_http: read line of 29 bytes: X-AspNet-Version: 2.0.50727
2010-09-02 20:12:25.723269 soap_transport_http: read line of 35 bytes: Cache-Control: private, max-age=0
2010-09-02 20:12:25.723345 soap_transport_http: read line of 39 bytes: Content-Type: text/xml; charset=utf-8
2010-09-02 20:12:25.723421 soap_transport_http: read line of 22 bytes: Content-Length: 9332
2010-09-02 20:12:25.723512 soap_transport_http: read line of 2 bytes:
2010-09-02 20:12:25.723649 soap_transport_http: found end of headers after length 250
2010-09-02 20:12:25.723769 soap_transport_http: want to read content of length 9332
2010-09-02 20:12:25.723874 soap_transport_http: read buffer of 2646 bytes
2010-09-02 20:12:25.723975 soap_transport_http: read buffer of 1448 bytes
2010-09-02 20:12:25.724076 soap_transport_http: read buffer of 1448 bytes
2010-09-02 20:12:25.724175 soap_transport_http: read buffer of 1448 bytes
2010-09-02 20:12:25.724313 soap_transport_http: read buffer of 1496 bytes
2010-09-02 20:12:25.725706 soap_transport_http: read buffer of 846 bytes
2010-09-02 20:12:25.725785 soap_transport_http: read to EOF
2010-09-02 20:12:25.725856 soap_transport_http: read body of length 9332
2010-09-02 20:12:25.725944 soap_transport_http: received a total of 9582 bytes of data from server
2010-09-02 20:12:25.726033 soap_transport_http: closed socket
2010-09-02 20:12:25.726118 soap_transport_http: No Content-Encoding header
2010-09-02 20:12:25.726191 soap_transport_http: end of send()
2010-09-02 20:12:25.726286 wsdl: got WSDL URL
2010-09-02 20:12:25.726357 wsdl: Parse WSDL
2010-09-02 20:12:25.727143 wsdl: Parsing WSDL schema
2010-09-02 20:12:25.727258 nusoap_xmlschema: nusoap_xmlschema class instantiated, inside constructor
2010-09-02 20:12:25.727477 nusoap_xmlschema: processing untyped element AffiliateStats type _AffiliateStats_ContainedType
2010-09-02 20:12:25.727573 nusoap_xmlschema: add element AffiliateStats to elements array
2010-09-02 20:12:25.727693 nusoap_xmlschema: processing unnamed complexType for element AffiliateStats named _AffiliateStats_ContainedType
2010-09-02 20:12:25.727899 nusoap_xmlschema: processing typed element affid of type http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.728002 nusoap_xmlschema: add element affid to complexType _AffiliateStats_ContainedType
2010-09-02 20:12:25.728110 nusoap_xmlschema: done processing element affid
2010-09-02 20:12:25.728300 nusoap_xmlschema: processing typed element sprid of type http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.728396 nusoap_xmlschema: add element sprid to complexType _AffiliateStats_ContainedType
2010-09-02 20:12:25.728499 nusoap_xmlschema: done processing element sprid
2010-09-02 20:12:25.728677 nusoap_xmlschema: processing typed element fromDate of type http://www.w3.org/2001/XMLSchema:dateTime
2010-09-02 20:12:25.728772 nusoap_xmlschema: add element fromDate to complexType _AffiliateStats_ContainedType
2010-09-02 20:12:25.728876 nusoap_xmlschema: done processing element fromDate
2010-09-02 20:12:25.729044 nusoap_xmlschema: processing typed element toDate of type http://www.w3.org/2001/XMLSchema:dateTime
2010-09-02 20:12:25.729138 nusoap_xmlschema: add element toDate to complexType _AffiliateStats_ContainedType
2010-09-02 20:12:25.729240 nusoap_xmlschema: done processing element toDate
2010-09-02 20:12:25.729367 nusoap_xmlschema: done processing complexType _AffiliateStats_ContainedType
2010-09-02 20:12:25.729483 nusoap_xmlschema: done processing element AffiliateStats
2010-09-02 20:12:25.729612 nusoap_xmlschema: processing untyped element AffiliateStatsResponse type _AffiliateStatsResponse_ContainedType
2010-09-02 20:12:25.729690 nusoap_xmlschema: add element AffiliateStatsResponse to elements array
2010-09-02 20:12:25.729812 nusoap_xmlschema: processing unnamed complexType for element AffiliateStatsResponse named _AffiliateStatsResponse_ContainedType
2010-09-02 20:12:25.729994 nusoap_xmlschema: processing untyped element AffiliateStatsResult type __AffiliateStatsResponse_ContainedType_AffiliateStatsResult_ContainedType
2010-09-02 20:12:25.730073 nusoap_xmlschema: add element AffiliateStatsResult to complexType _AffiliateStatsResponse_ContainedType
2010-09-02 20:12:25.730217 nusoap_xmlschema: processing unnamed complexType for element AffiliateStatsResult named __AffiliateStatsResponse_ContainedType_AffiliateStatsResult_ContainedType
2010-09-02 20:12:25.730425 nusoap_xmlschema: done processing complexType __AffiliateStatsResponse_ContainedType_AffiliateStatsResult_ContainedType
2010-09-02 20:12:25.730532 nusoap_xmlschema: done processing element AffiliateStatsResult
2010-09-02 20:12:25.730675 nusoap_xmlschema: done processing complexType _AffiliateStatsResponse_ContainedType
2010-09-02 20:12:25.730777 nusoap_xmlschema: done processing element AffiliateStatsResponse
2010-09-02 20:12:25.730899 nusoap_xmlschema: processing untyped element AffiliateTracking type _AffiliateTracking_ContainedType
2010-09-02 20:12:25.730976 nusoap_xmlschema: add element AffiliateTracking to elements array
2010-09-02 20:12:25.731102 nusoap_xmlschema: processing unnamed complexType for element AffiliateTracking named _AffiliateTracking_ContainedType
2010-09-02 20:12:25.731304 nusoap_xmlschema: processing typed element AffId of type http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.731385 nusoap_xmlschema: add element AffId to complexType _AffiliateTracking_ContainedType
2010-09-02 20:12:25.731500 nusoap_xmlschema: done processing element AffId
2010-09-02 20:12:25.731675 nusoap_xmlschema: processing typed element CtvId of type http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.731755 nusoap_xmlschema: add element CtvId to complexType _AffiliateTracking_ContainedType
2010-09-02 20:12:25.731871 nusoap_xmlschema: done processing element CtvId
2010-09-02 20:12:25.731998 nusoap_xmlschema: done processing complexType _AffiliateTracking_ContainedType
2010-09-02 20:12:25.732100 nusoap_xmlschema: done processing element AffiliateTracking
2010-09-02 20:12:25.732236 nusoap_xmlschema: processing untyped element AffiliateTrackingResponse type _AffiliateTrackingResponse_ContainedType
2010-09-02 20:12:25.732312 nusoap_xmlschema: add element AffiliateTrackingResponse to elements array
2010-09-02 20:12:25.732424 nusoap_xmlschema: processing unnamed complexType for element AffiliateTrackingResponse named _AffiliateTrackingResponse_ContainedType
2010-09-02 20:12:25.732647 nusoap_xmlschema: processing typed element AffiliateTrackingResult of type http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.732727 nusoap_xmlschema: add element AffiliateTrackingResult to complexType _AffiliateTrackingResponse_ContainedType
2010-09-02 20:12:25.732833 nusoap_xmlschema: done processing element AffiliateTrackingResult
2010-09-02 20:12:25.732976 nusoap_xmlschema: done processing complexType _AffiliateTrackingResponse_ContainedType
2010-09-02 20:12:25.733078 nusoap_xmlschema: done processing element AffiliateTrackingResponse
2010-09-02 20:12:25.733237 nusoap_xmlschema: processing typed element string of type http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.733329 nusoap_xmlschema: add element string to elements array
2010-09-02 20:12:25.733440 nusoap_xmlschema: done processing element string
2010-09-02 20:12:25.733547 wsdl: Parsing WSDL schema done
2010-09-02 20:12:25.733808 wsdl: msg AffiliateStatsSoapIn: found part (with element) parameters: parameters,http://tempuri.org/:AffiliateStats
2010-09-02 20:12:25.734076 wsdl: msg AffiliateStatsSoapOut: found part (with element) parameters: parameters,http://tempuri.org/:AffiliateStatsResponse
2010-09-02 20:12:25.734330 wsdl: msg AffiliateTrackingSoapIn: found part (with element) parameters: parameters,http://tempuri.org/:AffiliateTracking
2010-09-02 20:12:25.734605 wsdl: msg AffiliateTrackingSoapOut: found part (with element) parameters: parameters,http://tempuri.org/:AffiliateTrackingResponse
2010-09-02 20:12:25.734872 wsdl: msg AffiliateStatsHttpGetIn: found part (with type) affid: affid,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.735048 wsdl: msg AffiliateStatsHttpGetIn: found part (with type) sprid: sprid,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.735237 wsdl: msg AffiliateStatsHttpGetIn: found part (with type) fromDate: fromDate,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.735414 wsdl: msg AffiliateStatsHttpGetIn: found part (with type) toDate: toDate,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.735829 wsdl: msg AffiliateTrackingHttpGetIn: found part (with type) AffId: AffId,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.736020 wsdl: msg AffiliateTrackingHttpGetIn: found part (with type) CtvId: CtvId,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.736273 wsdl: msg AffiliateTrackingHttpGetOut: found part (with element) Body: Body,http://tempuri.org/:string
2010-09-02 20:12:25.736540 wsdl: msg AffiliateStatsHttpPostIn: found part (with type) affid: affid,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.736734 wsdl: msg AffiliateStatsHttpPostIn: found part (with type) sprid: sprid,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.736910 wsdl: msg AffiliateStatsHttpPostIn: found part (with type) fromDate: fromDate,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.737098 wsdl: msg AffiliateStatsHttpPostIn: found part (with type) toDate: toDate,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.737506 wsdl: msg AffiliateTrackingHttpPostIn: found part (with type) AffId: AffId,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.737690 wsdl: msg AffiliateTrackingHttpPostIn: found part (with type) CtvId: CtvId,http://www.w3.org/2001/XMLSchema:string
2010-09-02 20:12:25.737956 wsdl: msg AffiliateTrackingHttpPostOut: found part (with element) Body: Body,http://tempuri.org/:string
2010-09-02 20:12:25.738182 wsdl: portType affiliateSoap operation: AffiliateStats
2010-09-02 20:12:25.738538 wsdl: portType affiliateSoap operation: AffiliateTracking
2010-09-02 20:12:25.738966 wsdl: portType affiliateHttpGet operation: AffiliateStats
2010-09-02 20:12:25.739314 wsdl: portType affiliateHttpGet operation: AffiliateTracking
2010-09-02 20:12:25.739744 wsdl: portType affiliateHttpPost operation: AffiliateStats
2010-09-02 20:12:25.740090 wsdl: portType affiliateHttpPost operation: AffiliateTracking
2010-09-02 20:12:25.740496 wsdl: current binding: affiliateSoap of portType: http://tempuri.org/:affiliateSoap
2010-09-02 20:12:25.740728 wsdl: current binding operation: AffiliateStats
2010-09-02 20:12:25.741264 wsdl: current binding operation: AffiliateTracking
2010-09-02 20:12:25.741850 wsdl: current binding: affiliateSoap12 of portType: http://tempuri.org/:affiliateSoap
2010-09-02 20:12:25.742073 wsdl: current binding operation: AffiliateStats
2010-09-02 20:12:25.742614 wsdl: current binding operation: AffiliateTracking
2010-09-02 20:12:25.743193 wsdl: current binding: affiliateHttpGet of portType: http://tempuri.org/:affiliateHttpGet
2010-09-02 20:12:25.743417 wsdl: current binding operation: AffiliateStats
2010-09-02 20:12:25.743913 wsdl: current binding operation: AffiliateTracking
2010-09-02 20:12:25.744446 wsdl: current binding: affiliateHttpPost of portType: http://tempuri.org/:affiliateHttpPost
2010-09-02 20:12:25.744674 wsdl: current binding operation: AffiliateStats
2010-09-02 20:12:25.745183 wsdl: current binding operation: AffiliateTracking
2010-09-02 20:12:25.745701 wsdl: current service: affiliate
2010-09-02 20:12:25.745863 wsdl: current port: affiliateSoap
2010-09-02 20:12:25.746135 wsdl: current port: affiliateSoap12
2010-09-02 20:12:25.746406 wsdl: current port: affiliateHttpGet
2010-09-02 20:12:25.746671 wsdl: current port: affiliateHttpPost
2010-09-02 20:12:25.746911 wsdl: Parsing WSDL done
2010-09-02 20:12:25.747006 wsdl: post-parse data gathering for AffiliateStats
2010-09-02 20:12:25.747125 wsdl: post-parse data gathering for AffiliateTracking
2010-09-02 20:12:25.747224 wsdl: post-parse data gathering for AffiliateStats
2010-09-02 20:12:25.747321 wsdl: post-parse data gathering for AffiliateTracking
2010-09-02 20:12:25.747418 wsdl: post-parse data gathering for AffiliateStats
2010-09-02 20:12:25.747525 wsdl: post-parse data gathering for AffiliateTracking
2010-09-02 20:12:25.747622 wsdl: post-parse data gathering for AffiliateStats
2010-09-02 20:12:25.747714 wsdl: post-parse data gathering for AffiliateTracking
2010-09-02 20:12:25.747825 nusoap_client: checkWSDL
2010-09-02 20:12:25.747930 nusoap_client: got 2 operations from wsdl http://www.gamblingwages.com/services/affiliate.asmx?WSDL for binding type soap
2010-09-02 20:12:25.748008 nusoap_client: found operation
opData=array(9) {
["name"]=>
string(17) "AffiliateTracking"
["binding"]=>
string(13) "affiliateSoap"
["endpoint"]=>
string(52) "http://www.gamblingwages.com/services/affiliate.asmx"
["soapAction"]=>
string(36) "http://tempuri.org/AffiliateTracking"
["style"]=>
string(8) "document"
["input"]=>
array(3) {
["use"]=>
string(7) "literal"
["message"]=>
string(23) "AffiliateTrackingSoapIn"
["parts"]=>
array(1) {
["parameters"]=>
string(38) "http://tempuri.org/:AffiliateTracking^"
}
}
["output"]=>
array(3) {
["use"]=>
string(7) "literal"
["message"]=>
string(24) "AffiliateTrackingSoapOut"
["parts"]=>
array(1) {
["parameters"]=>
string(46) "http://tempuri.org/:AffiliateTrackingResponse^"
}
}
["transport"]=>
string(36) "http://schemas.xmlsoap.org/soap/http"
["documentation"]=>
string(0) ""
}
2010-09-02 20:12:25.748135 nusoap_client: serializing param array for WSDL operation AffiliateTracking
2010-09-02 20:12:25.748210 wsdl: in serializeRPCParameters: operation=AffiliateTracking, direction=input, XMLSchemaVersion=http://www.w3.org/2001/XMLSchema, bindingType=soap
parameters=array(2) {
["AffId"]=>
string(4) "7767"
["CtvId"]=>
string(4) "7767"
}
2010-09-02 20:12:25.748310 wsdl: in serializeRPCParameters: opData:
array(9) {
["name"]=>
string(17) "AffiliateTracking"
["binding"]=>
string(13) "affiliateSoap"
["endpoint"]=>
string(52) "http://www.gamblingwages.com/services/affiliate.asmx"
["soapAction"]=>
string(36) "http://tempuri.org/AffiliateTracking"
["style"]=>
string(8) "document"
["input"]=>
array(3) {
["use"]=>
string(7) "literal"
["message"]=>
string(23) "AffiliateTrackingSoapIn"
["parts"]=>
array(1) {
["parameters"]=>
string(38) "http://tempuri.org/:AffiliateTracking^"
}
}
["output"]=>
array(3) {
["use"]=>
string(7) "literal"
["message"]=>
string(24) "AffiliateTrackingSoapOut"
["parts"]=>
array(1) {
["parameters"]=>
string(46) "http://tempuri.org/:AffiliateTrackingResponse^"
}
}
["transport"]=>
string(36) "http://schemas.xmlsoap.org/soap/http"
["documentation"]=>
string(0) ""
}
2010-09-02 20:12:25.748409 wsdl: have 1 part(s) to serialize using document/literal
2010-09-02 20:12:25.748486 wsdl: have 2 parameter(s) provided as arrayStruct to serialize
2010-09-02 20:12:25.748570 wsdl: check whether the caller has wrapped the parameters
2010-09-02 20:12:25.748644 wsdl: check whether caller's parameters match the wrapped ones
2010-09-02 20:12:25.748714 wsdl: in parametersMatchWrapped type=http://tempuri.org/:AffiliateTracking^, parameters=
array(2) {
["AffId"]=>
string(4) "7767"
["CtvId"]=>
string(4) "7767"
}
2010-09-02 20:12:25.748795 wsdl: in parametersMatchWrapped: got a prefixed type: AffiliateTracking^, http://tempuri.org/
2010-09-02 20:12:25.748878 wsdl: in getTypeDef: type=AffiliateTracking^, ns=http://tempuri.org/
2010-09-02 20:12:25.748948 wsdl: in getTypeDef: have schema for namespace http://tempuri.org/
2010-09-02 20:12:25.749355 wsdl: in parametersMatchWrapped: found typeDef=
array(6) {
["name"]=>
string(17) "AffiliateTracking"
["form"]=>
string(9) "qualified"
["type"]=>
string(52) "http://tempuri.org/:_AffiliateTracking_ContainedType"
["typeClass"]=>
string(7) "element"
["phpType"]=>
string(6) "struct"
["elements"]=>
array(2) {
["AffId"]=>
array(5) {
["minOccurs"]=>
string(1) "0"
["maxOccurs"]=>
string(1) "1"
["name"]=>
string(5) "AffId"
["type"]=>
string(39) "http://www.w3.org/2001/XMLSchema:string"
["form"]=>
string(9) "qualified"
}
["CtvId"]=>
array(5) {
["minOccurs"]=>
string(1) "0"
["maxOccurs"]=>
string(1) "1"
["name"]=>
string(5) "CtvId"
["type"]=>
string(39) "http://www.w3.org/2001/XMLSchema:string"
["form"]=>
string(9) "qualified"
}
}
}
2010-09-02 20:12:25.749447 wsdl: in parametersMatchWrapped: uqType: AffiliateTracking, ns: http://tempuri.org/, phptype: struct, arrayType:
2010-09-02 20:12:25.749543 wsdl: in parametersMatchWrapped: have parameter named AffId
2010-09-02 20:12:25.749618 wsdl: in parametersMatchWrapped: have parameter named CtvId
2010-09-02 20:12:25.749689 wsdl: in parametersMatchWrapped: 2 parameter names match 2 wrapped parameter names
2010-09-02 20:12:25.749757 wsdl: wrap the parameters for the caller
2010-09-02 20:12:25.749843 wsdl: serializing part parameters of type http://tempuri.org/:AffiliateTracking^
2010-09-02 20:12:25.749913 wsdl: calling serializeType w/named param
2010-09-02 20:12:25.749986 wsdl: in serializeType: name=parameters, type=http://tempuri.org/:AffiliateTracking^, use=literal, encodingStyle=, unqualified=qualified
value=array(2) {
["AffId"]=>
string(4) "7767"
["CtvId"]=>
string(4) "7767"
}
2010-09-02 20:12:25.750081 wsdl: in serializeType: got a prefixed type: AffiliateTracking^, http://tempuri.org/
2010-09-02 20:12:25.750156 wsdl: in getTypeDef: type=AffiliateTracking^, ns=http://tempuri.org/
2010-09-02 20:12:25.750225 wsdl: in getTypeDef: have schema for namespace http://tempuri.org/
2010-09-02 20:12:25.750387 wsdl: in serializeType: found typeDef
typeDef=array(6) {
["name"]=>
string(17) "AffiliateTracking"
["form"]=>
string(9) "qualified"
["type"]=>
string(52) "http://tempuri.org/:_AffiliateTracking_ContainedType"
["typeClass"]=>
string(7) "element"
["phpType"]=>
string(6) "struct"
["elements"]=>
array(2) {
["AffId"]=>
array(5) {
["minOccurs"]=>
string(1) "0"
["maxOccurs"]=>
string(1) "1"
["name"]=>
string(5) "AffId"
["type"]=>
string(39) "http://www.w3.org/2001/XMLSchema:string"
["form"]=>
string(9) "qualified"
}
["CtvId"]=>
array(5) {
["minOccurs"]=>
string(1) "0"
["maxOccurs"]=>
string(1) "1"
["name"]=>
string(5) "CtvId"
["type"]=>
string(39) "http://www.w3.org/2001/XMLSchema:string"
["form"]=>
string(9) "qualified"
}
}
}
2010-09-02 20:12:25.750481 wsdl: in serializeType: uqType: AffiliateTracking, ns: http://tempuri.org/, phptype: struct, arrayType:
2010-09-02 20:12:25.750560 wsdl: no attributes to serialize for XML Schema type http://tempuri.org/:AffiliateTracking
2010-09-02 20:12:25.750638 wsdl: in serializeComplexTypeElements, serialize elements for XML Schema type http://tempuri.org/:AffiliateTracking
2010-09-02 20:12:25.750734 wsdl: in serializeType: name=AffId, type=http://www.w3.org/2001/XMLSchema:string, use=literal, encodingStyle=, unqualified=qualified
value=string(4) "7767"
2010-09-02 20:12:25.750815 wsdl: in serializeType: got a prefixed type: string, http://www.w3.org/2001/XMLSchema
2010-09-02 20:12:25.750886 wsdl: in serializeType: type namespace indicates XML Schema or SOAP Encoding type
2010-09-02 20:12:25.750969 wsdl: in getTypeDef: type=string, ns=http://www.w3.org/2001/XMLSchema
2010-09-02 20:12:25.751057 wsdl: in getTypeDef: do not have schema for namespace http://www.w3.org/2001/XMLSchema
2010-09-02 20:12:25.751128 wsdl: in serializeType: returning: 7767
2010-09-02 20:12:25.751208 wsdl: in serializeType: name=CtvId, type=http://www.w3.org/2001/XMLSchema:string, use=literal, encodingStyle=, unqualified=qualified
value=string(4) "7767"
2010-09-02 20:12:25.751300 wsdl: in serializeType: got a prefixed type: string, http://www.w3.org/2001/XMLSchema
2010-09-02 20:12:25.751371 wsdl: in serializeType: type namespace indicates XML Schema or SOAP Encoding type
2010-09-02 20:12:25.751448 wsdl: in getTypeDef: type=string, ns=http://www.w3.org/2001/XMLSchema
2010-09-02 20:12:25.751523 wsdl: in getTypeDef: do not have schema for namespace http://www.w3.org/2001/XMLSchema
2010-09-02 20:12:25.751609 wsdl: in serializeType: returning: 7767
2010-09-02 20:12:25.751682 wsdl: in serializeType: returning: 77677767
2010-09-02 20:12:25.751753 wsdl: serializeRPCParameters returning: 77677767
2010-09-02 20:12:25.751848 nusoap_client: In serializeEnvelope length=105 body (max 1000 characters)=77677767 style=document use=literal encodingStyle=
2010-09-02 20:12:25.751936 nusoap_client: headers:
bool(false)
2010-09-02 20:12:25.752009 nusoap_client: namespaces:
array(1) {
["ns1734"]=>
string(18) "http://tempuri.org"
}
2010-09-02 20:12:25.752100 nusoap_client: endpoint=http://www.gamblingwages.com/services/affiliate.asmx, soapAction=http://tempuri.org/AffiliateTracking, namespace=http://tempuri.org, style=document, use=literal, encodingStyle=
2010-09-02 20:12:25.752174 nusoap_client: SOAP message length=469 contents (max 1000 bytes)=77677767
2010-09-02 20:12:25.752282 nusoap_client: transporting via HTTP
2010-09-02 20:12:25.753027 nusoap_client: sending message, length=469
2010-09-02 20:12:25.752369 soap_transport_http: ctor url=http://www.gamblingwages.com/services/affiliate.asmx use_curl= curl_options:
array(0) {
}
2010-09-02 20:12:25.752452 soap_transport_http: parsed URL scheme = http
2010-09-02 20:12:25.752539 soap_transport_http: parsed URL host = www.gamblingwages.com
2010-09-02 20:12:25.752613 soap_transport_http: parsed URL path = /services/affiliate.asmx
2010-09-02 20:12:25.752689 soap_transport_http: set header Host: www.gamblingwages.com
2010-09-02 20:12:25.752790 soap_transport_http: set header User-Agent: NuSOAP/0.7.3 (1.114)
2010-09-02 20:12:25.752881 soap_transport_http: set header Content-Type: text/xml; charset=ISO-8859-1
2010-09-02 20:12:25.752953 soap_transport_http: set header SOAPAction: "http://tempuri.org/AffiliateTracking"
2010-09-02 20:12:25.753126 soap_transport_http: entered send() with data of length: 469
2010-09-02 20:12:25.753203 soap_transport_http: connect connection_timeout 0, response_timeout 30, scheme http, host www.gamblingwages.com, port 80
2010-09-02 20:12:25.753281 soap_transport_http: calling fsockopen with host www.gamblingwages.com connection_timeout 0
2010-09-02 20:12:25.780502 soap_transport_http: set response timeout to 30
2010-09-02 20:12:25.780606 soap_transport_http: socket connected
2010-09-02 20:12:25.780690 soap_transport_http: set header Content-Length: 469
2010-09-02 20:12:25.780763 soap_transport_http: HTTP request: POST /services/affiliate.asmx HTTP/1.0
2010-09-02 20:12:25.780836 soap_transport_http: HTTP header: Host: www.gamblingwages.com
2010-09-02 20:12:25.780921 soap_transport_http: HTTP header: User-Agent: NuSOAP/0.7.3 (1.114)
2010-09-02 20:12:25.780992 soap_transport_http: HTTP header: Content-Type: text/xml; charset=ISO-8859-1
2010-09-02 20:12:25.781062 soap_transport_http: HTTP header: SOAPAction: "http://tempuri.org/AffiliateTracking"
2010-09-02 20:12:25.781133 soap_transport_http: HTTP header: Content-Length: 469
2010-09-02 20:12:25.781238 soap_transport_http: wrote data to socket, length = 691
2010-09-02 20:12:25.790038 soap_transport_http: read line of 36 bytes: HTTP/1.1 500 Internal Server Error
2010-09-02 20:12:25.790133 soap_transport_http: read line of 19 bytes: Connection: close
2010-09-02 20:12:25.790226 soap_transport_http: read line of 37 bytes: Date: Fri, 03 Sep 2010 07:15:04 GMT
2010-09-02 20:12:25.790304 soap_transport_http: read line of 27 bytes: Server: Microsoft-IIS/6.0
2010-09-02 20:12:25.790380 soap_transport_http: read line of 23 bytes: X-Powered-By: ASP.NET
2010-09-02 20:12:25.790456 soap_transport_http: read line of 29 bytes: X-AspNet-Version: 2.0.50727
2010-09-02 20:12:25.790548 soap_transport_http: read line of 24 bytes: Cache-Control: private
2010-09-02 20:12:25.790629 soap_transport_http: read line of 39 bytes: Content-Type: text/xml; charset=utf-8
2010-09-02 20:12:25.790705 soap_transport_http: read line of 22 bytes: Content-Length: 2337
2010-09-02 20:12:25.790782 soap_transport_http: read line of 2 bytes:
2010-09-02 20:12:25.790933 soap_transport_http: found end of headers after length 258
2010-09-02 20:12:25.791049 soap_transport_http: want to read content of length 2337
2010-09-02 20:12:25.791137 soap_transport_http: read buffer of 2337 bytes
2010-09-02 20:12:25.791215 soap_transport_http: read to EOF
2010-09-02 20:12:25.791299 soap_transport_http: read body of length 2337
2010-09-02 20:12:25.791371 soap_transport_http: received a total of 2595 bytes of data from server
2010-09-02 20:12:25.791455 soap_transport_http: closed socket
2010-09-02 20:12:25.791554 soap_transport_http: No Content-Encoding header
2010-09-02 20:12:25.791630 soap_transport_http: end of send()
2010-09-02 20:12:25.791716 nusoap_client: got response, length=2337 type=text/xml; charset=utf-8
2010-09-02 20:12:25.791788 nusoap_client: Entering parseResponse() for data of length 2337 headers:
array(8) {
["connection"]=>
string(5) "close"
["date"]=>
string(29) "Fri, 03 Sep 2010 07:15:04 GMT"
["server"]=>
string(17) "Microsoft-IIS/6.0"
["x-powered-by"]=>
string(7) "ASP.NET"
["x-aspnet-version"]=>
string(9) "2.0.50727"
["cache-control"]=>
string(7) "private"
["content-type"]=>
string(23) "text/xml; charset=utf-8"
["content-length"]=>
string(4) "2337"
}
2010-09-02 20:12:25.791889 nusoap_client: Got response encoding: utf-8
2010-09-02 20:12:25.792014 nusoap_client: Use encoding: UTF-8 when creating nusoap_parser
2010-09-02 20:12:25.792153 nusoap_parser: Charset from HTTP Content-Type matches encoding from XML declaration
2010-09-02 20:12:25.792229 nusoap_parser: Entering nusoap_parser(), length=2337, encoding=UTF-8
2010-09-02 20:12:25.792547 nusoap_parser: found root struct Fault, pos 2
2010-09-02 20:12:25.792868 nusoap_parser: in buildVal() for Fault(pos 2) of type struct
2010-09-02 20:12:25.792946 nusoap_parser: in buildVal, there are children
2010-09-02 20:12:25.793039 nusoap_parser: in buildVal, adding Java Vector or generic compound type Fault
2010-09-02 20:12:25.793128 nusoap_parser: in buildVal, return:
array(3) {
["faultcode"]=>
&string(11) "soap:Server"
["faultstring"]=>
&string(1976) "System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Aff_tbAffiliateCreative_Aff_tbCreative". The conflict occurred in database "gwages", table "dbo.Aff_tbCreative", column 'ctvId'.
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
The statement has been terminated.
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.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at GWWebServices.affiliate.AffiliateTracking(String AffId, String CtvId) in D:\www\GWWebServices\GWWebServices\GWWebServices\affiliate.asmx.vb:line 122
--- End of inner exception stack trace ---"
["detail"]=>
&string(0) ""
}
2010-09-02 20:12:25.793243 nusoap_parser: parsed successfully, found root struct: 2 of name Fault
2010-09-02 20:12:25.793365 nusoap_client: sent message successfully and got a(n) array
return=array(3) {
["faultcode"]=>
string(11) "soap:Server"
["faultstring"]=>
string(1976) "System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Aff_tbAffiliateCreative_Aff_tbCreative". The conflict occurred in database "gwages", table "dbo.Aff_tbCreative", column 'ctvId'.
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
The statement has been terminated.
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.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at GWWebServices.affiliate.AffiliateTracking(String AffId, String CtvId) in D:\www\GWWebServices\GWWebServices\GWWebServices\affiliate.asmx.vb:line 122
--- End of inner exception stack trace ---"
["detail"]=>
string(0) ""
}
2010-09-02 20:12:25.793461 nusoap_client: got fault
2010-09-02 20:12:25.793539 nusoap_client: faultcode = soap:Server
2010-09-02 20:12:25.793614 nusoap_client: faultstring = System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Aff_tbAffiliateCreative_Aff_tbCreative". The conflict occurred in database "gwages", table "dbo.Aff_tbCreative", column 'ctvId'.
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
The statement has been terminated.
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.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at GWWebServices.affiliate.AffiliateTracking(String AffId, String CtvId) in D:\www\GWWebServices\GWWebServices\GWWebServices\affiliate.asmx.vb:line 122
--- End of inner exception stack trace ---
2010-09-02 20:12:25.793700 nusoap_client: detail =