Hello everybody,I have an issue with OS Outsystems.I have a data connection to an external SQL database. It's working well ever since I started to work upon the module.
Usually, my tables have a single primary key (as for master data tables like tblProjetc or tblAssociate) or a double primary key (as for linking tables, like ctbl_Project_Associate).
Yesterday I incorporated a new SQL table in my module: ctbl_Supplier_Project_ProductionVariantNow, - for the first time - I have a table which contains a triple primary key: supplier_ID, project_ID and productionVariant_ID
The inclusion of this new table didn't show any issues.
But when I start to access that table, I get the following message:
Does anybody know how to deal with that? I hope that Outsystems does not have limitations on the number of primary keys in a table.
Thank you for your support. Very appreciated.
Best regards
Ingo
Hi Ingo Janas,
please refer this similar post related to the error you are getting.
Error - "The data model of your module is inconsistent with the database" | OutSystems
Thanks,
Sanjay Kushwah
Did you made sure that the new atribute you created on outsystems table matches the external table atributes?
Absolutely. This is how it looks like i nOS11:
And this is the corresponding table design in MSSMS:
Note that a UniqueIdentifier in MSSMS is technically a text. The data type assign to text in OS11 is working well all the other tables in my application.
Ok. At the moment I don't see what else could be, but I can point you to look at the following points:1 - In you outsystems table, have you previously changed the name of any atribute? If so, try to delete it and create a new one with the same name, then publish and see if it works.2 - Consider if in your case you need to create entity indexes, as it might be the case if you want to mantain the uniqueness of the attributes. You can have a more in depth look at this topic in the OS documentation regarding entity indexes: Here