- Code: Select all
public int loadActivities()
long start = System.currentTimeMillis();
ArrayList list = new ArrayList ();
String sql = "SELECT * FROM AD_WF_Activity a "
+ "WHERE a.Processed='N' AND a.WFState='OR' AND (" //red1 perviously WFState='OS'
Then things manage to complete! OS means suspended which is strange as to why it looks for suspended activities instead of those requiring it to be processed. OR was the state of that acitivity awaiting processing by the GardenUser. It may mean ‘Running’ which sounds more logical.