Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011021Openbravo ERPZ. Otherspublic2009-10-16 17:472009-10-23 00:01
Reportershuehner 
Assigned Toshuehner 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011021: API check build 173 fails with warnings
DescriptionThis api check builds fails:

http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/173/console [^]

This issue tracks the following WARNINGS:

  Non unique index addition table:MA_PROCESSPLAN_VERSION- Index: MA_PROCESSPLAN_VERSION_PPLAN
  Non unique index addition table:MA_SEQUENCE- Index: MA_SEUENCE_PROCESSPLAN_VERSION
  Non unique index addition table:MA_SEQUENCEPRODUCT- Index: MA_SEQUENCEPRODUCT_PROD_SEQ
  Non unique index addition table:MA_WRPHASE- Index: MA_WRPHASE_WORKREQUIREMENT
  Non unique index addition table:MA_WRPHASEPRODUCT- Index: MA_WRPHASEPRODUCT_PROD_PHASE
  Non unique index addition table:MRP_RUN_PRODUCTIONLINE- Index: MRP_PRODUCTIONLINE_ID_PROD_ID
  Non unique index addition table:MRP_RUN_PRODUCTIONLINE- Index: MRP_RUN_PRODUCTIONLINE_PARENT
  Non unique index addition table:MRP_RUN_PURCHASELINE- Index: MRP_RUN_PURHCLINE_PURCH_PROD
  Modified view MA_PROCESSPLAN_TOTALIZED
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00108782.40MP11 closed shuehner Manufacturing Plan process runs so slowly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-16 17:47shuehnerNew Issue
2009-10-16 17:47shuehnerAssigned To => shuehner
2009-10-16 17:50shuehnerNote Added: 0021127
2009-10-16 17:53shuehnerNote Edited: 0021127
2009-10-16 17:54shuehnerRelationship addedrelated to 0010878
2009-10-16 17:54shuehnerAssigned Toshuehner => pjuvara
2009-10-19 12:35pjuvaraStatusnew => scheduled
2009-10-19 12:35pjuvaraNote Added: 0021169
2009-10-19 12:35pjuvaraAssigned Topjuvara => shuehner
2009-10-19 12:35pjuvarafix_in_branch => pi
2009-10-19 13:06hgbotCheckin
2009-10-19 13:06hgbotNote Added: 0021176
2009-10-19 13:06hgbotStatusscheduled => resolved
2009-10-19 13:06hgbotResolutionopen => fixed
2009-10-19 13:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/debd8991d884b03dd908238bce04211dc7380897 [^]
2009-10-22 09:05psarobeStatusresolved => closed
2009-10-23 00:01anonymoussf_bug_id0 => 2884266

Notes
(0021127)
shuehner   
2009-10-16 17:50   
(edited on: 2009-10-16 17:53)
Two distinct topics. Both regarding warnings only, as the api check cannot decide on its own:

- Addition on non-unique indices:
 I cannot see a possible issue with these ones and we are re-checking in the platform team why we decided to add a warning for these case.

- Modified view:
The view definition was simplified to achieve a better runtime performance. The output of the view should be identical in structure and data compared to before the change.

Proposal: Ack both as false positive, no need to issue a note
(0021169)
pjuvara   
2009-10-19 12:35   
Agreed. False positive.
(0021176)
hgbot   
2009-10-19 13:06   
Repository: erp/devel/api-checks
Changeset: debd8991d884b03dd908238bce04211dc7380897
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Oct 19 13:05:59 2009 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/debd8991d884b03dd908238bce04211dc7380897 [^]

Fixed 11021: Acknowledge change as false positive
- View output columns and output data is unchanged
- New non-unique indexes are not an api change

---
M model/model/tables/MA_PROCESSPLAN_VERSION.xml
M model/model/tables/MA_SEQUENCE.xml
M model/model/tables/MA_SEQUENCEPRODUCT.xml
M model/model/tables/MA_WRPHASE.xml
M model/model/tables/MA_WRPHASEPRODUCT.xml
M model/model/tables/MRP_RUN_PRODUCTIONLINE.xml
M model/model/tables/MRP_RUN_PURCHASELINE.xml
M model/model/views/MA_PROCESSPLAN_TOTALIZED.xml
---