OFBiz › OFBiz - User

ViewFacilityInventoryByProduct error

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

4 messages Options

Mark Mantarro

ViewFacilityInventoryByProduct error

Testing SVN 476275 but exists in many older versions.

When I run the Inventory By Product Report for my Facility, with the default
options I only get a list of one product's variants. In older versions I
suspected the code wasn't ready but if I run this same report at
https://demo.opensourcestrategies.com:8446/facility/control/InventoryReports
it works very well and gives a list of all in-stock products.

So, I did a comparison of the logs between the two and besides the
ClientAbortException error message in my log I noticed something else
strange. It's hard to see below, but my log has 2 rows for every message
where the demo log has only 1 row for each message. To me, this could mean
I have duplicate data somewhere, but all my indexes check out.

I'm stumped, I read ViewFacilityInventoryByProduct.bsh but I don't totally
understand what is happening. It appears the
getInventoryAvailableByFacility Service is called about 20 times in the
WebTools Service Log. This tells me that the code is looping more than the
number of lines shown in the resulting report(8 rows in report). The code
looks like there should be a 1:1 relationship between the get and the rows
shown.
Additionally, I do have products with -QOH and -ATP.

I am really at an impasse. Is this data or code or user?

Thanks,
Mark

2006-11-22 17:38:46,537 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct] Servlet
Starting, doing setup- total:0.0,since last(Begin):0.0]]
2006-11-22 17:38:46,537 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct] Servlet
Starting, doing setup- total:0.0,since last(Begin):0.0]]
2006-11-22 17:38:46,538 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct] Setup
done, doing Event(s) and View(s)- total:0.0,since
last([ViewFacilityInve...):0.0]]
2006-11-22 17:38:46,538 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct] Setup
done, doing Event(s) and View(s)- total:0.0,since
last([ViewFacilityInve...):0.0]]
2006-11-22 17:38:46,538 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:197:INFO ] [Processing Request]:
ViewFacilityInventoryByProduct
2006-11-22 17:38:46,538 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:197:INFO ] [Processing Request]:
ViewFacilityInventoryByProduct
2006-11-22 17:38:46,542 (http-0.0.0.0-8443-Processor2) [
RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute] Value
for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
2006-11-22 17:38:46,542 (http-0.0.0.0-8443-Processor2) [
RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute] Value
for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
2006-11-22 17:38:46,542 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response is a
view.
2006-11-22 17:38:46,542 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response is a
view.
2006-11-22 17:38:46,545 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:537:INFO ] servletName=control,
view=ViewFacilityInventoryByProduct
2006-11-22 17:38:46,545 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:537:INFO ] servletName=control,
view=ViewFacilityInventoryByProduct
2006-11-22 17:38:46,594 (http-0.0.0.0-8443-Processor2) [
ModelScreenWidget.java:359:INFO ] In the include-screen tag the screen name
was empty, ignoring include; in screen [GlobalDecorator]
2006-11-22 17:38:46,594 (http-0.0.0.0-8443-Processor2) [
ModelScreenWidget.java:359:INFO ] In the include-screen tag the screen name
was empty, ignoring include; in screen [GlobalDecorator]
2006-11-22 17:38:46,683 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
rendering page, Servlet Finished- total:0.145,since
last([ViewFacilityInve...):0.145]]
2006-11-22 17:38:46,683 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
rendering page, Servlet Finished- total:0.145,since
last([ViewFacilityInve...):0.145]]
2006-11-22 17:38:48,436 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:85 :INFO ] The character encoding of the request is:
[null]. The character encoding we will use for the request and response is:
[UTF-8]
2006-11-22 17:38:48,436 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:85 :INFO ] The character encoding of the request is:
[null]. The character encoding we will use for the request and response is:
[UTF-8]
2006-11-22 17:38:48,438 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct] Servlet
Starting, doing setup- total:0.0,since last(Begin):0.0]]
2006-11-22 17:38:48,438 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct] Servlet
Starting, doing setup- total:0.0,since last(Begin):0.0]]
2006-11-22 17:38:48,438 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct] Setup
done, doing Event(s) and View(s)- total:0.0,since
last([ViewFacilityInve...):0.0]]
2006-11-22 17:38:48,438 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct] Setup
done, doing Event(s) and View(s)- total:0.0,since
last([ViewFacilityInve...):0.0]]
2006-11-22 17:38:48,439 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:197:INFO ] [Processing Request]:
ViewFacilityInventoryByProduct
2006-11-22 17:38:48,439 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:197:INFO ] [Processing Request]:
ViewFacilityInventoryByProduct
2006-11-22 17:38:48,440 (http-0.0.0.0-8443-Processor2) [
RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute] Value
for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
2006-11-22 17:38:48,440 (http-0.0.0.0-8443-Processor2) [
RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute] Value
for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
2006-11-22 17:38:48,440 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response is a
view.
2006-11-22 17:38:48,440 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response is a
view.
2006-11-22 17:38:48,441 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:537:INFO ] servletName=control,
view=ViewFacilityInventoryByProduct
2006-11-22 17:38:48,441 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:537:INFO ] servletName=control,
view=ViewFacilityInventoryByProduct
2006-11-22 17:38:48,479 (http-0.0.0.0-8443-Processor3) [
ControlServlet.java:85 :INFO ] The character encoding of the request is:
[null]. The character encoding we will use for the request and response is:
[UTF-8]
2006-11-22 17:38:48,479 (http-0.0.0.0-8443-Processor3) [
ControlServlet.java:85 :INFO ] The character encoding of the request is:
[null]. The character encoding we will use for the request and response is:
[UTF-8]
2006-11-22 17:38:48,480 (http-0.0.0.0-8443-Processor3) [
ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct] Servlet
Starting, doing setup- total:0.0,since last(Begin):0.0]]
2006-11-22 17:38:48,480 (http-0.0.0.0-8443-Processor3) [
ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct] Servlet
Starting, doing setup- total:0.0,since last(Begin):0.0]]
2006-11-22 17:38:48,480 (http-0.0.0.0-8443-Processor3) [
ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct] Setup
done, doing Event(s) and View(s)- total:0.0,since
last([ViewFacilityInve...):0.0]]
2006-11-22 17:38:48,480 (http-0.0.0.0-8443-Processor3) [
ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct] Setup
done, doing Event(s) and View(s)- total:0.0,since
last([ViewFacilityInve...):0.0]]
2006-11-22 17:38:48,481 (http-0.0.0.0-8443-Processor3) [
RequestHandler.java:197:INFO ] [Processing Request]:
ViewFacilityInventoryByProduct
2006-11-22 17:38:48,481 (http-0.0.0.0-8443-Processor3) [
RequestHandler.java:197:INFO ] [Processing Request]:
ViewFacilityInventoryByProduct
2006-11-22 17:38:48,482 (http-0.0.0.0-8443-Processor3) [
RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute] Value
for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
2006-11-22 17:38:48,482 (http-0.0.0.0-8443-Processor3) [
RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute] Value
for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
2006-11-22 17:38:48,483 (http-0.0.0.0-8443-Processor3) [
RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response is a
view.
2006-11-22 17:38:48,483 (http-0.0.0.0-8443-Processor3) [
RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response is a
view.
2006-11-22 17:38:48,483 (http-0.0.0.0-8443-Processor3) [
RequestHandler.java:537:INFO ] servletName=control,
view=ViewFacilityInventoryByProduct
2006-11-22 17:38:48,483 (http-0.0.0.0-8443-Processor3) [
RequestHandler.java:537:INFO ] servletName=control,
view=ViewFacilityInventoryByProduct
2006-11-22 17:38:48,496 (http-0.0.0.0-8443-Processor2) [
EntityListIterator.java:126:WARN ] DynamicViewEntity] has already been
closed, not closing again.
2006-11-22 17:38:48,496 (http-0.0.0.0-8443-Processor2) [
EntityListIterator.java:126:WARN ] DynamicViewEntity] has already been
closed, not closing again.
2006-11-22 17:38:48,509 (http-0.0.0.0-8443-Processor3) [
EntityListIterator.java:126:WARN ] DynamicViewEntity] has already been
closed, not closing again.
2006-11-22 17:38:48,509 (http-0.0.0.0-8443-Processor3) [
EntityListIterator.java:126:WARN ] DynamicViewEntity] has already been
closed, not closing again.
2006-11-22 17:38:48,532 (http-0.0.0.0-8443-Processor3) [
ModelScreenWidget.java:359:INFO ] In the include-screen tag the screen name
was empty, ignoring include; in screen [GlobalDecorator]
2006-11-22 17:38:48,532 (http-0.0.0.0-8443-Processor3) [
ModelScreenWidget.java:359:INFO ] In the include-screen tag the screen name
was empty, ignoring include; in screen [GlobalDecorator]
2006-11-22 17:38:48,554 (http-0.0.0.0-8443-Processor2) [
ModelScreenWidget.java:359:INFO ] In the include-screen tag the screen name
was empty, ignoring include; in screen [GlobalDecorator]
2006-11-22 17:38:48,554 (http-0.0.0.0-8443-Processor2) [
ModelScreenWidget.java:359:INFO ] In the include-screen tag the screen name
was empty, ignoring include; in screen [GlobalDecorator]
2006-11-22 17:38:48,568 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:181:ERROR]
---- exception report
----------------------------------------------------------
Error in request handler:
Exception: org.apache.catalina.connector.ClientAbortException
Message: null
---- cause
---------------------------------------------------------------------
Exception: javax.net.ssl.SSLException
Message: Connection has been shutdown: javax.net.ssl.SSLException:
java.net.SocketException: Connection reset
---- cause
---------------------------------------------------------------------
Exception: javax.net.ssl.SSLException
Message: java.net.SocketException: Connection reset
---- cause
---------------------------------------------------------------------
Exception: java.net.SocketException
Message: Connection reset
---- stack trace
---------------------------------------------------------------
java.net.SocketException: Connection reset
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
java.net.SocketOutputStream.write(SocketOutputStream.java:136)
com.sun.net.ssl.internal.ssl.OutputRecord.a(DashoA12275)
com.sun.net.ssl.internal.ssl.SSLSocketImpl.a(DashoA12275)
com.sun.net.ssl.internal.ssl.AppOutputStream.write(DashoA12275)
org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputB
uffer.java:746)
org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:433)
org.apache.coyote.http11.InternalOutputBuffer.flush(InternalOutputBuffer.jav
a:304)
org.apache.coyote.http11.Http11Processor.action(Http11Processor.java:991)
org.apache.coyote.Response.action(Response.java:182)
org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:322)
org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:293)
org.apache.catalina.connector.CoyoteWriter.flush(CoyoteWriter.java:94)
freemarker.core.Environment.process(Environment.java:178)
freemarker.template.Template.process(Template.java:231)
org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplateAtLocation(FreeM
arkerWorker.java:173)
org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:74)
org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidge
t.java:102)
org.ofbiz.widget.screen.HtmlWidget.renderWidgetString(HtmlWidget.java:61)
org.ofbiz.widget.screen.ModelScreenWidget$PlatformSpecific.renderWidgetStrin
g(ModelScreenWidget.java:794)
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreen
Widget.java:149)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:242)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(M
odelScreenWidget.java:393)
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreen
Widget.java:149)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:242)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString
(ModelScreenWidget.java:488)
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreen
Widget.java:149)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:242)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString
(ModelScreenWidget.java:488)
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreen
Widget.java:149)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:242)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandl
er.java:75)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:602)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:387)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:74)
javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:245)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126
)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105
)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
java.lang.Thread.run(Thread.java:534)
----------------------------------------------------------------------------
----

2006-11-22 17:38:48,568 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:181:ERROR]
---- exception report
----------------------------------------------------------
Error in request handler:
Exception: org.apache.catalina.connector.ClientAbortException
Message: null
---- cause
---------------------------------------------------------------------
Exception: javax.net.ssl.SSLException
Message: Connection has been shutdown: javax.net.ssl.SSLException:
java.net.SocketException: Connection reset
---- cause
---------------------------------------------------------------------
Exception: javax.net.ssl.SSLException
Message: java.net.SocketException: Connection reset
---- cause
---------------------------------------------------------------------
Exception: java.net.SocketException
Message: Connection reset
---- stack trace
---------------------------------------------------------------
java.net.SocketException: Connection reset
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
java.net.SocketOutputStream.write(SocketOutputStream.java:136)
com.sun.net.ssl.internal.ssl.OutputRecord.a(DashoA12275)
com.sun.net.ssl.internal.ssl.SSLSocketImpl.a(DashoA12275)
com.sun.net.ssl.internal.ssl.AppOutputStream.write(DashoA12275)
org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputB
uffer.java:746)
org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:433)
org.apache.coyote.http11.InternalOutputBuffer.flush(InternalOutputBuffer.jav
a:304)
org.apache.coyote.http11.Http11Processor.action(Http11Processor.java:991)
org.apache.coyote.Response.action(Response.java:182)
org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:322)
org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:293)
org.apache.catalina.connector.CoyoteWriter.flush(CoyoteWriter.java:94)
freemarker.core.Environment.process(Environment.java:178)
freemarker.template.Template.process(Template.java:231)
org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplateAtLocation(FreeM
arkerWorker.java:173)
org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:74)
org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidge
t.java:102)
org.ofbiz.widget.screen.HtmlWidget.renderWidgetString(HtmlWidget.java:61)
org.ofbiz.widget.screen.ModelScreenWidget$PlatformSpecific.renderWidgetStrin
g(ModelScreenWidget.java:794)
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreen
Widget.java:149)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:242)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(M
odelScreenWidget.java:393)
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreen
Widget.java:149)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:242)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString
(ModelScreenWidget.java:488)
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreen
Widget.java:149)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:242)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString
(ModelScreenWidget.java:488)
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreen
Widget.java:149)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:242)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandl
er.java:75)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:602)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:387)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:74)
javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:245)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126
)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105
)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
java.lang.Thread.run(Thread.java:534)
----------------------------------------------------------------------------
----

2006-11-22 17:38:48,569 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:195:ERROR] An error occurred, going to the errorPage:
/error/error.jsp
2006-11-22 17:38:48,569 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:195:ERROR] An error occurred, going to the errorPage:
/error/error.jsp
2006-11-22 17:38:48,569 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:202:ERROR] Including errorPage: /error/error.jsp
2006-11-22 17:38:48,569 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:202:ERROR] Including errorPage: /error/error.jsp
2006-11-22 17:38:48,646 (http-0.0.0.0-8443-Processor3) [
ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
rendering page, Servlet Finished- total:0.165,since
last([ViewFacilityInve...):0.165]]
2006-11-22 17:38:48,646 (http-0.0.0.0-8443-Processor3) [
ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
rendering page, Servlet Finished- total:0.165,since
last([ViewFacilityInve...):0.165]]
2006-11-22 17:38:48,666 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
rendering page, Servlet Finished- total:0.227,since
last([ViewFacilityInve...):0.227]]
2006-11-22 17:38:48,666 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
rendering page, Servlet Finished- total:0.227,since
last([ViewFacilityInve...):0.227]]

David E Jones-2

Re: ViewFacilityInventoryByProduct error

Look like the browser is either timing out or someone hit the stop
button before the page finished loading.

-David

On Nov 22, 2006, at 4:42 PM, Mark Mantarro wrote:

>
> Testing SVN 476275 but exists in many older versions.
>
> When I run the Inventory By Product Report for my Facility, with
> the default
> options I only get a list of one product's variants. In older
> versions I
> suspected the code wasn't ready but if I run this same report at
> https://demo.opensourcestrategies.com:8446/facility/control/
> InventoryReports
> it works very well and gives a list of all in-stock products.
>
> So, I did a comparison of the logs between the two and besides the
> ClientAbortException error message in my log I noticed something else
> strange. It's hard to see below, but my log has 2 rows for every
> message
> where the demo log has only 1 row for each message. To me, this
> could mean
> I have duplicate data somewhere, but all my indexes check out.
>
> I'm stumped, I read ViewFacilityInventoryByProduct.bsh but I don't
> totally
> understand what is happening. It appears the
> getInventoryAvailableByFacility Service is called about 20 times in
> the
> WebTools Service Log. This tells me that the code is looping more
> than the
> number of lines shown in the resulting report(8 rows in report).
> The code
> looks like there should be a 1:1 relationship between the get and
> the rows
> shown.
> Additionally, I do have products with -QOH and -ATP.
>
> I am really at an impasse. Is this data or code or user?
>
> Thanks,
> Mark
>
>
>
> 2006-11-22 17:38:46,537 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct]
> Servlet
> Starting, doing setup- total:0.0,since last(Begin):0.0]]
> 2006-11-22 17:38:46,537 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct]
> Servlet
> Starting, doing setup- total:0.0,since last(Begin):0.0]]
> 2006-11-22 17:38:46,538 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct]
> Setup
> done, doing Event(s) and View(s)- total:0.0,since
> last([ViewFacilityInve...):0.0]]
> 2006-11-22 17:38:46,538 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct]
> Setup
> done, doing Event(s) and View(s)- total:0.0,since
> last([ViewFacilityInve...):0.0]]
> 2006-11-22 17:38:46,538 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:197:INFO ] [Processing Request]:
> ViewFacilityInventoryByProduct
> 2006-11-22 17:38:46,538 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:197:INFO ] [Processing Request]:
> ViewFacilityInventoryByProduct
> 2006-11-22 17:38:46,542 (http-0.0.0.0-8443-Processor2) [
> RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute]
> Value
> for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
> 2006-11-22 17:38:46,542 (http-0.0.0.0-8443-Processor2) [
> RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute]
> Value
> for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
> 2006-11-22 17:38:46,542 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response
> is a
> view.
> 2006-11-22 17:38:46,542 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response
> is a
> view.
> 2006-11-22 17:38:46,545 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:537:INFO ] servletName=control,
> view=ViewFacilityInventoryByProduct
> 2006-11-22 17:38:46,545 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:537:INFO ] servletName=control,
> view=ViewFacilityInventoryByProduct
> 2006-11-22 17:38:46,594 (http-0.0.0.0-8443-Processor2) [
> ModelScreenWidget.java:359:INFO ] In the include-screen tag the
> screen name
> was empty, ignoring include; in screen [GlobalDecorator]
> 2006-11-22 17:38:46,594 (http-0.0.0.0-8443-Processor2) [
> ModelScreenWidget.java:359:INFO ] In the include-screen tag the
> screen name
> was empty, ignoring include; in screen [GlobalDecorator]
> 2006-11-22 17:38:46,683 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
> rendering page, Servlet Finished- total:0.145,since
> last([ViewFacilityInve...):0.145]]
> 2006-11-22 17:38:46,683 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
> rendering page, Servlet Finished- total:0.145,since
> last([ViewFacilityInve...):0.145]]
> 2006-11-22 17:38:48,436 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:85 :INFO ] The character encoding of the
> request is:
> [null]. The character encoding we will use for the request and
> response is:
> [UTF-8]
> 2006-11-22 17:38:48,436 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:85 :INFO ] The character encoding of the
> request is:
> [null]. The character encoding we will use for the request and
> response is:
> [UTF-8]
> 2006-11-22 17:38:48,438 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct]
> Servlet
> Starting, doing setup- total:0.0,since last(Begin):0.0]]
> 2006-11-22 17:38:48,438 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct]
> Servlet
> Starting, doing setup- total:0.0,since last(Begin):0.0]]
> 2006-11-22 17:38:48,438 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct]
> Setup
> done, doing Event(s) and View(s)- total:0.0,since
> last([ViewFacilityInve...):0.0]]
> 2006-11-22 17:38:48,438 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct]
> Setup
> done, doing Event(s) and View(s)- total:0.0,since
> last([ViewFacilityInve...):0.0]]
> 2006-11-22 17:38:48,439 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:197:INFO ] [Processing Request]:
> ViewFacilityInventoryByProduct
> 2006-11-22 17:38:48,439 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:197:INFO ] [Processing Request]:
> ViewFacilityInventoryByProduct
> 2006-11-22 17:38:48,440 (http-0.0.0.0-8443-Processor2) [
> RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute]
> Value
> for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
> 2006-11-22 17:38:48,440 (http-0.0.0.0-8443-Processor2) [
> RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute]
> Value
> for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
> 2006-11-22 17:38:48,440 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response
> is a
> view.
> 2006-11-22 17:38:48,440 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response
> is a
> view.
> 2006-11-22 17:38:48,441 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:537:INFO ] servletName=control,
> view=ViewFacilityInventoryByProduct
> 2006-11-22 17:38:48,441 (http-0.0.0.0-8443-Processor2) [
> RequestHandler.java:537:INFO ] servletName=control,
> view=ViewFacilityInventoryByProduct
> 2006-11-22 17:38:48,479 (http-0.0.0.0-8443-Processor3) [
> ControlServlet.java:85 :INFO ] The character encoding of the
> request is:
> [null]. The character encoding we will use for the request and
> response is:
> [UTF-8]
> 2006-11-22 17:38:48,479 (http-0.0.0.0-8443-Processor3) [
> ControlServlet.java:85 :INFO ] The character encoding of the
> request is:
> [null]. The character encoding we will use for the request and
> response is:
> [UTF-8]
> 2006-11-22 17:38:48,480 (http-0.0.0.0-8443-Processor3) [
> ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct]
> Servlet
> Starting, doing setup- total:0.0,since last(Begin):0.0]]
> 2006-11-22 17:38:48,480 (http-0.0.0.0-8443-Processor3) [
> ControlServlet.java:121:DEBUG] [[[ViewFacilityInventoryByProduct]
> Servlet
> Starting, doing setup- total:0.0,since last(Begin):0.0]]
> 2006-11-22 17:38:48,480 (http-0.0.0.0-8443-Processor3) [
> ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct]
> Setup
> done, doing Event(s) and View(s)- total:0.0,since
> last([ViewFacilityInve...):0.0]]
> 2006-11-22 17:38:48,480 (http-0.0.0.0-8443-Processor3) [
> ControlServlet.java:170:DEBUG] [[[ViewFacilityInventoryByProduct]
> Setup
> done, doing Event(s) and View(s)- total:0.0,since
> last([ViewFacilityInve...):0.0]]
> 2006-11-22 17:38:48,481 (http-0.0.0.0-8443-Processor3) [
> RequestHandler.java:197:INFO ] [Processing Request]:
> ViewFacilityInventoryByProduct
> 2006-11-22 17:38:48,481 (http-0.0.0.0-8443-Processor3) [
> RequestHandler.java:197:INFO ] [Processing Request]:
> ViewFacilityInventoryByProduct
> 2006-11-22 17:38:48,482 (http-0.0.0.0-8443-Processor3) [
> RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute]
> Value
> for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
> 2006-11-22 17:38:48,482 (http-0.0.0.0-8443-Processor3) [
> RequestManager.java:110:INFO ] [RequestManager.getRequestAttribute]
> Value
> for attribute "null" of uri "ViewFacilityInventoryByProduct" not found
> 2006-11-22 17:38:48,483 (http-0.0.0.0-8443-Processor3) [
> RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response
> is a
> view.
> 2006-11-22 17:38:48,483 (http-0.0.0.0-8443-Processor3) [
> RequestHandler.java:385:INFO ] [RequestHandler.doRequest]: Response
> is a
> view.
> 2006-11-22 17:38:48,483 (http-0.0.0.0-8443-Processor3) [
> RequestHandler.java:537:INFO ] servletName=control,
> view=ViewFacilityInventoryByProduct
> 2006-11-22 17:38:48,483 (http-0.0.0.0-8443-Processor3) [
> RequestHandler.java:537:INFO ] servletName=control,
> view=ViewFacilityInventoryByProduct
> 2006-11-22 17:38:48,496 (http-0.0.0.0-8443-Processor2) [
> EntityListIterator.java:126:WARN ] DynamicViewEntity] has already been
> closed, not closing again.
> 2006-11-22 17:38:48,496 (http-0.0.0.0-8443-Processor2) [
> EntityListIterator.java:126:WARN ] DynamicViewEntity] has already been
> closed, not closing again.
> 2006-11-22 17:38:48,509 (http-0.0.0.0-8443-Processor3) [
> EntityListIterator.java:126:WARN ] DynamicViewEntity] has already been
> closed, not closing again.
> 2006-11-22 17:38:48,509 (http-0.0.0.0-8443-Processor3) [
> EntityListIterator.java:126:WARN ] DynamicViewEntity] has already been
> closed, not closing again.
> 2006-11-22 17:38:48,532 (http-0.0.0.0-8443-Processor3) [
> ModelScreenWidget.java:359:INFO ] In the include-screen tag the
> screen name
> was empty, ignoring include; in screen [GlobalDecorator]
> 2006-11-22 17:38:48,532 (http-0.0.0.0-8443-Processor3) [
> ModelScreenWidget.java:359:INFO ] In the include-screen tag the
> screen name
> was empty, ignoring include; in screen [GlobalDecorator]
> 2006-11-22 17:38:48,554 (http-0.0.0.0-8443-Processor2) [
> ModelScreenWidget.java:359:INFO ] In the include-screen tag the
> screen name
> was empty, ignoring include; in screen [GlobalDecorator]
> 2006-11-22 17:38:48,554 (http-0.0.0.0-8443-Processor2) [
> ModelScreenWidget.java:359:INFO ] In the include-screen tag the
> screen name
> was empty, ignoring include; in screen [GlobalDecorator]
> 2006-11-22 17:38:48,568 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:181:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error in request handler:
> Exception: org.apache.catalina.connector.ClientAbortException
> Message: null
> ---- cause
> ---------------------------------------------------------------------
> Exception: javax.net.ssl.SSLException
> Message: Connection has been shutdown: javax.net.ssl.SSLException:
> java.net.SocketException: Connection reset
> ---- cause
> ---------------------------------------------------------------------
> Exception: javax.net.ssl.SSLException
> Message: java.net.SocketException: Connection reset
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.net.SocketException
> Message: Connection reset
> ---- stack trace
> ---------------------------------------------------------------
> java.net.SocketException: Connection reset
> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
> java.net.SocketOutputStream.write(SocketOutputStream.java:136)
> com.sun.net.ssl.internal.ssl.OutputRecord.a(DashoA12275)
> com.sun.net.ssl.internal.ssl.SSLSocketImpl.a(DashoA12275)
> com.sun.net.ssl.internal.ssl.AppOutputStream.write(DashoA12275)
> org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes
> (InternalOutputB
> uffer.java:746)
> org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:433)
> org.apache.coyote.http11.InternalOutputBuffer.flush
> (InternalOutputBuffer.jav
> a:304)
> org.apache.coyote.http11.Http11Processor.action
> (Http11Processor.java:991)
> org.apache.coyote.Response.action(Response.java:182)
> org.apache.catalina.connector.OutputBuffer.doFlush
> (OutputBuffer.java:322)
> org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:
> 293)
> org.apache.catalina.connector.CoyoteWriter.flush(CoyoteWriter.java:94)
> freemarker.core.Environment.process(Environment.java:178)
> freemarker.template.Template.process(Template.java:231)
> org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplateAtLocation
> (FreeM
> arkerWorker.java:173)
> org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate
> (HtmlWidget.java:74)
> org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString
> (HtmlWidge
> t.java:102)
> org.ofbiz.widget.screen.HtmlWidget.renderWidgetString
> (HtmlWidget.java:61)
> org.ofbiz.widget.screen.ModelScreenWidget
> $PlatformSpecific.renderWidgetStrin
> g(ModelScreenWidget.java:794)
> org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString
> (ModelScreen
> Widget.java:149)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:242)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
> org.ofbiz.widget.screen.ModelScreenWidget
> $IncludeScreen.renderWidgetString(M
> odelScreenWidget.java:393)
> org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString
> (ModelScreen
> Widget.java:149)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:242)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
> org.ofbiz.widget.screen.ModelScreenWidget
> $DecoratorScreen.renderWidgetString
> (ModelScreenWidget.java:488)
> org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString
> (ModelScreen
> Widget.java:149)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:242)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
> org.ofbiz.widget.screen.ModelScreenWidget
> $DecoratorScreen.renderWidgetString
> (ModelScreenWidget.java:488)
> org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString
> (ModelScreen
> Widget.java:149)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:242)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render
> (ScreenWidgetViewHandl
> er.java:75)
> org.ofbiz.webapp.control.RequestHandler.renderView
> (RequestHandler.java:602)
> org.ofbiz.webapp.control.RequestHandler.doRequest
> (RequestHandler.java:387)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:74)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:252)
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> 245)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:202)
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.ja
> va:213)
> org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.ja
> va:178)
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126
> )
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105
> )
> org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java
> :107)
> org.apache.catalina.valves.AccessLogValve.invoke
> (AccessLogValve.java:541)
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148)
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869)
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processC
> onnection(Http11BaseProtocol.java:664)
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.jav
> a:527)
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWo
> rkerThread.java:80)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.jav
> a:684)
> java.lang.Thread.run(Thread.java:534)
> ----------------------------------------------------------------------
> ------
> ----
>
> 2006-11-22 17:38:48,568 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:181:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error in request handler:
> Exception: org.apache.catalina.connector.ClientAbortException
> Message: null
> ---- cause
> ---------------------------------------------------------------------
> Exception: javax.net.ssl.SSLException
> Message: Connection has been shutdown: javax.net.ssl.SSLException:
> java.net.SocketException: Connection reset
> ---- cause
> ---------------------------------------------------------------------
> Exception: javax.net.ssl.SSLException
> Message: java.net.SocketException: Connection reset
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.net.SocketException
> Message: Connection reset
> ---- stack trace
> ---------------------------------------------------------------
> java.net.SocketException: Connection reset
> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
> java.net.SocketOutputStream.write(SocketOutputStream.java:136)
> com.sun.net.ssl.internal.ssl.OutputRecord.a(DashoA12275)
> com.sun.net.ssl.internal.ssl.SSLSocketImpl.a(DashoA12275)
> com.sun.net.ssl.internal.ssl.AppOutputStream.write(DashoA12275)
> org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes
> (InternalOutputB
> uffer.java:746)
> org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:433)
> org.apache.coyote.http11.InternalOutputBuffer.flush
> (InternalOutputBuffer.jav
> a:304)
> org.apache.coyote.http11.Http11Processor.action
> (Http11Processor.java:991)
> org.apache.coyote.Response.action(Response.java:182)
> org.apache.catalina.connector.OutputBuffer.doFlush
> (OutputBuffer.java:322)
> org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:
> 293)
> org.apache.catalina.connector.CoyoteWriter.flush(CoyoteWriter.java:94)
> freemarker.core.Environment.process(Environment.java:178)
> freemarker.template.Template.process(Template.java:231)
> org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplateAtLocation
> (FreeM
> arkerWorker.java:173)
> org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate
> (HtmlWidget.java:74)
> org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString
> (HtmlWidge
> t.java:102)
> org.ofbiz.widget.screen.HtmlWidget.renderWidgetString
> (HtmlWidget.java:61)
> org.ofbiz.widget.screen.ModelScreenWidget
> $PlatformSpecific.renderWidgetStrin
> g(ModelScreenWidget.java:794)
> org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString
> (ModelScreen
> Widget.java:149)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:242)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
> org.ofbiz.widget.screen.ModelScreenWidget
> $IncludeScreen.renderWidgetString(M
> odelScreenWidget.java:393)
> org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString
> (ModelScreen
> Widget.java:149)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:242)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
> org.ofbiz.widget.screen.ModelScreenWidget
> $DecoratorScreen.renderWidgetString
> (ModelScreenWidget.java:488)
> org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString
> (ModelScreen
> Widget.java:149)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:242)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
> org.ofbiz.widget.screen.ModelScreenWidget
> $DecoratorScreen.renderWidgetString
> (ModelScreenWidget.java:488)
> org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString
> (ModelScreen
> Widget.java:149)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:242)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render
> (ScreenWidgetViewHandl
> er.java:75)
> org.ofbiz.webapp.control.RequestHandler.renderView
> (RequestHandler.java:602)
> org.ofbiz.webapp.control.RequestHandler.doRequest
> (RequestHandler.java:387)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:74)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:252)
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> 245)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:202)
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.ja
> va:213)
> org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.ja
> va:178)
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126
> )
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105
> )
> org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java
> :107)
> org.apache.catalina.valves.AccessLogValve.invoke
> (AccessLogValve.java:541)
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148)
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869)
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processC
> onnection(Http11BaseProtocol.java:664)
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.jav
> a:527)
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWo
> rkerThread.java:80)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.jav
> a:684)
> java.lang.Thread.run(Thread.java:534)
> ----------------------------------------------------------------------
> ------
> ----
>
> 2006-11-22 17:38:48,569 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:195:ERROR] An error occurred, going to the
> errorPage:
> /error/error.jsp
> 2006-11-22 17:38:48,569 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:195:ERROR] An error occurred, going to the
> errorPage:
> /error/error.jsp
> 2006-11-22 17:38:48,569 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:202:ERROR] Including errorPage: /error/error.jsp
> 2006-11-22 17:38:48,569 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:202:ERROR] Including errorPage: /error/error.jsp
> 2006-11-22 17:38:48,646 (http-0.0.0.0-8443-Processor3) [
> ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
> rendering page, Servlet Finished- total:0.165,since
> last([ViewFacilityInve...):0.165]]
> 2006-11-22 17:38:48,646 (http-0.0.0.0-8443-Processor3) [
> ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
> rendering page, Servlet Finished- total:0.165,since
> last([ViewFacilityInve...):0.165]]
> 2006-11-22 17:38:48,666 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
> rendering page, Servlet Finished- total:0.227,since
> last([ViewFacilityInve...):0.227]]
> 2006-11-22 17:38:48,666 (http-0.0.0.0-8443-Processor2) [
> ControlServlet.java:245:DEBUG] [[[ViewFacilityInventoryByProduct] Done
> rendering page, Servlet Finished- total:0.227,since
> last([ViewFacilityInve...):0.227]]
>
>

Mark Mantarro

RE: ViewFacilityInventoryByProduct error

I followed the SQL and discovered that none of my products were in the
PRODUCT_FACILITY table. Added products and report works fine....

Thanks for the help.

Mark

-----Original Message-----
From: David E Jones [mailto:[hidden email]]
Sent: Thursday, November 23, 2006 3:01 AM
To: [hidden email]
Subject: Re: ViewFacilityInventoryByProduct error

Look like the browser is either timing out or someone hit the stop
button before the page finished loading.

-David

On Nov 22, 2006, at 4:42 PM, Mark Mantarro wrote:

Mark Mantarro

RE: ViewFacilityInventoryByProduct error

In reply to this post by David E Jones-2

I found the problem.... following the SQL I realized that none of my
product variants were associated with the correct facility.

It appears that if you make a virtual product that is associated with a
facility, the variants do not get automatically associated with that same
facility.

I was assuming a parent/child relationship that if the virtual product was
setup first then the settings would cascade to the variant children. Not
sure if this is by design, but it makes for a lot more work to ensure every
variant is associated with the correct facility.

Mark

-----Original Message-----
From: David E Jones [mailto:[hidden email]]
Sent: Thursday, November 23, 2006 3:01 AM
To: [hidden email]
Subject: Re: ViewFacilityInventoryByProduct error

Look like the browser is either timing out or someone hit the stop
button before the page finished loading.

-David

On Nov 22, 2006, at 4:42 PM, Mark Mantarro wrote: