Database integrity - inconsistente database table and entity definitions

Hi,

when I publish a brank module (data model module) I receive the following information:

This message begun to happen since I deleted an atribute (Budget) from the Entity Expense.

Could you pease help me to fix this problem.

Thank you,

Luis



Hi LHHB,

This is hapening because when you create any entity and publish it. After that if you remove any attribute that time outsystems does not removes that column from the actual database table (which outsystems creates/ manages for your entity). This is done so that data which you have in your attribute is not lost and you can recover it (like for example if you rollback to previous version).

Here is a link where you can find details of this warning.

https://success.outsystems.com/Documentation/11/Reference/Errors_and_Warnings/Warnings/Database_Integrity_Suggestion_Warning

You can use this forge component if you want to delete this column from the database table in order to remove this warning

https://www.outsystems.com/forge/component-overview/423/dbcleaner