Click "Inventory Items" menu and click "Find" (https://localhost:18443/facility/control/EditFacilityInventoryItems) you get
2009-08-30 09:43:25,593 (http-0.0.0.0-18443-5) [ ControlServlet.java:130:INFO ] [[[EditFacilityInventoryItems] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2009-08-30 09:43:25,593 (http-0.0.0.0-18443-5) [ RequestHandler.java:716:INFO ] Rendering View [EditFacilityInventoryItems], sessionId=6D587C24284D4B23F7269FC26AFB92B0.jvm1 2009-08-30 09:43:25,687 (http-0.0.0.0-18443-5) [ ServiceEcaRule.java:134:INFO ] For Service ECA [facilityGenericPermission] on [return] got false for condition: [hasPermission][equals][false][true][Boolea n] 2009-08-30 09:43:25,718 (http-0.0.0.0-18443-5) [ UtilXml.java:1016:ERROR] XmlFileLoader: File file:/D:/workspace/ofbizRun/applications/product/webapp/facility/facility/FacilityForms.xml process err or. Line: 608. Error message: cvc-complex-type.2.3: Element 'form' cannot have character [children], because the type's content type is element-only. 2009-08-30 09:43:25,750 (http-0.0.0.0-18443-5) [ UtilProperties.java:870:INFO ] ResourceBundle conditional (en) created in 0.016s with 14 properties 2009-08-30 09:43:25,781 (http-0.0.0.0-18443-5) [ UtilXml.java:1016:ERROR] XmlFileLoader: File file:/D:/workspace/ofbizRun/applications/product/webapp/facility/facility/FacilityForms.xml process err or. Line: 608. Error message: cvc-complex-type.2.3: Element 'form' cannot have character [children], because the type's content type is element-only. 2009-08-30 09:43:25,875 (http-0.0.0.0-18443-5) [ ServiceDispatcher.java:585:INFO ] Sync service [facility/executeFind] finished in [94] milliseconds 2009-08-30 09:43:25,875 (http-0.0.0.0-18443-5) [ ServiceDispatcher.java:585:INFO ] Sync service [facility/performFind] finished in [94] milliseconds 2009-08-30 09:43:25,906 (http-0.0.0.0-18443-5) [ EntityListIterator.java:143:WARN ] Warning: auto-closed EntityListIterator because of exception: org.postgresql.util.PSQLException: Operation requires a scroll able ResultSet, but this ResultSet is FORWARD_ONLY. 2009-08-30 09:43:25,906 (http-0.0.0.0-18443-5) [ ModelForm.java:1351:ERROR] ---- exception report ---------------------------------------------------------- Error rewinding list form render EntityListIterator: org.ofbiz.entity.GenericEntityException: Error setting the cursor to first (Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY.) Exception: org.ofbiz.entity.GenericEntityException Message: Error setting the cursor to first (Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY.) ---- cause --------------------------------------------------------------------- Exception: org.postgresql.util.PSQLException Message: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. ---- stack trace --------------------------------------------------------------- org.postgresql.util.PSQLException: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkScrollable(AbstractJdbc2ResultSet.java:206) org.postgresql.jdbc2.AbstractJdbc2ResultSet.first(AbstractJdbc2ResultSet.java:291) org.apache.commons.dbcp.DelegatingResultSet.first(DelegatingResultSet.java:326) org.apache.commons.dbcp.DelegatingResultSet.first(DelegatingResultSet.java:326) org.ofbiz.entity.util.EntityListIterator.first(EntityListIterator.java:139) org.ofbiz.widget.form.ModelForm.preparePager(ModelForm.java:1349) org.ofbiz.widget.form.ModelForm.renderListFormString(ModelForm.java:1059) org.ofbiz.widget.form.ModelForm.renderFormString(ModelForm.java:819) org.ofbiz.widget.screen.ModelScreenWidget$Form.renderWidgetString(ModelScreenWidget.java:847) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:710) org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:187) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:742) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:316) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:316) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:248) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:678) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:710) org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:187) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:742) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:248) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:248) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:710) org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:187) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:742) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:316) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:316) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:316) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:248) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:582) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:248) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:582) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:248) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:678) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:248) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:678) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:157) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:248) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:132) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:95) org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:114) org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:808) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:215) 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) -------------------------------------------------------------------------------- 2009-08-30 09:43:25,906 (http-0.0.0.0-18443-5) [ ModelScreen.java:398:ERROR] Error rendering screen [component://common/widget/CommonScreens.xml#FindScreenDecorator]: org.ofbiz.base.util.GeneralRuntime Exception: Error getting the next result (This ResultSet is closed.). Rolling back transaction. Seems to be relate to Scott's recent work. I'm using PostGres 8.4 with postgresql-8.3-603.jdbc3.jar on XPsp3. Note that one time (I don't remember how exactly) I got the right result. Jacques
