org.apache.axis.AxisFault: (0)null in PQL

[tatiana....@cxense.com]

Hi,

Last week we often face with errors getting reports and loading some entities. Strange coincidence is the fact it started right after we migrated to last API v201705. 

Here is log for loading Audience_Segment entities:

2017-07-14 05:27:13.902 [WARN ] - 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/v201702" soapenv:mustUnderstand="0">
            <ns1:networkCode>29966721</ns1:networkCode>
            <ns1:applicationName>AdMax (DfpApi-Java, Dfp-Axis/3.2.0, Common-Java/3.2.0, Axis/1.4, Java/1.8.0_131, maven)</ns1:applicationName>
        </ns1:RequestHeader>
    </soapenv:Header>
    <soapenv:Body>
        <select xmlns="https://www.google.com/apis/ads/publisher/v201702">
            <selectStatement>
                <query>SELECT Id, Name FROM Audience_Segment LIMIT 500 OFFSET 79000</query>
            </selectStatement>
        </select>
    </soapenv:Body>
</soapenv:Envelope>
 [@eu-smr-qa-01.maxifier.com Sync executor#18 for pid_38,pid_39,pid_40,pid_41: Common c.g.a.a.c.l.u.l.AdsServiceLoggers.logSoapXml:84|fw5p85:903]
2017-07-14 05:27:13.902 [WARN ] - SOAP Response:
<?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:Body>
        <soapenv:Fault>
            <faultcode xmlns:ns1="http://xml.apache.org/axis/">ns1:HTTP</faultcode>
            <faultstring>(0)null</faultstring>
            <detail>
                <string>return code:  0
</string>
                <ns2:HttpErrorCode xmlns:ns2="http://xml.apache.org/axis/">0</ns2:HttpErrorCode>
            </detail>
        </soapenv:Fault>
    </soapenv:Body>
</soapenv:Envelope>


 [@eu-smr-qa-01.maxifier.com Sync executor#20 for pid_43,pid_44,pid_45,pid_46: Common c.g.a.a.c.l.u.l.AdsServiceLoggers.logSoapXml:85|fw5p85:1174]
2017-07-14 06:30:12.033 [WARN ] - Could not get pack of enities. [@eu-smr-qa-01.maxifier.com Sync executor#20 for pid_43,pid_44,pid_45,pid_46: Common c.m.i.d.u.PackExecutor.execute:115|fw5p85:1175]
org.apache.axis.AxisFault: (0)null
        at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:744) ~[axis-1.4.jar:na]
        at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144) ~[axis-1.4.jar:na]
        at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) ~[axis-1.4.jar:na]
        at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) ~[axis-1.4.jar:na]
        at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) ~[axis-1.4.jar:na]
        at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) ~[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.v201702.PublisherQueryLanguageServiceSoapBindingStub.select(PublisherQueryLanguageServiceSoapBindingStub.java:1282) ~[dfp-axis-3.2.0.jar:na]
        at sun.reflect.GeneratedMethodAccessor3490.invoke(Unknown Source) ~[na:na]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_131]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_131]
        at com.google.api.ads.common.lib.soap.SoapClientHandler.invoke(SoapClientHandler.java:109) ~[ads-lib-3.2.0.jar:na]
        at com.google.api.ads.common.lib.soap.axis.AxisHandler.invokeSoapCall(AxisHandler.java:246) ~[ads-lib-axis-3.2.0.jar:na]
        at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:62) ~[ads-lib-3.2.0.jar:na]
        at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:92) ~[ads-lib-3.2.0.jar:na]
        at com.sun.proxy.$Proxy297.select(Unknown Source) ~[na:na]
        at com.maxifier.integration.dfp6.getters.ResultTablePageGetter.getObjectsPage(ResultTablePageGetter.java:39) ~[maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.DFP6WebService.getObjectsByStatement(DFP6WebService.java:242) ~[maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.blocks.DFP6DataLoaderService$1.executeForPack(DFP6DataLoaderService.java:164) ~[maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.blocks.DFP6DataLoaderService$1.executeForPack(DFP6DataLoaderService.java:159) ~[maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.utils.PackExecutor.execute(PackExecutor.java:98) ~[maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.blocks.DFP6DataLoaderService.loadAndSaveByMapping(DFP6DataLoaderService.java:197) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.blocks.DFP6CommonSyncJob.doJob(DFP6CommonSyncJob.java:280) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.blocks.DFP6CommonSyncJob.doJob(DFP6CommonSyncJob.java:41) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.sync.JobExecutor.lambda$doJob$2(JobExecutor.java:327) [sync-reactor-17.14.0.jar:na]
        at com.maxifier.sync.JobDescriptor.lambda$wrapTask$0(JobDescriptor.java:256) ~[sync-reactor-17.14.0.jar:na]
        at com.maxifier.sync.JobExecutor.doJob(JobExecutor.java:333) [sync-reactor-17.14.0.jar:na]
        at com.maxifier.sync.JobExecutor.doWithThreads(JobExecutor.java:311) [sync-reactor-17.14.0.jar:na]
        at com.maxifier.sync.JobExecutor.doWithListeners(JobExecutor.java:273) [sync-reactor-17.14.0.jar:na]
        at com.maxifier.sync.JobExecutor.doWithServices(JobExecutor.java:252) [sync-reactor-17.14.0.jar:na]
        at com.maxifier.sync.JobExecutor.doWithHistory(JobExecutor.java:240) [sync-reactor-17.14.0.jar:na]
        at com.maxifier.sync.JobExecutor.startJobs(JobExecutor.java:174) [sync-reactor-17.14.0.jar:na]
        at com.maxifier.sync.JobExecutor.processQueue(JobExecutor.java:151) [sync-reactor-17.14.0.jar:na]
        at com.maxifier.sync.JobExecutor.lambda$submit$0(JobExecutor.java:129) [sync-reactor-17.14.0.jar:na]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[na:1.8.0_131]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[na:1.8.0_131]
        at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_131]

And here is log for loading reports:

2017-07-16 17:30:57.049 [WARN ] - 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/v201702" soapenv:mustUnderstand="0">
            <ns1:networkCode>29966721</ns1:networkCode>
            <ns1:applicationName>AdMax (DfpApi-Java, Dfp-Axis/3.2.0, Common-Java/3.2.0, Axis/1.4, Java/1.8.0_131, maven)</ns1:applicationName>
        </ns1:RequestHeader>
    </soapenv:Header>
    <soapenv:Body>
        <getReportDownloadUrlWithOptions xmlns="https://www.google.com/apis/ads/publisher/v201702">
            <reportJobId>10013359172</reportJobId>
            <reportDownloadOptions>
                <exportFormat>CSV_DUMP</exportFormat>
                <includeReportProperties>false</includeReportProperties>
                <includeTotalsRow>false</includeTotalsRow>
                <useGzipCompression>true</useGzipCompression>
            </reportDownloadOptions>
        </getReportDownloadUrlWithOptions>
    </soapenv:Body>
</soapenv:Envelope>
 [@eu-smr-qa-01.maxifier.com default-0: ApiReport c.g.a.a.c.l.u.l.AdsServiceLoggers.logSoapXml:84|fw5p85:1885]
2017-07-16 17:30:57.049 [WARN ] - SOAP Response:
<?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:Body>
        <soapenv:Fault>
            <faultcode xmlns:ns1="http://xml.apache.org/axis/">ns1:HTTP</faultcode>
            <faultstring>(0)null</faultstring>
            <detail>
                <string>return code:  0
</string>
                <ns2:HttpErrorCode xmlns:ns2="http://xml.apache.org/axis/">0</ns2:HttpErrorCode>
            </detail>
        </soapenv:Fault>
    </soapenv:Body>
</soapenv:Envelope>

[@eu-smr-qa-01.maxifier.com default-0: ApiReport c.g.a.a.c.l.u.l.AdsServiceLoggers.logSoapXml:85|fw5p85:1886]
2017-07-16 17:30:57.053 [WARN ] - ApiException ((0)null) is rethrown [@eu-smr-qa-01.maxifier.com default-0: ApiReport c.m.i.DFP6ServiceProxy.invoke:81|fw5p85:1887]
org.apache.axis.AxisFault: (0)null
        at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:744) ~[axis-1.4.jar:na]
        at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144) ~[axis-1.4.jar:na]
        at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) ~[axis-1.4.jar:na]
        at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) ~[axis-1.4.jar:na]
        at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) ~[axis-1.4.jar:na]
        at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) ~[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.v201702.ReportServiceSoapBindingStub.getReportDownloadUrlWithOptions(ReportServiceSoapBindingStub.java:753) ~[dfp-axis-3.2.0.jar:na]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_131]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_131]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_131]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_131]
        at com.google.api.ads.common.lib.soap.SoapClientHandler.invoke(SoapClientHandler.java:109) ~[ads-lib-3.2.0.jar:na]
        at com.google.api.ads.common.lib.soap.axis.AxisHandler.invokeSoapCall(AxisHandler.java:246) ~[ads-lib-axis-3.2.0.jar:na]
        at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:62) ~[ads-lib-3.2.0.jar:na]
        at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:92) ~[ads-lib-3.2.0.jar:na]
        at com.sun.proxy.$Proxy311.getReportDownloadUrlWithOptions(Unknown Source) [na:na]
        at sun.reflect.GeneratedMethodAccessor1273.invoke(Unknown Source) ~[na:na]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_131]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_131]
        at com.maxifier.integration.DFP6ServiceProxy.invoke(DFP6ServiceProxy.java:64) ~[maxifier-integration-dfp6-17.14.0.jar:na]
        at com.sun.proxy.$Proxy311.getReportDownloadUrlWithOptions(Unknown Source) [na:na]
        at com.google.api.ads.dfp.axis.utils.v201702.ReportDownloader.getDownloadUrl(ReportDownloader.java:189) [dfp-axis-3.2.0.jar:na]
        at com.maxifier.integration.DFP6WebService.downloadReportToOutputStream(DFP6WebService.java:768) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.DFP6WebService.downloadReport(DFP6WebService.java:741) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.DFP6WebService.executeReport(DFP6WebService.java:637) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.DFP6WebService.runReportJob(DFP6WebService.java:617) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.reportloader.DFP6AbstractUnfilledReportLoader.loadToCsv(DFP6AbstractUnfilledReportLoader.java:210) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.reportloader.DFP6AbstractReportLoader.loadAndSave(DFP6AbstractReportLoader.java:123) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.blocks.DFP6ApiReportSyncJob$ReportTask.call(DFP6ApiReportSyncJob.java:907) [maxifier-integration-dfp6-17.14.0.jar:na]
        at com.maxifier.integration.dfp6.blocks.DFP6ApiReportSyncJob$ReportTask.call(DFP6ApiReportSyncJob.java:820) [maxifier-integration-dfp6-17.14.0.jar:na]
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_131]
        at com.maxifier.sync.JobDescriptor.lambda$wrapTask$1(JobDescriptor.java:277) [sync-reactor-17.14.0.jar:na]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[na:1.8.0_131]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[na:1.8.0_131]
        at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_131]

Could you help with that?

[Vincent Racaza (DFP API Team)]

Hi,

I could not replicate your issue. I tried to get all the audience segments using PublisherQueryLanguageService in your network (29966721) and I was able to get all the 150,000+ audience segments successfully. I also tried to run a simple report and the report generation was also a success. I am using the v201705 version of the Java client library.

Could you confirm if this issue is consistent in your network? If you can confirm this, could you also try the other API services and check if the same issue will occur?

Thanks,

Vincent Racaza, DFP API Team

[tatiana....@cxense.com]

Hi, Vincent,

I guess issue is due to high load on DFP services, because single report run or single entity load works fine. We faces with error in the middle of usual daily entities and reports update. Interrupting API calls in 5 min does help, after that API responses become correct again. The question is why did this start to happen? Could you specify the limits of DFP services performance, e.g. per second? I would be glad if you'll show me documentation about that, if it exists.

[Vincent Racaza (DFP API Team)]

Hi,

You are right. Unexpected errors happen when there are a lot of requests per second in your network. There's a limitation on the number of requests per second. For small business networks, you are only allowed for 2 requests per second. For premium networks, the maximum is 8 requests per second. You can check this limitation here.

Let me know if you have further clarifications.

[tatiana....@cxense.com]

Thanks!