[
https://issues.apache.org/jira/browse/OFBIZ-11955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17183232#comment-17183232
]
Jacques Le Roux edited comment on OFBIZ-11955 at 8/24/20, 12:50 PM:
--------------------------------------------------------------------
When you get to
[https://localhost:8443/ecomseo/product/Micro-Chrome-Widget3-WG3-1111.html] the
UOM dropdown works.
Back from there, again I don't see the Catetgory tree. I see this error in log
which is maybe dur to using the same DB with different branches (trunk, R18 and
R17) while testing things
{noformat}
2020-08-24 14:47:56,696 |jsse-nio-8443-exec-1 |TransactionUtil |W| Calling
transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: rollback called in Entity Engine SQLProcessor
at
org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:362)
[main/:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:190)
[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111)
[main/:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897)
[main/:?]
at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76) [main/:?]
at org.apache.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:538)
[main/:?]
at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:249)
[main/:?]
at org.apache.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:97)
[main/:?]
at
org.apache.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:75)
[main/:?]
at
org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:367)
[main/:?]
at
org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:96)
[main/:?]
at
org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:87)
[main/:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:626)
[tomcat-servlet-api-9.0.37.jar:4.0.FR]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
[tomcat-servlet-api-9.0.37.jar:4.0.FR]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
[tomcat-embed-websocket-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:233)
[main/:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101)
[main/:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:328)
[main/:?]
at
org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:66)
[main/:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185)
[main/:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71)
[log4j-web-2.11.2.jar:2.11.2]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
[tomcat-catalina-9.0.37.jar:9.0.37]
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
[tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
[tomcat-catalina-9.0.37.jar:9.0.37]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
[tomcat-coyote-9.0.37.jar:9.0.37]
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
[tomcat-coyote-9.0.37.jar:9.0.37]
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
[tomcat-coyote-9.0.37.jar:9.0.37]
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589)
[tomcat-coyote-9.0.37.jar:9.0.37]
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
[tomcat-coyote-9.0.37.jar:9.0.37]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_202]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_202]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
[tomcat-util-9.0.37.jar:9.0.37]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
2020-08-24 14:47:56,696 |jsse-nio-8443-exec-1 |GenericDelegator |E| Failure in
create operation for entity [ServerHit]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:ServerHit][content
Id,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-24
14:47:56.687(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo/(java.lang.String)][requestUrl,https://localhost:8443/ecoms
eo/getJs?name=CategoryDetail-1(java.lang.String)][runningTimeMillis,1(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10904(java.lang.String)]
(SQL Exception while executing
the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID, CONTENT_ID,
HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS,
USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS,
SERVER_HOST_NAME, INTERNAL_CO
NTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was
aborted because it would have caused a duplicate key value in a unique or
primary key co
nstraint or unique index identified by 'SQL200822152450631' defined on
'SERVER_HIT'.)). Rolling back transaction.
2020-08-24 14:47:56,701 |jsse-nio-8443-exec-1 |TransactionUtil |I| Transaction
rolled back
2020-08-24 14:47:56,701 |jsse-nio-8443-exec-1 |ServerHitBin |W| Error saving
ServerHit: org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntit
y:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-24
14:47:56.687(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo/(java.lang.String)][requestUrl,https://
localhost:8443/ecomseo/getJs?name=CategoryDetail-1(java.lang.String)][runningTimeMillis,1(java.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10904(java.lang.String)]
(SQL Excep
tion while executing the following:INSERT INTO OFBIZ.SERVER_HIT (VISIT_ID,
CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
SERVER_IP_ADDRESS, SERVER_HO
ST_NAME, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID,
REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?) (The statement was aborted because it would have caused a duplicate key
value in a uniq
ue or primary key constraint or unique index identified by 'SQL200822152450631'
defined on 'SERVER_HIT'.)) (Error while inserting:
[GenericEntity:ServerHit][contentId,ecomseo.getJs(java.lang.String)][hitStartDateTime,2020-08-24
14:47:56.
687(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][referrerUrl,https://localhost:8443/ecomseo/(java.lang.String)][requestUrl,https://localhost:8443/ecomseo/getJs?name=CategoryDetail-1(java.lang.String)][runningTimeMillis,1(jav
a.lang.Long)][serverHostName,LDLC(java.lang.String)][serverIpAddress,192.168.56.1(java.lang.String)][visitId,10904(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.SERVER_HIT
(VISIT_ID, CONTENT_ID, HIT_ST
ART_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID,
STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME,
INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID,
REF_BY_WEB_CONTACT_MECH_ID)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was
aborted because it would have caused a duplicate key value in a unique or
primary key constraint or unique index identified by 'SQL200822152450631'
defined on 'S
ERVER_HIT'.)))
2020-08-24 14:47:56,701 |jsse-nio-8443-exec-1 |ControlServlet |T|
[[[ecomseo::getJs (Domain:https://localhost)] Request Done- total:0.014,since
last([ecomseo::getJs (...):0.014]]
{noformat}
I'll "cleanAll eclipse loadAll ofbiz" to confirm
was (Author: jacques.le.roux):
When you get to
[https://localhost:8443/ecomseo/product/Micro-Chrome-Widget3-WG3-1111.html] the
UOM dropdown works.
> display/selection of unit of measure is broken
> ----------------------------------------------
>
> Key: OFBIZ-11955
> URL: https://issues.apache.org/jira/browse/OFBIZ-11955
> Project: OFBiz
> Issue Type: Bug
> Components: ecommerce, order
> Affects Versions: Release Branch 17.12, Trunk
> Reporter: Alex Bodnaru
> Priority: Major
> Attachments: Image 002.png, Image 002.png, Image damned.png,
> Image1.png, image-2020-08-22-13-00-44-947.png,
> image-2020-08-22-13-00-57-856.png, image-2020-08-22-13-03-22-775.png,
> image-2020-08-22-13-04-07-722.png, variantinfojs-data.xml
>
>
> checkAmtReq and getVariantPrice are broken for similar reasons, too.
> the display and selection of alternative uom elements occur in multiple
> forms, one for each product: whether detailed or in summary. thus, they
> should be marked by names and classes, not by ids, that are unique in the
> entire document.
> the bug did not manifest in demo data, since only one product has alternative
> packaging.
> i did duplicate wg-1111* products and arranged their relations. is, btw, a
> way to export product trees in order to share them?
> the fix does span the framework and ecommerce repositories.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
