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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029853
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2015-05-12 16:232021-02-05 07:41
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in VersionPR21Q2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029853: ant validate.database fails in pi

Descriptionrunning 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.
Steps To Reproducepi - install.source
ant validate.database
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks feature request 0047036PR21Q3 closedshuehner Remove lots of obsolete support code for obsolete (update.database.mod, ezattributes module, dbmanager.jar references) 

-  Notes
(0125982)
hgbot (developer)
2021-02-04 17:24

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/303 [^]
(0126002)
hgbot (developer)
2021-02-05 07:29

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/303 [^]
(0126003)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2015-05-12 16:23 shuehner New Issue
2015-05-12 16:23 shuehner Assigned To => platform
2015-05-12 16:23 shuehner Modules => Core
2015-05-12 16:23 shuehner Triggers an Emergency Pack => No
2015-05-13 08:23 alostale Status new => acknowledged
2021-02-04 17:24 hgbot Note Added: 0125982
2021-02-05 07:29 hgbot Resolution open => fixed
2021-02-05 07:29 hgbot Status acknowledged => resolved
2021-02-05 07:29 hgbot Note Added: 0126002
2021-02-05 07:29 hgbot Fixed in Version => PR21Q2
2021-02-05 07:29 hgbot Note Added: 0126003
2021-02-05 07:34 alostale Assigned To platform => shuehner
2021-02-05 07:41 alostale Review Assigned To => alostale
2021-02-05 07:41 alostale Status resolved => closed
2021-06-09 15:12 shuehner Relationship added blocks 0047036


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker