Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053580ModulesAdvanced Warehouse Operationspublic2023-10-03 14:012023-10-05 13:06
ReporterSandrahuguet 
Assigned ToTriage Omni WMS 
PrioritynormalSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0053580: 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 [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-10-03 14:01SandrahuguetNew Issue
2023-10-03 14:01SandrahuguetAssigned To => Triage Omni WMS
2023-10-04 12:33dbazSeverityminor => critical
2023-10-05 09:50dbazIssue Monitored: dbaz
2023-10-05 09:50dbazIssue Monitored: dmiguelez
2023-10-05 09:55dbazNote Added: 0155554
2023-10-05 11:10SandrahuguetStatusnew => scheduled
2023-10-05 11:10hgbotNote Added: 0155561
2023-10-05 11:17SandrahuguetNote Added: 0155563
2023-10-05 13:06hgbotResolutionopen => fixed
2023-10-05 13:06hgbotStatusscheduled => closed
2023-10-05 13:06hgbotNote Added: 0155577
2023-10-05 13:06hgbotNote Added: 0155578

Notes
(0155554)
dbaz   
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   
2023-10-05 11:10   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/105 [^]
(0155563)
Sandrahuguet   
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   
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   
2023-10-05 13:06   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/105 [^]