Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0053580
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationscriticalhave not tried2023-10-03 14:012023-10-05 13:06
ReporterSandrahuguetView Statuspublic 
Assigned ToTriage Omni WMS 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0053580: Assign task from unassigned toolbar does not work in all cases

DescriptionAssign task from unassigned toolbar does not work in all cases
Steps To ReproduceIn backend
Go to task type and check Shortcut in Unassigned Task Bar and Assign Popup in all task

In AWOFE
Tap on GR filter and select Trout task the following error is shown:

A problem happened while loading task for user AWO_US_W


See video:
https://www.youtube.com/watch?v=fOk53URAVYQ&ab_channel=DavidBaz [^]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0155554)
dbaz (developer)
2023-10-05 09:55

 2023-10-03 12:55:33,097 [http-nio-8880-exec-3] ERROR org.openbravo.mobile.core.process.SecuredJSONProcess - query did not return a unique result: 2
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
at org.hibernate.query.internal.AbstractProducedQuery.uniqueElement(AbstractProducedQuery.java:1684) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
at org.hibernate.query.internal.AbstractProducedQuery.uniqueResult(AbstractProducedQuery.java:1659) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
at org.openbravo.warehouse.advancedwarehouseoperations.distributionorders.taskhook.DOGroupOfTasksProviderHook.getDocumentNo(DOGroupOfTasksProviderHook.java:57) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.distributionorders.taskhook.DOGroupOfTasksProviderHook.exec(DOGroupOfTasksProviderHook.java:29) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GroupOfTasksProvider.getValuesForExtraProperties(GroupOfTasksProvider.java:193) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GroupOfTasksProvider.getValue(GroupOfTasksProvider.java:148) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GroupOfTasksProvider.createHeaderTask(GroupOfTasksProvider.java:98) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GroupOfTasksProvider.addHeaderTaskForGroup(GroupOfTasksProvider.java:80) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GenericTaskProvider.getArrayOfTasks(GenericTaskProvider.java:106) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GenericTaskProvider.getArrayOfAssignedTasks(GenericTaskProvider.java:68) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.TasksProvider.exec(TasksProvider.java:67) ~[classes/:?]
at org.openbravo.mobile.core.process.JSONProcessSimple.exec(JSONProcessSimple.java:47) ~[classes/:?]
at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:65) [classes/:?]
at org.openbravo.mobile.core.process.MobileServiceProcessor.execProcess(MobileServiceProcessor.java:141) [classes/:?]
at org.openbravo.mobile.core.process.MobileServiceProcessor.execServiceName(MobileServiceProcessor.java:116) [classes/:?]
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:199) [classes/:?]
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:76) [classes/:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) [servlet-api.jar:?]
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:200) [openbravo-core.jar:?]
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:459) [classes/:?]
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:89) [classes/:?]
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:67) [classes/:?]
at org.openbravo.mobile.core.process.MobileService.service(MobileService.java:135) [classes/:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) [openbravo-core.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:38) [openbravo-core.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:65) [classes/:?]
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:47) [classes/:?]
at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:74) [classes/:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:96) [classes/:?]
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:47) [classes/:?]
at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:118) [classes/:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.17.1.jar:2.17.1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [catalina.jar:8.5.59]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.59]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544) [catalina.jar:8.5.59]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [catalina.jar:8.5.59]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.59]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:8.5.59]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.59]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:8.5.59]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:616) [tomcat-coyote.jar:8.5.59]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.59]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) [tomcat-coyote.jar:8.5.59]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626) [tomcat-coyote.jar:8.5.59]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.59]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.59]
at java.lang.Thread.run(Thread.java:829) [?:?]
2023-10-03 12:55:33,102 [http-nio-8880-exec-3] ERROR org.openbravo.mobile.core.process.JSONRowConverter - Error in JSON process: query did not return a unique result: 2
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
at org.hibernate.query.internal.AbstractProducedQuery.uniqueElement(AbstractProducedQuery.java:1684) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
at org.hibernate.query.internal.AbstractProducedQuery.uniqueResult(AbstractProducedQuery.java:1659) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
at org.openbravo.warehouse.advancedwarehouseoperations.distributionorders.taskhook.DOGroupOfTasksProviderHook.getDocumentNo(DOGroupOfTasksProviderHook.java:57) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.distributionorders.taskhook.DOGroupOfTasksProviderHook.exec(DOGroupOfTasksProviderHook.java:29) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GroupOfTasksProvider.getValuesForExtraProperties(GroupOfTasksProvider.java:193) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GroupOfTasksProvider.getValue(GroupOfTasksProvider.java:148) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GroupOfTasksProvider.createHeaderTask(GroupOfTasksProvider.java:98) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GroupOfTasksProvider.addHeaderTaskForGroup(GroupOfTasksProvider.java:80) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GenericTaskProvider.getArrayOfTasks(GenericTaskProvider.java:106) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.GenericTaskProvider.getArrayOfAssignedTasks(GenericTaskProvider.java:68) ~[classes/:?]
at org.openbravo.warehouse.advancedwarehouseoperations.mobile.datasources.TasksProvider.exec(TasksProvider.java:67) ~[classes/:?]
at org.openbravo.mobile.core.process.JSONProcessSimple.exec(JSONProcessSimple.java:47) ~[classes/:?]
at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:65) [classes/:?]
at org.openbravo.mobile.core.process.MobileServiceProcessor.execProcess(MobileServiceProcessor.java:141) [classes/:?]
at org.openbravo.mobile.core.process.MobileServiceProcessor.execServiceName(MobileServiceProcessor.java:116) [classes/:?]
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:199) [classes/:?]
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:76) [classes/:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) [servlet-api.jar:?]
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:200) [openbravo-core.jar:?]
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:459) [classes/:?]
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:89) [classes/:?]
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:67) [classes/:?]
at org.openbravo.mobile.core.process.MobileService.service(MobileService.java:135) [classes/:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) [openbravo-core.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:38) [openbravo-core.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:65) [classes/:?]
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:47) [classes/:?]
at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:74) [classes/:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:96) [classes/:?]
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:47) [classes/:?]
at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:118) [classes/:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.17.1.jar:2.17.1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.59]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.59]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [catalina.jar:8.5.59]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.59]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544) [catalina.jar:8.5.59]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [catalina.jar:8.5.59]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.59]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:8.5.59]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.59]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:8.5.59]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:616) [tomcat-coyote.jar:8.5.59]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.59]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) [tomcat-coyote.jar:8.5.59]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626) [tomcat-coyote.jar:8.5.59]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.59]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.59]
at java.lang.Thread.run(Thread.java:829) [?:?]
(0155561)
hgbot (developer)
2023-10-05 11:10

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/105 [^]
(0155563)
Sandrahuguet (developer)
2023-10-05 11:17

 Test Plan:

In backend
Go to task type and check Shortcut in Unassigned Task Bar and Assign Popup in all task

In AWOFE
Tap on GR filter and select Trout task
Trout task is assigned
(0155577)
hgbot (developer)
2023-10-05 13:06

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders [^]
Changeset: e499494ad8aa63ac2fc77a0ab294ba68397b3c4a
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 05-10-2023 11:06:32
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/commit/e499494ad8aa63ac2fc77a0ab294ba68397b3c4a [^]

Fixed ISSUE-53580 fix query to filter by id instead of documentno

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/distributionorders/taskhook/DOGroupOfTasksProviderHook.java
---
(0155578)
hgbot (developer)
2023-10-05 13:06

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/105 [^]

- Issue History
Date Modified Username Field Change
2023-10-03 14:01 Sandrahuguet New Issue
2023-10-03 14:01 Sandrahuguet Assigned To => Triage Omni WMS
2023-10-04 12:33 dbaz Severity minor => critical
2023-10-05 09:50 dbaz Issue Monitored: dbaz
2023-10-05 09:50 dbaz Issue Monitored: dmiguelez
2023-10-05 09:55 dbaz Note Added: 0155554
2023-10-05 11:10 Sandrahuguet Status new => scheduled
2023-10-05 11:10 hgbot Note Added: 0155561
2023-10-05 11:17 Sandrahuguet Note Added: 0155563
2023-10-05 13:06 hgbot Resolution open => fixed
2023-10-05 13:06 hgbot Status scheduled => closed
2023-10-05 13:06 hgbot Note Added: 0155577
2023-10-05 13:06 hgbot Note Added: 0155578

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker