Hi Jared, Could you also add a predicate for CampaignId in xxx, xxx? The SizeLimitError is coming in this case because the total number of items that match your conditions is quite high (this is independent of the page size you set in your request).
Cheers, Anash P. Oommen, AdWords API Advisor. On Tuesday, June 25, 2013 3:40:04 AM UTC+5:30, Jared wrote: > > I am now getting the SizeLimitError. I'm continuing to use paging (the > recommended value of 2000), and using a predicate of CriteriaType equal to > Platform, and I'm still getting the error. It seems that this error is > bring thrown independently of the number of results being returned. Is > there some other way I need to limit my query? > > 1211589 [main] WARN > com.google.api.ads.adwords.lib.client.AdWordsServiceClient.soapXmlLogger - > SOAP Request: > <?xml version="1.0" encoding="UTF-8"?> > <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; > xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance";> > <soapenv:Header> > <ns1:RequestHeader xmlns:ns1=" > https://adwords.google.com/api/adwords/cm/v201302"; > soapenv:mustUnderstand="0"> > <ns1:authToken>DELETED</ns1:authToken> > <ns1:clientCustomerId>DELETED</ns1:clientCustomerId> > <ns1:developerToken>DELETED</ns1:developerToken> > <ns1:userAgent>null (AwApi-Java, AdWords-Axis/1.15.0, > Common-Java/1.15.0, Axis/1.4, Java/1.6.0_29, maven)</ns1:userAgent> > <ns1:validateOnly>false</ns1:validateOnly> > <ns1:partialFailure>false</ns1:partialFailure> > </ns1:RequestHeader> > </soapenv:Header> > <soapenv:Body> > <get xmlns="https://adwords.google.com/api/adwords/cm/v201302";> > <serviceSelector> > <fields>Id</fields> > <fields>CampaignId</fields> > <fields>BidModifier</fields> > <fields>CriteriaType</fields> > <fields>DayOfWeek</fields> > <fields>StartHour</fields> > <fields>StartMinute</fields> > <fields>EndHour</fields> > <fields>EndMinute</fields> > <fields>PlatformName</fields> > <fields>LocationName</fields> > <fields>DisplayName</fields> > <fields>TargetingStatus</fields> > <fields>ParentLocations</fields> > <predicates> > <field>CriteriaType</field> > <operator>EQUALS</operator> > <values>PLATFORM</values> > </predicates> > <ordering> > <field>Id</field> > <sortOrder>ASCENDING</sortOrder> > </ordering> > <paging> > <startIndex>0</startIndex> > <numberResults>2000</numberResults> > </paging> > </serviceSelector> > </get> > </soapenv:Body> > </soapenv:Envelope> > > 1211589 [main] WARN > com.google.api.ads.adwords.lib.client.AdWordsServiceClient.soapXmlLogger - > SOAP Response: > <?xml version="1.0" encoding="UTF-8"?> > <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";> > <soap:Header> > <ResponseHeader xmlns=" > https://adwords.google.com/api/adwords/cm/v201302";> > <requestId>0004dfed90251c480ae58b4c000043fc</requestId> > <serviceName>CampaignCriterionService</serviceName> > <methodName>get</methodName> > <operations>0</operations> > <responseTime>8377</responseTime> > <units>0</units> > </ResponseHeader> > </soap:Header> > <soap:Body> > <soap:Fault> > <faultcode>soap:Server</faultcode> > <faultstring>[SizeLimitError.RESPONSE_SIZE_LIMIT_EXCEEDED @ > ]</faultstring> > <detail> > <ApiExceptionFault xmlns=" > https://adwords.google.com/api/adwords/cm/v201302";> > <message>[SizeLimitError.RESPONSE_SIZE_LIMIT_EXCEEDED > @ ]</message> > > <ApplicationException.Type>ApiException</ApplicationException.Type> > <errors xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance"; xsi:type="SizeLimitError"> > <fieldPath/> > <trigger/> > > <errorString>SizeLimitError.RESPONSE_SIZE_LIMIT_EXCEEDED</errorString> > <ApiError.Type>SizeLimitError</ApiError.Type> > <reason>RESPONSE_SIZE_LIMIT_EXCEEDED</reason> > </errors> > </ApiExceptionFault> > </detail> > </soap:Fault> > </soap:Body> > </soap:Envelope> > > > On Tuesday, June 18, 2013 11:16:20 PM UTC-5, Anash P. Oommen (AdWords API > Team) wrote: >> >> Hi Jared, >> >> You will now get a RESPONSE_SIZE_LIMIT_EXCEEDED instead of >> SHASTA_MAX_INTERNAL_ROW_STORAGE_EXCEEDED (which >> was an internal error code that shouldn't have been thrown to users). If >> you are still getting RESPONSE_SIZE_LIMIT_EXCEEDED, try adding a >> predicate to restrict your results to a few campaign ids. >> >> Cheers, >> Anash P. Oommen, >> AdWords API Advisor. >> >> On Tuesday, June 18, 2013 11:03:02 PM UTC+5:30, Jared wrote: >>> >>> Hello. Do you have an update on this? >>> >>> On Friday, May 17, 2013 6:01:47 PM UTC-5, Takeshi Hagikura wrote: >>>> >>>> Hi Jared, >>>> >>>> I'm looking into this. >>>> I'll update the thread for updates. >>>> >>>> Best, >>>> - Takeshi, AdWords API Team >>>> >>>> >>>> On Friday, May 17, 2013 12:44:58 AM UTC+9, Jared wrote: >>>>> >>>>> I am downloading the campaign criteria via >>>>> the CampaignCriterionService, and I'm getting an ApiError of type >>>>> SizeLimitError with the message SHASTA_MAX_INTERNAL_ROW_STORAGE_EXCEEDED. >>>>> I >>>>> cannot find any information about this error, and how to avoid it. I've >>>>> used paging of 1000 records and 500 records and the result is the same. >>>>> This error occurs in the same account each time, so I would imagine this >>>>> is >>>>> related to some specific condition within a campaign. >>>>> >>>>> Any idea what is going on here? >>>>> >>>>> <?xml version="1.0" encoding="UTF-8"?> >>>>> <soapenv:Envelope xmlns:soapenv=" >>>>> http://schemas.xmlsoap.org/soap/envelope/"; xmlns:xsd=" >>>>> http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" >>>>> http://www.w3.org/2001/XMLSchema-instance";> >>>>> <soapenv:Header> >>>>> <ns1:RequestHeader xmlns:ns1=" >>>>> https://adwords.google.com/api/adwords/cm/v201302"; >>>>> soapenv:mustUnderstand="0"> >>>>> <ns1:authToken>DELETED</ns1:authToken> >>>>> <ns1:clientCustomerId>DELETED</ns1:clientCustomerId> >>>>> <ns1:developerToken>DELETED</ns1:developerToken> >>>>> <ns1:userAgent>null (AwApi-Java, AdWords-Axis/1.15.0, >>>>> Common-Java/1.15.0, Axis/1.4, Java/1.6.0_29, maven)</ns1:userAgent> >>>>> <ns1:validateOnly>false</ns1:validateOnly> >>>>> <ns1:partialFailure>false</ns1:partialFailure> >>>>> </ns1:RequestHeader> >>>>> </soapenv:Header> >>>>> <soapenv:Body> >>>>> <get xmlns="https://adwords.google.com/api/adwords/cm/v201302 >>>>> "> >>>>> <serviceSelector> >>>>> <fields>Id</fields> >>>>> <fields>CampaignId</fields> >>>>> <fields>BidModifier</fields> >>>>> <fields>CriteriaType</fields> >>>>> <fields>DayOfWeek</fields> >>>>> <fields>StartHour</fields> >>>>> <fields>StartMinute</fields> >>>>> <fields>EndHour</fields> >>>>> <fields>EndMinute</fields> >>>>> <fields>PlatformName</fields> >>>>> <fields>LocationName</fields> >>>>> <fields>DisplayName</fields> >>>>> <fields>TargetingStatus</fields> >>>>> <fields>ParentLocations</fields> >>>>> <predicates> >>>>> <field>CriteriaType</field> >>>>> <operator>IN</operator> >>>>> <values>PLATFORM</values> >>>>> <values>AD_SCHEDULE</values> >>>>> <values>LOCATION</values> >>>>> </predicates> >>>>> <ordering> >>>>> <field>Id</field> >>>>> <sortOrder>ASCENDING</sortOrder> >>>>> </ordering> >>>>> <paging> >>>>> <startIndex>0</startIndex> >>>>> <numberResults>500</numberResults> >>>>> </paging> >>>>> </serviceSelector> >>>>> </get> >>>>> </soapenv:Body> >>>>> </soapenv:Envelope> >>>>> >>>>> Exception in thread "main" WARN logSoapXml, SOAP Response: >>>>> <?xml version="1.0" encoding="UTF-8"?> >>>>> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";> >>>>> <soap:Header> >>>>> <ResponseHeader xmlns=" >>>>> https://adwords.google.com/api/adwords/cm/v201302";> >>>>> <requestId>DELETED</requestId> >>>>> <serviceName>CampaignCriterionService</serviceName> >>>>> <methodName>get</methodName> >>>>> <operations>0</operations> >>>>> <responseTime>9625</responseTime> >>>>> <units>0</units> >>>>> </ResponseHeader> >>>>> </soap:Header> >>>>> <soap:Body> >>>>> <soap:Fault> >>>>> <faultcode>soap:Server</faultcode> >>>>> >>>>> <faultstring>[SizeLimitError.SHASTA_MAX_INTERNAL_ROW_STORAGE_EXCEEDED @ >>>>> ]</faultstring> >>>>> <detail> >>>>> <ApiExceptionFault xmlns=" >>>>> https://adwords.google.com/api/adwords/cm/v201302";> >>>>> >>>>> <message>[SizeLimitError.SHASTA_MAX_INTERNAL_ROW_STORAGE_EXCEEDED @ >>>>> ]</message> >>>>> >>>>> <ApplicationException.Type>ApiException</ApplicationException.Type> >>>>> <errors xmlns:xsi=" >>>>> http://www.w3.org/2001/XMLSchema-instance"; xsi:type="SizeLimitError"> >>>>> <fieldPath/> >>>>> <trigger/> >>>>> >>>>> <errorString>SizeLimitError.SHASTA_MAX_INTERNAL_ROW_STORAGE_EXCEEDED</errorString> >>>>> <ApiError.Type>SizeLimitError</ApiError.Type> >>>>> <reason>UNKNOWN</reason> >>>>> </errors> >>>>> </ApiExceptionFault> >>>>> </detail> >>>>> </soap:Fault> >>>>> </soap:Body> >>>>> </soap:Envelope> >>>>> >>>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
