Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0032992 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | major | always | 2016-05-18 18:04 | 2016-06-17 19:37 | |||
| Reporter | VictorVillar | View Status | public | |||||
| Assigned To | aaroncalero | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0PR16Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | b96aeecd4268 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | aferraz | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0032992: [SER QA 1126] Not possible to create a Picking when either the Product or Storage Bin length is the maximum length | |||||||
| Description | Not possible to create a Picking when either the Product or Storage Bin length is the maximum length with punctual signs. It is reproducible in Oracle. Necessary to check in Postgres too. | |||||||
| 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) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Issue32992.export [^] (1,115 bytes) 2016-05-20 10:19 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0086604) hgbot (developer) 2016-05-20 12:29 |
Repository: erp/devel/pi Changeset: b96aeecd42688b00f375cca4f9f011b9c0fb45d9 Author: Aaron Calero <aaron.calero <at> openbravo.com> Date: Fri May 20 10:18:42 2016 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/b96aeecd42688b00f375cca4f9f011b9c0fb45d9 [^] Fixed issue 32992: [SER QA 1126] Error when creating a picking list Not possible to create a Picking when either the Product or Storage Bin length is the maximum length --- M src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml --- |
|
(0086605) hgbot (developer) 2016-05-20 12:30 |
Repository: erp/devel/pi Changeset: 5aa0a9461d396c28a3d1ae84978944faf9e2d9f7 Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> Date: Fri May 20 12:09:23 2016 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/5aa0a9461d396c28a3d1ae84978944faf9e2d9f7 [^] Related to issue 32992: Update copyright --- M src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml --- |
|
(0086606) aferraz (viewer) 2016-05-20 12:40 |
Code review + Testing OK |
|
(0087547) hudsonbot (viewer) 2016-06-17 19:37 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^] Maturity status: Test |
|
(0087548) hudsonbot (viewer) 2016-06-17 19:37 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-05-18 18:04 | VictorVillar | New Issue | |
| 2016-05-18 18:04 | VictorVillar | Assigned To | => Triage Finance |
| 2016-05-18 18:04 | VictorVillar | OBNetwork customer | => Yes |
| 2016-05-18 18:04 | VictorVillar | Modules | => Core |
| 2016-05-18 18:04 | VictorVillar | Resolution time | => 1464732000 |
| 2016-05-18 18:04 | VictorVillar | Triggers an Emergency Pack | => No |
| 2016-05-18 18:42 | VictorVillar | Issue Monitored: VictorVillar | |
| 2016-05-18 18:42 | VictorVillar | File Added: 1118.diff | |
| 2016-05-18 19:39 | aferraz | Assigned To | Triage Finance => markmm82 |
| 2016-05-19 10:10 | VictorVillar | Steps to Reproduce Updated | View Revisions |
| 2016-05-20 10:19 | aaroncalero | File Added: Issue32992.export | |
| 2016-05-20 10:20 | aaroncalero | File Deleted: 1118.diff | |
| 2016-05-20 12:03 | VictorVillar | Steps to Reproduce Updated | View Revisions |
| 2016-05-20 12:29 | hgbot | Checkin | |
| 2016-05-20 12:29 | hgbot | Note Added: 0086604 | |
| 2016-05-20 12:29 | hgbot | Status | new => resolved |
| 2016-05-20 12:29 | hgbot | Resolution | open => fixed |
| 2016-05-20 12:29 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b96aeecd42688b00f375cca4f9f011b9c0fb45d9 [^] |
| 2016-05-20 12:30 | hgbot | Checkin | |
| 2016-05-20 12:30 | hgbot | Note Added: 0086605 | |
| 2016-05-20 12:40 | aferraz | Assigned To | markmm82 => aaroncalero |
| 2016-05-20 12:40 | aferraz | Review Assigned To | => aferraz |
| 2016-05-20 12:40 | aferraz | Note Added: 0086606 | |
| 2016-05-20 12:40 | aferraz | Status | resolved => closed |
| 2016-05-20 12:40 | aferraz | Fixed in Version | => 3.0PR16Q3 |
| 2016-06-17 19:37 | hudsonbot | Checkin | |
| 2016-06-17 19:37 | hudsonbot | Note Added: 0087547 | |
| 2016-06-17 19:37 | hudsonbot | Checkin | |
| 2016-06-17 19:37 | hudsonbot | Note Added: 0087548 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |