change date format in BI component when calling loadDateDimension
----------------------------------------------------------------- Key: OFBIZ-2113 URL: https://issues.apache.org/jira/browse/OFBIZ-2113 Project: OFBiz Issue Type: Improvement Affects Versions: SVN trunk Reporter: Erwan de FERRIERES Fix For: SVN trunk We found an error when calling loadDateDimension on the date format, there was an incoherence when trying to initialise the data. There was a problem with the Date format, which has been transformed as java.sql.Date. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[ https://issues.apache.org/jira/browse/OFBIZ-2113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Erwan de FERRIERES updated OFBIZ-2113: -------------------------------------- Attachment: patch.diff > change date format in BI component when calling loadDateDimension > ----------------------------------------------------------------- > > Key: OFBIZ-2113 > URL: https://issues.apache.org/jira/browse/OFBIZ-2113 > Project: OFBiz > Issue Type: Improvement > Affects Versions: SVN trunk > Reporter: Erwan de FERRIERES > Fix For: SVN trunk > > Attachments: patch.diff > > > We found an error when calling loadDateDimension on the date format, there was an incoherence when trying to initialise the data. There was a problem with the Date format, which has been transformed as java.sql.Date. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Erwan de FERRIERES updated OFBIZ-2113: -------------------------------------- Priority: Minor (was: Major) > change date format in BI component when calling loadDateDimension > ----------------------------------------------------------------- > > Key: OFBIZ-2113 > URL: https://issues.apache.org/jira/browse/OFBIZ-2113 > Project: OFBiz > Issue Type: Improvement > Affects Versions: SVN trunk > Reporter: Erwan de FERRIERES > Priority: Minor > Fix For: SVN trunk > > Attachments: patch.diff > > > We found an error when calling loadDateDimension on the date format, there was an incoherence when trying to initialise the data. There was a problem with the Date format, which has been transformed as java.sql.Date. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12661854#action_12661854 ] Jacques Le Roux commented on OFBIZ-2113: ---------------------------------------- Hi Erwan, Could you be more specific please, in which case did you get this error ? I mean could you describe the steps of the use case to reproduce the error ? Thanks > change date format in BI component when calling loadDateDimension > ----------------------------------------------------------------- > > Key: OFBIZ-2113 > URL: https://issues.apache.org/jira/browse/OFBIZ-2113 > Project: OFBiz > Issue Type: Improvement > Affects Versions: SVN trunk > Reporter: Erwan de FERRIERES > Priority: Minor > Fix For: SVN trunk > > Attachments: patch.diff > > > We found an error when calling loadDateDimension on the date format, there was an incoherence when trying to initialise the data. There was a problem with the Date format, which has been transformed as java.sql.Date. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12661866#action_12661866 ] Erwan de FERRIERES commented on OFBIZ-2113: ------------------------------------------- Sure ! When you are doing a quickInitDatawarehouse, by clicking on the link in the https://demo.hotwaxmedia.com/bi/control/main page, you will have a lot of errors in the log, like this one. With this patch, there are no more errors. [ EntityExpr.java:267:WARN ] ---- exception report ---------------------------------------------------------- =-=-=-=-=-=-=-=-= Database type warning in EntityExpr =-=-=-=-=-=-=-=-= In entity field [DateDimension.dateValue] set the value passed in [java.util.Date] is not compatible with the Java type of the field [java.sql.Date] Exception: java.lang.Exception Message: Location of database type warning ---- stack trace --------------------------------------------------------------- java.lang.Exception: Location of database type warning org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:267) org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:167) org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:67) org.ofbiz.entity.condition.EntityConditionListBase.makeWhereString(EntityConditionListBase.java:89) org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:676) org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140) org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:2273) org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:2314) org.ofbiz.entity.GenericDelegator.findByAnd(GenericDelegator.java:1925) org.ofbiz.common.olap.CommonDimensionServices.loadDateDimension(CommonDimensionServices.java:89) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:585) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:96) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:163) org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:244) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:921) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:749) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:149) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:131) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149) org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:332) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:461) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:293) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:204) javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568) org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:42) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) java.lang.Thread.run(Thread.java:595) -------------------------------------------------------------------------------- 2009-01-08 01:17:57,787 (TP-Processor27) > change date format in BI component when calling loadDateDimension > ----------------------------------------------------------------- > > Key: OFBIZ-2113 > URL: https://issues.apache.org/jira/browse/OFBIZ-2113 > Project: OFBiz > Issue Type: Improvement > Affects Versions: SVN trunk > Reporter: Erwan de FERRIERES > Priority: Minor > Fix For: SVN trunk > > Attachments: patch.diff > > > We found an error when calling loadDateDimension on the date format, there was an incoherence when trying to initialise the data. There was a problem with the Date format, which has been transformed as java.sql.Date. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12661896#action_12661896 ] Jacques Le Roux commented on OFBIZ-2113: ---------------------------------------- Hi Erwan, Weird, I do not get any errors locally, {code} 2009-01-08 09:48:28,296 (http-0.0.0.0-18443-1) [ ControlServlet.java:131:INFO ] [[[quickInitDataWarehouse] Servlet Starting, doing setup- total:0.0,since last(Begin):0.0]] 2009-01-08 09:48:28,296 (http-0.0.0.0-18443-1) [ ControlServlet.java:196:INFO ] [[[quickInitDataWarehouse] Setup done, doing Event(s) and View(s)- total:0.0,since last([quickInitDataWar...):0.0]] 2009-01-08 09:48:28,312 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: jndi:/0.0.0.0/bi/WEB-INF/controller.xml 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:631:INFO ] ConfigMap Created: (4) records in 0.016s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:631:INFO ] ConfigMap Created: (4) records in 0.016s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:774:INFO ] HandlerMap Created: (7) view handlers and (11) request/event handlers in 0.0s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:774:INFO ] HandlerMap Created: (7) view handlers and (11) request/event handlers in 0.0s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,343 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:379:INFO ] RequestMap Created: (14) records in 0.015s 2009-01-08 09:48:28,343 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:379:INFO ] RequestMap Created: (21) records in 0.015s 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:467:INFO ] ViewMap Created: (12) records in 0.016s 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:467:INFO ] ViewMap Created: (15) records in 0.016s 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,375 (http-0.0.0.0-18443-1) [ RequestHandler.java:256:INFO ] [Processing Request]: quickInitDataWarehouse sessionId=CEC67F4842E2E5E7930C9192E22506B6.jvm1 2009-01-08 09:48:28,437 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: file:/D:/workspace/ofbizRun/framework/bi/script/org/ofbiz/bi/DimensionServices.xml 2009-01-08 09:48:28,468 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10740, maxSeqId=10750, bankSize=10 2009-01-08 09:48:28,546 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10750, maxSeqId=10760, bankSize=10 2009-01-08 09:48:28,578 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10760, maxSeqId=10770, bankSize=10 2009-01-08 09:48:28,609 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10770, maxSeqId=10780, bankSize=10 2009-01-08 09:48:28,671 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10780, maxSeqId=10790, bankSize=10 2009-01-08 09:48:28,703 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10790, maxSeqId=10800, bankSize=10 2009-01-08 09:48:28,750 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10800, maxSeqId=10810, bankSize=10 2009-01-08 09:48:28,796 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10810, maxSeqId=10820, bankSize=10 2009-01-08 09:48:28,828 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10820, maxSeqId=10830, bankSize=10 2009-01-08 09:48:28,859 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10830, maxSeqId=10840, bankSize=10 2009-01-08 09:48:28,890 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10840, maxSeqId=10850, bankSize=10 2009-01-08 09:48:28,906 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10850, maxSeqId=10860, bankSize=10 2009-01-08 09:48:28,921 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10860, maxSeqId=10870, bankSize=10 2009-01-08 09:48:28,953 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10870, maxSeqId=10880, bankSize=10 2009-01-08 09:48:28,984 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10880, maxSeqId=10890, bankSize=10 2009-01-08 09:48:29,000 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10890, maxSeqId=10900, bankSize=10 2009-01-08 09:48:29,031 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10900, maxSeqId=10910, bankSize=10 2009-01-08 09:48:29,078 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10910, maxSeqId=10920, bankSize=10 2009-01-08 09:48:29,109 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10920, maxSeqId=10930, bankSize=10 2009-01-08 09:48:29,125 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10930, maxSeqId=10940, bankSize=10 2009-01-08 09:48:29,156 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10940, maxSeqId=10950, bankSize=10 2009-01-08 09:48:29,171 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10950, maxSeqId=10960, bankSize=10 2009-01-08 09:48:29,203 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10960, maxSeqId=10970, bankSize=10 2009-01-08 09:48:29,218 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10970, maxSeqId=10980, bankSize=10 2009-01-08 09:48:29,234 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10980, maxSeqId=10990, bankSize=10 2009-01-08 09:48:29,265 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10990, maxSeqId=11000, bankSize=10 2009-01-08 09:48:29,281 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11000, maxSeqId=11010, bankSize=10 2009-01-08 09:48:29,312 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11010, maxSeqId=11020, bankSize=10 2009-01-08 09:48:29,328 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11020, maxSeqId=11030, bankSize=10 2009-01-08 09:48:29,343 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11030, maxSeqId=11040, bankSize=10 2009-01-08 09:48:29,359 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11040, maxSeqId=11050, bankSize=10 2009-01-08 09:48:29,406 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11050, maxSeqId=11060, bankSize=10 2009-01-08 09:48:29,421 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11060, maxSeqId=11070, bankSize=10 2009-01-08 09:48:29,437 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11070, maxSeqId=11080, bankSize=10 2009-01-08 09:48:29,453 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11080, maxSeqId=11090, bankSize=10 2009-01-08 09:48:29,468 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11090, maxSeqId=11100, bankSize=10 2009-01-08 09:48:29,484 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11100, maxSeqId=11110, bankSize=10 2009-01-08 09:48:29,515 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11110, maxSeqId=11120, bankSize=10 2009-01-08 09:48:29,531 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11120, maxSeqId=11130, bankSize=10 2009-01-08 09:48:29,546 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11130, maxSeqId=11140, bankSize=10 2009-01-08 09:48:29,578 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11140, maxSeqId=11150, bankSize=10 2009-01-08 09:48:29,593 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11150, maxSeqId=11160, bankSize=10 2009-01-08 09:48:29,609 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11160, maxSeqId=11170, bankSize=10 2009-01-08 09:48:29,625 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11170, maxSeqId=11180, bankSize=10 2009-01-08 09:48:29,656 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11180, maxSeqId=11190, bankSize=10 2009-01-08 09:48:29,671 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11190, maxSeqId=11200, bankSize=10 2009-01-08 09:48:29,687 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11200, maxSeqId=11210, bankSize=10 2009-01-08 09:48:29,703 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11210, maxSeqId=11220, bankSize=10 2009-01-08 09:48:29,734 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11220, maxSeqId=11230, bankSize=10 2009-01-08 09:48:29,765 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11230, maxSeqId=11240, bankSize=10 2009-01-08 09:48:29,796 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11240, maxSeqId=11250, bankSize=10 2009-01-08 09:48:29,812 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11250, maxSeqId=11260, bankSize=10 2009-01-08 09:48:29,812 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11260, maxSeqId=11270, bankSize=10 2009-01-08 09:48:29,828 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11270, maxSeqId=11280, bankSize=10 2009-01-08 09:48:29,843 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11280, maxSeqId=11290, bankSize=10 2009-01-08 09:48:29,875 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11290, maxSeqId=11300, bankSize=10 2009-01-08 09:48:29,890 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11300, maxSeqId=11310, bankSize=10 2009-01-08 09:48:29,906 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11310, maxSeqId=11320, bankSize=10 2009-01-08 09:48:29,937 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11320, maxSeqId=11330, bankSize=10 2009-01-08 09:48:29,953 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11330, maxSeqId=11340, bankSize=10 2009-01-08 09:48:29,968 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11340, maxSeqId=11350, bankSize=10 2009-01-08 09:48:29,984 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11350, maxSeqId=11360, bankSize=10 2009-01-08 09:48:30,000 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11360, maxSeqId=11370, bankSize=10 2009-01-08 09:48:30,015 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11370, maxSeqId=11380, bankSize=10 2009-01-08 09:48:30,031 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11380, maxSeqId=11390, bankSize=10 2009-01-08 09:48:30,062 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11390, maxSeqId=11400, bankSize=10 2009-01-08 09:48:30,078 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11400, maxSeqId=11410, bankSize=10 2009-01-08 09:48:30,093 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11410, maxSeqId=11420, bankSize=10 2009-01-08 09:48:30,125 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11420, maxSeqId=11430, bankSize=10 2009-01-08 09:48:30,140 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11430, maxSeqId=11440, bankSize=10 2009-01-08 09:48:30,156 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11440, maxSeqId=11450, bankSize=10 2009-01-08 09:48:30,187 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11450, maxSeqId=11460, bankSize=10 2009-01-08 09:48:30,218 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11460, maxSeqId=11470, bankSize=10 2009-01-08 09:48:30,234 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11470, maxSeqId=11480, bankSize=10 2009-01-08 09:48:30,234 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadDateDimension] finished in [1797] milliseconds 2009-01-08 09:48:30,250 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: XML Properties file 2009-01-08 09:48:30,250 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,250 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 3 properties for: DefaultMessages (en) 2009-01-08 09:48:30,265 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,265 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 3 properties for: DefaultMessages (fr) 2009-01-08 09:48:30,265 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle DefaultMessages (fr) created in 31.0 mS 2009-01-08 09:48:30,281 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/script/org/ofbiz/common/olap/CommonDimensionServices.xml 2009-01-08 09:48:30,343 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:30,406 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:30,406 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 1294 properties for: CommonEntityLabels (en) 2009-01-08 09:48:30,453 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.032s: XML Properties file 2009-01-08 09:48:30,468 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 698 properties for: CommonEntityLabels (fr) 2009-01-08 09:48:30,484 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle CommonEntityLabels (fr) created in 172.0 mS 2009-01-08 09:48:30,484 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10190, maxSeqId=10200, bankSize=10 2009-01-08 09:48:30,531 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10200, maxSeqId=10210, bankSize=10 2009-01-08 09:48:30,562 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10210, maxSeqId=10220, bankSize=10 2009-01-08 09:48:30,562 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10220, maxSeqId=10230, bankSize=10 2009-01-08 09:48:30,578 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10230, maxSeqId=10240, bankSize=10 2009-01-08 09:48:30,593 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10240, maxSeqId=10250, bankSize=10 2009-01-08 09:48:30,593 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10250, maxSeqId=10260, bankSize=10 2009-01-08 09:48:30,609 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10260, maxSeqId=10270, bankSize=10 2009-01-08 09:48:30,625 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10270, maxSeqId=10280, bankSize=10 2009-01-08 09:48:30,625 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10280, maxSeqId=10290, bankSize=10 2009-01-08 09:48:30,640 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10290, maxSeqId=10300, bankSize=10 2009-01-08 09:48:30,656 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10300, maxSeqId=10310, bankSize=10 2009-01-08 09:48:30,671 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10310, maxSeqId=10320, bankSize=10 2009-01-08 09:48:30,687 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10320, maxSeqId=10330, bankSize=10 2009-01-08 09:48:30,703 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10330, maxSeqId=10340, bankSize=10 2009-01-08 09:48:30,718 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10340, maxSeqId=10350, bankSize=10 2009-01-08 09:48:30,718 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10350, maxSeqId=10360, bankSize=10 2009-01-08 09:48:30,734 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10360, maxSeqId=10370, bankSize=10 2009-01-08 09:48:30,750 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10370, maxSeqId=10380, bankSize=10 2009-01-08 09:48:30,750 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadCurrencyDimension] finished in [485] milliseconds 2009-01-08 09:48:30,750 (http-0.0.0.0-18443-1) [ ModelService.java:450:INFO ] Set default value [TYPE1] for parameter [updateMode] 2009-01-08 09:48:30,781 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: file:/D:/workspace/ofbizRun/applications/product/script/org/ofbiz/product/olap/ProductDimensionServices. 2009-01-08 09:48:30,812 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,828 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,828 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 226 properties for: ProductEntityLabels (en) 2009-01-08 09:48:30,843 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,843 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 226 properties for: ProductEntityLabels (fr) 2009-01-08 09:48:30,859 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle ProductEntityLabels (fr) created in 63.0 mS 2009-01-08 09:48:30,859 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/prepareProductDimensionData] finished in [63] milliseconds 2009-01-08 09:48:30,859 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10020, maxSeqId=10030, bankSize=10 2009-01-08 09:48:30,875 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadProductInProductDimension] finished in [79] milliseconds 2009-01-08 09:48:30,906 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10030, maxSeqId=10040, bankSize=10 2009-01-08 09:48:30,968 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10040, maxSeqId=10050, bankSize=10 2009-01-08 09:48:31,031 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10050, maxSeqId=10060, bankSize=10 2009-01-08 09:48:31,062 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10060, maxSeqId=10070, bankSize=10 2009-01-08 09:48:31,109 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10070, maxSeqId=10080, bankSize=10 2009-01-08 09:48:31,140 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10080, maxSeqId=10090, bankSize=10 2009-01-08 09:48:31,187 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10090, maxSeqId=10100, bankSize=10 2009-01-08 09:48:31,203 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadAllProductsInProductDimension] finished in [453] milliseconds 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/quickInitDataWarehouse] finished in [2812] milliseconds 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ RequestHandler.java:440:INFO ] [RequestHandler.doRequest]: Response is a view. sessionId=CEC67F4842E2E5E7930C9192E22506B6.jvm1 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ RequestHandler.java:591:INFO ] servletName=control, view=main sessionId=CEC67F4842E2E5E7930C9192E22506B6.jvm1 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ UtilJ2eeCompat.java:69 :INFO ] serverInfo: apache tomcat/6.0.16 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ UtilJ2eeCompat.java:78 :INFO ] Apache Tomcat detected, using response.getWriter to write text out instead of response.getOutputStream 2009-01-08 09:48:31,265 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/bi/widget/BiScreens.xml 2009-01-08 09:48:31,296 (http-0.0.0.0-18443-1) [ ScreenFactory.java:129:INFO ] Got 5 screens in 0.031s from: file:/D:/workspace/ofbizRun/framework/bi/widget/BiScreens.xml 2009-01-08 09:48:31,296 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 47 properties for: BiUiLabels (en) 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 47 properties for: BiUiLabels (fr) 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle BiUiLabels (fr) created in 16.0 mS 2009-01-08 09:48:31,359 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:31,406 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:31,406 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 640 properties for: CommonUiLabels (en) 2009-01-08 09:48:31,437 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:31,453 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 621 properties for: CommonUiLabels (fr) 2009-01-08 09:48:31,453 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle CommonUiLabels (fr) created in 141.0 mS 2009-01-08 09:48:31,468 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.015s: file:/D:/workspace/ofbizRun/framework/common/widget/CommonScreens.xml 2009-01-08 09:48:31,484 (http-0.0.0.0-18443-1) [ ScreenFactory.java:129:INFO ] Got 21 screens in 0.031s from: file:/D:/workspace/ofbizRun/framework/common/widget/CommonScreens.xml 2009-01-08 09:48:31,531 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: file:/D:/workspace/ofbizRun/framework/common/script/org/ofbiz/common/CommonServices.xml 2009-01-08 09:48:31,531 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 20 properties for: general () 2009-01-08 09:48:31,562 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle general (fr) created in 31.0 mS 2009-01-08 09:48:31,984 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/bi/widget/BiMenus.xml 2009-01-08 09:48:32,000 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/widget/CommonMenus.xml 2009-01-08 09:48:32,031 (http-0.0.0.0-18443-1) [ ModelScreenWidget.java:519:INFO ] In the include-screen tag the screen name was empty, ignoring include; in screen [GlobalDecorator] 2009-01-08 09:48:32,093 (http-0.0.0.0-18443-1) [ ControlServlet.java:302:INFO ] [[[quickInitDataWarehouse] Done rendering page, Servlet Finished- total:3.797,since last([quickInitDataWar...):3.797]] {code} But I get them on Demo server. {code} 2009-01-08 02:54:21,122 (TP-Processor28) [ EntityExpr.java:267:WARN ] ---- exception report ---------------------------------------------------------- =-=-=-=-=-=-=-=-= Database type warning in EntityExpr =-=-=-=-=-=-=-=-= In entity field [DateDimension.dateValue] set the value passed in [java.util.Date] is not compatible with the Java type of the field [java.sql.Date] Exception: java.lang.Exception Message: Location of database type warning ---- stack trace --------------------------------------------------------------- java.lang.Exception: Location of database type warning org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:267) org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:167) org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:67) org.ofbiz.entity.condition.EntityConditionListBase.makeWhereString(EntityConditionListBase.java:89) org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:676) org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140) org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:2273) org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:2314) org.ofbiz.entity.GenericDelegator.findByAnd(GenericDelegator.java:1925) org.ofbiz.common.olap.CommonDimensionServices.loadDateDimension(CommonDimensionServices.java:89) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:585) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:96) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:163) org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:244) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:921) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:749) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:149) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:131) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149) org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:332) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:461) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:293) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:204) javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568) org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:42) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) java.lang.Thread.run(Thread.java:595) --------------------------------------------------------------------------------{code} I don't know what to think since both are using Derby. Anyway I will apply your patch, thanks > change date format in BI component when calling loadDateDimension > ----------------------------------------------------------------- > > Key: OFBIZ-2113 > URL: https://issues.apache.org/jira/browse/OFBIZ-2113 > Project: OFBiz > Issue Type: Improvement > Affects Versions: SVN trunk > Reporter: Erwan de FERRIERES > Priority: Minor > Fix For: SVN trunk > > Attachments: patch.diff > > > We found an error when calling loadDateDimension on the date format, there was an incoherence when trying to initialise the data. There was a problem with the Date format, which has been transformed as java.sql.Date. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12661896#action_12661896 ] jacques.le.roux edited comment on OFBIZ-2113 at 1/8/09 1:05 AM: ---------------------------------------------------------------- Hi Erwan, Weird, I do not get any errors locally, {code} 2009-01-08 09:48:28,296 (http-0.0.0.0-18443-1) [ ControlServlet.java:131:INFO ] [[[quickInitDataWarehouse] Servlet Starting, doing setup- total:0.0,since last(Begin):0.0]] 2009-01-08 09:48:28,296 (http-0.0.0.0-18443-1) [ ControlServlet.java:196:INFO ] [[[quickInitDataWarehouse] Setup done, doing Event(s) and View(s)- total:0.0,since last([quickInitDataWar...):0.0]] 2009-01-08 09:48:28,312 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: jndi:/0.0.0.0/bi/WEB-INF/controller.xml 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:631:INFO ] ConfigMap Created: (4) records in 0.016s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:631:INFO ] ConfigMap Created: (4) records in 0.016s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:774:INFO ] HandlerMap Created: (7) view handlers and (11) request/event handlers in 0.0s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:774:INFO ] HandlerMap Created: (7) view handlers and (11) request/event handlers in 0.0s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,343 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:379:INFO ] RequestMap Created: (14) records in 0.015s 2009-01-08 09:48:28,343 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:379:INFO ] RequestMap Created: (21) records in 0.015s 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:467:INFO ] ViewMap Created: (12) records in 0.016s 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:467:INFO ] ViewMap Created: (15) records in 0.016s 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,375 (http-0.0.0.0-18443-1) [ RequestHandler.java:256:INFO ] [Processing Request]: quickInitDataWarehouse sessionId=CEC67F4842E2E5E7930C9192E22506B6.jvm1 2009-01-08 09:48:28,437 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: file:/D:/workspace/ofbizRun/framework/bi/script/org/ofbiz/bi/DimensionServices.xml 2009-01-08 09:48:28,468 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10740, maxSeqId=10750, bankSize=10 2009-01-08 09:48:28,546 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10750, maxSeqId=10760, bankSize=10 2009-01-08 09:48:28,578 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10760, maxSeqId=10770, bankSize=10 2009-01-08 09:48:28,609 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10770, maxSeqId=10780, bankSize=10 2009-01-08 09:48:28,671 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10780, maxSeqId=10790, bankSize=10 2009-01-08 09:48:28,703 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10790, maxSeqId=10800, bankSize=10 2009-01-08 09:48:28,750 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10800, maxSeqId=10810, bankSize=10 2009-01-08 09:48:28,796 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10810, maxSeqId=10820, bankSize=10 2009-01-08 09:48:28,828 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10820, maxSeqId=10830, bankSize=10 2009-01-08 09:48:28,859 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10830, maxSeqId=10840, bankSize=10 2009-01-08 09:48:28,890 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10840, maxSeqId=10850, bankSize=10 2009-01-08 09:48:28,906 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10850, maxSeqId=10860, bankSize=10 2009-01-08 09:48:28,921 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10860, maxSeqId=10870, bankSize=10 2009-01-08 09:48:28,953 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10870, maxSeqId=10880, bankSize=10 2009-01-08 09:48:28,984 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10880, maxSeqId=10890, bankSize=10 2009-01-08 09:48:29,000 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10890, maxSeqId=10900, bankSize=10 2009-01-08 09:48:29,031 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10900, maxSeqId=10910, bankSize=10 2009-01-08 09:48:29,078 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10910, maxSeqId=10920, bankSize=10 2009-01-08 09:48:29,109 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10920, maxSeqId=10930, bankSize=10 2009-01-08 09:48:29,125 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10930, maxSeqId=10940, bankSize=10 2009-01-08 09:48:29,156 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10940, maxSeqId=10950, bankSize=10 2009-01-08 09:48:29,171 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10950, maxSeqId=10960, bankSize=10 2009-01-08 09:48:29,203 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10960, maxSeqId=10970, bankSize=10 2009-01-08 09:48:29,218 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10970, maxSeqId=10980, bankSize=10 2009-01-08 09:48:29,234 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10980, maxSeqId=10990, bankSize=10 2009-01-08 09:48:29,265 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10990, maxSeqId=11000, bankSize=10 2009-01-08 09:48:29,281 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11000, maxSeqId=11010, bankSize=10 2009-01-08 09:48:29,312 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11010, maxSeqId=11020, bankSize=10 2009-01-08 09:48:29,328 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11020, maxSeqId=11030, bankSize=10 2009-01-08 09:48:29,343 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11030, maxSeqId=11040, bankSize=10 2009-01-08 09:48:29,359 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11040, maxSeqId=11050, bankSize=10 2009-01-08 09:48:29,406 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11050, maxSeqId=11060, bankSize=10 2009-01-08 09:48:29,421 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11060, maxSeqId=11070, bankSize=10 2009-01-08 09:48:29,437 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11070, maxSeqId=11080, bankSize=10 2009-01-08 09:48:29,453 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11080, maxSeqId=11090, bankSize=10 2009-01-08 09:48:29,468 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11090, maxSeqId=11100, bankSize=10 2009-01-08 09:48:29,484 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11100, maxSeqId=11110, bankSize=10 2009-01-08 09:48:29,515 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11110, maxSeqId=11120, bankSize=10 2009-01-08 09:48:29,531 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11120, maxSeqId=11130, bankSize=10 2009-01-08 09:48:29,546 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11130, maxSeqId=11140, bankSize=10 2009-01-08 09:48:29,578 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11140, maxSeqId=11150, bankSize=10 2009-01-08 09:48:29,593 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11150, maxSeqId=11160, bankSize=10 2009-01-08 09:48:29,609 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11160, maxSeqId=11170, bankSize=10 2009-01-08 09:48:29,625 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11170, maxSeqId=11180, bankSize=10 2009-01-08 09:48:29,656 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11180, maxSeqId=11190, bankSize=10 2009-01-08 09:48:29,671 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11190, maxSeqId=11200, bankSize=10 2009-01-08 09:48:29,687 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11200, maxSeqId=11210, bankSize=10 2009-01-08 09:48:29,703 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11210, maxSeqId=11220, bankSize=10 2009-01-08 09:48:29,734 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11220, maxSeqId=11230, bankSize=10 2009-01-08 09:48:29,765 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11230, maxSeqId=11240, bankSize=10 2009-01-08 09:48:29,796 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11240, maxSeqId=11250, bankSize=10 2009-01-08 09:48:29,812 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11250, maxSeqId=11260, bankSize=10 2009-01-08 09:48:29,812 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11260, maxSeqId=11270, bankSize=10 2009-01-08 09:48:29,828 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11270, maxSeqId=11280, bankSize=10 2009-01-08 09:48:29,843 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11280, maxSeqId=11290, bankSize=10 2009-01-08 09:48:29,875 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11290, maxSeqId=11300, bankSize=10 2009-01-08 09:48:29,890 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11300, maxSeqId=11310, bankSize=10 2009-01-08 09:48:29,906 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11310, maxSeqId=11320, bankSize=10 2009-01-08 09:48:29,937 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11320, maxSeqId=11330, bankSize=10 2009-01-08 09:48:29,953 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11330, maxSeqId=11340, bankSize=10 2009-01-08 09:48:29,968 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11340, maxSeqId=11350, bankSize=10 2009-01-08 09:48:29,984 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11350, maxSeqId=11360, bankSize=10 2009-01-08 09:48:30,000 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11360, maxSeqId=11370, bankSize=10 2009-01-08 09:48:30,015 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11370, maxSeqId=11380, bankSize=10 2009-01-08 09:48:30,031 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11380, maxSeqId=11390, bankSize=10 2009-01-08 09:48:30,062 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11390, maxSeqId=11400, bankSize=10 2009-01-08 09:48:30,078 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11400, maxSeqId=11410, bankSize=10 2009-01-08 09:48:30,093 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11410, maxSeqId=11420, bankSize=10 2009-01-08 09:48:30,125 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11420, maxSeqId=11430, bankSize=10 2009-01-08 09:48:30,140 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11430, maxSeqId=11440, bankSize=10 2009-01-08 09:48:30,156 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11440, maxSeqId=11450, bankSize=10 2009-01-08 09:48:30,187 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11450, maxSeqId=11460, bankSize=10 2009-01-08 09:48:30,218 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11460, maxSeqId=11470, bankSize=10 2009-01-08 09:48:30,234 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11470, maxSeqId=11480, bankSize=10 2009-01-08 09:48:30,234 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadDateDimension] finished in [1797] milliseconds 2009-01-08 09:48:30,250 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: XML Properties file 2009-01-08 09:48:30,250 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,250 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 3 properties for: DefaultMessages (en) 2009-01-08 09:48:30,265 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,265 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 3 properties for: DefaultMessages (fr) 2009-01-08 09:48:30,265 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle DefaultMessages (fr) created in 31.0 mS 2009-01-08 09:48:30,281 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/script/org/ofbiz/common/olap/CommonDimensionServices.xml 2009-01-08 09:48:30,343 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:30,406 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:30,406 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 1294 properties for: CommonEntityLabels (en) 2009-01-08 09:48:30,453 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.032s: XML Properties file 2009-01-08 09:48:30,468 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 698 properties for: CommonEntityLabels (fr) 2009-01-08 09:48:30,484 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle CommonEntityLabels (fr) created in 172.0 mS 2009-01-08 09:48:30,484 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10190, maxSeqId=10200, bankSize=10 2009-01-08 09:48:30,531 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10200, maxSeqId=10210, bankSize=10 2009-01-08 09:48:30,562 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10210, maxSeqId=10220, bankSize=10 2009-01-08 09:48:30,562 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10220, maxSeqId=10230, bankSize=10 2009-01-08 09:48:30,578 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10230, maxSeqId=10240, bankSize=10 2009-01-08 09:48:30,593 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10240, maxSeqId=10250, bankSize=10 2009-01-08 09:48:30,593 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10250, maxSeqId=10260, bankSize=10 2009-01-08 09:48:30,609 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10260, maxSeqId=10270, bankSize=10 2009-01-08 09:48:30,625 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10270, maxSeqId=10280, bankSize=10 2009-01-08 09:48:30,625 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10280, maxSeqId=10290, bankSize=10 2009-01-08 09:48:30,640 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10290, maxSeqId=10300, bankSize=10 2009-01-08 09:48:30,656 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10300, maxSeqId=10310, bankSize=10 2009-01-08 09:48:30,671 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10310, maxSeqId=10320, bankSize=10 2009-01-08 09:48:30,687 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10320, maxSeqId=10330, bankSize=10 2009-01-08 09:48:30,703 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10330, maxSeqId=10340, bankSize=10 2009-01-08 09:48:30,718 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10340, maxSeqId=10350, bankSize=10 2009-01-08 09:48:30,718 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10350, maxSeqId=10360, bankSize=10 2009-01-08 09:48:30,734 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10360, maxSeqId=10370, bankSize=10 2009-01-08 09:48:30,750 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10370, maxSeqId=10380, bankSize=10 2009-01-08 09:48:30,750 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadCurrencyDimension] finished in [485] milliseconds 2009-01-08 09:48:30,750 (http-0.0.0.0-18443-1) [ ModelService.java:450:INFO ] Set default value [TYPE1] for parameter [updateMode] 2009-01-08 09:48:30,781 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: file:/D:/workspace/ofbizRun/applications/product/script/org/ofbiz/product/olap/ProductDimensionServices. 2009-01-08 09:48:30,812 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,828 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,828 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 226 properties for: ProductEntityLabels (en) 2009-01-08 09:48:30,843 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,843 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 226 properties for: ProductEntityLabels (fr) 2009-01-08 09:48:30,859 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle ProductEntityLabels (fr) created in 63.0 mS 2009-01-08 09:48:30,859 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/prepareProductDimensionData] finished in [63] milliseconds 2009-01-08 09:48:30,859 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10020, maxSeqId=10030, bankSize=10 2009-01-08 09:48:30,875 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadProductInProductDimension] finished in [79] milliseconds 2009-01-08 09:48:30,906 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10030, maxSeqId=10040, bankSize=10 2009-01-08 09:48:30,968 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10040, maxSeqId=10050, bankSize=10 2009-01-08 09:48:31,031 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10050, maxSeqId=10060, bankSize=10 2009-01-08 09:48:31,062 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10060, maxSeqId=10070, bankSize=10 2009-01-08 09:48:31,109 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10070, maxSeqId=10080, bankSize=10 2009-01-08 09:48:31,140 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10080, maxSeqId=10090, bankSize=10 2009-01-08 09:48:31,187 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10090, maxSeqId=10100, bankSize=10 2009-01-08 09:48:31,203 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadAllProductsInProductDimension] finished in [453] milliseconds 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/quickInitDataWarehouse] finished in [2812] milliseconds 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ RequestHandler.java:440:INFO ] [RequestHandler.doRequest]: Response is a view. sessionId=CEC67F4842E2E5E7930C9192E22506B6.jvm1 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ RequestHandler.java:591:INFO ] servletName=control, view=main sessionId=CEC67F4842E2E5E7930C9192E22506B6.jvm1 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ UtilJ2eeCompat.java:69 :INFO ] serverInfo: apache tomcat/6.0.16 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ UtilJ2eeCompat.java:78 :INFO ] Apache Tomcat detected, using response.getWriter to write text out instead of response.getOutputStream 2009-01-08 09:48:31,265 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/bi/widget/BiScreens.xml 2009-01-08 09:48:31,296 (http-0.0.0.0-18443-1) [ ScreenFactory.java:129:INFO ] Got 5 screens in 0.031s from: file:/D:/workspace/ofbizRun/framework/bi/widget/BiScreens.xml 2009-01-08 09:48:31,296 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 47 properties for: BiUiLabels (en) 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 47 properties for: BiUiLabels (fr) 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle BiUiLabels (fr) created in 16.0 mS 2009-01-08 09:48:31,359 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:31,406 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:31,406 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 640 properties for: CommonUiLabels (en) 2009-01-08 09:48:31,437 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:31,453 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 621 properties for: CommonUiLabels (fr) 2009-01-08 09:48:31,453 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle CommonUiLabels (fr) created in 141.0 mS 2009-01-08 09:48:31,468 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.015s: file:/D:/workspace/ofbizRun/framework/common/widget/CommonScreens.xml 2009-01-08 09:48:31,484 (http-0.0.0.0-18443-1) [ ScreenFactory.java:129:INFO ] Got 21 screens in 0.031s from: file:/D:/workspace/ofbizRun/framework/common/widget/CommonScreens.xml 2009-01-08 09:48:31,531 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: file:/D:/workspace/ofbizRun/framework/common/script/org/ofbiz/common/CommonServices.xml 2009-01-08 09:48:31,531 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 20 properties for: general () 2009-01-08 09:48:31,562 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle general (fr) created in 31.0 mS 2009-01-08 09:48:31,984 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/bi/widget/BiMenus.xml 2009-01-08 09:48:32,000 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/widget/CommonMenus.xml 2009-01-08 09:48:32,031 (http-0.0.0.0-18443-1) [ ModelScreenWidget.java:519:INFO ] In the include-screen tag the screen name was empty, ignoring include; in screen [GlobalDecorator] 2009-01-08 09:48:32,093 (http-0.0.0.0-18443-1) [ ControlServlet.java:302:INFO ] [[[quickInitDataWarehouse] Done rendering page, Servlet Finished- total:3.797,since last([quickInitDataWar...):3.797]] {code} But I get them on Demo server. I don't know what to think since both are using Derby. Anyway I will apply your patch, thanks was (Author: jacques.le.roux): Hi Erwan, Weird, I do not get any errors locally, {code} 2009-01-08 09:48:28,296 (http-0.0.0.0-18443-1) [ ControlServlet.java:131:INFO ] [[[quickInitDataWarehouse] Servlet Starting, doing setup- total:0.0,since last(Begin):0.0]] 2009-01-08 09:48:28,296 (http-0.0.0.0-18443-1) [ ControlServlet.java:196:INFO ] [[[quickInitDataWarehouse] Setup done, doing Event(s) and View(s)- total:0.0,since last([quickInitDataWar...):0.0]] 2009-01-08 09:48:28,312 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: jndi:/0.0.0.0/bi/WEB-INF/controller.xml 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:631:INFO ] ConfigMap Created: (4) records in 0.016s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:631:INFO ] ConfigMap Created: (4) records in 0.016s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:774:INFO ] HandlerMap Created: (7) view handlers and (11) request/event handlers in 0.0s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:774:INFO ] HandlerMap Created: (7) view handlers and (11) request/event handlers in 0.0s 2009-01-08 09:48:28,328 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,343 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:379:INFO ] RequestMap Created: (14) records in 0.015s 2009-01-08 09:48:28,343 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:379:INFO ] RequestMap Created: (21) records in 0.015s 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:467:INFO ] ViewMap Created: (12) records in 0.016s 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ ConfigXMLReader.java:467:INFO ] ViewMap Created: (15) records in 0.016s 2009-01-08 09:48:28,359 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/common/webcommon/WEB-INF/common-controller.xml 2009-01-08 09:48:28,375 (http-0.0.0.0-18443-1) [ RequestHandler.java:256:INFO ] [Processing Request]: quickInitDataWarehouse sessionId=CEC67F4842E2E5E7930C9192E22506B6.jvm1 2009-01-08 09:48:28,437 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: file:/D:/workspace/ofbizRun/framework/bi/script/org/ofbiz/bi/DimensionServices.xml 2009-01-08 09:48:28,468 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10740, maxSeqId=10750, bankSize=10 2009-01-08 09:48:28,546 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10750, maxSeqId=10760, bankSize=10 2009-01-08 09:48:28,578 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10760, maxSeqId=10770, bankSize=10 2009-01-08 09:48:28,609 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10770, maxSeqId=10780, bankSize=10 2009-01-08 09:48:28,671 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10780, maxSeqId=10790, bankSize=10 2009-01-08 09:48:28,703 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10790, maxSeqId=10800, bankSize=10 2009-01-08 09:48:28,750 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10800, maxSeqId=10810, bankSize=10 2009-01-08 09:48:28,796 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10810, maxSeqId=10820, bankSize=10 2009-01-08 09:48:28,828 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10820, maxSeqId=10830, bankSize=10 2009-01-08 09:48:28,859 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10830, maxSeqId=10840, bankSize=10 2009-01-08 09:48:28,890 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10840, maxSeqId=10850, bankSize=10 2009-01-08 09:48:28,906 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10850, maxSeqId=10860, bankSize=10 2009-01-08 09:48:28,921 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10860, maxSeqId=10870, bankSize=10 2009-01-08 09:48:28,953 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10870, maxSeqId=10880, bankSize=10 2009-01-08 09:48:28,984 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10880, maxSeqId=10890, bankSize=10 2009-01-08 09:48:29,000 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10890, maxSeqId=10900, bankSize=10 2009-01-08 09:48:29,031 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10900, maxSeqId=10910, bankSize=10 2009-01-08 09:48:29,078 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10910, maxSeqId=10920, bankSize=10 2009-01-08 09:48:29,109 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10920, maxSeqId=10930, bankSize=10 2009-01-08 09:48:29,125 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10930, maxSeqId=10940, bankSize=10 2009-01-08 09:48:29,156 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10940, maxSeqId=10950, bankSize=10 2009-01-08 09:48:29,171 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10950, maxSeqId=10960, bankSize=10 2009-01-08 09:48:29,203 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10960, maxSeqId=10970, bankSize=10 2009-01-08 09:48:29,218 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10970, maxSeqId=10980, bankSize=10 2009-01-08 09:48:29,234 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10980, maxSeqId=10990, bankSize=10 2009-01-08 09:48:29,265 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=10990, maxSeqId=11000, bankSize=10 2009-01-08 09:48:29,281 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11000, maxSeqId=11010, bankSize=10 2009-01-08 09:48:29,312 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11010, maxSeqId=11020, bankSize=10 2009-01-08 09:48:29,328 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11020, maxSeqId=11030, bankSize=10 2009-01-08 09:48:29,343 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11030, maxSeqId=11040, bankSize=10 2009-01-08 09:48:29,359 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11040, maxSeqId=11050, bankSize=10 2009-01-08 09:48:29,406 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11050, maxSeqId=11060, bankSize=10 2009-01-08 09:48:29,421 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11060, maxSeqId=11070, bankSize=10 2009-01-08 09:48:29,437 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11070, maxSeqId=11080, bankSize=10 2009-01-08 09:48:29,453 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11080, maxSeqId=11090, bankSize=10 2009-01-08 09:48:29,468 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11090, maxSeqId=11100, bankSize=10 2009-01-08 09:48:29,484 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11100, maxSeqId=11110, bankSize=10 2009-01-08 09:48:29,515 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11110, maxSeqId=11120, bankSize=10 2009-01-08 09:48:29,531 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11120, maxSeqId=11130, bankSize=10 2009-01-08 09:48:29,546 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11130, maxSeqId=11140, bankSize=10 2009-01-08 09:48:29,578 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11140, maxSeqId=11150, bankSize=10 2009-01-08 09:48:29,593 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11150, maxSeqId=11160, bankSize=10 2009-01-08 09:48:29,609 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11160, maxSeqId=11170, bankSize=10 2009-01-08 09:48:29,625 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11170, maxSeqId=11180, bankSize=10 2009-01-08 09:48:29,656 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11180, maxSeqId=11190, bankSize=10 2009-01-08 09:48:29,671 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11190, maxSeqId=11200, bankSize=10 2009-01-08 09:48:29,687 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11200, maxSeqId=11210, bankSize=10 2009-01-08 09:48:29,703 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11210, maxSeqId=11220, bankSize=10 2009-01-08 09:48:29,734 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11220, maxSeqId=11230, bankSize=10 2009-01-08 09:48:29,765 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11230, maxSeqId=11240, bankSize=10 2009-01-08 09:48:29,796 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11240, maxSeqId=11250, bankSize=10 2009-01-08 09:48:29,812 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11250, maxSeqId=11260, bankSize=10 2009-01-08 09:48:29,812 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11260, maxSeqId=11270, bankSize=10 2009-01-08 09:48:29,828 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11270, maxSeqId=11280, bankSize=10 2009-01-08 09:48:29,843 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11280, maxSeqId=11290, bankSize=10 2009-01-08 09:48:29,875 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11290, maxSeqId=11300, bankSize=10 2009-01-08 09:48:29,890 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11300, maxSeqId=11310, bankSize=10 2009-01-08 09:48:29,906 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11310, maxSeqId=11320, bankSize=10 2009-01-08 09:48:29,937 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11320, maxSeqId=11330, bankSize=10 2009-01-08 09:48:29,953 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11330, maxSeqId=11340, bankSize=10 2009-01-08 09:48:29,968 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11340, maxSeqId=11350, bankSize=10 2009-01-08 09:48:29,984 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11350, maxSeqId=11360, bankSize=10 2009-01-08 09:48:30,000 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11360, maxSeqId=11370, bankSize=10 2009-01-08 09:48:30,015 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11370, maxSeqId=11380, bankSize=10 2009-01-08 09:48:30,031 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11380, maxSeqId=11390, bankSize=10 2009-01-08 09:48:30,062 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11390, maxSeqId=11400, bankSize=10 2009-01-08 09:48:30,078 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11400, maxSeqId=11410, bankSize=10 2009-01-08 09:48:30,093 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11410, maxSeqId=11420, bankSize=10 2009-01-08 09:48:30,125 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11420, maxSeqId=11430, bankSize=10 2009-01-08 09:48:30,140 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11430, maxSeqId=11440, bankSize=10 2009-01-08 09:48:30,156 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11440, maxSeqId=11450, bankSize=10 2009-01-08 09:48:30,187 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11450, maxSeqId=11460, bankSize=10 2009-01-08 09:48:30,218 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11460, maxSeqId=11470, bankSize=10 2009-01-08 09:48:30,234 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [DateDimension]; curSeqId=11470, maxSeqId=11480, bankSize=10 2009-01-08 09:48:30,234 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadDateDimension] finished in [1797] milliseconds 2009-01-08 09:48:30,250 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: XML Properties file 2009-01-08 09:48:30,250 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,250 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 3 properties for: DefaultMessages (en) 2009-01-08 09:48:30,265 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,265 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 3 properties for: DefaultMessages (fr) 2009-01-08 09:48:30,265 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle DefaultMessages (fr) created in 31.0 mS 2009-01-08 09:48:30,281 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/script/org/ofbiz/common/olap/CommonDimensionServices.xml 2009-01-08 09:48:30,343 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:30,406 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:30,406 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 1294 properties for: CommonEntityLabels (en) 2009-01-08 09:48:30,453 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.032s: XML Properties file 2009-01-08 09:48:30,468 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 698 properties for: CommonEntityLabels (fr) 2009-01-08 09:48:30,484 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle CommonEntityLabels (fr) created in 172.0 mS 2009-01-08 09:48:30,484 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10190, maxSeqId=10200, bankSize=10 2009-01-08 09:48:30,531 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10200, maxSeqId=10210, bankSize=10 2009-01-08 09:48:30,562 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10210, maxSeqId=10220, bankSize=10 2009-01-08 09:48:30,562 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10220, maxSeqId=10230, bankSize=10 2009-01-08 09:48:30,578 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10230, maxSeqId=10240, bankSize=10 2009-01-08 09:48:30,593 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10240, maxSeqId=10250, bankSize=10 2009-01-08 09:48:30,593 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10250, maxSeqId=10260, bankSize=10 2009-01-08 09:48:30,609 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10260, maxSeqId=10270, bankSize=10 2009-01-08 09:48:30,625 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10270, maxSeqId=10280, bankSize=10 2009-01-08 09:48:30,625 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10280, maxSeqId=10290, bankSize=10 2009-01-08 09:48:30,640 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10290, maxSeqId=10300, bankSize=10 2009-01-08 09:48:30,656 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10300, maxSeqId=10310, bankSize=10 2009-01-08 09:48:30,671 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10310, maxSeqId=10320, bankSize=10 2009-01-08 09:48:30,687 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10320, maxSeqId=10330, bankSize=10 2009-01-08 09:48:30,703 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10330, maxSeqId=10340, bankSize=10 2009-01-08 09:48:30,718 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10340, maxSeqId=10350, bankSize=10 2009-01-08 09:48:30,718 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10350, maxSeqId=10360, bankSize=10 2009-01-08 09:48:30,734 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10360, maxSeqId=10370, bankSize=10 2009-01-08 09:48:30,750 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [CurrencyDimension]; curSeqId=10370, maxSeqId=10380, bankSize=10 2009-01-08 09:48:30,750 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadCurrencyDimension] finished in [485] milliseconds 2009-01-08 09:48:30,750 (http-0.0.0.0-18443-1) [ ModelService.java:450:INFO ] Set default value [TYPE1] for parameter [updateMode] 2009-01-08 09:48:30,781 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: file:/D:/workspace/ofbizRun/applications/product/script/org/ofbiz/product/olap/ProductDimensionServices. 2009-01-08 09:48:30,812 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,828 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,828 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 226 properties for: ProductEntityLabels (en) 2009-01-08 09:48:30,843 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:30,843 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 226 properties for: ProductEntityLabels (fr) 2009-01-08 09:48:30,859 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle ProductEntityLabels (fr) created in 63.0 mS 2009-01-08 09:48:30,859 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/prepareProductDimensionData] finished in [63] milliseconds 2009-01-08 09:48:30,859 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10020, maxSeqId=10030, bankSize=10 2009-01-08 09:48:30,875 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadProductInProductDimension] finished in [79] milliseconds 2009-01-08 09:48:30,906 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10030, maxSeqId=10040, bankSize=10 2009-01-08 09:48:30,968 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10040, maxSeqId=10050, bankSize=10 2009-01-08 09:48:31,031 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10050, maxSeqId=10060, bankSize=10 2009-01-08 09:48:31,062 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10060, maxSeqId=10070, bankSize=10 2009-01-08 09:48:31,109 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10070, maxSeqId=10080, bankSize=10 2009-01-08 09:48:31,140 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10080, maxSeqId=10090, bankSize=10 2009-01-08 09:48:31,187 (http-0.0.0.0-18443-1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [ProductDimension]; curSeqId=10090, maxSeqId=10100, bankSize=10 2009-01-08 09:48:31,203 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/loadAllProductsInProductDimension] finished in [453] milliseconds 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ ServiceDispatcher.java:578:INFO ] Sync service [bi/quickInitDataWarehouse] finished in [2812] milliseconds 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ RequestHandler.java:440:INFO ] [RequestHandler.doRequest]: Response is a view. sessionId=CEC67F4842E2E5E7930C9192E22506B6.jvm1 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ RequestHandler.java:591:INFO ] servletName=control, view=main sessionId=CEC67F4842E2E5E7930C9192E22506B6.jvm1 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ UtilJ2eeCompat.java:69 :INFO ] serverInfo: apache tomcat/6.0.16 2009-01-08 09:48:31,218 (http-0.0.0.0-18443-1) [ UtilJ2eeCompat.java:78 :INFO ] Apache Tomcat detected, using response.getWriter to write text out instead of response.getOutputStream 2009-01-08 09:48:31,265 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/bi/widget/BiScreens.xml 2009-01-08 09:48:31,296 (http-0.0.0.0-18443-1) [ ScreenFactory.java:129:INFO ] Got 5 screens in 0.031s from: file:/D:/workspace/ofbizRun/framework/bi/widget/BiScreens.xml 2009-01-08 09:48:31,296 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 47 properties for: BiUiLabels (en) 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: XML Properties file 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 47 properties for: BiUiLabels (fr) 2009-01-08 09:48:31,312 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle BiUiLabels (fr) created in 16.0 mS 2009-01-08 09:48:31,359 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:31,406 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:31,406 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 640 properties for: CommonUiLabels (en) 2009-01-08 09:48:31,437 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: XML Properties file 2009-01-08 09:48:31,453 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 621 properties for: CommonUiLabels (fr) 2009-01-08 09:48:31,453 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle CommonUiLabels (fr) created in 141.0 mS 2009-01-08 09:48:31,468 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.015s: file:/D:/workspace/ofbizRun/framework/common/widget/CommonScreens.xml 2009-01-08 09:48:31,484 (http-0.0.0.0-18443-1) [ ScreenFactory.java:129:INFO ] Got 21 screens in 0.031s from: file:/D:/workspace/ofbizRun/framework/common/widget/CommonScreens.xml 2009-01-08 09:48:31,531 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.031s: file:/D:/workspace/ofbizRun/framework/common/script/org/ofbiz/common/CommonServices.xml 2009-01-08 09:48:31,531 (http-0.0.0.0-18443-1) [ UtilProperties.java:550:INFO ] Loaded 20 properties for: general () 2009-01-08 09:48:31,562 (http-0.0.0.0-18443-1) [ UtilProperties.java:868:INFO ] ResourceBundle general (fr) created in 31.0 mS 2009-01-08 09:48:31,984 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.0s: file:/D:/workspace/ofbizRun/framework/bi/widget/BiMenus.xml 2009-01-08 09:48:32,000 (http-0.0.0.0-18443-1) [ UtilXml.java:241:INFO ] XML Read 0.016s: file:/D:/workspace/ofbizRun/framework/common/widget/CommonMenus.xml 2009-01-08 09:48:32,031 (http-0.0.0.0-18443-1) [ ModelScreenWidget.java:519:INFO ] In the include-screen tag the screen name was empty, ignoring include; in screen [GlobalDecorator] 2009-01-08 09:48:32,093 (http-0.0.0.0-18443-1) [ ControlServlet.java:302:INFO ] [[[quickInitDataWarehouse] Done rendering page, Servlet Finished- total:3.797,since last([quickInitDataWar...):3.797]] {code} But I get them on Demo server. {code} 2009-01-08 02:54:21,122 (TP-Processor28) [ EntityExpr.java:267:WARN ] ---- exception report ---------------------------------------------------------- =-=-=-=-=-=-=-=-= Database type warning in EntityExpr =-=-=-=-=-=-=-=-= In entity field [DateDimension.dateValue] set the value passed in [java.util.Date] is not compatible with the Java type of the field [java.sql.Date] Exception: java.lang.Exception Message: Location of database type warning ---- stack trace --------------------------------------------------------------- java.lang.Exception: Location of database type warning org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:267) org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:167) org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:67) org.ofbiz.entity.condition.EntityConditionListBase.makeWhereString(EntityConditionListBase.java:89) org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:676) org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140) org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:2273) org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:2314) org.ofbiz.entity.GenericDelegator.findByAnd(GenericDelegator.java:1925) org.ofbiz.common.olap.CommonDimensionServices.loadDateDimension(CommonDimensionServices.java:89) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:585) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:96) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:163) org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:244) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:921) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:749) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:149) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:131) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149) org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:332) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:461) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:293) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:204) javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568) org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:42) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) java.lang.Thread.run(Thread.java:595) --------------------------------------------------------------------------------{code} I don't know what to think since both are using Derby. Anyway I will apply your patch, thanks > change date format in BI component when calling loadDateDimension > ----------------------------------------------------------------- > > Key: OFBIZ-2113 > URL: https://issues.apache.org/jira/browse/OFBIZ-2113 > Project: OFBiz > Issue Type: Improvement > Affects Versions: SVN trunk > Reporter: Erwan de FERRIERES > Priority: Minor > Fix For: SVN trunk > > Attachments: patch.diff > > > We found an error when calling loadDateDimension on the date format, there was an incoherence when trying to initialise the data. There was a problem with the Date format, which has been transformed as java.sql.Date. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-2113. ---------------------------------- Resolution: Fixed Assignee: Jacques Le Roux I should also say that locally I did an "ant clean-data". Anyway your patch is harmful and commited in trunk revision: 732653 Thanks > change date format in BI component when calling loadDateDimension > ----------------------------------------------------------------- > > Key: OFBIZ-2113 > URL: https://issues.apache.org/jira/browse/OFBIZ-2113 > Project: OFBiz > Issue Type: Improvement > Affects Versions: SVN trunk > Reporter: Erwan de FERRIERES > Assignee: Jacques Le Roux > Priority: Minor > Fix For: SVN trunk > > Attachments: patch.diff > > > We found an error when calling loadDateDimension on the date format, there was an incoherence when trying to initialise the data. There was a problem with the Date format, which has been transformed as java.sql.Date. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
Free forum by Nabble | Edit this page |