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 =