How To: Turn off internal rules for CreateIndexType, CreateTableType, and ModifyDataType

Liquibase Enterprise throws failures and warnings for the following conditions in the Packager and Forecast operations:

• CreateIndexType -- Using the tablespace that doesn't exist check (Failure)

• Forecast: CreateTableType -- Using the tablespace that doesn't exist check (Failure)

• Warning: ModifyDataType statement with non-null value in column (Warning)

If you wish to disable any of these internal rules, add an entry in the daticaldb.properties file.

Instructions

1. In the DDB project repo, either add or modify a file called daticaldb.properties in the root directory.

2. The daticaldb.properties file may be included in your .gitignore file. If so, remove this change from .gitignore so that any changes to this file can be saved to the project.

3. Add a property in this file called internalRules.disabledDefaultRules

4. Valid values for this property include:

   • MODIFY_DATA_TYPE_CHECKER

   • CREATE_INDEX_CHECK_TABLESPACE_CHECKER

   • CREATE_TABLE_CHECK_TABLESPACE_CHECKER

5. Add any values to the string for the Forecast items you wish to disable. Values are comma-separated. Example:

   internalRules.disabledDefaultRules=MODIFY_DATA_TYPE_CHECKER,CREATE_INDEX_CHECK_TABLESPACE_CHECKER,CREATE_TABLE_CHECK_TABLESPACE_CHECKER

6. Check-in the changes to Git for your DDB project repo.

7. Run Packager to see the changes reflected for that operation and to update any artifacts to be used by Forecast.