Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002734Openbravo ERP05. Production managementpublic2008-03-19 15:482008-07-08 17:14
Reportercarbonete 
Assigned Topheenan 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40beta 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002734: Calculate Standard Cost Error
DescriptionOpenbravo R2.35 MP1
Path : Production Management || Transactions || Calculate Standard Costs
Database : Postgresql

Enter this option, leave fields in blank and click OK. You receive this error message

Error:
ERROR: invalid input syntax for type numeric: "P0001"
    
Thanks

Carbonete
    
Steps To Reproduce
Proposed Solution
Additional Information
TagsPostgreSQL
Relationships
depends on backport 0003693 closed pheenan Calculate Standard Cost Error 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-04 18:10plujanTag Attached: PostgreSQL
2008-07-08 17:14psarobeStatusresolved => closed
2008-07-08 17:14psarobeFixed in Version2.40alpha-r2 => 2.40beta

Notes
(0006323)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1919682 [^]
(0003348)
pheenan   
2008-04-28 11:31   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1883435
Originator: NO

Running under 2.3x process returns WARNING message in Postgres and SUCCESS message in Oracle.
(0003349)
pheenan   
2008-04-28 18:00   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1883435
Originator: NO

Fixed in revision 3872. Added extra validation so Postgres picks up the empty string. Unable to duplicate error message "P0001".