Exception while getting CustomTargetingValues by statement

[Elena Saymanina]

Hi all,

I have some problems while I'm trying to get CustomTargetingValues by statement. This method worked fine earlier, but now I'm getting SOAP Response = null and Exception.

NetworkCode = 3379. Here are an example of SOAP request and StackTrace:

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/v201302" soapenv:mustUnderstand="0">
            <ns1:networkCode>3379</ns1:networkCode>
            <ns1:applicationName>null (DfpApi-Java, Dfp-Axis/1.20.1, Common-Java/1.14.1, Axis/1.4, Java/1.6.0_45, maven)</ns1:applicationName>
        </ns1:RequestHeader>
    </soapenv:Header>
    <soapenv:Body>
        <getCustomTargetingValuesByStatement xmlns="https://www.google.com/apis/ads/publisher/v201302">
            <filterStatement>
                <query>LIMIT 2 OFFSET 18572</query>
            </filterStatement>
        </getCustomTargetingValuesByStatement>
    </soapenv:Body>
</soapenv:Envelope>

SOAP Response:
null

java.rmi.RemoteException: ; nested exception is: 
        org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x1f) was found in the element content of the document.; nested exception is: 
        org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x1f) was found in the element content of the document.
...
Caused by: org.apache.axis.AxisFault: ; nested exception is: 
        org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x1f) was found in the element content of the document.
        at org.apache.axis.AxisFault.makeFault(AxisFault.java:101) ~[axis-1.4.jar:na]
        at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:701) ~[axis-1.4.jar:na]
        at org.apache.axis.Message.getSOAPEnvelope(Message.java:435) ~[axis-1.4.jar:na]
        at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62) ~[axis-1.4.jar:na]
        at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206) ~[axis-1.4.jar:na]
        at org.apache.axis.client.Call.invokeEngine(Call.java:2784) ~[axis-1.4.jar:na]
        at org.apache.axis.client.Call.invoke(Call.java:2767) ~[axis-1.4.jar:na]
        at org.apache.axis.client.Call.invoke(Call.java:2443) ~[axis-1.4.jar:na]
        at org.apache.axis.client.Call.invoke(Call.java:2366) ~[axis-1.4.jar:na]
        at org.apache.axis.client.Call.invoke(Call.java:1812) ~[axis-1.4.jar:na]
        at com.google.api.ads.dfp.axis.v201302.CustomTargetingServiceSoapBindingStub.getCustomTargetingValuesByStatement(CustomTargetingServiceSoapBindingStub.java:849) ~[dfp-axis-1.20.1.jar:na]
        at sun.reflect.GeneratedMethodAccessor4574.invoke(Unknown Source) ~[na:na]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_45]
        at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_45]
        at com.google.api.ads.common.lib.soap.SoapClientHandler.invoke(SoapClientHandler.java:109) ~[ads-lib-1.20.1.jar:na]
        at com.google.api.ads.common.lib.soap.axis.AxisHandler.invokeSoapCall(AxisHandler.java:175) ~[ads-lib-axis-1.20.1.jar:na]
        at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:64) ~[ads-lib-1.20.1.jar:na]
        at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:93) ~[ads-lib-1.20.1.jar:na]
        at com.sun.proxy.$Proxy279.getCustomTargetingValuesByStatement(Unknown Source) ~[na:na]
        at sun.reflect.GeneratedMethodAccessor4573.invoke(Unknown Source) ~[na:na]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_45]
        at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_45]
        at com.maxifier.integration.dfp6.getters.ResultEntitiesPageGetter.getObjectsPage(ResultEntitiesPageGetter.java:35) ~[maxifier-integration-dfp6-1.18.3.jar:na]
        at com.maxifier.integration.DFP6WebService.getObjectsByStatement(DFP6WebService.java:135) ~[maxifier-integration-dfp6-1.18.3.jar:na]
        ... 15 common frames omitted
Caused by: org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x1f) was found in the element content of the document.
        at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) ~[xercesImpl-2.9.1.jar:na]
        at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227) ~[axis-1.4.jar:na]
        at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696) ~[axis-1.4.jar:na]
        ... 37 common frames omitted

Is there any ideas why does it happen?

Thanks,
Elena.

[Vincent Tsao (DFP API Team)]

Hi Elena:

The issue is that there are invalid characters for XML in some custom targeting values on that network, hence when they are retrieved via the SOAP API, it is invalid XML. We are working to fix these kinds of issues, but for now you can filter out the following custom targeting value IDs (on network 3379):

67361919655

58077063055

and you can continue to pull down all your custom criteria for now. I will try to update this thread when I have more information.

Thanks,

Vincent Tsao, DFP API Team

[Elena Saymanina]

Thanks, Vincent!