Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004620 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 02. Master data management | major | always | 2008-08-13 18:57 | 2008-10-08 17:48 | |||
| Reporter | javiexpo1 | View Status | public | |||||
| Assigned To | gorka_gil | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.35MP9 | |||
| Status | closed | Fix in branch | 2.3x | Fixed in SCM revision | 6378 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Windows | Database | PostgreSQL | Java version | 1.5.0 | |||
| OS Version | XP | Database version | 8.2 | Ant version | 1.6.5 | |||
| Product Version | 2.35MP5 | SCM revision | ||||||
| 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 | 0004620: 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0008591) svnbot (viewer) 2008-08-18 15:22 |
Repository: openbravo Revision: 6378 Author: gorka_gil Date: 2008-08-18 15:22:46 +0200 (Mon, 18 Aug 2008) Fixed bug 4620 Fix a problem of transformation to number in postgres in m_pricelist_create function --- U branches/r2.3x/database/model/functions/M_PRICELIST_CREATE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=6378&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-08-13 18:57 | psarobe | New Issue | |
| 2008-08-13 18:57 | psarobe | Assigned To | => gorka_gil |
| 2008-08-13 18:57 | psarobe | Status | new => scheduled |
| 2008-08-18 15:22 | svnbot | Checkin | |
| 2008-08-18 15:22 | svnbot | Note Added: 0008591 | |
| 2008-08-18 15:22 | svnbot | Status | scheduled => resolved |
| 2008-08-18 15:22 | svnbot | Resolution | open => fixed |
| 2008-08-18 15:22 | svnbot | svn_revision | => 6378 |
| 2008-10-08 17:48 | psarobe | Regression testing | => No |
| 2008-10-08 17:48 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |