Skip to main content

Reference

 

OutSystems

Database Integrity Suggestion Warning

Message
Inconsistent database table and entity definitions: Column <table>.<column> exists in database, but there is no corresponding attribute in entity '<entity>'
Cause
The entity definition, in your module, does not include the attribute associated with <column>. You deleted this attribute from entity, but OutSystems kept the corresponding column in the table. This inconsistency only occurs if the module has been published with the previous entity definition.
Recommendation

Do one of the following:

  • Drop column from the table, in the database, and publish the module again;
  • Add a new attribute to entity with the same name as column;
  • Ignore the warning.

Message
Inconsistent database table and entity definitions: 'Binary Data' column <table>.<column> exists in database, but there is no corresponding attribute in entity '<entity>'
Cause
The entity definition, in your module, does not include the attribute associated with column. You deleted this attribute from entity, but the OutSystems platform kept the corresponding column in the table. This inconsistency only occurs if the module has been published with the previous entity definition.
Recommendation

Do one of the following:

  • Drop column from the table, in the database, and publish the module again;
  • Add a new attribute to entity with the same name as column. In this situation, it is advisable that you don't ignore the warning to prevent runtime errors.

Message
Inconsistent database table and entity definitions: 'Auto Number' column <table>.<column> exists in database, but there is no corresponding attribute in entity '<entity>'
Cause
The entity definition, in your module, does not include the attribute associated with column. You deleted this attribute from entity, but the OutSystems platform kept the corresponding column in the table. This inconsistency only occurs if the module has been published with the previous entity definition.
Recommendation

Do one of the following:

  • Drop column from the table, in the database, and publish the module again;
  • Add a new attribute to entity with the same name as column. In this situation, it is advisable that you don't ignore the warning otherwise you won't be able to create another auto number attribute, since only one is allowed by the database.

Message
Column <entity>.<column> exist in the database with unknown / unsupported data type: <type>
Cause
You have an attribute with an unknown or unsupported data type.

Message
The table name of <entity> entity is not supported. You should change it, in the database, in order to prevent runtime errors
Cause
The physical table name of <entity> is not supported. This situation occurs if, for example, changes are made directly in the database and therefore the table name does not have the OS*_ prefix.
  • Was this article helpful?