Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0042389 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | minor | always | 2019-11-25 14:25 | 2020-04-06 15:51 | |||
| Reporter | francisco | View Status | public | |||||
| Assigned To | inigo_lerga | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR20Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 508345e21164 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | dmiguelez | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 13056 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0042389: Error processing inventory with reservation | |||||||
| Description | When you have a reservation in a product and try to to process a physical inventory with Quantity count inferior to the Reserved QTY it throw the following error: Error: org.hibernate.exception.GenericJDBCException: could not execute statement | |||||||
| Steps To Reproduce | Tested in retail_modules_pgsql_pi: Go to Sales Order window and complete an order with: Cerveza Ale 0.5L Line: 5 units Click on button Manage Reservation Go to Physical Inventory Window and create a new inventory Line: Cerveza Ale 0.5L Quantity count less than you reserved before (1) Click on button Process Inventory Count You ger the error Error: org.hibernate.exception.GenericJDBCException: could not execute statement This is the log: 2019-11-25 13:05:21,465 [http-3] ERROR org.openbravo.materialmgmt.InventoryCountProcess - Exception processing physical inventory javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1617) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.openbravo.materialmgmt.InventoryCountProcess.processInventory(InventoryCountProcess.java:242) ~[classes/:?] at org.openbravo.materialmgmt.InventoryCountProcess.processInventory(InventoryCountProcess.java:145) ~[classes/:?] at org.openbravo.materialmgmt.InventoryCountProcess.processInventory(InventoryCountProcess.java:140) ~[classes/:?] at org.openbravo.materialmgmt.InventoryCountProcess.execute(InventoryCountProcess.java:99) [classes/:?] at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:84) [classes/:?] at org.openbravo.erpWindows.PhysicalInventory.Header.doPost(Header.java:330) [classes/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [tomcat8-servlet-api-8.5.39.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.erpWindows.PhysicalInventory.Header.service(Header.java:112) [classes/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [tomcat8-servlet-api-8.5.39.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat8-websocket-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:75) [classes/:?] at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:47) [classes/:?] at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:83) [classes/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) [openbravo-core.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:38) [openbravo-core.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] 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) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] 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) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.1.jar:2.11.1] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:476) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat8-coyote-8.5.39.jar:8.5.39] 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) [tomcat8-util-8.5.39.jar:8.5.39] at java.lang.Thread.run(Thread.java:834) [?:?] Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:100) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:59) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:454) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:382) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1562) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1626) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1608) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] ... 56 more Caused by: org.postgresql.util.PSQLException: ERROR: @CannotTakeOutReservedStock@ @of@ @Product@: ES/0001cd , @AttributeSetInstance@: -, @UOM@: Ud @And@ @StorageBin@: Rn-0-0-0 Where: PL/pgSQL function m_transaction_trg2() line 93 at RAISE at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at jdk.internal.reflect.GeneratedMethodAccessor336.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:138) ~[tomcat-jdbc.jar:?] at com.sun.proxy.$Proxy1127.executeUpdate(Unknown Source) ~[?:?] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:100) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:59) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:454) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:382) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1562) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1626) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1608) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0116597) inigo_lerga (viewer) 2020-01-02 09:52 |
Test Plan Mantis: As the F&B International Group Admin role: - Enter the Sales Order window. - Create a new record with any business partner. Create a new line of Cerveza Ale 0.5L with 5 units in the Ordered Quantity field. - Save the record and press Book button. - Select the line of Cerveza Ale 0.5L and click or button Manage Reservation. Press the Done button in the popup window. - Go to Physical Inventory window. Create a new line of Cerveza Ale 0.5L with 1 unit in the Quantity field. - Press the Process Inventory Count button. #Apreciate the error message is now the proper one# |
|
(0118714) hgbot (developer) 2020-03-20 13:29 |
Repository: erp/devel/pi Changeset: 2009bff0c56b7a48a959549e7cd9d825dda93c3e Author: David Miguelez <david.miguelez <at> openbravo.com> Date: Fri Mar 20 13:28:54 2020 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/2009bff0c56b7a48a959549e7cd9d825dda93c3e [^] Fixes ISSUE-42389. Moved try condition of try-catch block to encapsulate the queryInsert.execute statement and provide the proper message to the user when the process fails. --- M src/org/openbravo/materialmgmt/InventoryCountProcess.java --- |
|
(0118715) dmiguelez (viewer) 2020-03-20 13:30 |
Code Review + Testing Ok |
|
(0118754) hgbot (developer) 2020-03-23 12:23 |
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations Changeset: 42e055fd911c875d16ed4182cd72d0bf51ccc1c2 Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> Date: Mon Mar 23 11:34:51 2020 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/42e055fd911c875d16ed4182cd72d0bf51ccc1c2 [^] Related to BUG-42389: Adapted AWO JUnit test The test was expecting a PersistenceException, however the core's code now launches an OBException. The test has been adapted to work with Exception class that properly shows the expected message --- M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOb_BasicFunctionalFlowsWithAWOPreference.java --- |
|
(0118973) hgbot (developer) 2020-04-06 11:53 |
Repository: erp/devel/pi Changeset: 508345e2116418669408647db90b35c133b1392c Author: David Miguelez <david.miguelez <at> openbravo.com> Date: Fri Mar 20 13:28:54 2020 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/508345e2116418669408647db90b35c133b1392c [^] Fixes ISSUE-42389. Moved try condition of try-catch block to encapsulate the queryInsert.execute statement and provide the proper message to the user when the process fails. --- M src/org/openbravo/materialmgmt/InventoryCountProcess.java --- |
|
(0118996) jarmendariz (viewer) 2020-04-06 15:51 |
closed: wrongly reopened |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2019-11-25 14:25 | francisco | New Issue | |
| 2019-11-25 14:25 | francisco | Assigned To | => Triage Finance |
| 2019-11-25 14:25 | francisco | OBNetwork customer | => OBPS |
| 2019-11-25 14:25 | francisco | Modules | => Core |
| 2019-11-25 14:25 | francisco | Resolution time | => 1576450800 |
| 2019-11-25 14:25 | francisco | Triggers an Emergency Pack | => No |
| 2019-11-25 14:27 | Practics | Issue Monitored: Practics | |
| 2019-11-27 09:49 | francisco | Priority | high => normal |
| 2019-11-27 09:49 | francisco | Severity | major => minor |
| 2019-11-27 09:51 | francisco | Support ticket | => 13056 |
| 2019-11-27 09:51 | francisco | Resolution time | 1576450800 => |
| 2019-12-26 12:37 | inigo_lerga | Assigned To | Triage Finance => inigo_lerga |
| 2019-12-26 12:37 | inigo_lerga | Status | new => scheduled |
| 2020-01-02 09:52 | inigo_lerga | Note Added: 0116597 | |
| 2020-03-20 13:29 | hgbot | Checkin | |
| 2020-03-20 13:29 | hgbot | Note Added: 0118714 | |
| 2020-03-20 13:29 | hgbot | Status | scheduled => resolved |
| 2020-03-20 13:29 | hgbot | Resolution | open => fixed |
| 2020-03-20 13:29 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/2009bff0c56b7a48a959549e7cd9d825dda93c3e [^] |
| 2020-03-20 13:30 | dmiguelez | Review Assigned To | => dmiguelez |
| 2020-03-20 13:30 | dmiguelez | Note Added: 0118715 | |
| 2020-03-20 13:30 | dmiguelez | Status | resolved => closed |
| 2020-03-20 13:30 | dmiguelez | Fixed in Version | => 3.0PR20Q2 |
| 2020-03-23 12:23 | hgbot | Checkin | |
| 2020-03-23 12:23 | hgbot | Note Added: 0118754 | |
| 2020-04-06 11:53 | hgbot | Checkin | |
| 2020-04-06 11:53 | hgbot | Note Added: 0118973 | |
| 2020-04-06 11:53 | hgbot | Status | closed => resolved |
| 2020-04-06 11:53 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/2009bff0c56b7a48a959549e7cd9d825dda93c3e [^] => http://code.openbravo.com/erp/devel/pi/rev/508345e2116418669408647db90b35c133b1392c [^] |
| 2020-04-06 15:51 | jarmendariz | Note Added: 0118996 | |
| 2020-04-06 15:51 | jarmendariz | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |