Hi Maxim:We are looking into this right now. Some questions for you:(1) Does a same report sometimes work and sometimes fail? That is, has a retry ever succeeded?
(2) Did any reports succeed today at all?Thanks,Vincent Tsao, DFP API Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
An important reminder: v201203, v201204, v201206 and lower have been
deprecated.
Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/dfp_api
https://developers.google.com/doubleclick-publishers/community
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
On 06/24/13 01:15:56 maxim....@maxifier.com wrote:Hi Adam,This problem still there:2013-06-24 05:57:27.304 [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/v201302" soapenv:mustUnderstand="0"><ns1:networkCode>NNNN</ns1:networkCode><ns1:applicationName> (DfpApi-Java, Dfp-Axis/1.14.1, Common-Java/1.14.1, Axis/1.4, Java/1.6.0_31, maven)</ns1:applicationName><ns1:authentication xsi:type="ns1:ClientLogin"><ns1:token></ns1:token></ns1:authentication></ns1:RequestHeader></soapenv:Header><soapenv:Body><getReportDownloadURL xmlns="https://www.google.com/apis/ads/publisher/v201302"><reportJobId>2167803294</reportJobId><exportFormat>CSV_DUMP</exportFormat></getReportDownloadURL></soapenv:Body></soapenv:Envelope>2013-06-24 05:57:27.305 [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>soapenv:Server.userException</faultcode><faultstring>java.net.SocketTimeoutException: Read timed out</faultstring><detail><ns1:stackTrace xmlns:ns1="http://xml.apache.org/axis/">java.net.SocketTimeoutException: Read timed outat java.net.SocketInputStream.socketRead0(Native Method)at java.net.SocketInputStream.read(SocketInputStream.java:129)at com.sun.net.ssl.internal.ssl.InputRecord.readFully(InputRecord.java:293)at com.sun.net.ssl.internal.ssl.InputRecord.read(InputRecord.java:331)at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:830)at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:787)at com.sun.net.ssl.internal.ssl.AppInputStream.read(AppInputStream.java:75)at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)at java.io.BufferedInputStream.read(BufferedInputStream.java:237)at org.apache.axis.transport.http.HTTPSender.readHeadersFromSocket(HTTPSender.java:583)at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:143)at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)at org.apache.axis.client.Call.invokeEngine(Call.java:2784)at org.apache.axis.client.Call.invoke(Call.java:2767)at org.apache.axis.client.Call.invoke(Call.java:2443)at org.apache.axis.client.Call.invoke(Call.java:2366)at org.apache.axis.client.Call.invoke(Call.java:1812)at com.google.api.ads.dfp.axis.v201302.ReportServiceSoapBindingStub.getReportDownloadURL(ReportServiceSoapBindingStub.java:595)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at com.google.api.ads.common.lib.soap.SoapClientHandler.invoke(SoapClientHandler.java:109)at com.google.api.ads.common.lib.soap.axis.AxisHandler.invokeSoapCall(AxisHandler.java:175)at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:64)at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:93)at $Proxy181.getReportDownloadURL(Unknown Source)at com.google.api.ads.dfp.axis.utils.v201302.ReportDownloader.getDownloadUrl(ReportDownloader.java:193)at com.google.api.ads.dfp.axis.utils.v201302.ReportDownloader.downloadReport(ReportDownloader.java:164)at com.maxifier.integration.DFP6WebService$4.call(DFP6WebService.java:625)at com.maxifier.integration.DFP6WebService$4.call(DFP6WebService.java:619)at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)at java.util.concurrent.FutureTask.run(FutureTask.java:138)at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)at java.lang.Thread.run(Thread.java:662)</ns1:stackTrace><ns2:hostname xmlns:ns2="http://xml.apache.org/axis/"></ns2:hostname></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>Could you take a look again on this?Thanks,2013/6/21 Adam Rogal (DFP API Team) <dfpapi-advisor+adam@google.com>
Hi Simon,Is this still occurring for you? If so, can you please let me know your report job ID?Thanks,Adam Rogal, DFP API Team
On Friday, June 21, 2013 4:45:42 AM UTC-4, Maxim Oreshek wrote:Hi Guys,We are now trying to get some reports and getting error from API.Request:2013-06-21 05:39:20.373 (BST) [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/v201302" soapenv:mustUnderstand="0"><ns1:networkCode>NNNN</ns1:networkCode><ns1:applicationName>(DfpApi-Java, Dfp-Axis/1.14.1, Common-Java/1.14.1, Axis/1.4, Java/1.6.0_31, maven)</ns1:applicationName><ns1:authentication xsi:type="ns1:ClientLogin"><ns1:token>***TOKEN***</ns1:token></ns1:authentication></ns1:RequestHeader></soapenv:Header><soapenv:Body><getReportDownloadURL xmlns="https://www.google.com/apis/ads/publisher/v201302"><reportJobId>JobID</reportJobId><exportFormat>CSV_DUMP</exportFormat></getReportDownloadURL></soapenv:Body></soapenv:Envelope>Result:2013-06-21 05:39:20.373 (BST) [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>soapenv:Server.userException</faultcode><faultstring>java.net.SocketTimeoutException: Read timed out</faultstring><detail><ns1:stackTrace xmlns:ns1="http://xml.apache.org/axis/">java.net.SocketTimeoutException: Read timed outat java.net.SocketInputStream.socketRead0(Native Method)at java.net.SocketInputStream.read(SocketInputStream.java:129)at com.sun.net.ssl.internal.ssl.InputRecord.readFully(InputRecord.java:293)at com.sun.net.ssl.internal.ssl.InputRecord.read(InputRecord.java:331)at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:830)at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:787)at com.sun.net.ssl.internal.ssl.AppInputStream.read(AppInputStream.java:75)at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)at java.io.BufferedInputStream.read(BufferedInputStream.java:237)at org.apache.axis.transport.http.HTTPSender.readHeadersFromSocket(HTTPSender.java:583)at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:143)at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)at org.apache.axis.client.Call.invokeEngine(Call.java:2784)at org.apache.axis.client.Call.invoke(Call.java:2767)at org.apache.axis.client.Call.invoke(Call.java:2443)at org.apache.axis.client.Call.invoke(Call.java:2366)at org.apache.axis.client.Call.invoke(Call.java:1812)at com.google.api.ads.dfp.axis.v201302.ReportServiceSoapBindingStub.getReportDownloadURL(ReportServiceSoapBindingStub.java:595)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at com.google.api.ads.common.lib.soap.SoapClientHandler.invoke(SoapClientHandler.java:109)at com.google.api.ads.common.lib.soap.axis.AxisHandler.invokeSoapCall(AxisHandler.java:175)at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:64)at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:93)at $Proxy180.getReportDownloadURL(Unknown Source)at com.google.api.ads.dfp.axis.utils.v201302.ReportDownloader.getDownloadUrl(ReportDownloader.java:193)at com.google.api.ads.dfp.axis.utils.v201302.ReportDownloader.downloadReport(ReportDownloader.java:164)at com.maxifier.integration.DFP6WebService$4.call(DFP6WebService.java:625)at com.maxifier.integration.DFP6WebService$4.call(DFP6WebService.java:619)at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)at java.util.concurrent.FutureTask.run(FutureTask.java:138)at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)at java.lang.Thread.run(Thread.java:662)</ns1:stackTrace><ns2:hostname xmlns:ns2="http://xml.apache.org/axis/">servername</ns2:hostname></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>Until now, the problem still occurs.Could you confirm the problem?Thanks,--____________________
Maxim Oreshek
Maintenance Engineer
Mob: +7-937-794-75-09
Skype: romeg_ul
http://www.maxifier.ru
____________________
Maxim Oreshek
Maintenance Engineer
Mob: +7-937-794-75-09
Skype: romeg_ul
http://www.maxifier.ru
Hi Vincent,1) We do the 5 requests with 5 minute timeout between. If report failed we do 5 minute pause and request again.So sometime it help, sometime not.Logs:
1) In this case we have only third request successful2013-06-24 13:00:16.553 (BST) [INFO ] - Run report Job (reportJobId = 2167847694)2013-06-24 13:10:47.462 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...> <reportJobId>2167847694</reportJobId>2013-06-24 13:21:47.956 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...> <reportJobId>2167847694</reportJobId>2013-06-24 13:30:38.564 (BST) [DEBUG] - Report file report_2013-06-12_2013-06-13_1372076567965_55.csv.gz has been saved
2) In this case 2167892454 we haven't success even after 5 times.Logs:2013-06-24 18:57:05.018 (BST) [INFO ] - Run report Job (reportJobId = 2167892454)
2013-06-24 19:08:06.393 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:19:07.068 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:30:07.648 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:41:08.230 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:52:08.731 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>3) Before Friday for exactly the same report usually we have successful response after first attempt.
Hi Vincent,1) We do the 5 requests with 5 minute timeout between. If report failed we do 5 minute pause and request again.So sometime it help, sometime not.Logs:
1) In this case we have only third request successful2013-06-24 13:00:16.553 (BST) [INFO ] - Run report Job (reportJobId = 2167847694)2013-06-24 13:10:47.462 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...> <reportJobId>2167847694</reportJobId>2013-06-24 13:21:47.956 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...> <reportJobId>2167847694</reportJobId>2013-06-24 13:30:38.564 (BST) [DEBUG] - Report file report_2013-06-12_2013-06-13_1372076567965_55.csv.gz has been saved
2) In this case 2167892454 we haven't success even after 5 times.Logs:2013-06-24 18:57:05.018 (BST) [INFO ] - Run report Job (reportJobId = 2167892454)
2013-06-24 19:08:06.393 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:19:07.068 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:30:07.648 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:41:08.230 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:52:08.731 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>3) Before Friday for exactly the same report usually we have successful response after first attempt.
2015-03-17 19:42:24,623 [pool-2-thread-1] WARN c.g.a.a.d.l.client.DfpServiceClient.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://www.google.com/apis/ads/publisher/v201411" soapenv:mustUnderstand="0"> <ns1:networkCode>5555</ns1:networkCode> <ns1:applicationName>Revee (DfpApi-Java, Dfp-Axis/1.36.0, Common-Java/1.36.0, Axis/1.4, Java/1.7.0_76, maven)</ns1:applicationName> </ns1:RequestHeader> </soapenv:Header> <soapenv:Body> <runReportJob xmlns="https://www.google.com/apis/ads/publisher/v201411"> <reportJob> <reportQuery> <dimensions>LINE_ITEM_ID</dimensions> <columns>AD_SERVER_IMPRESSIONS</columns> <columns>AD_SERVER_ALL_REVENUE</columns> <columns>AD_SERVER_CLICKS</columns> <dateRangeType>TODAY</dateRangeType> <statement> <query>WHERE LINE_ITEM_ID IN (555555555,about 200 line time ids)</query> </statement> </reportQuery> </reportJob> </runReportJob> </soapenv:Body> </soapenv:Envelope> 2015-03-17 19:42:24,623 [pool-2-thread-1] WARN c.g.a.a.d.l.client.DfpServiceClient.soapXmlLogger - 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>soapenv:Server.userException</faultcode> <faultstring>java.net.SocketTimeoutException: Read timed out</faultstring> <detail> <ns1:stackTrace xmlns:ns1="http://xml.apache.org/axis/">java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:152) at java.net.SocketInputStream.read(SocketInputStream.java:122) at sun.security.ssl.InputRecord.readFully(InputRecord.java:442) at sun.security.ssl.InputRecord.read(InputRecord.java:480) at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:934) at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:891) at sun.security.ssl.AppInputStream.read(AppInputStream.java:102) at java.io.BufferedInputStream.fill(BufferedInputStream.java:235) at java.io.BufferedInputStream.read(BufferedInputStream.java:254) at org.apache.axis.transport.http.HTTPSender.readHeadersFromSocket(HTTPSender.java:583) at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:143) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.google.api.ads.dfp.axis.v201411.ReportServiceSoapBindingStub.runReportJob(ReportServiceSoapBindingStub.java:749) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.google.api.ads.common.lib.soap.SoapClientHandler.invoke(SoapClientHandler.java:109) at com.google.api.ads.common.lib.soap.axis.AxisHandler.invokeSoapCall(AxisHandler.java:213) at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:64) at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:93) at com.sun.proxy.$Proxy19.runReportJob(Unknown Source) at com.accessmedia.integration.google.dfp.MetricsService.runReportJob(MetricsService.java:354) at com.accessmedia.integration.google.dfp.MetricsService.runImpressionsServedReport(MetricsService.java:320) at com.accessmedia.integration.google.dfp.MetricsService.getTodayMetrics(MetricsService.java:564) at com.accessmedia.analytics.etl.revenue.dfp.LineItemMetricsEtl$1.call(LineItemMetricsEtl.java:580) at com.accessmedia.analytics.etl.revenue.dfp.LineItemMetricsEtl$1.call(LineItemMetricsEtl.java:539) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) </ns1:stackTrace> <ns2:hostname xmlns:ns2="http://xml.apache.org/axis/">ip-172-31-21-230</ns2:hostname> </detail> </soapenv:Fault> </soapenv:Body> </soapenv:Envelope>
On Monday, June 24, 2013 at 11:29:55 PM UTC-7, Maxim Oreshek wrote:
Hi Vincent,1) We do the 5 requests with 5 minute timeout between. If report failed we do 5 minute pause and request again.So sometime it help, sometime not.Logs:
1) In this case we have only third request successful2013-06-24 13:00:16.553 (BST) [INFO ] - Run report Job (reportJobId = 2167847694)2013-06-24 13:10:47.462 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...> <reportJobId>2167847694</reportJobId>2013-06-24 13:21:47.956 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...> <reportJobId>2167847694</reportJobId>2013-06-24 13:30:38.564 (BST) [DEBUG] - Report file report_2013-06-12_2013-06-13_1372076567965_55.csv.gz has been saved
2) In this case 2167892454 we haven't success even after 5 times.Logs:2013-06-24 18:57:05.018 (BST) [INFO ] - Run report Job (reportJobId = 2167892454)
2013-06-24 19:08:06.393 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:19:07.068 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:30:07.648 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:41:08.230 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>2013-06-24 19:52:08.731 (BST) [WARN ] - SOAP Response:<...>java.net.SocketTimeoutException: Read timed out <...>3) Before Friday for exactly the same report usually we have successful response after first attempt.
...