Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028823Openbravo ERP04. Warehouse managementpublic2015-01-30 13:152015-02-02 16:36
ReporterSandrahuguet 
Assigned ToSandrahuguet 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028823: API Change Request on performance c_order_post
DescriptionRelated to issue 27160: C_Order_Post poor performance

* API Break due to AD_EXTENSION_POINTS.DESCRIPTION column size changed from 255 to 2000

* API Break due to in table: M_STOCK_PROPOSED removed Foreign Key: AD_PINSTANCE_MSTOCKPROPOSED

Risk api-changes:
AD_PINSTANCE_MSTOCKPROPOSED column can store items that are not pinstance column, modules that use this column should be reviewed and updated. For example retail and pickinglist.
Steps To ReproduceLook at:
https://ci.openbravo.com/job/try-api/1235/consoleFull [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-01-30 13:15SandrahuguetNew Issue
2015-01-30 13:15SandrahuguetAssigned To => dmitry_mezentsev
2015-01-30 13:15SandrahuguetOBNetwork customer => No
2015-01-30 13:15SandrahuguetModules => Core
2015-01-30 13:15SandrahuguetTriggers an Emergency Pack => No
2015-01-30 14:29dmitry_mezentsevNote Added: 0073952
2015-01-30 14:30dmitry_mezentsevAssigned Todmitry_mezentsev => Sandrahuguet
2015-02-02 12:30hgbotCheckin
2015-02-02 12:30hgbotNote Added: 0073982
2015-02-02 12:30hgbotStatusnew => resolved
2015-02-02 12:30hgbotResolutionopen => fixed
2015-02-02 12:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/0ebb2a3181e5569dcd8149c94d43c417e63a36e2 [^]
2015-02-02 12:49SandrahuguetDescription Updatedbug_revision_view_page.php?rev_id=7575#r7575
2015-02-02 16:36umartirenaReview Assigned To => umartirena
2015-02-02 16:36umartirenaNote Added: 0073992
2015-02-02 16:36umartirenaStatusresolved => closed
2015-02-02 16:36umartirenaFixed in Version => pi

Notes
(0073952)
dmitry_mezentsev   
2015-01-30 14:29   
Accepted.

Sandra,
Could you explain in the API change description in the wiki the reason we decided to go for it instead of "workarounding" it please.
(0073982)
hgbot   
2015-02-02 12:30   
Repository: erp/devel/api-checks
Changeset: 0ebb2a3181e5569dcd8149c94d43c417e63a36e2
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon Feb 02 12:27:30 2015 +0100
URL: http://code.openbravo.com/erp/devel/api-checks/rev/0ebb2a3181e5569dcd8149c94d43c417e63a36e2 [^]

Fixes issue 28823: API Change Request on performance c_order_post

---
M java/reference/java.japi.gz
M model/src-db/database/model/tables/AD_EXTENSION_POINTS.xml
M model/src-db/database/model/tables/M_STOCK_PROPOSED.xml
---
(0073992)
umartirena   
2015-02-02 16:36   
Code Review OK