Problem :
Trying to modify a User Directory adding more servers, then I get an error in the AdminUI. The Policy Server logs report also an error :
Pending error in smps.log :
[ERROR][sm-Server-03090] Policy store failed operation 'Save' for object type 'UserDirectory' .
Internal Error: DB Transport Error. Code is -4017 (DBMSG: <<<State = HY000 Internal Code = 12899 -
[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12899: value too large for column "SCHEMA"."SMUSERDIRECTORY5"."SERVER" (actual: 893, maximum: 512)>>>)
Environment:
ProductName=CA SiteMinder Policy Server
FullVersion=12.51.6.1315
OS= Windows 2008 R2 SP1 64-bit
Oracle DB as Policy Store.
Cause:
Value too long for the defined server names or IP's. By default we can put up to 512 chars only.
Resolution :
Increase the column accordingly. This is certified as per documentation:
https://docops.ca.com/ca-single-sign-on-12-52-sp1/en/troubleshooting/policy-store-troubleshooting#PolicyStoreTroubleshooting-ODBCPolicyStoreImportFailswithUserDirectoryError
"It is possible that the server name in the ODBC store's userDirectory object is longer than 512 characters, which by default, exceeds the limit allowed by the MS SQL Server and Oracle policy store schema scripts that are shipped with CA Single Sign-On."