Issue
When attempting to create an object in a controller, Continuum throws the error:
"Unable to insert row in Database Table."
Product Line
Andover Continuum
Environment
- SQL
- CyberStation
Cause
This issue typically occurs when a new database user is created with restricted permissions.
During Continuum DB initialization, the system creates the Andover97 user in SQL and assigns essential database access permissions. If these permissions are restricted or modified, it can impair routine operations such as object creation.
Resolution
To resolve this issue:
- Verify SQL Permissions for the Andover97 user.
- Ensure the following permissions are granted:
- INSERT, UPDATE, DELETE, and SELECT on relevant tables.
- Access to stored procedures used by CyberStation.
- If permissions were altered, restore them to default or re-run the DB initialization to reapply correct settings.
Additional Notes
- This issue is commonly seen after database migrations or security audits where user permissions are tightened.
- Always validate user roles and permissions post-deployment to avoid operational disruptions.
