914
Views
10
Comments
Database Integrity Suggestion  Inconsistent database table and entity definitions

Hello, 


I renamed two variables and every time I see these warnings: 


Database Integrity Suggestion

Inconsistent database table and entity definitions: column 'OSUSR_x8w_ToDo.PRIORITYIDENTIFIER' exists in database, but there is no corresponding attribute in entity 'ToDo'.


Database Integrity Suggestion

Inconsistent database table and entity definitions: column 'OSUSR_x8w_ToDo.CATEGORYIDENTIFIER' exists in database, but there is no corresponding attribute in entity 'ToDo'.


is there a easy way to solve this in a personal enviroment ?  


I tried dbcleaner but there I cannot find the entity todo with as parts categoryIndentifier and proiorityItendetifier 

2021-09-06 15-09-53
Dorine Boudry
 
MVP

Hi Roelof,


you can use DB Cleaner (the database section) to drop unused columns from tables.


Dorine

2019-05-22 11-30-09
Marcelo Ferreira

Hi Roelof,

You can use this component. Install it on your environment. After that open in browser and go to Database Entities tab. At the bottom of that page you will see a list with title attributes with a button "Drop All" below. The list should show those attributes you are getting warnings and if you want to delete them just click the button.

Regards,

Marcelo

2023-02-15 11-07-55
Evelyn Silva

It worked perfectly for me. The warnings disappeared, although I could only ignore them. Thanks 

2019-09-16 10-37-22
Roelof Wobben

Like I said I tried taht but see onlly this 



so nothing about todo and the parts or do I something not good 

2019-05-22 11-30-09
Marcelo Ferreira

Hi,

If you scroll down that page what you have on the other table with tittle attributes?

Regards,

Marcelo

2019-09-16 10-37-22
Roelof Wobben

nothing this is all I see


2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Your screen shot shows a scroll bars on the right at the bottom of the page are the deleted fields.

You need to scroll down that page.

Or else you just ignore the messages, those are not error messages.

2019-09-16 10-37-22
Roelof Wobben

I think I did something terrible wrong because I do now only see this : 



but still  I see the info messages

2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Ok, slow done, there is nothing going terrible wrong. As you say it are only informational messages.

So whatever you are coding, contiunue with it, If I understand correctly you are learning OutSystems right now with the training material. Just continue with that. At this stage I wouldn't worry about those messages.


2026-01-19 17-09-56
Carlos Lessa
 
MVP

Roelof Wobben wrote:

Hello, 


I renamed two variables and every time I see these warnings: 


Database Integrity Suggestion

Inconsistent database table and entity definitions: column 'OSUSR_x8w_ToDo.PRIORITYIDENTIFIER' exists in database, but there is no corresponding attribute in entity 'ToDo'.


Database Integrity Suggestion

Inconsistent database table and entity definitions: column 'OSUSR_x8w_ToDo.CATEGORYIDENTIFIER' exists in database, but there is no corresponding attribute in entity 'ToDo'.


is there a easy way to solve this in a personal enviroment ?  


I tried dbcleaner but there I cannot find the entity todo with as parts categoryIndentifier and proiorityItendetifier 

Good evening Roelof Wobben,

Here is a suggestion of how you can deal if these warnings:

"You deleted this attribute from an 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."

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

Hope I could help you, good luck.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.