It seems that it has something to do with the entity group org.ofbiz.olap. After seeing that reference in my log files I get: 2009-10-09 15:04:22,550 (main) [ DatabaseUtil.java:368:WARN ] Table named [public.ACCOMMODATION_CLASS] exists in the database but has no corresponding entity 2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named [public.ACCOMMODATION_MAP] exists in the database but has no corresponding entity 2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named [public.ACCOMMODATION_MAP_TYPE] exists in the database but has no corresponding entity 2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named [public.ACCOMMODATION_SPOT] exists in the database but has no corresponding entity 2009-10-09 15:04:22,551 (main) [ DatabaseUtil.java:368:WARN ] Table named [public.ACCTG_TRANS] exists in the database but has no corresponding entity
When the startup sequence has completed it's run, and I try to login via the browser I get: 2009-10-09 15:05:06,606 (http-0.0.0.0-8443-1) [ LoginWorker.java:228:INFO ] User does not have permission or is flagged as logged out 2009-10-09 15:05:06,607 (http-0.0.0.0-8443-1) [ TransactionUtil.java:406:WARN ] No transaction in place, so not suspending. 2009-10-09 15:05:06,609 (http-0.0.0.0-8443-1) [ LoginWorker.java:174:ERROR] Could not find UserLogin record for setLoggedOut with userLoginId [s0001] 2009-10-09 15:05:06,616 (http-0.0.0.0-8443-1) [ GenericDelegator.java:1311:ERROR] ---- exception report ---------------------------------------------------------- Failure in store operation for entity [Visit]: org.ofbiz.entity.GenericEntityNotFoundException: Tried to update an entity that does not exist.. Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityNotFoundException Message: Tried to update an entity that does not exist. ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericEntityNotFoundException: Tried to update an entity that does not exist. org.ofbiz.entity.datasource.GenericDAO.singleUpdate(GenericDAO.java:279) org.ofbiz.entity.datasource.GenericDAO.customUpdate(GenericDAO.java:211) org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:205) org.ofbiz.entity.datasource.GenericHelperDAO.store(GenericHelperDAO.java:172) org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1296) org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1259) org.ofbiz.entity.GenericValue.store(GenericValue.java:129) org.ofbiz.webapp.control.ControlEventListener.sessionDestroyed(ControlEventListener.java:78) org.apache.catalina.session.StandardSession.expire(StandardSession.java:702) org.apache.catalina.session.StandardSession.expire(StandardSession.java:660) org.apache.catalina.session.StandardSession.invalidate(StandardSession.java:1111) org.apache.catalina.session.StandardSessionFacade.invalidate(StandardSessionFacade.java:150) org.ofbiz.webapp.control.LoginWorker.doBasicLogout(LoginWorker.java:505) org.ofbiz.webapp.control.LoginWorker.checkLogin(LoginWorker.java:229) 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:597) org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:92) org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:78) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:611) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:341) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:221) 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:265) 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.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) java.lang.Thread.run(Thread.java:619) Can you help? Thanks, Pierre 2009/10/9 Pierre Smits <[email protected]> > Hi Jacques, > > Thanks for the prompt reply. > > I did change the path for the db engine to the ip addres of the postgresql > server prior to starting up ofbiz. > > Regards, > > Pierre > > > 2009/10/9 Jacques Le Roux <[email protected]> > > Did you set the path to your DB machine in entityengine.xml ? >> ie change jdbc-uri="jdbc:postgresql://127.0.0.1/ofbiz" accordingly >> >> Jacques >> >> From: "Pierre Smits" <[email protected]> >> >> Hi all, >>> >>> I trying to setup ofbiz on server a (an ubuntu applicance under esxi) >>> with >>> the database (postgresql on another ubuntu appliance under esxi). But >>> that >>> doesn't seem to work. I see tables and indexes created on postgresql, but >>> when I access ofbiz in the browser it returns error messages. >>> >>> Does anybody have the same experience and how did it get resolved? >>> >>> Regards, >>> >>> Pierre >>> >>> >> >
