OFBiz
  1. OFBiz
  2. OFBIZ-4863

Scrum productstatistics shows errors

    Details

      Description

      When accesssing the product statistics page in scrum following errors are shown

      On the Project and Sprint Information Chart:

      The following items have errors:

      Chart (id = 10):
      + A BIRT exception occurred. See next exception for more information.
      Invalid javascript expression: row["DataName"] (Element ID:10)

      The following items have errors:

      Chart (id = 7):
      + A BIRT exception occurred. See next exception for more information.
      Invalid javascript expression: row["ProjectName"] (Element ID:7)

      On the Backlogs Information Chart:

      The following items have errors:

      Chart (id = 10):
      + A BIRT exception occurred. See next exception for more information.
      Invalid javascript expression: row["DataName"] (Element ID:10)

      The following items have errors:

      Chart (id = 10):
      + A BIRT exception occurred. See next exception for more information.
      Invalid javascript expression: row["DataName"] (Element ID:10)

      On the Tasks Information Chart:

      The following items have errors:

      Chart (id = 10):
      + A BIRT exception occurred. See next exception for more information.
      Invalid javascript expression: row["TaskName"] (Element ID:10)

      The following items have errors:

      Chart (id = 12):
      + A BIRT exception occurred. See next exception for more information.
      Invalid javascript expression: row["TaskType"] (Element ID:12)

        Activity

        Pierre Smits created issue -
        Erwan de FERRIERES made changes -
        Field Original Value New Value
        Parent OFBIZ-4849 [ 12553699 ]
        Issue Type Bug [ 1 ] Sub-task [ 7 ]
        Jacopo Cappellato made changes -
        Fix Version/s Trunk [ 12311928 ]
        Jacopo Cappellato made changes -
        Fix Version/s Release 11.04.01 [ 12320772 ]
        Pierre Smits made changes -
        Affects Version/s Release Branch 13.07 [ 12324879 ]
        Affects Version/s Release Branch 12.04 [ 12321265 ]
        Pierre Smits made changes -
        Affects Version/s Release Branch 13.07 [ 12324879 ]
        Pierre Smits made changes -
        Comment [ The error shown in one of the chart screens is:

        {code}
        he following items have errors:

        ReportDesign (id = 1):
        + Unhandled exception when executing script.

        ReportDesign (id = 1):
        + There are errors evaluating script "num = 2;
        data = null;

        projectActiveList = null;
        projectClosedList = null;

        projectActiveData = 0;
        projectClosedData = 0;

        try{
            var projectActiveList = delegator.findByAnd("WorkEffortAndProduct", UtilMisc.toMap("productId", productId, "workEffortTypeId", "SCRUM_PROJECT", "currentStatusId", "SPJ_ACTIVE"), null, false);
             if(projectActiveList != null) projectActiveData = projectActiveList.size();
            else projectActiveData = 0;
            
            var projectClosedList = delegator.findByAnd("WorkEffortAndProduct", UtilMisc.toMap("productId", productId, "workEffortTypeId", "SCRUM_PROJECT", "currentStatusId", "SPJ_CLOSED"), null, false);
             if(projectClosedList != null) projectClosedData = projectClosedList.size();
            else projectClosedData = 0;
            
        }catch(e){
                Debug.logError(e, module);
        }
        ":
        Fail to execute script in function __bm_OPEN(). Source:
        ------
        " + num = 2;
        data = null;

        projectActiveList = null;
        projectClosedList = null;

        projectActiveData = 0;
        projectClosedData = 0;

        try{
            var projectActiveList = delegator.findByAnd("WorkEffortAndProduct", UtilMisc.toMap("productId", productId, "workEffortTypeId", "SCRUM_PROJECT", "currentStatusId", "SPJ_ACTIVE"), null, false);
             if(projectActiveList != null) projectActiveData = projectActiveList.size();
            else projectActiveData = 0;
            
            var projectClosedList = delegator.findByAnd("WorkEffortAndProduct", UtilMisc.toMap("productId", productId, "workEffortTypeId", "SCRUM_PROJECT", "currentStatusId", "SPJ_CLOSED"), null, false);
             if(projectClosedList != null) projectClosedData = projectClosedList.size();
            else projectClosedData = 0;
            
        }catch(e){
                Debug.logError(e, module);
        }
         + "
        -----
        A BIRT exception occurred. See next exception for more information.
        ReferenceError: "Debug" is not defined. (/report/data-sets/script-data-set[@id="14"]/method[@name="open"]#20).
        {code} ]
        Hide
        Pierre Smits added a comment -

        This patch resolves the various rptdesign issues.

        Show
        Pierre Smits added a comment - This patch resolves the various rptdesign issues.
        Pierre Smits made changes -
        Attachment OFBIZ-4863-reports.patch [ 12754403 ]
        Pierre Smits made changes -
        Assignee Pierre Smits [ pfm.smits ]
        Pierre Smits made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Hide
        Pierre Smits added a comment -

        Updated patch to also fix OFBIZ-4861

        Show
        Pierre Smits added a comment - Updated patch to also fix OFBIZ-4861
        Pierre Smits made changes -
        Attachment OFBIZ-4863-reportsv2.patch [ 12754412 ]
        Pierre Smits made changes -
        Attachment OFBIZ-4863-reports.patch [ 12754403 ]
        Jacques Le Roux made changes -
        Parent OFBIZ-4849 [ 12553699 ]
        Issue Type Sub-task [ 7 ] Bug [ 1 ]
        Hide
        Jacques Le Roux added a comment -

        Not sure what productstatistics is, please be more specific

        Show
        Jacques Le Roux added a comment - Not sure what productstatistics is, please be more specific
        Hide
        Jacques Le Roux added a comment -

        OK it's

        <request-map uri="ProductStatistics">
        

        I applied the patch locally I got no errors but this in log.

        [java] 2015-09-09 15:23:48,246 |http-bio-8443-exec-1 |ControlServlet                |T| [[[ProductStatistics(Domain:https://localhost)] Request Done- total:3.123,since last([ProductStatistic...):3.123]]
        [java] 2015-09-09 15:23:53,957 |http-bio-8443-exec-6 |rptdesign                     |E| ReferenceError: "LinkedkList" n'est pas dÚfini
        [java] 2015-09-09 15:23:53,958 |http-bio-8443-exec-7 |rptdesign                     |E| ReferenceError: "LinkedkList" n'est pas dÚfini
        [java] 2015-09-09 15:23:53,962 |http-bio-8443-exec-2 |rptdesign                     |E| ReferenceError: "LinkedkList" n'est pas dÚfini
        [java] 2015-09-09 15:23:54,011 |http-bio-8443-exec-3 |ServiceDispatcher             |T| Sync service [birt/getProductBacklogSize] finished in [309] milliseconds
        [java] 2015-09-09 15:23:54,013 |http-bio-8443-exec-3 |ServiceDispatcher             |T| Sync service [birt/getProductBacklogSize] finished in [2] milliseconds
        [java] 2015-09-09 15:23:54,016 |http-bio-8443-exec-3 |ServiceDispatcher             |T| Sync service [birt/getProductBacklogSize] finished in [1] milliseconds
        

        I commit though, but I will put back some removed license headers

        Show
        Jacques Le Roux added a comment - OK it's <request-map uri= "ProductStatistics" > I applied the patch locally I got no errors but this in log. [java] 2015-09-09 15:23:48,246 |http-bio-8443-exec-1 |ControlServlet |T| [[[ProductStatistics(Domain:https: //localhost)] Request Done- total:3.123,since last([ProductStatistic...):3.123]] [java] 2015-09-09 15:23:53,957 |http-bio-8443-exec-6 |rptdesign |E| ReferenceError: "LinkedkList" n'est pas dÚfini [java] 2015-09-09 15:23:53,958 |http-bio-8443-exec-7 |rptdesign |E| ReferenceError: "LinkedkList" n'est pas dÚfini [java] 2015-09-09 15:23:53,962 |http-bio-8443-exec-2 |rptdesign |E| ReferenceError: "LinkedkList" n'est pas dÚfini [java] 2015-09-09 15:23:54,011 |http-bio-8443-exec-3 |ServiceDispatcher |T| Sync service [birt/getProductBacklogSize] finished in [309] milliseconds [java] 2015-09-09 15:23:54,013 |http-bio-8443-exec-3 |ServiceDispatcher |T| Sync service [birt/getProductBacklogSize] finished in [2] milliseconds [java] 2015-09-09 15:23:54,016 |http-bio-8443-exec-3 |ServiceDispatcher |T| Sync service [birt/getProductBacklogSize] finished in [1] milliseconds I commit though, but I will put back some removed license headers
        Hide
        Jacques Le Roux added a comment -

        Thanks Pierre,

        Your slightly modified (put back license headers removed) patch is in
        trunk r1702002
        R14.12 r1702003 (handled by hand, I left some javolution stuff)

        Show
        Jacques Le Roux added a comment - Thanks Pierre, Your slightly modified (put back license headers removed) patch is in trunk r1702002 R14.12 r1702003 (handled by hand, I left some javolution stuff)
        Jacques Le Roux made changes -
        Status Patch Available [ 10002 ] Closed [ 6 ]
        Fix Version/s 14.12.01 [ 12327361 ]
        Fix Version/s Upcoming Branch [ 12329183 ]
        Assignee Pierre Smits [ pfm.smits ] Jacques Le Roux [ jacques.le.roux ]
        Resolution Fixed [ 1 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Patch Available Patch Available
        1216d 7h 52m 1 Pierre Smits 06/Sep/15 18:28
        Patch Available Patch Available Closed Closed
        2d 19h 3m 1 Jacques Le Roux 09/Sep/15 13:31

          People

          • Assignee:
            Jacques Le Roux
            Reporter:
            Pierre Smits
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development