getLineItemsByStatement Exception SERVER_ERROR

[Anthony Garcia]

We have been getting this esception for over a month when we try using the API.

WARNING: Request made: Service: LineItemService Method: getLineItemsByStatement networkCode: 29484806 URL: https://ads.google.com/apis/ads/publisher/v201711/LineItemService Request ID: 92a6c7d5df471fa6addeaf08b0641300 ResponseTime(ms): 95 OperationsCount: null IsFault: true FaultMessage: ApiException{errors=[ServerError{errorString=ServerError.SERVER_ERROR, fieldPath=, reason=SERVER_ERROR, trigger=}]}

INFO: 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://www.google.com/apis/ads/publisher/v201711" soapenv:mustUnderstand="0">
            <ns1:networkCode>29484806</ns1:networkCode>
            <ns1:applicationName>eeDfpAccess (DfpApi-Java, Dfp-Axis/3.13.0, Common-Java/3.13.0, Axis/1.4, Java/1.8.0_151, maven)</ns1:applicationName>
        </ns1:RequestHeader>
    </soapenv:Header>
    <soapenv:Body>
        <getLineItemsByStatement xmlns="https://www.google.com/apis/ads/publisher/v201711">
            <filterStatement>
                <query>WHERE LastModifiedDateTime &gt; :lmd</query>
                <values>
                    <key>lmd</key>
                    <value xmlns:ns2="https://www.google.com/apis/ads/publisher/v201711" xsi:type="ns2:DateTimeValue">
                        <ns2:value>
                            <ns2:date>
                                <ns2:year>2018</ns2:year>
                                <ns2:month>3</ns2:month>
                                <ns2:day>11</ns2:day>
                            </ns2:date>
                            <ns2:hour>2</ns2:hour>
                            <ns2:minute>6</ns2:minute>
                            <ns2:second>1</ns2:second>
                            <ns2:timeZoneID>America/Los_Angeles</ns2:timeZoneID>
                        </ns2:value>
                    </value>
                </values>
            </filterStatement>
        </getLineItemsByStatement>
    </soapenv:Body>
</soapenv:Envelope>


Apr 24, 2018 10:21:05 AM com.google.api.ads.common.lib.utils.logging.RemoteCallLoggerDelegate logRequestDetails
INFO: SOAP response:
<?xml version="1.0" encoding="UTF-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Header>
        <ResponseHeader xmlns="https://www.google.com/apis/ads/publisher/v201711">
            <requestId>92a6c7d5df471fa6addeaf08b0641300</requestId>
            <responseTime>95</responseTime>
        </ResponseHeader>
    </soap:Header>
    <soap:Body>
        <soap:Fault>
            <faultcode>soap:Server</faultcode>
            <faultstring>[ServerError.SERVER_ERROR @ ]</faultstring>
            <detail>
                <ApiExceptionFault xmlns="https://www.google.com/apis/ads/publisher/v201711">
                    <message>[ServerError.SERVER_ERROR @ ]</message>
                    <errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ServerError">
                        <fieldPath/>
                        <trigger/>
                        <errorString>ServerError.SERVER_ERROR</errorString>
                        <reason>SERVER_ERROR</reason>
                    </errors>
                </ApiExceptionFault>
            </detail>
        </soap:Fault>
    </soap:Body>
</soap:Envelope>

[Nicholas Figeac (DFP API Team)]

Hello,

The request structure is correct but 2018-03-11T02:06:01 technically does not exist because of daylight savings time. Therefore any value between 01:59:99 and 03:00:00 will not work for that day (2018-03-11). You will need to update the time for that day.

Thanks,
Nicholas Figeac, DFP API Team

[Anthony Garcia]

Hello Nicholas,

thank you for taking the time to look into this. It seems that was the reason behind our error. I ran the report starting at the following hour and it seemed to run to completion correctly.