Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-4102

Feed Item Search Engine Identifiers Read as Integers From DB

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Gingersnap
    • Fix Version/s: Gingersnap
    • Component/s: None
    • Labels:
      None

      Description

      The code that retrieves feed item search engine identifiers from the db is pulling them out as integers instead of longs. As a result the max integer value (2147483647) is being used in SOAP requests causing them to fail with DUPLICATE_ELEMENT errors.

      <?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/v201601" soapenv:mustUnderstand="0">
                  <ns1:clientCustomerId>5136381118</ns1:clientCustomerId>
                  <ns1:developerToken>ojCnjZaM6RD1h0yt_DOJZg</ns1:developerToken>
                  <ns1:userAgent>AdMaxLocal AdWords Software TSA QA (AwApi-Java, AdWords-Axis/2.11.0, Common-Java/2.11.0, Axis/1.4, Java/1.6.0_27, maven)</ns1:userAgent>
                  <ns1:validateOnly>false</ns1:validateOnly>
                  <ns1:partialFailure>false</ns1:partialFailure>
              </ns1:RequestHeader>
          </soapenv:Header>
          <soapenv:Body>
              <mutate xmlns="https://adwords.google.com/api/adwords/cm/v201601">
                  <operations>
                      <operator>SET</operator>
                      <operand>
                          <feedId>34697603</feedId>
                          <feedItemId>2147483647</feedItemId>
                          <attributeValues>
                              <feedAttributeId>3</feedAttributeId>
                              <booleanValue>false</booleanValue>
                          </attributeValues>
                          <attributeValues>
                              <feedAttributeId>1</feedAttributeId>
                              <stringValue>647-478-8059</stringValue>
                          </attributeValues>
                          <attributeValues>
                              <feedAttributeId>2</feedAttributeId>
                              <stringValue>CA</stringValue>
                          </attributeValues>
                      </operand>
                  </operations>
                  <operations>
                      <operator>SET</operator>
                      <operand>
                          <feedId>34697603</feedId>
                          <feedItemId>2147483647</feedItemId>
                          <attributeValues>
                              <feedAttributeId>3</feedAttributeId>
                              <booleanValue>false</booleanValue>
                          </attributeValues>
                          <attributeValues>
                              <feedAttributeId>1</feedAttributeId>
                              <stringValue>647-478-8059</stringValue>
                          </attributeValues>
                          <attributeValues>
                              <feedAttributeId>2</feedAttributeId>
                              <stringValue>CA</stringValue>
                          </attributeValues>
                      </operand>
                  </operations>
              </mutate>
          </soapenv:Body>
      </soapenv:Envelope>
      
      2016-03-30 11:54:37,406 [P13T1] WARN  c.g.a.a.a.l.c.A.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/v201601">
                  <requestId>00052f42cf6238880a4c97694b0ccca2</requestId>
                  <serviceName>FeedItemService</serviceName>
                  <methodName>mutate</methodName>
                  <operations>2</operations>
                  <responseTime>43</responseTime>
              </ResponseHeader>
          </soap:Header>
          <soap:Body>
              <soap:Fault>
                  <faultcode>soap:Server</faultcode>
                  <faultstring>[DistinctError.DUPLICATE_ELEMENT @ operations[1]]</faultstring>
                  <detail>
                      <ApiExceptionFault xmlns="https://adwords.google.com/api/adwords/cm/v201601">
                          <message>[DistinctError.DUPLICATE_ELEMENT @ operations[1]]</message>
                          <ApplicationException.Type>ApiException</ApplicationException.Type>
                          <errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="DistinctError">
                              <fieldPath>operations[1]</fieldPath>
                              <trigger/>
                              <errorString>DistinctError.DUPLICATE_ELEMENT</errorString>
                              <ApiError.Type>DistinctError</ApiError.Type>
                              <reason>DUPLICATE_ELEMENT</reason>
                          </errors>
                      </ApiExceptionFault>
                  </detail>
              </soap:Fault>
          </soap:Body>
      </soap:Envelope>
      
      

      Steps to reproduce:

      1. Create and deploy an order with a location extension
      2. Change the company name and redeploy

      Note: you can also test this with sitelinks or call extensions

        Attachments

          Activity

            People

            • Assignee:
              sanjaykumar.biswal Sanjay Kumar Biswal
              Reporter:
              stacie.waleyko Stacie Waleyko (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: