Bug ID 876393: General database error while creating Access Profile via the GUI

Last Modified: Jul 12, 2023

Affected Product(s):
BIG-IP APM(all modules)

Known Affected Versions:
15.1.0, 15.1.0.1

Fixed In:
16.0.0, 15.1.0.2

Opened: Feb 03, 2020

Severity: 2-Critical

Symptoms

While trying to create an Access profile, the GUI reports a general database error. There are errors in /var/log/tomcat: profiles.ProfileUtils$SettingsHandler:error - java.sql.SQLException: Column not found: SOURCE in statement [INSERT into profile_access

Impact

You are unable to create the profile using the GUI.

Conditions

This occurs when you try to create an Access Profile of type SSO from the GUI.

Workaround

You can create the Access Profile using TMSH. tmsh create access access_test_sso type sso accept-languages add { en } sso-name sso_test1

Fix Information

Access Profile of type SSO can now be created and edited from the GUI.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips