You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "patrick LE BLAN (Commented) (JIRA)" <ji...@apache.org> on 2011/12/09 14:48:40 UTC

[jira] [Commented] (OFBIZ-4615) Selected post Jul 27, 2010; 9:24am [ofbiz-trunk] Error in starting BIRT platform imsskonline 12 posts reopenning ( maybe...)

    [ https://issues.apache.org/jira/browse/OFBIZ-4615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13166188#comment-13166188 ] 

patrick LE BLAN commented on OFBIZ-4615:
----------------------------------------

while opening scrum: sprint overview the burdown chart widget returns this :
The following items have errors:

ReportDesign (id = 1):
+ There are errors evaluating script "importPackage(Packages.java.math);
importPackage(Packages.java.text);
importPackage(Packages.java.sql);
importPackage(Packages.javolution.util);
importPackage(Packages.org.ofbiz.base.util);
importPackage(Packages.org.ofbiz.entity.condition);

module = "Burndown.rptdesign";

sprintId = params["sprintId"].value;
actualStartDate = params["actualStartDate"].value;
actualCompletionDate = params["actualCompletionDate"].value;
dayNumber = params["dayNumber"];
estimatedHrs = params["estimatedHrs"].value;
maxHours = params["maxHours"].value;
currentDay = -1;

userLogin = delegator.findByPrimaryKey("UserLogin",UtilMisc.toMap("userLoginId","admin"));
// caculate average diff hours
var holidayNumber = BigDecimal.ZERO;
var notHolidayNumber = BigDecimal.ZERO;
var countHoliday = 0;
while (countHoliday < dayNumber) {
    var conditionTimestampFrom = new Timestamp(actualStartDate.getTime() + (countHoliday*1000*60*60*24));
    // get public holiday
    var holidayConds = FastList.newInstance();
    holidayConds.add(EntityCondition.makeCondition("workEffortTypeId",EntityOperator.EQUALS, "PUBLIC_HOLIDAY"));
    holidayConds.add(EntityCondition.makeCondition("estimatedStartDate", EntityOperator.EQUALS, conditionTimestampFrom));
    var fieldsToSelect = UtilMisc.toSet("workEffortId","estimatedStartDate");
    var holidayList = delegator.findList("WorkEffort", EntityCondition.makeCondition(holidayConds), fieldsToSelect, null, null, false);
    // check holiday 
    var dayOfWeek = UtilDateTime.getDayOfWeek(conditionTimestampFrom, new java.util.SimpleTimeZone(reportContext.getTimeZone().getRawOffset(), reportContext.getTimeZone().getID()), reportContext.getLocale());
    var day = UtilDateTime.days[dayOfWeek - 2];
    if (!UtilValidate.isNotEmpty(holidayList) && !"Saturday".equals(day) && !"undefined".equals(day) /*Sunday*/) {
        notHolidayNumber = notHolidayNumber.add(BigDecimal.ONE);
    } else {
        holidayNumber = holidayNumber.add(BigDecimal.ONE);
    }
    countHoliday ++;
}
// get plan hours 
input =  FastMap.newInstance();
input.put("userLogin",userLogin);
input.put("sprintId",sprintId);
result = dispatcher.runSync("getScrumPlanHour", input);
var phs = result.get("initPlanHours");
maxHours = phs;
averageDiffHours = maxHours/notHolidayNumber;":
Wrapped org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour (/report/method[@name="initialize"]#45)

birt.core.JavascriptCommonError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "importPackage(Packages.java.math);
importPackage(Packages.java.text);
importPackage(Packages.java.sql);
importPackage(Packages.javolution.util);
importPackage(Packages.org.ofbiz.base.util);
importPackage(Packages.org.ofbiz.entity.condition);

module = "Burndown.rptdesign";

sprintId = params["sprintId"].value;
actualStartDate = params["actualStartDate"].value;
actualCompletionDate = params["actualCompletionDate"].value;
dayNumber = params["dayNumber"];
estimatedHrs = params["estimatedHrs"].value;
maxHours = params["maxHours"].value;
currentDay = -1;

userLogin = delegator.findByPrimaryKey("UserLogin",UtilMisc.toMap("userLoginId","admin"));
// caculate average diff hours
var holidayNumber = BigDecimal.ZERO;
var notHolidayNumber = BigDecimal.ZERO;
var countHoliday = 0;
while (countHoliday < dayNumber) {
    var conditionTimestampFrom = new Timestamp(actualStartDate.getTime() + (countHoliday*1000*60*60*24));
    // get public holiday
    var holidayConds = FastList.newInstance();
    holidayConds.add(EntityCondition.makeCondition("workEffortTypeId",EntityOperator.EQUALS, "PUBLIC_HOLIDAY"));
    holidayConds.add(EntityCondition.makeCondition("estimatedStartDate", EntityOperator.EQUALS, conditionTimestampFrom));
    var fieldsToSelect = UtilMisc.toSet("workEffortId","estimatedStartDate");
    var holidayList = delegator.findList("WorkEffort", EntityCondition.makeCondition(holidayConds), fieldsToSelect, null, null, false);
    // check holiday 
    var dayOfWeek = UtilDateTime.getDayOfWeek(conditionTimestampFrom, new java.util.SimpleTimeZone(reportContext.getTimeZone().getRawOffset(), reportContext.getTimeZone().getID()), reportContext.getLocale());
    var day = UtilDateTime.days[dayOfWeek - 2];
    if (!UtilValidate.isNotEmpty(holidayList) && !"Saturday".equals(day) && !"undefined".equals(day) /*Sunday*/) {
        notHolidayNumber = notHolidayNumber.add(BigDecimal.ONE);
    } else {
        holidayNumber = holidayNumber.add(BigDecimal.ONE);
    }
    countHoliday ++;
}
// get plan hours 
input =  FastMap.newInstance();
input.put("userLogin",userLogin);
input.put("sprintId",sprintId);
result = dispatcher.runSync("getScrumPlanHour", input);
var phs = result.get("initPlanHours");
maxHours = phs;
averageDiffHours = maxHours/notHolidayNumber;":
Wrapped org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour (/report/method[@name="initialize"]#45)
	at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:158)
	at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleInitialize(ReportScriptExecutor.java:53)
	at org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesign(EngineTask.java:1637)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:95)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
	at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:920)
	at org.ofbiz.birt.report.service.OFBizBirtViewerReportService.runAndRenderReport(OFBizBirtViewerReportService.java:251)
	at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java:76)
	at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
	at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(EngineFragment.java:318)
	at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(AbstractBaseFragment.java:76)
	at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(BirtEngineServlet.java:120)
	at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(BaseReportEngineServlet.java:185)
	at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPost(BaseReportEngineServlet.java:224)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.eclipse.birt.report.servlet.BaseReportEngineServlet.service(BaseReportEngineServlet.java:116)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:337)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "importPackage(Packages.java.math);
importPackage(Packages.java.text);
importPackage(Packages.java.sql);
importPackage(Packages.javolution.util);
importPackage(Packages.org.ofbiz.base.util);
importPackage(Packages.org.ofbiz.entity.condition);

module = "Burndown.rptdesign";

sprintId = params["sprintId"].value;
actualStartDate = params["actualStartDate"].value;
actualCompletionDate = params["actualCompletionDate"].value;
dayNumber = params["dayNumber"];
estimatedHrs = params["estimatedHrs"].value;
maxHours = params["maxHours"].value;
currentDay = -1;

userLogin = delegator.findByPrimaryKey("UserLogin",UtilMisc.toMap("userLoginId","admin"));
// caculate average diff hours
var holidayNumber = BigDecimal.ZERO;
var notHolidayNumber = BigDecimal.ZERO;
var countHoliday = 0;
while (countHoliday < dayNumber) {
    var conditionTimestampFrom = new Timestamp(actualStartDate.getTime() + (countHoliday*1000*60*60*24));
    // get public holiday
    var holidayConds = FastList.newInstance();
    holidayConds.add(EntityCondition.makeCondition("workEffortTypeId",EntityOperator.EQUALS, "PUBLIC_HOLIDAY"));
    holidayConds.add(EntityCondition.makeCondition("estimatedStartDate", EntityOperator.EQUALS, conditionTimestampFrom));
    var fieldsToSelect = UtilMisc.toSet("workEffortId","estimatedStartDate");
    var holidayList = delegator.findList("WorkEffort", EntityCondition.makeCondition(holidayConds), fieldsToSelect, null, null, false);
    // check holiday 
    var dayOfWeek = UtilDateTime.getDayOfWeek(conditionTimestampFrom, new java.util.SimpleTimeZone(reportContext.getTimeZone().getRawOffset(), reportContext.getTimeZone().getID()), reportContext.getLocale());
    var day = UtilDateTime.days[dayOfWeek - 2];
    if (!UtilValidate.isNotEmpty(holidayList) && !"Saturday".equals(day) && !"undefined".equals(day) /*Sunday*/) {
        notHolidayNumber = notHolidayNumber.add(BigDecimal.ONE);
    } else {
        holidayNumber = holidayNumber.add(BigDecimal.ONE);
    }
    countHoliday ++;
}
// get plan hours 
input =  FastMap.newInstance();
input.put("userLogin",userLogin);
input.put("sprintId",sprintId);
result = dispatcher.runSync("getScrumPlanHour", input);
var phs = result.get("initPlanHours");
maxHours = phs;
averageDiffHours = maxHours/notHolidayNumber;":
Wrapped org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour (/report/method[@name="initialize"]#45)
	at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:287)
	at org.eclipse.birt.core.script.ScriptContext.evaluate(ScriptContext.java:152)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:746)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:675)
	at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleScriptInternal(ScriptExecutor.java:61)
	at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleScript(ScriptExecutor.java:48)
	at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleInitialize(ReportScriptExecutor.java:44)
	... 35 more
Caused by: org.mozilla.javascript.WrappedException: Wrapped org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour (/report/method[@name="initialize"]#45)
	at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1654)
	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:175)
	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
	at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)
	at org.mozilla.javascript.gen.c22._c0(/report/method[@name="initialize"]:45)
	at org.mozilla.javascript.gen.c22.call(/report/method[@name="initialize"])
	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401)
	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003)
	at org.mozilla.javascript.gen.c22.call(/report/method[@name="initialize"])
	at org.mozilla.javascript.gen.c22.exec(/report/method[@name="initialize"])
	at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:282)
	... 41 more
Caused by: org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour
	at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:359)
	at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226)
	at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:163)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:160)
	... 50 more

							


ReportDesign (id = 1):
+ There are errors evaluating script "if (dayCount >= dayNumber || currentDay >= 0) return false;

var sprintDay = dayCount + 1;
var actualStartDay = UtilDateTime.getDayStart(new Timestamp(actualStartDate.getTime()), new java.util.SimpleTimeZone(reportContext.getTimeZone().getRawOffset(), reportContext.getTimeZone().getID()), reportContext.getLocale());
var conditionTimestampFrom = new Timestamp(actualStartDay.getTime() + (dayCount*1000*60*60*24));
var conditionTimestampTo = new Timestamp(actualStartDay.getTime() + (dayCount*1000*60*60*24) + (1000*60*60*24) - 1);

// check current day
var nowTimestamp = UtilDateTime.nowTimestamp();
if (nowTimestamp.getTime() >= conditionTimestampFrom.getTime() && nowTimestamp.getTime() <= conditionTimestampTo.getTime()) {
    reportContext.getAppContext().put("sprintDayLabel", sprintDay + "");
}

// get public holiday
var holidayConds = FastList.newInstance();
holidayConds.add(EntityCondition.makeCondition("workEffortTypeId",EntityOperator.EQUALS, "PUBLIC_HOLIDAY"));
holidayConds.add(EntityCondition.makeCondition("estimatedStartDate", EntityOperator.EQUALS, conditionTimestampFrom));
var fieldsToSelect = UtilMisc.toSet("workEffortId","estimatedStartDate");
var holidayList = delegator.findList("WorkEffort", EntityCondition.makeCondition(holidayConds), fieldsToSelect, null, null, false);

// check holiday
var isHoliday = false;
var dayOfWeek = UtilDateTime.getDayOfWeek(conditionTimestampFrom, new java.util.SimpleTimeZone(reportContext.getTimeZone().getRawOffset(), reportContext.getTimeZone().getID()), reportContext.getLocale());
var day = UtilDateTime.days[dayOfWeek - 2];
if (UtilValidate.isNotEmpty(holidayList) || "Saturday".equals(day) || "undefined".equals(day) /*Sunday*/) {
    isHoliday = true;
}
if (isHoliday) {
    holidays.add(sprintDay + "");
    reportContext.getAppContext().put("holidays", holidays);
}
input =  FastMap.newInstance();
var plannedHours = BigDecimal.ZERO;
var actualHours = BigDecimal.ZERO;

// get times from all backlog item's tasks
var sprint = delegator.findOne("WorkEffort", UtilMisc.toMap("workEffortId", sprintId), false);
var backlogItems = sprint.getRelated("CustRequestWorkEffort");
for (i=0; i<backlogItems.size(); i++) {
    // get all task from backlog item
    var backlogItem = backlogItems.get(i);
    var custRequestId = backlogItem.get("custRequestId");
    var conds = FastList.newInstance();
    conds.add(EntityCondition.makeCondition("custRequestId", custRequestId));
    conds.add(EntityCondition.makeCondition("workEffortTypeId", EntityOperator.NOT_EQUAL, "SCRUM_SPRINT"));
    var tasks = delegator.findList("CustRequestAndWorkEffort", EntityCondition.makeCondition(conds), null, null, null, false);
    for (j=0; j<tasks.size(); j++) {
        var task = tasks.get(j);
        // get plan hours by taskId
        var workEffortId = task.get("workEffortId");
        input.put("userLogin",userLogin);
        input.put("taskId",workEffortId);
        result = dispatcher.runSync("getScrumPlanHour", input);
        var phs = result.get("planHours");
        if (phs != null) {
            plannedHours = plannedHours.add(BigDecimal.valueOf(phs));
        } else {
            var estimatedMilliSeconds = task.get("estimatedMilliSeconds");
            if (estimatedMilliSeconds != null) {
                var phs = BigDecimal.valueOf(estimatedMilliSeconds/1000/60/60);
                plannedHours = plannedHours.add(phs);
            }
        }
        // get all time entries from task
        var timeEntryConds = FastList.newInstance();
        timeEntryConds.add(EntityCondition.makeCondition("workEffortId", workEffortId));
        timeEntryConds.add(EntityCondition.makeCondition("fromDate", EntityOperator.GREATER_THAN_EQUAL_TO, conditionTimestampFrom));
        timeEntryConds.add(EntityCondition.makeCondition("fromDate", EntityOperator.LESS_THAN_EQUAL_TO, conditionTimestampTo));
        var timeEntries = delegator.findList("TimeEntry", EntityCondition.makeCondition(timeEntryConds), null, null, null, false);
        if (timeEntries.size() > 0) {
            // get actual hours from task
            for (k=0; k<timeEntries.size(); k++) {
                var timeEntry = timeEntries.get(k);
                var ahs = timeEntry.get("hours");
                if (ahs != null) {
                    actualHours = actualHours.add(BigDecimal.valueOf(ahs));
                }
            }
        }
    }
}

sumPlannedHours = sumPlannedHours.add(plannedHours);
sumActualHours = sumActualHours.add(actualHours);
var isPlannedOver = false;
if (previousRemainPlannedHours.compareTo(plannedHours) < 0) {
    isPlannedOver = true;
}

var dialyCompleted = BigDecimal.ZERO;

// calculate balance actual hours
var balanceActualHours = maxHours - sumActualHours;

// calculate remain plan hours
if (!isHoliday) {
    remainPlannedHours = BigDecimal.valueOf(maxHours).subtract(sumActualHours);
    previousRemainPlannedHours = remainPlannedHours;
    dialyCompleted = actualHours;
}

// calculate average hours
if (!isHoliday) {
    averageHours = previousAverageHours.subtract(BigDecimal.valueOf(averageDiffHours));
    previousAverageHours = averageHours;
} else {
    averageHours = previousAverageHours;
}

row["sprintDay"] = sprintDay;
row["balanceActualHours"] = balanceActualHours;
row["dialyCompleteed"] = dialyCompleted;
row["remainPlannedHours"] = remainPlannedHours;
row["averageHours"] = averageHours;

previousActualHours = BigDecimal.valueOf(balanceActualHours);
dayCount ++;

return true;":
{1}.

Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (dayCount >= dayNumber || currentDay >= 0) return false;

var sprintDay = dayCount + 1;
var actualStartDay = UtilDateTime.getDayStart(new Timestamp(actualStartDate.getTime()), new java.util.SimpleTimeZone(reportContext.getTimeZone().getRawOffset(), reportContext.getTimeZone().getID()), reportContext.getLocale());
var conditionTimestampFrom = new Timestamp(actualStartDay.getTime() + (dayCount*1000*60*60*24));
var conditionTimestampTo = new Timestamp(actualStartDay.getTime() + (dayCount*1000*60*60*24) + (1000*60*60*24) - 1);

// check current day
var nowTimestamp = UtilDateTime.nowTimestamp();
if (nowTimestamp.getTime() >= conditionTimestampFrom.getTime() && nowTimestamp.getTime() <= conditionTimestampTo.getTime()) {
    reportContext.getAppContext().put("sprintDayLabel", sprintDay + "");
}

// get public holiday
var holidayConds = FastList.newInstance();
holidayConds.add(EntityCondition.makeCondition("workEffortTypeId",EntityOperator.EQUALS, "PUBLIC_HOLIDAY"));
holidayConds.add(EntityCondition.makeCondition("estimatedStartDate", EntityOperator.EQUALS, conditionTimestampFrom));
var fieldsToSelect = UtilMisc.toSet("workEffortId","estimatedStartDate");
var holidayList = delegator.findList("WorkEffort", EntityCondition.makeCondition(holidayConds), fieldsToSelect, null, null, false);

// check holiday
var isHoliday = false;
var dayOfWeek = UtilDateTime.getDayOfWeek(conditionTimestampFrom, new java.util.SimpleTimeZone(reportContext.getTimeZone().getRawOffset(), reportContext.getTimeZone().getID()), reportContext.getLocale());
var day = UtilDateTime.days[dayOfWeek - 2];
if (UtilValidate.isNotEmpty(holidayList) || "Saturday".equals(day) || "undefined".equals(day) /*Sunday*/) {
    isHoliday = true;
}
if (isHoliday) {
    holidays.add(sprintDay + "");
    reportContext.getAppContext().put("holidays", holidays);
}
input =  FastMap.newInstance();
var plannedHours = BigDecimal.ZERO;
var actualHours = BigDecimal.ZERO;

// get times from all backlog item's tasks
var sprint = delegator.findOne("WorkEffort", UtilMisc.toMap("workEffortId", sprintId), false);
var backlogItems = sprint.getRelated("CustRequestWorkEffort");
for (i=0; i<backlogItems.size(); i++) {
    // get all task from backlog item
    var backlogItem = backlogItems.get(i);
    var custRequestId = backlogItem.get("custRequestId");
    var conds = FastList.newInstance();
    conds.add(EntityCondition.makeCondition("custRequestId", custRequestId));
    conds.add(EntityCondition.makeCondition("workEffortTypeId", EntityOperator.NOT_EQUAL, "SCRUM_SPRINT"));
    var tasks = delegator.findList("CustRequestAndWorkEffort", EntityCondition.makeCondition(conds), null, null, null, false);
    for (j=0; j<tasks.size(); j++) {
        var task = tasks.get(j);
        // get plan hours by taskId
        var workEffortId = task.get("workEffortId");
        input.put("userLogin",userLogin);
        input.put("taskId",workEffortId);
        result = dispatcher.runSync("getScrumPlanHour", input);
        var phs = result.get("planHours");
        if (phs != null) {
            plannedHours = plannedHours.add(BigDecimal.valueOf(phs));
        } else {
            var estimatedMilliSeconds = task.get("estimatedMilliSeconds");
            if (estimatedMilliSeconds != null) {
                var phs = BigDecimal.valueOf(estimatedMilliSeconds/1000/60/60);
                plannedHours = plannedHours.add(phs);
            }
        }
        // get all time entries from task
        var timeEntryConds = FastList.newInstance();
        timeEntryConds.add(EntityCondition.makeCondition("workEffortId", workEffortId));
        timeEntryConds.add(EntityCondition.makeCondition("fromDate", EntityOperator.GREATER_THAN_EQUAL_TO, conditionTimestampFrom));
        timeEntryConds.add(EntityCondition.makeCondition("fromDate", EntityOperator.LESS_THAN_EQUAL_TO, conditionTimestampTo));
        var timeEntries = delegator.findList("TimeEntry", EntityCondition.makeCondition(timeEntryConds), null, null, null, false);
        if (timeEntries.size() > 0) {
            // get actual hours from task
            for (k=0; k<timeEntries.size(); k++) {
                var timeEntry = timeEntries.get(k);
                var ahs = timeEntry.get("hours");
                if (ahs != null) {
                    actualHours = actualHours.add(BigDecimal.valueOf(ahs));
                }
            }
        }
    }
}

sumPlannedHours = sumPlannedHours.add(plannedHours);
sumActualHours = sumActualHours.add(actualHours);
var isPlannedOver = false;
if (previousRemainPlannedHours.compareTo(plannedHours) < 0) {
    isPlannedOver = true;
}

var dialyCompleted = BigDecimal.ZERO;

// calculate balance actual hours
var balanceActualHours = maxHours - sumActualHours;

// calculate remain plan hours
if (!isHoliday) {
    remainPlannedHours = BigDecimal.valueOf(maxHours).subtract(sumActualHours);
    previousRemainPlannedHours = remainPlannedHours;
    dialyCompleted = actualHours;
}

// calculate average hours
if (!isHoliday) {
    averageHours = previousAverageHours.subtract(BigDecimal.valueOf(averageDiffHours));
    previousAverageHours = averageHours;
} else {
    averageHours = previousAverageHours;
}

row["sprintDay"] = sprintDay;
row["balanceActualHours"] = balanceActualHours;
row["dialyCompleteed"] = dialyCompleted;
row["remainPlannedHours"] = remainPlannedHours;
row["averageHours"] = averageHours;

previousActualHours = BigDecimal.valueOf(balanceActualHours);
dayCount ++;

return true;":
{1}.
	at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:96)
	at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:219)
	at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:130)
	at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
	at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:257)
	at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:165)
	at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:105)
	at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
	at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:311)
	at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:283)
	at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:244)
	at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:69)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSetCacheInResultSetPopulator(PassManager.java:320)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateDataSet(PassManager.java:282)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:101)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:128)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:77)
	at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:198)
	at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:188)
	at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:106)
	at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1045)
	at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
	at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:159)
	at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
	at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
	at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:205)
	at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)
	at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62)
	at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
	at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:172)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
	at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:920)
	at org.ofbiz.birt.report.service.OFBizBirtViewerReportService.runAndRenderReport(OFBizBirtViewerReportService.java:251)
	at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java:76)
	at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
	at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(EngineFragment.java:318)
	at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(AbstractBaseFragment.java:76)
	at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(BirtEngineServlet.java:120)
	at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(BaseReportEngineServlet.java:185)
	at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPost(BaseReportEngineServlet.java:224)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.eclipse.birt.report.servlet.BaseReportEngineServlet.service(BaseReportEngineServlet.java:116)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:337)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: Error evaluating Javascript expression. Script engine error: Wrapped org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour (#53)
 Script source: , line: 0, text:
__bm_FETCH(). See next exception for more information.
Error evaluating Javascript expression. Script engine error: Wrapped org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour (#53)
 Script source: , line: 0, text:
__bm_FETCH()
	at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118)
	at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:853)
	at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76)
	at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)
	... 71 more
Caused by: org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript expression. Script engine error: Wrapped org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour (#53)
 Script source: , line: 0, text:
__bm_FETCH()
	at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:303)
	at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:102)
	at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:134)
	at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:849)
	... 73 more
Caused by: org.mozilla.javascript.WrappedException: Wrapped org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour (#53)
	at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1654)
	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:175)
	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
	at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)
	at org.mozilla.javascript.gen.c8._c1(:53)
	at org.mozilla.javascript.gen.c8.call()
	at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
	at org.mozilla.javascript.gen.c9._c0(:0)
	at org.mozilla.javascript.gen.c9.call()
	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401)
	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003)
	at org.mozilla.javascript.gen.c9.call()
	at org.mozilla.javascript.gen.c9.exec()
	at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:95)
	... 75 more
Caused by: org.ofbiz.service.ServiceAuthException: User authorization is required for this service: getScrumPlanHour
	at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:359)
	at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226)
	at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:163)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:160)
	... 87 more

							

+ data.engine.BadFetchScriptReturnType

data.engine.BadFetchScriptReturnType ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: data.engine.BadFetchScriptReturnType
	at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:158)
	at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:147)
	at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:150)
	at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
	at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:257)
	at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:165)
	at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:105)
	at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
	at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:311)
	at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:283)
	at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:244)
	at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:69)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSetCacheInResultSetPopulator(PassManager.java:320)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateDataSet(PassManager.java:282)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:101)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:128)
	at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:77)
	at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:198)
	at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:188)
	at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:106)
	at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1045)
	at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
	at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:159)
	at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
	at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
	at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:205)
	at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)
	at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62)
	at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
	at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:172)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
	at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:920)
	at org.ofbiz.birt.report.service.OFBizBirtViewerReportService.runAndRenderReport(OFBizBirtViewerReportService.java:251)
	at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java:76)
	at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
	at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(EngineFragment.java:318)
	at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(AbstractBaseFragment.java:76)
	at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(BirtEngineServlet.java:120)
	at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(BaseReportEngineServlet.java:185)
	at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPost(BaseReportEngineServlet.java:224)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.eclipse.birt.report.servlet.BaseReportEngineServlet.service(BaseReportEngineServlet.java:116)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:337)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.eclipse.birt.data.engine.core.DataException: data.engine.BadFetchScriptReturnType
	at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:140)
	... 69 more

							


                
>   Selected post    Jul 27, 2010; 9:24am [ofbiz-trunk] Error in starting BIRT platform imsskonline 12 posts 	 reopenning ( maybe...)
> -----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-4615
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4615
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: SVN trunk
>         Environment: redhat 5 entreprise server   S
> Apache Ant(TM) version 1.8.2 
> java version "1.6.0_27"
> Java(TM) SE Runtime Environment (build 1.6.0_27-b07)
> Java HotSpot(TM) Server VM (build 20.2-b06, mixed mode)
> 	
>            Reporter: patrick LE BLAN
>
> reopening the post [ofbiz-trunk] Error in starting BIRT platform started by imssk last 
> BUILD SUCCESSFUL
>  but starting the platform failed
> 2011-12-07 17:00:21,302 (main) [  CatalinaContainer.java:248:INFO ] Started Apache Tomcat/6.0.32
> 2011-12-07 17:00:21,302 (main) [      BirtContainer.java:72 :INFO ] Start birt container
> 2011-12-07 17:00:21,320 (main) [  GenericDispatcher.java:69 :INFO ] Creating new dispatcher [birt-dispatcher] (main)
> 2011-12-07 17:00:21,323 (main) [      BirtContainer.java:130:INFO ] Startup birt platform
> org.ofbiz.base.start.StartupException: Cannot start() org.ofbiz.birt.container.BirtContainer (org.eclipse.birt.core.exception.BirtException: Can not startup the OSGI framework (Can not startup the OSGI framework))
>         at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:232)
>         at org.ofbiz.base.start.Start.startStartLoaders(Start.java:294)
>         at org.ofbiz.base.start.Start.start(Start.java:273)
>         at org.ofbiz.base.start.Start.main(Start.java:119)
> org.ofbiz.base.container.ContainerException: org.eclipse.birt.core.exception.BirtException: Can not startup the OSGI framework (Can not startup the OSGI framework)
>         at org.ofbiz.birt.container.BirtContainer.start(BirtContainer.java:133)
>         at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:230)
>         at org.ofbiz.base.start.Start.startStartLoaders(Start.java:294)
>         at org.ofbiz.base.start.Start.start(Start.java:273)
>         at org.ofbiz.base.start.Start.main(Start.java:119)
> Caused by: org.eclipse.birt.core.exception.BirtException: Can not startup the OSGI framework
>         at org.eclipse.birt.core.framework.Platform.startup(Platform.java:91)
>         at org.ofbiz.birt.container.BirtContainer.start(BirtContainer.java:131)
>         ... 4 more
> Caused by: org.eclipse.birt.core.exception.CoreException
>         at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:90)
>         at org.eclipse.birt.core.framework.Platform.startup(Platform.java:79)
>         ... 5 more
> org.ofbiz.base.container.ContainerException: org.eclipse.birt.core.exception.BirtException: Can not startup the OSGI framework (Can not startup the OSGI framework)
>         at org.ofbiz.birt.container.BirtContainer.start(BirtContainer.java:133)
>         at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:230)
>         at org.ofbiz.base.start.Start.startStartLoaders(Start.java:294)
>         at org.ofbiz.base.start.Start.start(Start.java:273)
>         at org.ofbiz.base.start.Start.main(Start.java:119)
> Caused by: org.eclipse.birt.core.exception.BirtException: Can not startup the OSGI framework
>         at org.eclipse.birt.core.framework.Platform.startup(Platform.java:91)
>         at org.ofbiz.birt.container.BirtContainer.start(BirtContainer.java:131)
>         ... 4 more
> Caused by: org.eclipse.birt.core.exception.CoreException
>         at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:90)
>         at org.eclipse.birt.core.framework.Platform.startup(Platform.java:79)
>         ... 5 more
> 2011-12-07 17:00:21,360 (Thread-0) [    ContainerLoader.java:246:INFO ] Shutting down containers
> 2011-12-07 17:02:27,847 (default-invoker-Thread-15) [   ServiceSemaphore.java:105:WARN ] Service [purgeOldJobs] with wait semaphore exceeded wait timeout, waited [304.438], wait started at 2011-12-07 16:57:23.409
> 2011-12-07 17:02:27,850 (default-invoker-Thread-15) [  GenericServiceJob.java:118:ERROR] 
> ---- exception report ----------------------------------------------------------
> Async-Service failed.
> Exception: org.ofbiz.service.semaphore.SemaphoreWaitException
> Message: Service [purgeOldJobs] with wait semaphore exceeded wait timeout, waited [304.438], wait started at 2011-12-07 16:57:23.409

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira