Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032992Openbravo ERP04. Warehouse managementpublic2016-05-18 18:042016-06-17 19:37
ReporterVictorVillar 
Assigned Toaaroncalero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032992: [SER QA 1126] Not possible to create a Picking when either the Product or Storage Bin length is the maximum length
DescriptionNot 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 ReproduceInstall 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)
 
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? Issue32992.export (1,115) 2016-05-20 10:19
https://issues.openbravo.com/file_download.php?file_id=9428&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-05-18 18:04VictorVillarNew Issue
2016-05-18 18:04VictorVillarAssigned To => Triage Finance
2016-05-18 18:04VictorVillarOBNetwork customer => Yes
2016-05-18 18:04VictorVillarModules => Core
2016-05-18 18:04VictorVillarResolution time => 1464732000
2016-05-18 18:04VictorVillarTriggers an Emergency Pack => No
2016-05-18 18:42VictorVillarIssue Monitored: VictorVillar
2016-05-18 18:42VictorVillarFile Added: 1118.diff
2016-05-18 19:39aferrazAssigned ToTriage Finance => markmm82
2016-05-19 10:10VictorVillarSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12154#r12154
2016-05-20 10:19aaroncaleroFile Added: Issue32992.export
2016-05-20 10:20aaroncaleroFile Deleted: 1118.diff
2016-05-20 12:03VictorVillarSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12187#r12187
2016-05-20 12:29hgbotCheckin
2016-05-20 12:29hgbotNote Added: 0086604
2016-05-20 12:29hgbotStatusnew => resolved
2016-05-20 12:29hgbotResolutionopen => fixed
2016-05-20 12:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b96aeecd42688b00f375cca4f9f011b9c0fb45d9 [^]
2016-05-20 12:30hgbotCheckin
2016-05-20 12:30hgbotNote Added: 0086605
2016-05-20 12:40aferrazAssigned Tomarkmm82 => aaroncalero
2016-05-20 12:40aferrazReview Assigned To => aferraz
2016-05-20 12:40aferrazNote Added: 0086606
2016-05-20 12:40aferrazStatusresolved => closed
2016-05-20 12:40aferrazFixed in Version => 3.0PR16Q3
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087547
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087548

Notes
(0086604)
hgbot   
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   
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   
2016-05-20 12:40   
Code review + Testing OK
(0087547)
hudsonbot   
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   
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