Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024941Openbravo ERP05. Production managementpublic2013-10-14 18:402013-10-17 18:21
ReporterVictorVillar 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP29Fixed in Version3.0MP28 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024941: The cost calculation process fails after introducing a string in the Work Effort's document No.
DescriptionThe cost calculation process fails after introducing a string in the Work Effort's document No.
Steps To ReproduceAs group admin role,
Create a work effort with Document No = A10000141X
Process it and launch the costing background process.

Realise in the Process Monitor that the costing background process fails, with the following error:

java.lang.IllegalStateException: org.postgresql.util.PSQLException: ERROR: invalid input syntax for type numeric: "A10000141X"
Proposed SolutionDefine in a correct way the v_ProductionNo variable in the ma_production_cost


v_ProductionNo M_Production.DocumentNo%TYPE;
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff 0024941.diff (643) 2013-10-14 18:50
https://issues.openbravo.com/file_download.php?file_id=6448&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-10-14 18:40VictorVillarNew Issue
2013-10-14 18:40VictorVillarAssigned To => dmiguelez
2013-10-14 18:40VictorVillarModules => Core
2013-10-14 18:40VictorVillarResolution time => 1384470000
2013-10-14 18:40VictorVillarTriggers an Emergency Pack => No
2013-10-14 18:49VictorVillarProposed Solution updated
2013-10-14 18:50VictorVillarFile Added: 0024941.diff
2013-10-14 18:50VictorVillarAssigned Todmiguelez => jonalegriaesarte
2013-10-14 18:50VictorVillarIssue Monitored: networkb
2013-10-16 16:55hgbotCheckin
2013-10-16 16:55hgbotNote Added: 0061718
2013-10-16 16:55hgbotStatusnew => resolved
2013-10-16 16:55hgbotResolutionopen => fixed
2013-10-16 16:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/955bf27da7e31ab5cb26738e88f0f6d0841918c6 [^]
2013-10-16 17:31egoitzReview Assigned To => egoitz
2013-10-16 17:31egoitzStatusresolved => closed
2013-10-16 17:31egoitzFixed in Version => 3.0MP28
2013-10-17 18:21hudsonbotCheckin
2013-10-17 18:21hudsonbotNote Added: 0061775

Notes
(0061718)
hgbot   
2013-10-16 16:55   
Repository: erp/devel/pi
Changeset: 955bf27da7e31ab5cb26738e88f0f6d0841918c6
Author: Victor Villar <victor.villar <at> openbravo.com>
Date: Wed Oct 16 16:47:23 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/955bf27da7e31ab5cb26738e88f0f6d0841918c6 [^]

fixes issue 24941: The cost calculation process fails after introducing a string in the Work Effort's document No

---
M src-db/database/model/functions/MA_PRODUCTION_COST.xml
---
(0061775)
hudsonbot   
2013-10-17 18:21   
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/121b38a3673a [^]

Maturity status: Test