christopherseeley
commented
4 years ago Apologies for the late reply here, please reopen if this is still an issue. For posterity this may have been caused by a change to the custom field settings or your user's permissions.
hi team,
we are getting the Report from dfp using custom fields for past 3 months.
Today while running the same class we got below error,
Exception in thread "main" java.lang.IllegalStateException: Report 11240782934 must be completed before downloading. It is currently: IN_PROGRESS at com.google.common.base.Preconditions.checkState(Preconditions.java:444) at com.google.api.ads.admanager.axis.utils.v201811.ReportDownloader.getDownloadUrl(ReportDownloader.java:181) at banner.RunReportWithCustomFields.runExample(RunReportWithCustomFields.java:120) at banner.RunReportWithCustomFields.createCredentialAndDfSession(RunReportWithCustomFields.java:166) at banner.RunReportWithCustomFields.main(RunReportWithCustomFields.java:205)
my class file is:
public class RunReportWithCustomFields { //static boolean downloadstatus = false;
private static class RunReportWithCustomFieldsParams extends CodeSampleParams { @Parameter(names = ArgumentNames.CUSTOM_FIELD_ID, required = true, description = "The ID of the custom field to include in the report.") // private long[] customFieldId_HC = new long[3];//info:have to change the length when new column is added in DFP private long[] customFieldId_CUG = new long[2];//info:have to change the length when new column is added in DFP }
/**
complete. */ public static void runExample(AdManagerServices adManagerServices, AdManagerSession session,String downloadFileName, long[] customFieldId) throws IOException, InterruptedException { // Get the ReportService. ReportServiceInterface reportService = adManagerServices.get(session, ReportServiceInterface.class);
// Create report query. ReportQuery reportQuery = new ReportQuery(); reportQuery.setDimensions(new Dimension[] { Dimension.DATE, Dimension.ORDER_ID, Dimension.LINE_ITEM_ID, Dimension.LINE_ITEM_NAME }); reportQuery.setColumns(new Column[] { Column.AD_SERVER_IMPRESSIONS, Column.AD_SERVER_CLICKS, Column.AD_SERVER_CTR}); reportQuery.setDimensionAttributes(new DimensionAttribute[] { DimensionAttribute.LINE_ITEM_START_DATE_TIME,DimensionAttribute.LINE_ITEM_END_DATE_TIME}); // Set the dynamic date range type or a custom start and end date. // reportQuery.setDateRangeType(DateRangeType.YESTERDAY); // reportQuery.setDateRangeType(DateRangeType.LAST_3_MONTHS); // reportQuery.setDateRangeType(DateRangeType.CUSTOM_DATE); // reportQuery.setStartDate(DateTimes.toDateTime("2018-10-01T00:00:00", // "America/New_York").getDate()); // reportQuery.setEndDate(DateTimes.toDateTime("2019-04-29T00:00:00", // "America/New_York").getDate()); reportQuery.setDateRangeType(DateRangeType.TODAY);
// Set the custom field IDs. reportQuery.setCustomFieldIds(customFieldId); // Create report job. ReportJob reportJob = new ReportJob(); reportJob.setReportQuery(reportQuery);
// Run report job. reportJob = reportService.runReportJob(reportJob); System.out.println(reportJob+" reportJob"); // Create report downloader. ReportDownloader reportDownloader = new ReportDownloader(reportService, reportJob.getId());
// Wait for the report to be ready. reportDownloader.waitForReportReady(); System.out.println(downloadFileName+" file Downloading started ..."); // Change to your file location. File file = File.createTempFile(downloadFileName, ".csv.gz", new File(BannerConstants.CSV_FILE_DOWNLOAD_PATH));
System.out.println("Downloading report to %s ..." + file.toString());
// Download the report. ReportDownloadOptions options = new ReportDownloadOptions(); options.setExportFormat(ExportFormat.CSV_DUMP); options.setUseGzipCompression(true); URL url = reportDownloader.getDownloadUrl(options); Resources.asByteSource(url).copyTo(Files.asByteSink(file)); System.out.println(downloadFileName+" file downloading done."); // downloadstatus = true; }
public static long[] setParams(String[] args,String[] customFieldIds,Boolean accountTypeIsCUG){ RunReportWithCustomFieldsParams params = new RunReportWithCustomFieldsParams(); long[] assignedParams = new long[customFieldIds.length]; if (!params.parseArguments(args)) { // Either pass the required parameters for this example on the // command line, or insert them // into the code here. See the parameter class definition above for // descriptions. // for(int i = 0;i < customFieldIds.length;i++){ for (int i = 0; i < customFieldIds.length; i++) { if(accountTypeIsCUG){
params.customFieldId_CUG[i] = Long.parseLong(customFieldIds[i]); assignedParams[i] = params.customFieldId_CUG[i]; }else{ // params.customFieldId_HC[i] = Long.parseLong(customFieldIds[i]); // assignedParams[i] = params.customFieldId_HC[i]; } } } return assignedParams; }
public static void createCredentialAndDfSession(String credentialPath,String applicationName,String networkCode,String downloadFileName,long[] dfpParams){ AdManagerSession session; try { // Generate a refreshable OAuth2 credential. Credential oAuth2Credential = new OfflineCredentials.Builder().forApi(Api.AD_MANAGER).withJsonKeyFilePath(credentialPath).build().generateCredential(); // Construct a DfpSession. session = new AdManagerSession.Builder().withApplicationName(applicationName).withNetworkCode(networkCode).withOAuth2Credential(oAuth2Credential).build(); } catch (ValidationException ve) { System.err.printf("REQUEST_FAILED configuration in the %s file. Exception: %s%n", DEFAULT_CONFIGURATION_FILENAME, ve); return; } catch (OAuthException oe) { System.err.printf("REQUEST_FAILED to create OAuth credentials. Check OAuth settings in the %s file. " + "Exception: %s%n", DEFAULT_CONFIGURATION_FILENAME, oe); return; } AdManagerServices adManagerServices = new AdManagerServices(); try { runExample(adManagerServices, session,downloadFileName ,dfpParams); } catch (ApiException apiException) { // ApiException is the base class for most exceptions thrown by an // API request. Instances // of this exception have a message and a collection of ApiErrors // that indicate the // type and underlying cause of the exception. Every exception // object in the admanager.axis // packages will return a meaningful value from toString // // ApiException extends RemoteException, so this catch block must // appear before the // catch block for RemoteException. System.err.println("REQUEST_FAILED due to ApiException. Underlying ApiErrors:"); if (apiException.getErrors() != null) { int i = 0; for (ApiError apiError : apiException.getErrors()) { System.err.printf(" Error %d: %s%n", i++, apiError); } } } catch (RemoteException re) { System.err.printf("REQUEST_FAILED unexpectedly due to RemoteException: %s%n", re); } catch (IOException ioe) { System.err.printf("REQUEST_FAILED due to IOException: %s%n", ioe); } catch (InterruptedException ie) { System.err.printf("REQUEST_FAILED Thread was interrupted: %s%n", ie); } }
public static void main(String[] args) { BannerConstants BannerConstants = new BannerConstants(); //setting parameters and fetching stats from HC account // long[] customParamsHe = setParams(args,BannerConstants.CUSTOMFIELDS_HE,false); // createCredentialAndDfSession(BannerConstants.JSON_CREDENTIAL_PATH_HC,BannerConstants.APPLICATION_NAME,BannerConstants.NETWORK_CODE,BannerConstants.FILE_NAME_HC,customParamsHe); // //setting parameters and fetching stats from CUG account
// if(downloadstatus){ // downloadstatus = false; long[] customParamsCug = setParams(args,BannerConstants.CUSTOMFIELDS_CUG,true); createCredentialAndDfSession(BannerConstants.JSON_CREDENTIAL_PATH_CUG,BannerConstants.APPLICATION_NAME_CUG,BannerConstants.NETWORK_CODE_CUG,BannerConstants.FILE_NAME_CUG,customParamsCug); // } // if(downloadstatus){ System.out.println("Sucessfully downloaded two files..!"); // } }
}
Please help me on this as soon as possible, as this is priority for us.
Thanks in advance.