Re: Has any one seen this error when running ReportJob

[Tesfamichael Hailegeorgis(DFP API Team)]

Hi,

To confirm, are you still experiencing this issue? I am asking this as I am able to run this report in my test network. Please try to pass the startDate and endDate values in the following format:

reportQuery.setStartDate(DateTimes.toDateTime("2017-3-5T00:00:00", "America/New_York").getDate()); //Use your network's time zone if it is different from America/New_York

reportQuery.setEndDate(DateTimes.toDateTime("2017-3-7T00:00:00", "America/New_York").getDate());

 Feel free to let us know how this goes.

Thanks,

Tesfamichael Hailegeorgis, DFP API Team

On Monday, March 6, 2017 at 5:57:13 PM UTC-5, JJ wrote:

Hi

I was trying to get DFP report using ReportJob, like this:

        ReportServiceInterface reportService = dfpService.get(dfpSession, ReportServiceInterface.class);
        ReportQuery reportQuery = new ReportQuery();

        reportQuery.setDimensions(new Dimension[] {Dimension.DATE, Dimension.HOUR, Dimension.LINE_ITEM_ID});
        reportQuery.setColumns(new Column[] {Column.TOTAL_LINE_ITEM_LEVEL_IMPRESSIONS, Column.TOTAL_LINE_ITEM_LEVEL_CLICKS, Column.TOTAL_LINE_ITEM_LEVEL_CTR});
        reportQuery.setDateRangeType(DateRangeType.CUSTOM_DATE);
        reportQuery.setStartDate(DateTimes.toDateTime(new DateTime().minusDays(2)).getDate());
        reportQuery.setEndDate(new com.google.api.ads.dfp.axis.v201702.Date());

        ReportJob reportJob = new ReportJob();
        reportJob.setReportQuery(reportQuery);
        reportJob = reportService.runReportJob(reportJob);

But I'm getting this error, 

 "Invalid element in com.google.api.ads.dfp.axis.v201702.ReportError - fieldPathElements"

doesn't seem to give me much direction to fix it, wondering has anyone met this before? Any insights for what I need to do here? 

Thanks!

Full log here:

06-Mar-2017 17:14:04.078 SEVERE [ScheduleFilter] com.some.class Error processing line items

 AxisFault

 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException

 faultSubcode: 

 faultString: org.xml.sax.SAXException: Invalid element in com.google.api.ads.dfp.axis.v201702.ReportError - fieldPathElements

 faultActor: 

 faultNode: 

 faultDetail: 

{http://xml.apache.org/axis/}stackTrace:org.xml.sax.SAXException: Invalid element in com.google.api.ads.dfp.axis.v201702.ReportError - fieldPathElements

at org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserializer.java:258)

at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:509)

at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:380)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2787)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)

at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:118)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:643)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:327)

at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)

at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)

at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)

at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:796)

at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)

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.v201702.ReportServiceSoapBindingStub.runReportJob(ReportServiceSoapBindingStub.java:872)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

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:246)

at com.google.api.ads.common.lib.soap.SoapServiceClient.callSoapClient(SoapServiceClient.java:62)

at com.google.api.ads.common.lib.soap.SoapServiceClient.invoke(SoapServiceClient.java:92)

at com.sun.proxy.$Proxy230.runReportJob(Unknown Source)

at com.some.taskclass.getReport(taskclass.java:123)// call-site class

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

[JJ]

Hi Tesfamichael,

Thanks for your reply, I'm able to solve this issue by update my api version to 3.1.1 (didn't think that would be related...). 

But I'm having another issue on report column, could you help take a look? https://groups.google.com/forum/#!topic/google-doubleclick-for-publishers-api/K_mxEF_Z4h0