Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Trunk, Release Branch 16.11
    • Fix Version/s: Upcoming Release, 16.11.02
    • Component/s: accounting
    • Labels:
      None
    • Environment:

      database oracle 12c

      Description

      go to
      Accouting --> Organization GL Settings -->Accounting button – >> reports --> GL Account Trial Balance
      when excute this report the give me error
      NOTE: we used oracle 12c database
      ---------------------------------------------
      ERROR rendering error page [/error/error.jsp], but here is the error text: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen component://accounting/widget/ReportFinancialSummaryScreens.xml#GlAccountTrialBalance: java.lang.IllegalArgumentException: Error running script at location [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'com.ibm.icu.util.GregorianCalendar[time=1483221600000,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,811116000,828655200,843170400,860104800,874620000,891554400,906069600,930780000,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,1161900000,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone: Asia/Amman],firstDayOfWeek=1,minimalDaysInFirstWeek=1,repeatedWallTime=0,skippedWallTime=0,ERA=0,YEAR=0,MONTH=0,WEEK_OF_YEAR=0,WEEK_OF_MONTH=0,DAY_OF_MONTH=0,DAY_OF_YEAR=0,DAY_OF_WEEK=0,DAY_OF_WEEK_IN_MONTH=0,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0,YEAR_WOY=0,DOW_LOCAL=0,EXTENDED_YEAR=0,JULIAN_DAY=0,MILLISECONDS_IN_DAY=0,Field 22=0]' with class 'com.ibm.icu.util.GregorianCalendar' to class 'java.util.Calendar' (Error running script at location [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'com.ibm.icu.util.GregorianCalendar[time=1483221600000,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,811116000,828655200,843170400,860104800,874620000,891554400,906069600,930780000,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,1161900000,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone: Asia/Amman],firstDayOfWeek=1,minimalDaysInFirstWeek=1,repeatedWallTime=0,skippedWallTime=0,ERA=0,YEAR=0,MONTH=0,WEEK_OF_YEAR=0,WEEK_OF_MONTH=0,DAY_OF_MONTH=0,DAY_OF_YEAR=0,DAY_OF_WEEK=0,DAY_OF_WEEK_IN_MONTH=0,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0,YEAR_WOY=0,DOW_LOCAL=0,EXTENDED_YEAR=0,JULIAN_DAY=0,MILLISECONDS_IN_DAY=0,Field 22=0]' with class 'com.ibm.icu.util.GregorianCalendar' to class 'java.util.Calendar')

        Activity

        Hide
        pfm.smits Pierre Smits added a comment -

        Thanks Jacques.

        Show
        pfm.smits Pierre Smits added a comment - Thanks Jacques.
        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        No there are no issues, it's OK as is

        Show
        jacques.le.roux Jacques Le Roux added a comment - No there are no issues, it's OK as is
        Hide
        pfm.smits Pierre Smits added a comment -

        How do you mean?
        Is there still an issue? If so, this could be re-opened.

        Show
        pfm.smits Pierre Smits added a comment - How do you mean? Is there still an issue? If so, this could be re-opened.
        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        BTW weird the files are the same :-o

        Show
        jacques.le.roux Jacques Le Roux added a comment - BTW weird the files are the same :-o
        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        OK then we could revert, but I think it's not an issue anyway... Bigger fishes to fry...

        Show
        jacques.le.roux Jacques Le Roux added a comment - OK then we could revert, but I think it's not an issue anyway... Bigger fishes to fry...
        Show
        pfm.smits Pierre Smits added a comment - I don't see it happening in https://ofbiz-vm2.apache.org:28443/accounting/control/GlAccountTrialBalance
        Hide
        jacques.le.roux Jacques Le Roux added a comment -

        Thanks Moatasim, Ahmad,

        Pierre, your patch is in
        trunk r1783202
        R16.11 r1783211

        Older releases have conflicts, I let that for interested persons...

        Show
        jacques.le.roux Jacques Le Roux added a comment - Thanks Moatasim, Ahmad, Pierre, your patch is in trunk r1783202 R16.11 r1783211 Older releases have conflicts, I let that for interested persons...
        Hide
        pfm.smits Pierre Smits added a comment -

        This patch addresses the issue.

        Show
        pfm.smits Pierre Smits added a comment - This patch addresses the issue.
        Hide
        pfm.smits Pierre Smits added a comment -
        Show
        pfm.smits Pierre Smits added a comment - This issue also exists in https://ofbiz-vm2.apache.org:8443/accounting/control/GlAccountTrialBalance (demo against trunk)
        Hide
        moatasim Moatasim Al Masri added a comment -

        this issue solved by adding import com.ibm.icu.util.Calendar
        in file GlAccountTrialBalance.groovy

        Show
        moatasim Moatasim Al Masri added a comment - this issue solved by adding import com.ibm.icu.util.Calendar in file GlAccountTrialBalance.groovy
        Hide
        moatasim Moatasim Al Masri added a comment -

        thank you Ahmad, this import statement solved my issue

        Show
        moatasim Moatasim Al Masri added a comment - thank you Ahmad, this import statement solved my issue
        Hide
        aalajarmeh@bi-bst.com ahmad alajarmeh added a comment -

        you can solve this problem :
        go to groovy file with name "GlAccountTrialBalance.groovy" ,
        and insert this line as import statment "import com.ibm.icu.util.Calendar"

        Show
        aalajarmeh@bi-bst.com ahmad alajarmeh added a comment - you can solve this problem : go to groovy file with name "GlAccountTrialBalance.groovy" , and insert this line as import statment "import com.ibm.icu.util.Calendar"

          People

          • Assignee:
            pfm.smits Pierre Smits
            Reporter:
            moatasim Moatasim Al Masri
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development