problem while fetching the data for dimension city_name

[ankur....@timesinternet.in]

Hi,

I am facing problem while fetching the data for dimension city_name.

parameters passed as list are:

dimension: [CITY_NAME]  /  [DATE,LINE_ITEM_NAME,LINE_ITEM_ID,CITY_NAME] / [DATE,CITY_NAME]

column: [AD_SERVER_IMPRESSIONS,AD_SERVER_CLICKS,AD_SERVER_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS,AD_SERVER_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS,AD_SERVER_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS,VIDEO_VIEWERSHIP_START,VIDEO_VIEWERSHIP_FIRST_QUARTILE,VIDEO_VIEWERSHIP_MIDPOINT,VIDEO_VIEWERSHIP_THIRD_QUARTILE,VIDEO_VIEWERSHIP_COMPLETE,VIDEO_VIEWERSHIP_AVERAGE_VIEW_RATE,VIDEO_VIEWERSHIP_AVERAGE_VIEW_TIME,VIDEO_VIEWERSHIP_COMPLETION_RATE,VIDEO_VIEWERSHIP_TOTAL_ERROR_COUNT,VIDEO_VIEWERSHIP_TOTAL_ERROR_RATE,VIDEO_VIEWERSHIP_VIDEO_LENGTH,VIDEO_VIEWERSHIP_SKIP_BUTTON_SHOWN,VIDEO_VIEWERSHIP_ENGAGED_VIEW,VIDEO_VIEWERSHIP_VIEW_THROUGH_RATE,VIDEO_VIEWERSHIP_AUTO_PLAYS,VIDEO_VIEWERSHIP_CLICK_TO_PLAYS]

exception occurs at following line : reportService.runReportJob(reportJob);

exception:

com.google.api.ads.dfp.axis.v201608.ApiException: null

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:422)

at java.lang.Class.newInstance(Class.java:442)

at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:104)

at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:90)

at com.google.api.ads.dfp.axis.v201608.ApiException.getDeserializer(ApiException.java:154)

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

at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized(BaseDeserializerFactory.java:154)

at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs(BaseDeserializerFactory.java:84)

at org.apache.axis.encoding.DeserializationContext.getDeserializer(DeserializationContext.java:464)

at org.apache.axis.encoding.DeserializationContext.getDeserializerForType(DeserializationContext.java:547)

at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild(SOAPFaultDetailsBuilder.java:157)

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

at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)

at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)

at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)

at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)

at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)

at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)

at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)

at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)

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.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)

at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)

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.v201608.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:497)

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

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.$Proxy124.runReportJob(Unknown Source)

at com.til.das.service.DFPReportsServiceImpl.generateReports(DFPReportsServiceImpl.java:131)

at com.til.das.service.DFPReportsServiceImpl.execute(DFPReportsServiceImpl.java:57)

at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

Please help to fetch the data.

[Vincent Racaza (DFP API Team)]

Hi,

Thanks for providing the report parameters.

Were you able to do this report in the UI? I am asking this since not all report combinations (dimensions and columns) are supported. We always recommend to do the report in the UI first to check if the report combination is valid or not. In my test network, when I added the "City" dimension in the UI, other columns were disabled. These columns include AD_SERVER_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS, AD_SERVER_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS, etc.

Please do the report in the UI first. If it is successful in the UI, then the same report can be generated through the API.

Thanks,

Vincent Racaza, DFP API Team