Do one of the following: Drop column from the table, in the database, and publish the eSpace again; add a new attribute to entity with the same name as column ; or ignore the warning." How can I drop a column from the table in the database? Thanks for any help. Regards.
Hi all,
I renamed an attribute in one of the entities, and the result (after publishing the app) is an internal error.
In Service Studio I get the warning:
Database Integrity SuggestionInconsistent database table and entity definitions: column 'OSUSR_5ib_Medewerker3.NAME' exists in database, but there is no corresponding attribute in entity 'Medewerker'.
I will try to fix it with DBCleaner, don't know what else to do, but isn't this a serious bug in the OutSystems Platform? If it let me change the name of an attribute, it shouldn't result in any error situation at all???
I'm lost (but I'm a relative newbie :-)) ... I really didn't know how DBCleaner was going to help me out.
So, I deleted the entire app, re-installed it in my personal environment ... same error.
What caused the problem was renaming the attribute NAME to DISPLAYNAME. So I renamed it back to NAME, got the following warningmessage complaining about DISPLAYNAME now
Database Integrity SuggestionInconsistent database table and entity definitions: column 'OSUSR_5ib_Medewerker.DISPLAYNAME' exists in database, but there is no corresponding attribute in entity 'Medewerker'.
but publishing the app worked, running it didn't result in an internal error, however, my data is partially gone (the Name data).
I cannot imagine that, when developing and maintaining 'real' applications, changing an attribute name can or may result in problems like these. Did I do anything wrong, illegal whatever?
And, can somebody tell me how to get rid of this warning message?
Gonçalo Azambujo wrote:
Do one of the following: Drop column from the table, in the database, and publish the eSpace again; add a new attribute to entity with the same name as column ; or ignore the warning."How can I drop a column from the table in the database?Thanks for any help.Regards.
I'm also a newbie, testing Outsystems. I'm getting the same message, due to some database edits I made. I was going to try DB Cleaner, but when I went to install it I got a message that it is incompatible with my release of Outsystems. It looks like I could try it anyway, but I'm concerned it will only screw things up more. Suggestions? Thanks!
Hi JM Ackerman,
As you can read above in this post I was (and still am) experiencing the exact same thing. DB Cleaner didn't solve the problem for me. I think of it as a serious flaw in OutSystems, it really should be possible without warnings/errors to adjust the data model. I hope they'll fix it in one of the future releases, as soon as possible would be my suggestion. I guess we'll have to live with and ignore the warning as Gonçalo Azambujo suggests :-)
Hi,
Downloaded the DBCleaner stated by Izak Joubert.
After that run in my personal trial environment. Click "Database Entities" button. Under attributes, system will display the problem entity column (Circle with blue color) and press "Drop" button.
After that compile the project, there is no more error display.
Thank you Izak Joubert.
No meu caso a plataforma continua com o mesmo erro, mesmo utilizando o DBCleaner.
In my case the platform continues with the same error, even using DBCleaner.
HI.
Just use the "DB Cleaner on Steroids" to solve the problem. Its fine.