Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0004602 | Openbravo ERP | 02. Master data management | public | 2008-08-08 23:23 | 2008-09-03 23:05 |
|
| Reporter | javiexpo1 | |
| Assigned To | gorka_gil | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 10 | OS Version | XP |
| Product Version | 2.35MP5 | |
| Target Version | | Fixed in Version | 2.40 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0004602: Create PriceList - Get PL/SQL Error |
| Description | When I am trying to modify my product prices creating a PriceList (CreatePriceList Button in Price List version Tab) for a new Price List Version applying to it a new Price List Schema i got this error message:
Error:
invalid input syntax for type numeric: """
This error raise from the PL/SQL store procedure named m_pricelist_create, and i think that the application is sending the parameters pInstanceID in an incorrect type format.
I could debug the application using Eclipse and i could see that in the line 307 of the method process103 "M_PriceList_Create" of the ActionButtonData class, there is a call for the method:
RDBMSIndependent.getCallableResult(null, connectionProvider, strSql, parametersData, parametersTypes, 0);
Inside of this method in line 63 theres is a call for the method:
UtilSql.setValue(st, iParameter, 12, "Test", parameters.elementAt(i)), that is using the number 12 hardcoded in order to define the type of the variable, if you see the class UtilSql.java the type of the variable 12 means that is a String and this is wrong because the PL/SQl Procedure M_PRICELIST_CREATE() is waiting for the pInstance value that is a variable type numeric nor string. |
| Steps To Reproduce | You can reproduce it in Openbravo ERP 2.35MP5 or 2.40Beta: triying to create a new Price List Version from an old Price List Version applying a Price List Schema, this is a standard transaction in Openbravo ERP. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | depends on | backport | 0004620 | | closed | gorka_gil | Create PriceList - Get PL/SQL Error |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2008-08-08 23:23 | javiexpo1 | New Issue | |
| 2008-08-08 23:23 | javiexpo1 | Assigned To | => cromero |
| 2008-08-08 23:23 | javiexpo1 | sf_bug_id | 0 => 2043556 |
| 2008-08-12 01:00 | javiexpo1 | Issue Monitored: javiexpo1 | |
| 2008-08-13 18:54 | psarobe | OBNetwork customer | => No |
| 2008-08-13 18:54 | psarobe | Priority | normal => high |
| 2008-08-13 18:54 | psarobe | Severity | critical => major |
| 2008-08-13 18:57 | psarobe | Status | new => scheduled |
| 2008-08-13 18:57 | psarobe | Assigned To | cromero => gorka_gil |
| 2008-08-13 18:57 | psarobe | fix_in_branch | => trunk |
| 2008-08-14 15:47 | jpabloae | Note Added: 0008557 | |
| 2008-08-18 13:36 | gorka_gil | Note Added: 0008584 | |
| 2008-08-18 13:41 | svnbot | Checkin | |
| 2008-08-18 13:41 | svnbot | Note Added: 0008585 | |
| 2008-08-18 13:41 | svnbot | Status | scheduled => resolved |
| 2008-08-18 13:41 | svnbot | Resolution | open => fixed |
| 2008-08-18 13:41 | svnbot | svn_revision | => 6370 |
| 2008-09-03 23:05 | psarobe | Regression testing | => No |
| 2008-09-03 23:05 | psarobe | Status | resolved => closed |
| 2008-09-03 23:05 | psarobe | Fixed in Version | => 2.40 |
|
Notes |
|
|
|
|
Reminder sent to: gorka_gil
The 2.40 release is close. As soon as all the major bugs are closed, we are ready to release. This is why I'd ask you to prioritize this issue. |
|
|
|
|
The problem is in line 83 of M_PRICELIST_CREATE pl/sql function.
"...IF (v_PriceList_Version_Base_ID IS NULL OR v_PriceList_Version_Base_ID='') THEN..."
The problem occurs in postgres when tries to transform '' into number, the method to_number outputs the error: invalid input syntax for type numeric: """ |
|
|
|
(0008585)
|
|
svnbot
|
|
2008-08-18 13:41
|
|
Repository: openbravo
Revision: 6370
Author: gorka_gil
Date: 2008-08-18 13:41:42 +0200 (Mon, 18 Aug 2008)
Fixed bug 4602 Fix a problem of transformation to number in postgres in m_pricelist_create function
---
U trunk/src-db/database/model/functions/M_PRICELIST_CREATE.xml
---
https://dev.openbravo.com/websvn/openbravo/?rev=6370&sc=1 [^]
|
|