May we seek assistance regarding an issue encountered by our client. They are unable to add a record in the database entities, even when using an admin account. Please see the attached screenshots for your reference. For context this is an on-premise deployment.
Notably, no errors are shown in the logs.
Hi @Jared.Amul ,
In on-premise OutSystems environments, database access is governed by the database catalog user (DB user), not just the application’s logic or UI role-based permissions. So even admin-level roles in the app don’t guarantee insert access to a specific entity unless:1.The database catalog user has insert permissions on that entity.2.The app is properly configured to allow data manipulation at the entity level
Try this:1.Check Entity Settings Service Center > Factory > Entities and search for the System entity.
Make sure:
The entity is allowed to add/update data (not read-only).
It's not marked as Private if other modules need to access it.
2. Check Database Permissions
The error likely means the database user used by OutSystems (like OSRuntimeUser) doesn't have permission to insert data into the System table.
To fix this, run this SQL command in your database:GRANT INSERT ON [YourSchema].[OSUSR_XXXX_SYSTEM] TO [OSRuntimeUser];
Hope it help you.Thanks