0007346: Solve inconsistency: nullable db-columns which have mandatory to Y in the Application Dictionary

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0007346

Openbravo ERP

A. Platform

public

2009-02-03 17:09

2022-02-01 08:08

Reporter

mtaal

Assigned To

Triage Platform Base

Priority

high

Severity

major

Reproducibility

have not tried

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0007346: Solve inconsistency: nullable db-columns which have mandatory to Y in the Application Dictionary

Description

In the 2.60 clean up project the following inconsistency needs to be solved:

There is a validate.database task which checks the database for inconsistencies. One of the checks is for nullable database columns which are defined as mandatory in the Application Dictionary.

The check is there, but disabled in the org.openbravo.service.system.DatabaseValidator. See these lines:
    // disabled this check, will be done in 2.60
    if (false) {
      if (property != null && property.isMandatory() && !dbColumn.isRequired()) {
        result.addWarning(SystemValidationType.MANDATORY_IN_AD_NULLABLE_IN_DB, "Column "
            + dbTable.getName() + "." + dbColumn.getName()
            + " is not-required (null-allowed) but in the Application Dictonary"
            + " it is set as mandatory");
      }
    }

Steps To Reproduce

Proposed Solution

Additional Information