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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0038642
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2018-05-28 12:202018-06-15 10:41
ReporteralostaleView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision388783574ed6
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0038642: API change: removed ad_session_status table

DescriptionIn order to implement 0038629 FR, ad_session_status table will be removed in PostgreSQL.
Steps To Reproduce+++++++++++++++++++++++++++++++++++++++++++++++++++
  Errors in API model validation
+++++++++++++++++++++++++++++++++++++++++++++++++++
  Removed table: AD_SESSION_STATUS
  Removed function AD_ISTRIGGERENABLED -> False positive: still present, now implemented in pre-scripts


+++++++++++++++++++++++++++++++++++++++++++++++++++
  Errors in API data validation
+++++++++++++++++++++++++++++++++++++++++++++++++++
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD351EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD361EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD371EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD381EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD391EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD3A1EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD3B1EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD3C1EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD3D1EA1E040007F01002676
  Removed row from table AD_ELEMENT - ID: 5C7FF22CBB46A376E040007F01002783
  Removed row from table AD_ELEMENT - ID: 5C7FF22CBB48A376E040007F01002783
  Removed row from table AD_TABLE - ID: BBB7275AB448478885E0FB24AA4BCB0B

see https://ci.openbravo.com/view/try/job/try-api/6100/console [^]

Proposed SolutionThere is some risk of modules using directly this table:
* When enabling/disabling triggers from Java, now it is mandatory to do it through TriggerHandler class
* If enabling/disabling triggers from PL code, use ad_disable_triggers and ad_enable_triggers new PL functions
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks feature request 0038629 closedalostale do not use ad_session_status to disable PG triggers 

-  Notes
(0104744)
hgbot (developer)
2018-05-28 12:27

 Repository: erp/devel/api-checks
Changeset: 388783574ed6785d7af369a9ca96836b8e1a07de
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon May 28 12:27:23 2018 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/388783574ed6785d7af369a9ca96836b8e1a07de [^]

fixes 38642: API change: removed ad_session_status table

+++++++++++++++++++++++++++++++++++++++++++++++++++
  Errors in API model validation
+++++++++++++++++++++++++++++++++++++++++++++++++++
  Removed table: AD_SESSION_STATUS
  Removed function AD_ISTRIGGERENABLED -> False positive: still present, now implemented in pre-scripts


+++++++++++++++++++++++++++++++++++++++++++++++++++
  Errors in API data validation
+++++++++++++++++++++++++++++++++++++++++++++++++++
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD351EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD361EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD371EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD381EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD391EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD3A1EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD3B1EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD3C1EA1E040007F01002676
  Removed row from table AD_COLUMN - ID: 5C7FEB5FDD3D1EA1E040007F01002676
  Removed row from table AD_ELEMENT - ID: 5C7FF22CBB46A376E040007F01002783
  Removed row from table AD_ELEMENT - ID: 5C7FF22CBB48A376E040007F01002783
  Removed row from table AD_TABLE - ID: BBB7275AB448478885E0FB24AA4BCB0B

---
M java/reference/java.japi.gz
M model/src-db/database/sourcedata/AD_COLUMN.xml
M model/src-db/database/sourcedata/AD_ELEMENT.xml
M model/src-db/database/sourcedata/AD_TABLE.xml
R model/src-db/database/model/functions/AD_ISTRIGGERENABLED.xml
R model/src-db/database/model/tables/AD_SESSION_STATUS.xml
---

- Issue History
Date Modified Username Field Change
2018-05-28 12:20 alostale New Issue
2018-05-28 12:20 alostale Assigned To => platform
2018-05-28 12:20 alostale Modules => Core
2018-05-28 12:20 alostale Triggers an Emergency Pack => No
2018-05-28 12:25 alostale Relationship added blocks 0038629
2018-05-28 12:27 hgbot Checkin
2018-05-28 12:27 hgbot Note Added: 0104744
2018-05-28 12:27 hgbot Status new => resolved
2018-05-28 12:27 hgbot Resolution open => fixed
2018-05-28 12:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/388783574ed6785d7af369a9ca96836b8e1a07de [^]
2018-06-15 10:41 alostale Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker