Hi, Lessons in how to totally screw up a perfectly running ofbiz application... It appears I've incorrectly gone about the task as listed below :-} . Any help would be greatly appreciated. I had the lastest trunk version of ofbiz running on my dev server (RHEL4, PostgreSQL8.2.4). I believe it was 585993. I wanted to switch it out mirror the production server which meant checking out the release4.0 version. I'm rather new to svn and did try to just svn co the release version but I received not an error but a comment indicating I could not download it. I apoligize as I did not save the message. At any rate, at that point, here are the steps I took:
- killed the ofbiz and java processes - deleted the ofbiz directory - svn co'd the Release 4.0 version 589691 - change datasource to localpostgres - edit localpostgres w/ correct username and password - copied correct jdbc driver to .../jdbc directory - started ofbiz: ./startofbiz.sh& Upon browsing to https://127.0.0.1:8443/webtools/control/main I'm getting an "Exception Error". Please see message below. In addition, the rolling console.log in my terminal is indicating errors and I've included those messages as well type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception java.lang.IllegalArgumentException: Could not get next sequenced ID for sequence name: ServerHitBin org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2442) org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2428) org.ofbiz.webapp.stats.ServerHitBin.advanceBin(ServerHitBin.java:552) org.ofbiz.webapp.stats.ServerHitBin.addHit(ServerHitBin.java:506) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:206) org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85) org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs. org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (Unable to esablish a connection with the database. Connection was null!) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. Connection was null! org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:267) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:325 ) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288 ) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD AO.java:189) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:946 ) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:921 ) org.ofbiz.service.job.JobManager.poll(JobManager.java:148) org.ofbiz.service.job.JobPoller.run(JobPoller.java:85) java.lang.Thread.run(Thread.java:619) Case Torres [EMAIL PROTECTED]
