Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024941
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementmajoralways2013-10-14 18:402013-10-17 18:21
ReporterVictorVillarView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityurgentResolutionfixedFixed in Version3.0MP28
StatusclosedFix in branchFixed in SCM revision955bf27da7e3
ProjectionnoneETAnoneTarget Version3.0MP29
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket23978
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0024941: 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;
TagsNo tags attached.
Attached Filesdiff file icon 0024941.diff [^] (643 bytes) 2013-10-14 18:50 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0061718)
hgbot (developer)
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 (viewer)
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

- Issue History
Date Modified Username Field Change
2013-10-14 18:40 VictorVillar New Issue
2013-10-14 18:40 VictorVillar Assigned To => dmiguelez
2013-10-14 18:40 VictorVillar Modules => Core
2013-10-14 18:40 VictorVillar OBNetwork customer => Yes
2013-10-14 18:40 VictorVillar Support ticket => 23978
2013-10-14 18:40 VictorVillar Resolution time => 1384470000
2013-10-14 18:40 VictorVillar Triggers an Emergency Pack => No
2013-10-14 18:49 VictorVillar Proposed Solution updated
2013-10-14 18:50 VictorVillar File Added: 0024941.diff
2013-10-14 18:50 VictorVillar Assigned To dmiguelez => jonalegriaesarte
2013-10-14 18:50 VictorVillar Issue Monitored: networkb
2013-10-16 16:55 hgbot Checkin
2013-10-16 16:55 hgbot Note Added: 0061718
2013-10-16 16:55 hgbot Status new => resolved
2013-10-16 16:55 hgbot Resolution open => fixed
2013-10-16 16:55 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/955bf27da7e31ab5cb26738e88f0f6d0841918c6 [^]
2013-10-16 17:31 egoitz Review Assigned To => egoitz
2013-10-16 17:31 egoitz Status resolved => closed
2013-10-16 17:31 egoitz Fixed in Version => 3.0MP28
2013-10-17 18:21 hudsonbot Checkin
2013-10-17 18:21 hudsonbot Note Added: 0061775

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker