public ReportDefinition findJobWithIdOf(String jobId) { ReportDefinition rd = null; for (int i = 0; i < getCompletedJobs().size(); i++) { if (getCompletedJobs().get(i).getJob().getJobId().equals(jobId)) { rd = getCompletedJobs().get(i).getJob(); return rd; } } return rd; }
private void updateLastRanAt(ReportDefinition get) { Connection con = Utility.getPerformanceDBConnection(); PreparedStatement cmd = null; try { cmd = con.prepareStatement("update arsjobs set lastranat=? where jobid=?"); cmd.setLong(1, System.currentTimeMillis()); cmd.setString(2, get.getJobId()); cmd.executeUpdate(); } catch (Exception ex) { log.log(Level.WARN, null, ex); } finally { DBUtils.safeClose(cmd); DBUtils.safeClose(con); } } }
for (int i = 0; i < items.size(); i++) { if (items.get(i).isEnabled() && CalendarCalculator.isTimeToRun(items.get(i), Calendar.getInstance())) { log.log(Level.INFO, "Enqueing report generation for " + items.get(i).getJobId()); if (waitforfinish) { String id = GenerateReport(items.get(i), pooled); log.log(Level.DEBUG, "Skipping report generation for " + items.get(i).getJobId() + " it's not time to fire");
if (!Utility.stringIsNullOrEmpty(request.getJobs().get(i).getJobId())) { cmd = con.prepareStatement("UPDATE arsjobs SET reportdef=?, hasextrapermissions=?, enabled=? WHERE jobid=?;"); cmd.setString(4, request.getJobs().get(i).getJobId()); } else { request.getJobs().get(i).setJobId(UUID.randomUUID().toString()); cmd.setString(5, request.getJobs().get(i).getJobId()); cmd.setString(6, currentUser);
cmd.setString(1, ret.getCompletedJobs().get(i).getJob().getJobId()); cmd.setInt(2, request.getRecordlimit()); cmd.setInt(3, request.getOffset());
private static void validateRequest(AddOrUpdateScheduledReportRequestMsg request, String currentUser, WebServiceContext ctx) throws AccessDeniedException { for (int i = 0; i < request.getJobs().size(); i++) { request.getJobs().get(i).setOwner(currentUser); if (Utility.stringIsNullOrEmpty(request.getJobs().get(i).getJobId())) { if (!IsReportJobOwner(currentUser, request.getJobs().get(i).getJobId())) { AccessDeniedException f = new AccessDeniedException("the report job " + request.getJobs().get(i).getJobId() + " is not owned by you", null); throw f;
log.log(Level.INFO,"excuting ARS job " + get.getJobId() + " for " + get.getOwner()); Reporting r = new Reporting(); if (get.getExportCSVDataRequestMsg() != null) { return storeReport(Reporting.generateZipFileandDelete(files, path), get.getJobId(), pooled); } catch (Exception e) { log.log(Level.ERROR, "error caught generating report", e); updateLastRanAt(get); byte[] bits = exportDataToHTML.getZipFile(); return storeReport(bits, get.getJobId(), pooled); } catch (Exception ex) { log.log(Level.ERROR, "error caught generating report ", ex);