Database integrity suggestion after switching to a previous version

Hi, I was trying (and failing) to upload a photo following those steps:

https://www.outsystems.com/forums/discussion/36927/how-to-upload-an-image-with-outsystems-beginner/

and as I experienced with the location of the photo, and got some issues in the database, I decided to go back to a previous version. 


However: switching back to this previous version resulted in Database Integrity Suggestion messages while uploading. I'm a bit surprised by this: When I switch back to a previous version I expect that the whole previous version will replace the whole currect version.

The integrity issues seems to be caused by my handling in the version that should have been replaced. The "previous version" that I uploaded had no issues whatsoever. 

2 suggestions:

- Inconsistent database table and entity definitions: column 'OSUSR_iqe_AssetType.ASSETTYPEICON' exists in database, but there is no cprresponding atttribute in entity 'AssetType'.

- Inconsistent database table and entity definitions: column 'OSUSR_iqe_AssetType.ASSETTYPEPHOTO' exists in database, but there is no cprresponding atttribute in entity 'AssetType'.


Where can I fix this? 

Solution

Hi Coen,

You got that error because your previous version (now is the new version) don't have those fields on table Asset but they are created on database in other version before:

Please see more info about the errors in Documentation: https://success.outsystems.com/Documentation/11/Reference/Errors_and_Warnings/Warnings/Database_Integrity_Suggestion_Warning

To fix this you need to delete those atributes from database. You can use DBCleaner https://www.outsystems.com/forge/component-overview/423/dbcleaner from Forge and clean it.

Click "Database Entities" button. Under attributes, system will display the problem entity column (Circle with blue color) and press "Drop" button.

Hope it helps!

BR,

Luis


Solution

Well, that truly was an easy thing to do. Tnx!!

Coen Hendrikx wrote:

Well, that truly was an easy thing to do. Tnx!!

Hi!

Yes it is ;)