Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0038642Openbravo ERPA. Platformpublic2018-05-28 12:202018-06-15 10:41
alostale 
platform 
normalmajorhave not tried
closedfixed 
5
 
 
Core
No
0038642: API change: removed ad_session_status table
In order to implement 0038629 FR, ad_session_status table will be removed in PostgreSQL.
+++++++++++++++++++++++++++++++++++++++++++++++++++
  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 [^]

There 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
No tags attached.
blocks feature request 0038629 closed alostale do not use ad_session_status to disable PG triggers 
Issue History
2018-05-28 12:20alostaleNew Issue
2018-05-28 12:20alostaleAssigned To => platform
2018-05-28 12:20alostaleModules => Core
2018-05-28 12:20alostaleTriggers an Emergency Pack => No
2018-05-28 12:25alostaleRelationship addedblocks 0038629
2018-05-28 12:27hgbotCheckin
2018-05-28 12:27hgbotNote Added: 0104744
2018-05-28 12:27hgbotStatusnew => resolved
2018-05-28 12:27hgbotResolutionopen => fixed
2018-05-28 12:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/388783574ed6785d7af369a9ca96836b8e1a07de [^]
2018-06-15 10:41alostaleStatusresolved => closed

Notes
(0104744)
hgbot   
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
---