Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0029853Openbravo ERPA. Platformpublic2015-05-12 16:232021-02-05 07:41
shuehner 
shuehner 
normalminorhave not tried
closedfixed 
5
 
PR21Q2 
alostale
Core
No
0029853: ant validate.database fails in pi
running that command shows several errors.

Checking them looks like when adding computedColumns feature to core it was forgotten to exclude those from this check.

Note: As that has been not noticed until now, means probably that this test is not run during normal 'ant run.all.tests'

That should be checked and maybe added as well

[validateDatabase] 18477 [main] WARN SystemValidation - +++++++++++++++++++++++++++++++++++++++++++++++++++
[validateDatabase] 18479 [main] WARN SystemValidation - Warnings for Validation type: NOT_PART_OF_FOREIGN_KEY
[validateDatabase] 18480 [main] WARN SystemValidation - +++++++++++++++++++++++++++++++++++++++++++++++++++
[validateDatabase] 18482 [main] WARN SystemValidation - Foreign Key Column C_ORDER._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18483 [main] WARN SystemValidation - Foreign Key Column C_PERIOD._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18484 [main] WARN SystemValidation - Foreign Key Column FIN_DOUBTFUL_DEBT._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18485 [main] WARN SystemValidation - Foreign Key Column FIN_FINANCIAL_ACCOUNT._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18486 [main] WARN SystemValidation - Foreign Key Column FIN_PAYMENT_PROPOSAL._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18487 [main] WARN SystemValidation - Foreign Key Column FIN_PAYMENT_SCHEDULE._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18488 [main] WARN SystemValidation - Foreign Key Column FIN_RECONCILIATION._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18489 [main] WARN SystemValidation - Foreign Key Column MA_WORKREQUIREMENT._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18490 [main] WARN SystemValidation - Foreign Key Column M_INOUT._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18491 [main] WARN SystemValidation - Foreign Key Column M_TRANSACTION._computedColumns is not part of a foreign key constraint.
[validateDatabase] 18492 [main] WARN SystemValidation - Foreign Key Column S_TIMEEXPENSE._computedColumns is not part of a foreign key constraint.
pi - install.source
ant validate.database
No tags attached.
blocks feature request 0047036PR21Q3 closed shuehner Remove lots of obsolete support code for obsolete (update.database.mod, ezattributes module, dbmanager.jar references) 
Issue History
2015-05-12 16:23shuehnerNew Issue
2015-05-12 16:23shuehnerAssigned To => platform
2015-05-12 16:23shuehnerModules => Core
2015-05-12 16:23shuehnerTriggers an Emergency Pack => No
2015-05-13 08:23alostaleStatusnew => acknowledged
2021-02-04 17:24hgbotNote Added: 0125982
2021-02-05 07:29hgbotResolutionopen => fixed
2021-02-05 07:29hgbotStatusacknowledged => resolved
2021-02-05 07:29hgbotNote Added: 0126002
2021-02-05 07:29hgbotFixed in Version => PR21Q2
2021-02-05 07:29hgbotNote Added: 0126003
2021-02-05 07:34alostaleAssigned Toplatform => shuehner
2021-02-05 07:41alostaleReview Assigned To => alostale
2021-02-05 07:41alostaleStatusresolved => closed
2021-06-09 15:12shuehnerRelationship addedblocks 0047036

Notes
(0125982)
hgbot   
2021-02-04 17:24   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/303 [^]
(0126002)
hgbot   
2021-02-05 07:29   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/303 [^]
(0126003)
hgbot   
2021-02-05 07:29   
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 2415c89e293c31ade8337b24a9ee2623cfb85b49
Author: Stefan Huehner <stefan.huehner@openbravo.com>
Date: 2021-02-04T16:14:51+01:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/2415c89e293c31ade8337b24a9ee2623cfb85b49 [^]

Fixes ISSUE-29853. Remove ant validate.database (broken since before 2015)

This task does not work cleanly since at least since 2015. The validations
done (implemented in DatabaseValidator) are also executed during ExportDatabase
(for the module being exported) so no functionality is actually lost.

---
M build.xml
M src/build.xml
M src/org/openbravo/service/system/SystemValidationTask.java
---