1 Reply Latest reply on Mar 27, 2020 4:24 PM by Lokesh Kumar

    Schedule Export using ExportScheduleProfile

    Ajikumar Murukan Active Member

      Trying to schedule an export using ExportScheduleProfile. Set the datasource using reportquery where passing all the items required for export. The schedule export is successful but getting an error while the export start processing the job. Max no. of 1000 items works fine; more than 1000 items is getting failed. Is there any limitation in no. of items passing the datasource as argument to ExportScheduleProfile?

       

      ExportRequest  exportRequest = restClient.createExportRequest();

      ExportSchedulingDataSource exportDataSource = new ExportSchedulingDataSource();

      ExportSchedulingProfile exportSchedulingProfile = new ExportSchedulingProfile(); 

      Map<String, ExportSchedulingDataSource> exportScheduleDS= new HashMap<String, ExportSchedulingDataSource>();

      HashMap<String, Object> exportVariables = new HashMap<String, Object>();

      exportSchedulingProfile.setProfileName(profileName);

      exportSchedulingProfile.setExecutionDate(executionTime);

       

      ReportQuery reportQuery1 = new ReportQuery( "bySearch" ).addParameterValue( "query", "Article.Res_Text250_01 in ("+ ItemList +")" );    

                                     

      //Connect Report Query to Datasource

      exportDataSource.setReportQuery(reportQuery1);                                       

       

      //Set PDKList to Export Schedule object

      exportScheduleDS.put("Changed and new items", exportDataSource); 

      exportSchedulingProfile.setDataSources(exportScheduleDS);

       

      exportRequest.scheduleExport(exportSchedulingProfile);   

       

      Internal technical error, export profile: '<ProfileName>', error: 'org.eclipse.core.runtime.CoreException: Invalid arguments were transferred while executing the query "Items for 'Article.Res_Text250_01 in (Item1, Item2, Item3...