Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0053580 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Modules] Advanced Warehouse Operations | critical | have not tried | 2023-10-03 14:01 | 2023-10-05 13:06 | |||
Reporter | Sandrahuguet | View Status | public | |||||
Assigned To | Triage Omni WMS | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM 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 | |||||||
Description | Assign task from unassigned toolbar does not work in all cases | |||||||
Steps To Reproduce | 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 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 [^] | |||||||
Tags | No 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 |