Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 320C8200C1D for ; Thu, 16 Feb 2017 12:35:47 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 2D51F160B61; Thu, 16 Feb 2017 11:35:47 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 552DE160B57 for ; Thu, 16 Feb 2017 12:35:46 +0100 (CET) Received: (qmail 35338 invoked by uid 500); 16 Feb 2017 11:35:45 -0000 Mailing-List: contact notifications-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ofbiz.apache.org Delivered-To: mailing list notifications@ofbiz.apache.org Received: (qmail 35329 invoked by uid 99); 16 Feb 2017 11:35:45 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Feb 2017 11:35:45 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 28575185F35 for ; Thu, 16 Feb 2017 11:35:45 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.199 X-Spam-Level: X-Spam-Status: No, score=-1.199 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id OBAKgBOREfi9 for ; Thu, 16 Feb 2017 11:35:44 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 8F7D65FE4C for ; Thu, 16 Feb 2017 11:35:43 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 7CAFAE05F1 for ; Thu, 16 Feb 2017 11:35:42 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id E07D724123 for ; Thu, 16 Feb 2017 11:35:41 +0000 (UTC) Date: Thu, 16 Feb 2017 11:35:41 +0000 (UTC) From: "Jacques Le Roux (JIRA)" To: notifications@ofbiz.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Closed] (OFBIZ-9216) report GL Account Trial Balance MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Thu, 16 Feb 2017 11:35:47 -0000 [ https://issues.apache.org/jira/browse/OFBIZ-9216?page=3Dcom.atlassia= n.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-9216. ---------------------------------- > report GL Account Trial Balance > ------------------------------- > > Key: OFBIZ-9216 > URL: https://issues.apache.org/jira/browse/OFBIZ-9216 > Project: OFBiz > Issue Type: Bug > Components: accounting > Affects Versions: Release Branch 16.11 > Environment: database oracle 12c > Reporter: Moatasim Al Masri > > go to=20 > Accouting --> Organization GL Settings -->Accounting button -- >> reports= --> GL Account Trial Balance > when excute this report the give me error=20 > 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 s= creen [component://accounting/widget/ReportFinancialSummaryScreens.xml#GlAc= countTrialBalance]: java.lang.IllegalArgumentException: Error running scrip= t at location [component://accounting/groovyScripts/reports/GlAccountTrialB= alance.groovy]: org.codehaus.groovy.runtime.typehandling.GroovyCastExceptio= n: Cannot cast object 'com.ibm.icu.util.GregorianCalendar[time=3D1483221600= 000,areFieldsSet=3Dfalse,areAllFieldsSet=3Dfalse,lenient=3Dtrue,zone=3Dcom.= ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=3D71,typeCount=3D3,tran= sitionTimes=3D[-1230776624,108165600,118270800,136591200,149806800,16812720= 0,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481= 154400,496962000,512949600,528670800,544399200,560120400,575848800,59217480= 0,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717= 973200,733701600,749422800,765151200,779662800,797205600,811116000,82865520= 0,843170400,860104800,874620000,891554400,906069600,930780000,938124000,954= 367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066= 946400,1080252000,1097791200,1112306400,1128031200,1143756000,1161900000,11= 75205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,= 1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,141470640= 0],typeOffsets=3D[8624,0,7200,0,7200,3600],typeMapData=3D[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=3D2015,fin= alStartMillis=3D1.4200704E12,finalZone=3DSimpleTimeZone: Asia/Amman],firstD= ayOfWeek=3D1,minimalDaysInFirstWeek=3D1,repeatedWallTime=3D0,skippedWallTim= e=3D0,ERA=3D0,YEAR=3D0,MONTH=3D0,WEEK_OF_YEAR=3D0,WEEK_OF_MONTH=3D0,DAY_OF_= MONTH=3D0,DAY_OF_YEAR=3D0,DAY_OF_WEEK=3D0,DAY_OF_WEEK_IN_MONTH=3D0,AM_PM=3D= 0,HOUR=3D0,HOUR_OF_DAY=3D0,MINUTE=3D0,SECOND=3D0,MILLISECOND=3D0,ZONE_OFFSE= T=3D0,DST_OFFSET=3D0,YEAR_WOY=3D0,DOW_LOCAL=3D0,EXTENDED_YEAR=3D0,JULIAN_DA= Y=3D0,MILLISECONDS_IN_DAY=3D0,Field 22=3D0]' with class 'com.ibm.icu.util.G= regorianCalendar' to class 'java.util.Calendar' (Error running script at lo= cation [component://accounting/groovyScripts/reports/GlAccountTrialBalance.= groovy]: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cann= ot cast object 'com.ibm.icu.util.GregorianCalendar[time=3D1483221600000,are= FieldsSet=3Dfalse,areAllFieldsSet=3Dfalse,lenient=3Dtrue,zone=3Dcom.ibm.icu= .impl.OlsonTimeZone@4ebd0d68[transitionCount=3D71,typeCount=3D3,transitionT= imes=3D[-1230776624,108165600,118270800,136591200,149806800,168127200,18134= 2800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,= 496962000,512949600,528670800,544399200,560120400,575848800,592174800,61058= 1600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,= 733701600,749422800,765151200,779662800,797205600,811116000,828655200,84317= 0400,860104800,874620000,891554400,906069600,930780000,938124000,954367200,= 970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,= 1080252000,1097791200,1112306400,1128031200,1143756000,1161900000,117520560= 0,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303= 200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],type= Offsets=3D[8624,0,7200,0,7200,3600],typeMapData=3D[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=3D2015,finalStart= Millis=3D1.4200704E12,finalZone=3DSimpleTimeZone: Asia/Amman],firstDayOfWee= k=3D1,minimalDaysInFirstWeek=3D1,repeatedWallTime=3D0,skippedWallTime=3D0,E= RA=3D0,YEAR=3D0,MONTH=3D0,WEEK_OF_YEAR=3D0,WEEK_OF_MONTH=3D0,DAY_OF_MONTH= =3D0,DAY_OF_YEAR=3D0,DAY_OF_WEEK=3D0,DAY_OF_WEEK_IN_MONTH=3D0,AM_PM=3D0,HOU= R=3D0,HOUR_OF_DAY=3D0,MINUTE=3D0,SECOND=3D0,MILLISECOND=3D0,ZONE_OFFSET=3D0= ,DST_OFFSET=3D0,YEAR_WOY=3D0,DOW_LOCAL=3D0,EXTENDED_YEAR=3D0,JULIAN_DAY=3D0= ,MILLISECONDS_IN_DAY=3D0,Field 22=3D0]' with class 'com.ibm.icu.util.Gregor= ianCalendar' to class 'java.util.Calendar') -- This message was sent by Atlassian JIRA (v6.3.15#6346)