[jira] [Comment Edited] (OFBIZ-11955) display/selection of unit of measure is broken

[Nicolas Malin (Jira)]

    [ 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)