I am unable to configure the default value for custom field of type selectlist in jira 4.4.5. I tested this in 4.1.2 it is working fine. Also the default value it is showing me is null. I have attached the code below . The execute method is throwing the following error
2012-11-27 13:56:00,011 QuartzWorker-0 ERROR ServiceRunner [org.quartz.core.
2012-11-27 13:56:00,011 QuartzWorker-0 ERROR ServiceRunner [org.quartz.core.
ErrorLogger] Job (DEFAULT.CalculatedFieldsJob threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exc
public class CalculatedFieldsJob implements Job{
private static Logger log = Logger.getLogger(CalculatedFieldsJob.class);
public final static long ONE_SECOND = 1000;
public final static long SECONDS = 60;
public final static long ONE_MINUTE = ONE_SECOND * 60;
public final static long MINUTES = 60;
public final static long ONE_HOUR = ONE_MINUTE * 60;
public final static long HOURS = 24;
public final static long ONE_DAY = ONE_HOUR * 24;
private CustomFieldManager customFieldManager;
private static final String AF_PROPERTIES_FILE = "appfirecalculatedfields.properties";
private static final String AF_USER_KEY_DEFAULT = "calculatedfieldsuser";
private static final String AF_USER_DEFAULT = "admin";
public final String CUSTOMFIELD_KEY = "com.appfire.jira.plugins.customfield.ext.appfire-customfields-ext:af-daysinstatus";
private static Properties clientProperties = null;
public CustomFieldManager getCustomFieldManager() {
return customFieldManager;
}
public void setCustomFieldManager(CustomFieldManager customFieldManager) {
this.customFieldManager = customFieldManager;
}
public void execute(JobExecutionContext context) throws JobExecutionException {
try {
final URL sampleConfigurationFile = ClassLoaderUtils.getResource(AF_PROPERTIES_FILE, CalculatedFieldsJob.class);
clientProperties = new Properties();
if (sampleConfigurationFile == null) {
log.error("<< appfire properties file could not be found ");
}
clientProperties.load(sampleConfigurationFile.openStream());
log.debug("<< Loaded file " + AF_PROPERTIES_FILE);
if (clientProperties == null) {
log.error("<< clientProperties is null ");
}
} catch (Exception e) {
log.error("<< Error loading " + AF_PROPERTIES_FILE + " " + e.getMessage());
e.printStackTrace();
}
String serviceUser = clientProperties.get(AF_USER_KEY_DEFAULT).toString();
try {
if(serviceUser == null || UserUtils.getUser(serviceUser) == null){
log.error(">> Appfire Custom Field Ext Plugin: Configured user in appfirecalculatedfields.properties is not valid user");
log.info("Reverting to 'admin' user");
serviceUser = AF_USER_DEFAULT;
}
} catch (EntityNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
customFieldManager = (CustomFieldManager)ComponentManager.getComponentInstanceOfType(CustomFieldManager.class);
GenericConfigManager genericConfigManager = (GenericConfigManager)ComponentManager.getComponentInstanceOfType(GenericConfigManager.class);
List<CustomField> fieldList = customFieldManager.getCustomFieldObjects();
boolean wasIndexing = ImportUtils.isIndexIssues();
ImportUtils.setIndexIssues(true);
long jobStartTime = context.getFireTime().getTime();
log.info(">> Appfire Custom Field Ext Plugin: Calculated Field job trigerred at: " + context.getFireTime());
for(Iterator itr = fieldList.iterator(); itr.hasNext();){
CustomField cf = (CustomField)itr.next();
CustomFieldType cft = cf.getCustomFieldType();
if(cft.getKey().equals(CUSTOMFIELD_KEY))
{
FieldConfigSchemeManager sm = (FieldConfigSchemeManager) ComponentManager.getComponentInstanceOfType(FieldConfigSchemeManager.class);
long fieldConfigId = ((FieldConfigSchemeImpl) ((List) sm.getConfigSchemesForField(cf)).get(0)).getId();
Object list = genericConfigManager.retrieve(CustomFieldType.DEFAULT_VALUE_TYPE, Long.toString(fieldConfigId));
if(list == null)
{
log.info(">> Appfire Custom Field Ext Plugin: Default value is not configured for custom field:" + cf.getNameKey());
}
//check if the default value is a valid status
ConstantsManager constantsManager = (ConstantsManager) ComponentManager.getComponentInstanceOfType(ConstantsManager.class);
Status status = constantsManager.getStatusByName(list.toString());
if(status == null){
log.info(">> Appfire Custom Field Ext Plugin: Default value configured for custom field:" + cf.getNameKey() + " is not a valid status");
}else{
log.info(">> Appfire Custom Field Ext Plugin: calculating for custom field: " + cf.getName() );
}
long startCFTime = System.currentTimeMillis();
final JqlQueryBuilder builder = JqlQueryBuilder.newBuilder();
// builder.where().status().eq("Open").and().assignee().eq(getRemoteUser().getName());
builder.where().status().eq(status.getName());
//builder.orderBy().createdDate(SortOrder.DESC);
Query query = builder.buildQuery();
SearchService searchService = ComponentManager.getInstance()
.getSearchService();
SearchResults results = null;
try {
User user = UserUtils.getUser(serviceUser);
JiraServiceContextImpl jiraServiceContextImpl = new JiraServiceContextImpl(user);
results = searchService.search(jiraServiceContextImpl.getUser(), query, PagerFilter.getUnlimitedFilter());
List<Issue> issues = results.getIssues();
log.debug(">> Appfire Custom Field Ext Plugin: Number of issues retreived :" + issues.size());
for (int i = 0; i < issues.size(); i++) {
Issue issue = (Issue) issues.get(i);
List<Transition> transList = getTransitionsList(issue);
long cfValue = getDurantionInStatus(issue,transList);
double secs = (double)cfValue/1000;
double days = ((double)secs)/86400d;
NumberFormat formatter = new DecimalFormat("#0.00");
String numDays = formatter.format(days) + " Days";
MutableIssue missue = ComponentManager.getInstance().getIssueManager().getIssueObject(issue.getId());
DefaultIssueChangeHolder issueChangeHolder = new DefaultIssueChangeHolder();
// final ModifiedValue modifiedValue = (ModifiedValue) modifiedFields.get(cf.getId());
cft.updateValue(cf, missue, numDays);
if(i%100 == 0){
log.debug(">> Appfire Custom Field Ext Plugin: updated issues "+ i + ", custom field value for " + cf.getName() + " calculated as:" + numDays + " current time " + new Date());
}
}
}catch (SearchException e) {
log.error(">> Appfire Custom Field Ext Plugin: Error while executing the search query" );
e.printStackTrace();
} catch (EntityNotFoundException e) {
log.error(">> Appfire Custom Field Ext Plugin: Error rereiving the issse " );
e.printStackTrace();
}
//end for a custom field
long timetakenForCF = System.currentTimeMillis() - startCFTime;
String timeforCF = CalculatedFieldsJob.millisToLongDHMS(timetakenForCF);
log.info(">> Appfire Custom Field Ext Plugin: time to complete values for all issues for Custom Field:" + timeforCF );
}
else
continue;
}
long timetakenForCF = System.currentTimeMillis() - jobStartTime;
String timeforJob = CalculatedFieldsJob.millisToLongDHMS(timetakenForCF);
log.info(">> Appfire Custom Field Ext Plugin: calculated fields job finsihed at :" + timeforJob );
}
private long getDurantionInStatus(Issue issue, List<Transition> transList) {
long timeinMS = 0;
Timestamp tChanged = null;
if(transList.size() > 0 )
{
for(Iterator<Transition> iterator = transList.iterator(); iterator.hasNext();){
Transition tran = iterator.next();
if(tran.getFromStatus().getName().equals(issue.getStatusObject().getName())){
timeinMS = timeinMS + tran.getDurationInMillis();
}
if(tran.getToStatus().getName().equals(issue.getStatusObject().getName()))
tChanged = tran.getChangedAt();
}
}
else{
//No transitions, so initial status is being tracked. get the durationfrom the issue created
timeinMS = ( System.currentTimeMillis() - issue.getCreated().getTime());
}
if( tChanged != null)
timeinMS = timeinMS + ( System.currentTimeMillis() - ( tChanged != null ? tChanged.getTime() : 0 ) );
return timeinMS;
}
private List<Transition> getTransitionsList(Issue issue) {
ChangeHistoryManager changeHistoryManager =
(ChangeHistoryManager)ComponentManager.getComponentInstanceOfType(ChangeHistoryManager.class);
List<ChangeHistory> changeHistoryOfIssue = changeHistoryManager.getChangeHistoriesForUser(issue,null);
ConstantsManager constantsManager = (ConstantsManager) ComponentManager.getComponentInstanceOfType(ConstantsManager.class);
Timestamp tsStartDate = issue.getCreated();
List<Transition> transList1 = new ArrayList<Transition>();
for(ChangeHistory changeHistory : changeHistoryOfIssue) {
//long timeCreated = issue.getCreated().getTime();
for(Object o : changeHistory.getChangeItems()) {
GenericValue gv = (GenericValue) o;
if(gv.get("field").equals("status")){
String prevStatus = (String)gv.get("oldstring");
String nextStatus = (String)gv.get("newstring");
Transition tran = new Transition();
tran.setChangedAt(changeHistory.getTimePerformed());
tran.setFromStatus(constantsManager.getStatusByName(prevStatus));
tran.setToStatus(constantsManager.getStatusByName(nextStatus));
tran.setStartAt(tsStartDate);
transList1.add(tran);
//used to calculate the start of next tranistion
tsStartDate = changeHistory.getTimePerformed();
}
}
}
return transList1;
}
public static String millisToLongDHMS(long duration) {
StringBuffer res = new StringBuffer();
long temp = 0;
if (duration >= ONE_SECOND) {
temp = duration / ONE_DAY;
if (temp > 0) {
duration -= temp * ONE_DAY;
res.append(temp).append(" day").append(temp > 1 ? "s" : "")
.append(duration >= ONE_MINUTE ? ", " : "");
}
temp = duration / ONE_HOUR;
if (temp > 0) {
duration -= temp * ONE_HOUR;
res.append(temp).append(" hour").append(temp > 1 ? "s" : "")
.append(duration >= ONE_MINUTE ? ", " : "");
}
temp = duration / ONE_MINUTE;
if (temp > 0) {
duration -= temp * ONE_MINUTE;
res.append(temp).append(" minute").append(temp > 1 ? "s" : "");
}
if (!res.toString().equals("") && duration >= ONE_SECOND) {
res.append(" and ");
}
temp = duration / ONE_SECOND;
if (temp > 0) {
res.append(temp).append(" second").append(temp > 1 ? "s" : "");
}
return res.toString();
} else {
return "0 second";
}
}
}
![Jobin Kuruvilla [Adaptavist]](https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/557058:3e04e228-4ce2-4b19-8845-c9d1d168cdeb/14b658ae-e54e-43b0-a73d-4b8fe17750b6/128 "Jobin Kuruvilla [Adaptavist]"){kind=avatar}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.