0032992: [SER QA 1126] Not possible to create a Picking when either the Product or Storage Bin length is the maximum length

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #32992		[ All Revisions ] [ Back to Issue ]
Summary	0032992: [SER QA 1126] Not possible to create a Picking when either the Product or Storage Bin length is the maximum length

Revision	2016-05-20 12:03 by VictorVillar
Steps To Reproduce	Install Picking List module and activate the enable the Enable Stock Reservations preference. Go to Warehouses and Storage Bins: select: Región Norte change both storage bin names and write: Yosemité Store 0-0-1aaaaaaaaaaaaaaaaaaaa Yosemité Store 0-0-0aaaaaaaaaaaaaaaaaaaa. Type Outbound Go to Sales Orders window, Región Norte organization Lines: Product: Insect repellent extra Qty: 1 Book it Try to Generate the Picking List. Type Outbound: You receive an error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 It is reproducible in Oracle. Necessary to check in Postgres too. In the log: 2016-05-18 17:49:48,208 [ajp-localhost%2F127.0.0.1-8809-9] ERROR org.openbravo.materialmgmt.ReservationUtilsData - SQL error in query: CALL M_RESERVATION_REALLOCATE(?, ?, ?, to_number(?), ?, ?, ?)Exception:java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 2016-05-18 17:49:48,225 [ajp-localhost%2F127.0.0.1-8809-9] ERROR org.openbravo.base.exception.OBException - ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 javax.servlet.ServletException: @CODE=6502@ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 at org.openbravo.materialmgmt.ReservationUtilsData.reallocateStock(ReservationUtilsData.java:326) at org.openbravo.materialmgmt.ReservationUtils.reallocateStock(ReservationUtils.java:195) at org.openbravo.warehouse.pickinglist.Utilities.processOrderLineOutbound(Utilities.java:536) at org.openbravo.warehouse.pickinglist.Utilities.processOrderOutbound(Utilities.java:411) at org.openbravo.warehouse.pickinglist.CreateActionHandler.doCreate(CreateActionHandler.java:264) at org.openbravo.warehouse.pickinglist.CreateActionHandler.execute(CreateActionHandler.java:90) at org.openbravo.client.kernel.BaseActionHandler.execute(BaseActionHandler.java:73) at org.openbravo.client.kernel.KernelServlet.processActionRequest(KernelServlet.java:314) at org.openbravo.client.kernel.KernelServlet.doGet(KernelServlet.java:206) at org.openbravo.client.kernel.KernelServlet.doPost(KernelServlet.java:287) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:228) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:431) at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88) at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:59) at org.openbravo.client.kernel.KernelServlet.service(KernelServlet.java:168) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:71) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:79) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)

Revision	2016-05-19 10:10 by VictorVillar
Steps To Reproduce	Install Picking List module and activate the enable the Enable Stock Reservations preference. Go to Warehouses and Storage Bins: select: Región Norte change both storage bin names and write: Yosemité Store 0-0-1aaaaaaaaaaaaaaaaaaaa Yosemité Store 0-0-0aaaaaaaaaaaaaaaaaaaa. Type Outbound Go to Sales Orders window, Región Norte organization Lines: Product: Insect repellent extra Qty: 1 Book it Try to Generate the Picking List: You receive an error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 It is reproducible in Oracle. Necessary to check in Postgres too. In the log: 2016-05-18 17:49:48,208 [ajp-localhost%2F127.0.0.1-8809-9] ERROR org.openbravo.materialmgmt.ReservationUtilsData - SQL error in query: CALL M_RESERVATION_REALLOCATE(?, ?, ?, to_number(?), ?, ?, ?)Exception:java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 2016-05-18 17:49:48,225 [ajp-localhost%2F127.0.0.1-8809-9] ERROR org.openbravo.base.exception.OBException - ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 javax.servlet.ServletException: @CODE=6502@ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 at org.openbravo.materialmgmt.ReservationUtilsData.reallocateStock(ReservationUtilsData.java:326) at org.openbravo.materialmgmt.ReservationUtils.reallocateStock(ReservationUtils.java:195) at org.openbravo.warehouse.pickinglist.Utilities.processOrderLineOutbound(Utilities.java:536) at org.openbravo.warehouse.pickinglist.Utilities.processOrderOutbound(Utilities.java:411) at org.openbravo.warehouse.pickinglist.CreateActionHandler.doCreate(CreateActionHandler.java:264) at org.openbravo.warehouse.pickinglist.CreateActionHandler.execute(CreateActionHandler.java:90) at org.openbravo.client.kernel.BaseActionHandler.execute(BaseActionHandler.java:73) at org.openbravo.client.kernel.KernelServlet.processActionRequest(KernelServlet.java:314) at org.openbravo.client.kernel.KernelServlet.doGet(KernelServlet.java:206) at org.openbravo.client.kernel.KernelServlet.doPost(KernelServlet.java:287) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:228) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:431) at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88) at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:59) at org.openbravo.client.kernel.KernelServlet.service(KernelServlet.java:168) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:71) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:79) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)

Revision	2016-05-18 19:39 by VictorVillar
Steps To Reproduce	As group Admin role, Go to https://livebuilds.openbravo.com/retail_modules_oracle_pi/ [^] and rol with organization: White Valley Group Go to Warehouses and Storage Bins: select: Yosemite Store change both storage bin names: Yosemité Store 0-0-1aaaaaaaaaaaaaaaaaaaa Yosemité Store 0-0-0aaaaaaaaaaaaaaaaaaaa Go to Sales Orders window, Yosemite Store Business Partner: Arturo Montoro Lines: Product: Insect repellent extra Qty: 1 Book it Try to Generate the Picking List: You receive an error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 It is reproducible in Oracle. Necessary to check in Postgres too. In the log: 2016-05-18 17:49:48,208 [ajp-localhost%2F127.0.0.1-8809-9] ERROR org.openbravo.materialmgmt.ReservationUtilsData - SQL error in query: CALL M_RESERVATION_REALLOCATE(?, ?, ?, to_number(?), ?, ?, ?)Exception:java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 2016-05-18 17:49:48,225 [ajp-localhost%2F127.0.0.1-8809-9] ERROR org.openbravo.base.exception.OBException - ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 javax.servlet.ServletException: @CODE=6502@ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "RETAIL_MODULES_ORACLE_PI.M_RESERVATION_REALLOCATE", line 331 at org.openbravo.materialmgmt.ReservationUtilsData.reallocateStock(ReservationUtilsData.java:326) at org.openbravo.materialmgmt.ReservationUtils.reallocateStock(ReservationUtils.java:195) at org.openbravo.warehouse.pickinglist.Utilities.processOrderLineOutbound(Utilities.java:536) at org.openbravo.warehouse.pickinglist.Utilities.processOrderOutbound(Utilities.java:411) at org.openbravo.warehouse.pickinglist.CreateActionHandler.doCreate(CreateActionHandler.java:264) at org.openbravo.warehouse.pickinglist.CreateActionHandler.execute(CreateActionHandler.java:90) at org.openbravo.client.kernel.BaseActionHandler.execute(BaseActionHandler.java:73) at org.openbravo.client.kernel.KernelServlet.processActionRequest(KernelServlet.java:314) at org.openbravo.client.kernel.KernelServlet.doGet(KernelServlet.java:206) at org.openbravo.client.kernel.KernelServlet.doPost(KernelServlet.java:287) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:228) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:431) at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88) at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:59) at org.openbravo.client.kernel.KernelServlet.service(KernelServlet.java:168) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:71) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:79) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)