Hi Jacques,
the datawarehouse entities are stored in a separate database; have a
look at the settings for derby, I think that you have to replicate them
for Postgres... there are now two entity-groups:
org.ofbiz
org.ofbiz.olap
My first guess is that the second one is not associated to a valid
datasource.
if it doesn't work let me know, and I will help to fix.!
Jacopo
Jacques Le Roux wrote:
Hi Jacopo,
Using rev. 586670 and a new fresh postgres DB I got this message on ant
run-install
[java] 2007-10-20 14:07:59,218 (main) [ EntitySaxReader.java:217:INFO ]
Beginning import from URL:
file:/D:/workspace/ofbizRun/specialpurpose/bi/data/DimensionTypeData.xml
[java] 2007-10-20 14:07:59,218 (main) [ EntitySaxReader.java:255:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
[java] 2007-10-20 14:07:59,234 (main) [ EntitySaxReader.java:556:WARN ]
[java] ---- runtime exception report
--------------------------------------------------
[java] Could not set field CurrencyDimension.dimensionId to the value _NF_
[java] Exception: java.lang.IllegalArgumentException
[java] Message: Type id-ne not found
[java] ---- stack trace
---------------------------------------------------------------
[java] java.lang.IllegalArgumentException: Type id-ne not found
[java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:457)
[java]
org.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:550)
[java] javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source)
[java] javolution.xml.sax.XMLReaderImpl.parse(Unknown Source)
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:258)
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
[java]
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
[java]
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:267)
[java]
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:79)
[java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261)
[java] org.ofbiz.base.start.Start.startServer(Start.java:310)
[java] org.ofbiz.base.start.Start.start(Start.java:314)
[java] org.ofbiz.base.start.Start.main(Start.java:397)
[java]
--------------------------------------------------------------------------------
[java]
[java] 2007-10-20 14:07:59,234 (main) [ EntitySaxReader.java:556:WARN ]
[java] ---- runtime exception report
--------------------------------------------------
[java] Could not set field CurrencyDimension.description to the value
Currency Not Found.
[java] Exception: java.lang.IllegalArgumentException
[java] Message: Type description not found
[java] ---- stack trace
---------------------------------------------------------------
[java] java.lang.IllegalArgumentException: Type description not found
[java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:457)
[java]
org.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:550)
[java] javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source)
[java] javolution.xml.sax.XMLReaderImpl.parse(Unknown Source)
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:258)
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
[java]
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
[java]
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:267)
[java]
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:79)
[java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261)
[java] org.ofbiz.base.start.Start.startServer(Start.java:310)
[java] org.ofbiz.base.start.Start.start(Start.java:314)
[java] org.ofbiz.base.start.Start.main(Start.java:397)
[java]
--------------------------------------------------------------------------------
[java]
[java] 2007-10-20 14:07:59,250 (main) [ SequenceUtil.java:236:WARN ]
[SequenceUtil.SequenceBank.fillBank] first select
failed: will try to add new row, result set was empty for sequence [CurrencyDi
mension]
[java] Used SQL: SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE
SEQ_NAME='CurrencyDimension'
[java] Thread Name is: main:Thread[main,5,main]
[java] 2007-10-20 14:07:59,265 (main) [ SequenceUtil.java:341:INFO ]
Got bank of sequenced IDs for [CurrencyDimension];
curSeqId=10000, maxSeqId=10010, bankSize=10
[java] 2007-10-20 14:07:59,265 (main) [ EntitySaxReader.java:267:ERROR]
[java] ---- runtime exception report
--------------------------------------------------
[java] An error occurred saving the data, rolling back transaction (true)
[java] Exception: java.lang.IllegalArgumentException
[java] Message: Type id-ne not found
[java] ---- stack trace
---------------------------------------------------------------
[java] java.lang.IllegalArgumentException: Type id-ne not found
[java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:457)
[java]
org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:396)
[java] javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source)
[java] javolution.xml.sax.XMLReaderImpl.parse(Unknown Source)
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:258)
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
[java]
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
[java]
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:267)
[java]
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:79)
[java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261)
[java] org.ofbiz.base.start.Start.startServer(Start.java:310)
[java] org.ofbiz.base.start.Start.start(Start.java:314)
[java] org.ofbiz.base.start.Start.main(Start.java:397)
[java]
--------------------------------------------------------------------------------
[java]
[java] 2007-10-20 14:07:59,265 (main) [ TransactionUtil.java:262:ERROR]
[java] ---- exception report
----------------------------------------------------------
[java] [TransactionUtil.rollback]
[java] Exception: java.lang.Exception
[java] Message: Stack Trace
[java] ---- stack trace
---------------------------------------------------------------
[java] java.lang.Exception: Stack Trace
[java]
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:261)
[java]
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:243)
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:268)
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
[java]
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
[java]
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:267)
[java]
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:79)
[java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261)
[java] org.ofbiz.base.start.Start.startServer(Start.java:310)
[java] org.ofbiz.base.start.Start.start(Start.java:314)
[java] org.ofbiz.base.start.Start.main(Start.java:397)
[java]
--------------------------------------------------------------------------------
[java]
[java] 2007-10-20 14:07:59,265 (main) [ TransactionUtil.java:272:INFO ]
[TransactionUtil.rollback] transaction rolled back
[java] 2007-10-20 14:07:59,265 (main) [ EntityDataLoader.java:215:ERROR]
[java] ---- exception report
----------------------------------------------------------
[java] [install.loadData]: Error loading XML Resource
"file:/D:/workspace/ofbizRun/specialpurpose/bi/data/DimensionTypeData.xml";
Error was: A transaction error occurred reading data
[java] Exception: org.xml.sax.SAXException
[java] Message: A transaction error occurred reading data
[java] ---- stack trace
---------------------------------------------------------------
[java] java.lang.IllegalArgumentException: Type id-ne not found
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:269)
[java]
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
[java]
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
[java]
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:267)
[java]
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:79)
[java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261)
[java] org.ofbiz.base.start.Start.startServer(Start.java:310)
[java] org.ofbiz.base.start.Start.start(Start.java:314)
[java] org.ofbiz.base.start.Start.main(Start.java:397)
[java]
--------------------------------------------------------------------------------
[java]
[java] 2007-10-20 14:07:59,265 (main) [ EntitySaxReader.java:217:INFO ]
Beginning import from URL:
file:/D:/workspace/ofbizRun/applications/securityext/data/UserDemoData.xml
Then using Quick Init DataWarehouse I got :
2007-10-20 14:11:20,296 (http-0.0.0.0-28443-Processor4) [
GenericDelegator.java:1959:ERROR]
---- exception report ----------------------------------------------------------
Failure in findByCondition operation for entity [DateDimension]:
org.ofbiz.entity.GenericEntityException: Helper name not found for
entity DateDimension. Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Helper name not found for entity DateDimension
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Helper name not found for entity
DateDimension
org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.java:389)
org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:2050)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1951)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1930)
org.ofbiz.entity.GenericDelegator.findByAnd(GenericDelegator.java:1795)
org.ofbiz.entity.GenericDelegator.findByAnd(GenericDelegator.java:1765)
org.ofbiz.bi.util.DimensionServices.loadDateDimension(DimensionServices.java:151)
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:95)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:371)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:206)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:154)
org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:239)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931)
org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568)
org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105)
org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87)
org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76)
org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:371)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:206)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136)
org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:327)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:454)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:281)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:193)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:542)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
java.lang.Thread.run(Thread.java:595)
--------------------------------------------------------------------------------
I did not look further for now..
Jacques
Hi all,
in rev. 584727 I've committed my work on a proof of concept for an
Integrated OFBiz framework for business intelligence.
This is essentially a new specialpurpose component (but it will probably
disappear as soon as all its parts will be integrated in the main OFBiz
applications) with a simple web application.
For more details, visit the new tab "Business Intelligence" and read the
component introduction in the main page (there are also instructions on
how to start.... everything is very simple).
And of course, let me know your opinions/questions/comments etc...
*IMPORTANT*: the datawarehouse report will drill up/down correctly only
if the patch attached to this mail is applied; I will commit it (or an
equivalent variant) soon but I have to wait for feedback on this in the
dev list before... by the way I'll let you know as soon as it is in.
Jacopo
--------------------------------------------------------------------------------
Index: framework/entity/src/org/ofbiz/entity/datasource/GenericDAO.java
===================================================================
--- framework/entity/src/org/ofbiz/entity/datasource/GenericDAO.java (revision
584577)
+++ framework/entity/src/org/ofbiz/entity/datasource/GenericDAO.java (working
copy)
@@ -711,7 +711,7 @@
// GROUP BY clause for view-entity
if (modelEntity instanceof ModelViewEntity) {
ModelViewEntity modelViewEntity = (ModelViewEntity) modelEntity;
- String groupByString =
modelViewEntity.colNameString(modelViewEntity.getGroupBysCopy(), ", ", "",
false);
+ String groupByString =
modelViewEntity.colNameString(modelViewEntity.getGroupBysCopy(selectFields), ", ",
"", false);
if (UtilValidate.isNotEmpty(groupByString)) {
sqlBuffer.append(" GROUP BY ");
