LCFS - Admin User Saving gives null error in Production

[AlexZorkin]

Description
Address the “User Admin Saving” bug that occurs when attempting to save role changes on a user in Production. The error message indicates the database receives a None value for user_profile_id, triggering a null-value constraint failure.

https://lcfs-prod.apps.silver.devops.gov.bc.ca/login

Purpose
Ensure successful role changes for users in the admin interface without encountering null-value errors. Guarantee that role updates in Production align with database constraints and do not halt the save operation.

Acceptance Criteria

• Investigate code paths that set user_profile_id to None during a role change.
• Update logic or schema to handle null values correctly, or ensure a valid integer is always provided.
• Validate that user role changes no longer produce errors in Production.

Additional context

• The issue surfaces as an autoflush error in SQLAlchemy when user_profile_id is unexpectedly null.
• Production logs confirm that role change attempts fail due to the disallowed null value.
• A thorough review of role update flows will help prevent similar bugs in the future.

[Grulin]

Still getting an error message here when trying to change roles in the PROD environment for an IDIR user. Please see screenshot for error message: