Dear all, Attached you'll find the error log generated when I restart the ofbiz engine.
Can you help me? Regards, Pierre 2009/10/9 Pierre Smits <[email protected]> > 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 >>>> >>>> >>> >> >
