[
https://issues.apache.org/jira/browse/OFBIZ-5047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13485397#comment-13485397
]
Jacques Le Roux commented on OFBIZ-5047:
----------------------------------------
To be clear, when you select all, and choice to export in browser then in FF
you get a lot of garbage which shows in the page and at some point FF asks to
stop a failing script (not in Chrome, maybe related to one of my addons or FF
itself). Anyway you finally get this at the bottom of the page
]]> Open For Business Message :ERROR MESSAGE: javax.servlet.ServletException:
org.ofbiz.entity.transaction.GenericTransactionException: Roll back error (with
no rollbackOnly cause found), could not commit transaction, was rolled back
instead: javax.transaction.RollbackException: Transaction timeout (Transaction
timeout)
With Chrome you get a lof of stuff (texts,images) but finally the same error
blocks you.
The normal way with FF is then to show the HTML source to get the generated
XML. It does no longer work (url
https://demo-trunk.ofbiz.apache.org/webtools/control/xmldsrawdump). Same for
Chrome. You get "ERROR: No entityName list was found in the session, go back to
the export page and try again." in HTML source.
With Chrome using the file export, it works correctly on the official trunk
demo (w/out my patch, runs on Ubuntu 11.10 (GNU/Linux 3.0.0-17-server x86_64)).
Same with FF locally with my patch. So I will apply the patch. We still need to
fix the issue for the export to browser.
Then I checked a bit more and actually I was really surprised to see the same
in all OFBiz versions (even the log is the same), but in R4.0 where we get this
error. I was also surprised about that, maybe the reason the other releases and
trunk have changed and view are not preselected when all is selected...
{code}
2012-10-27 10:40:30,640 (http-0.0.0.0-8443-Processor1) [
ControlServlet.java:181:DEBUG] [[[xmldsrawdump] Setup done, doing Event(s) and
View(s)- total:0.0,since last([xmldsrawdump] Se...):0.0]]
2012-10-27 10:40:30,640 (http-0.0.0.0-8443-Processor1) [
RequestHandler.java:236:INFO ] [Processing Request]: xmldsrawdump
sessionId=5CEE9DB4CD0CBB0C20ACD5EC3AD9AB20.jvm1
2012-10-27 10:40:30,640 (http-0.0.0.0-8443-Processor1) [
RequestManager.java:116:INFO ] [RequestManager.getRequestAttribute] Value for
attribute "null" of uri "xmldsrawdump" not found
2012-10-27 10:40:30,640 (http-0.0.0.0-8443-Processor1) [
RequestHandler.java:425:INFO ] [RequestHandler.doRequest]: Response is a view.
sessionId=5CEE9DB4CD0CBB0C20ACD5EC3AD9AB20.jvm1
2012-10-27 10:40:30,640 (http-0.0.0.0-8443-Processor1) [
RequestHandler.java:578:INFO ] servletName=control, view=xmldsrawdump
sessionId=5CEE9DB4CD0CBB0C20ACD5EC3AD9AB20.jvm1
2012-10-27 10:40:32,562 (http-0.0.0.0-8443-Processor1) [
xmldsrawdump_jsp.java:130:ERROR]
---- exception report ----------------------------------------------------------
Failure in operation, rolling back transaction
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT
ATE.ORGANIZATION_PARTY_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG,
SUM(ATE.AMOUNT), ATE.GL_ACCOUNT_ID, GLA.GL_ACCOUNT_TYPE_ID, ACT.IS_POSTED,
ACT.TRA
NSACTION_DATE FROM (OFBIZ.ACCTG_TRANS_ENTRY ATE INNER JOIN OFBIZ.GL_ACCOUNT GLA
ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) INNER JOIN OFBIZ.ACCTG_TRANS ACT ON
ATE.ACCTG_TRANS_ID = ACT.ACCTG_TRANS_ID GROUP BY A
TE.ORGANIZATION_PARTY_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG,
GLA.GL_ACCOUNT_TYPE_ID (The SELECT list of a grouped query contains at least
one invalid expression. If a SELECT list has a GROUP BY, the list
may only contain valid grouping expressions and valid aggregate expressions. )
---- stack trace ---------------------------------------------------------------
{code}
So it must be something backported, maybe related to not exporting view. Tough
I clearly remember having saw this working not so long ago (in a customised
version of OFBiz based on a revision around 11.04 creation)
To summarize: I will commit my patch and we need to see why the export in
browser does not work and when fixed to backport to all releases. This is not
blocking since the file export works.
> Import/export
> -------------
>
> Key: OFBIZ-5047
> URL: https://issues.apache.org/jira/browse/OFBIZ-5047
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: Release Branch 12.04
> Environment: ubuntu 12_4, ofBIZ_12_4
> Reporter: sergio kosik
> Assignee: Jacques Le Roux
> Attachments: ofbiz_result_screen.png, start_screen.png
>
> Original Estimate: 2h
> Remaining Estimate: 2h
>
> I just check out code from SVN,
> - invoked <ant load-demo> command and
> - just tried invoke Import/export functionality from backoffice page
> The Faield :ERROR MESSAGE: was result:
> https://localhost:8443/webtools/control/xmldsdump
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://webtools/widget/EntityScreens.xml#xmldsdump]:
> java.lang.IllegalArgumentException: Error running script at location
> [component://webtools/webapp/webtools/WEB-INF/actions/entity/XmlDsDump.groovy]:
> javax.script.ScriptException:
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast
> object '[null]' with class 'java.util.ArrayList' to class 'java.util.TreeSet'
> due to: java.lang.NullPointerException (Error running script at location
> [component://webtools/webapp/webtools/WEB-INF/actions/entity/XmlDsDump.groovy]:
> javax.script.ScriptException:
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast
> object '[null]' with class 'java.util.ArrayList' to class 'java.util.TreeSet'
> due to: java.lang.NullPointerException)
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.IllegalArgumentException: Error running script at location
> [component://webtools/webapp/webtools/WEB-INF/actions/entity/XmlDsDump.groovy]:
> javax.script.ScriptException:
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast
> object '[null]' with class 'java.util.ArrayList' to class 'java.util.TreeSet'
> due to: java.lang.NullPointerException
> org.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:348)
> org.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324)
> org.ofbiz.widget.ModelWidgetAction$Script.runAction(ModelWidgetAction.java:416)
> org.ofbiz.widget.ModelWidgetAction.runSubActions(ModelWidgetAction.java:116)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:184)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:396)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:864)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:581)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:224)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:337)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> java.lang.Thread.run(Thread.java:722)
> ----------------------------------------------------------------------------
> I will check it for 11_x release soon
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
