Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0057578Openbravo ERPA. Platformpublic2025-01-07 16:232025-01-09 16:49
ignacio_deandres 
ignacio_deandres 
normalmajorhave not tried
closedfixed 
5
 
main 
approved
OBPS
Core
No
0057578: [API Change] Add check constraints in some tables
 [checkAPI] 5924 [main] ERROR org.openbravo.ddlutils.task.CheckAPIDistribution - +++++++++++++++++++++++++++++++++++++++++++++++++++
 [checkAPI] 5924 [main] ERROR org.openbravo.ddlutils.task.CheckAPIDistribution - Errors in API model validation
 [checkAPI] 5924 [main] ERROR org.openbravo.ddlutils.task.CheckAPIDistribution - +++++++++++++++++++++++++++++++++++++++++++++++++++
 [checkAPI] 5925 [main] ERROR org.openbravo.ddlutils.task.CheckAPIDistribution - Check Constraint addition: table: AD_CLIENTINFO - Constraint: AD_CLIENTINFO_RSTPWD_CH defined as: ENABLE_RESET_PASSWORD_BY_EMAIL IN ('Y', 'N')
 [checkAPI] 5925 [main] ERROR org.openbravo.ddlutils.task.CheckAPIDistribution - Check Constraint addition: table: AD_USER_PWD_RESET_TOKEN - Constraint: AD_USR_PWD_RST_TK_ISACTIVE_CH defined as: ISACTIVE IN ('Y', 'N')
 [checkAPI] 5925 [main] ERROR org.openbravo.ddlutils.task.CheckAPIDistribution - Check Constraint addition: table: AD_USER_PWD_RESET_TOKEN - Constraint: AD_USR_PWD_RST_TK_REDEEMED_CH defined as: REDEEMED IN ('Y', 'N')
 [checkAPI] 5925 [main] ERROR org.openbravo.ddlutils.task.CheckAPIDistribution - Check Constraint addition: table: C_EMAIL_TYPE - Constraint: C_EMAIL_TYPE_ISACTIVE_CH defined as: ISACTIVE IN ('Y', 'N')
Send it to try - backoffice without having the backoffice-api repo with the proper changes.
Add the same changes done in the original repo to the backoffice-api one.
No tags attached.
blocks defect 0057571main closed ignacio_deandres Audit fixes for the Forgot password development 
Issue History
2025-01-07 16:23ignacio_deandresNew Issue
2025-01-07 16:23ignacio_deandresAssigned To => ignacio_deandres
2025-01-07 16:23ignacio_deandresOBNetwork customer => No
2025-01-07 16:23ignacio_deandresModules => Core
2025-01-07 16:23ignacio_deandresTriggers an Emergency Pack => No
2025-01-07 16:41hgbotMerge Request Status => open
2025-01-07 16:41hgbotNote Added: 0173875
2025-01-07 17:09adrianromeroOBNetwork customerNo => OBPS
2025-01-07 17:09adrianromeroStatusnew => scheduled
2025-01-09 16:47hgbotMerge Request Statusopen => approved
2025-01-09 16:48adrianromeroRelationship addedblocks 0057571
2025-01-09 16:49hgbotResolutionopen => fixed
2025-01-09 16:49hgbotStatusscheduled => closed
2025-01-09 16:49hgbotNote Added: 0173960
2025-01-09 16:49hgbotNote Added: 0173961

Notes
(0173875)
hgbot   
2025-01-07 16:41   
Merge Request created: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/93 [^]
(0173960)
hgbot   
2025-01-09 16:49   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: 4e80bb7d5ed81e7b2adfc78893fa8615f2a681ec
Author: Ignacio De Andrés <i.deandres@orisha.com>
Date: 07-01-2025 16:31:51
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/4e80bb7d5ed81e7b2adfc78893fa8615f2a681ec [^]

FIXES ISSUE-57578: Added missing check constraints for the boolean columns

---
M model/src-db/database/model/tables/AD_CLIENTINFO.xml
M model/src-db/database/model/tables/AD_USER_PWD_RESET_TOKEN.xml
M model/src-db/database/model/tables/C_EMAIL_TYPE.xml
---
(0173961)
hgbot   
2025-01-09 16:49   
Merge request merged: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/93 [^]