Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026233Openbravo ERP04. Warehouse managementpublic2014-04-10 01:172014-05-08 16:21
ReporterVictorVillar 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR14Q3Fixed in Version3.0PR14Q3 
Merge Request Status
Review Assigned Togorkaion
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket27604
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026233: It is not possible to migrate to the new costing server under some circumstancies
DescriptionIt is not possible to migrate to the new costing server under some circumstancies. If you have defined a Costing register with Ending date = 31/12/9999 for a product which has transactions, you can not migrate to the new costing engine using oracle.
Steps To ReproduceIt is not possible to migrate to the new costing server under some circumstancies. If you have defined a Costing register with Ending date = 31/12/9999 for a product which has transactions, you can not migrate to the new costing engine using oracle.

Please check the query in getLegacyCostScroll() method in CostingMigrationProcess.java:

    where.append(" and trx." + MaterialTransaction.PROPERTY_MOVEMENTDATE + " < (c."
        + Costing.PROPERTY_ENDINGDATE + " + 1) ");

when sum 1 day to the Ending date = 31/12/9999 --> an error appears:

Error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-04-10 01:17VictorVillarNew Issue
2014-04-10 01:17VictorVillarAssigned To => dmiguelez
2014-04-10 01:17VictorVillarModules => Core
2014-04-10 01:17VictorVillarOBNetwork customer => Yes
2014-04-10 01:17VictorVillarSupport ticket => 27604
2014-04-10 01:17VictorVillarResolution time => 1399586400
2014-04-10 01:17VictorVillarTriggers an Emergency Pack => No
2014-04-10 01:18VictorVillarIssue Monitored: networkb
2014-04-24 06:19dmiguelezAssigned Todmiguelez => jonalegriaesarte
2014-04-28 16:54jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2014-05-06 19:43eduardo_ArgalAssigned Topramakrishnan => eduardo_Argal
2014-05-06 19:43eduardo_ArgalStatusnew => scheduled
2014-05-06 19:43eduardo_Argalfix_in_branch => pi
2014-05-07 10:11hgbotCheckin
2014-05-07 10:11hgbotNote Added: 0066863
2014-05-07 10:11hgbotStatusscheduled => resolved
2014-05-07 10:11hgbotResolutionopen => fixed
2014-05-07 10:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/886a59579fd0485eee4114c6a4baee07a2875405 [^]
2014-05-07 18:12hudsonbotCheckin
2014-05-07 18:12hudsonbotNote Added: 0067004
2014-05-08 16:21gorkaionReview Assigned To => gorkaion
2014-05-08 16:21gorkaionNote Added: 0067028
2014-05-08 16:21gorkaionStatusresolved => closed
2014-05-08 16:21gorkaionFixed in Version => PR14Q3

Notes
(0066863)
hgbot   
2014-05-07 10:11   
Repository: erp/devel/pi
Changeset: 886a59579fd0485eee4114c6a4baee07a2875405
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed May 07 10:10:30 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/886a59579fd0485eee4114c6a4baee07a2875405 [^]

Fixes issue 26233: It is not possible to migrate to the new costing server

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0067004)
hudsonbot   
2014-05-07 18:12   
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/02ca2648bcdc [^]
Maturity status: Test
(0067028)
gorkaion   
2014-05-08 16:21   
Code reviewed