Unable to set User Directory using the AdminUI : [Oracle] ORA-12899: value too large for column

Document ID : KB000045271
Last Modified Date : 14/02/2018
Show Technical Document Details

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."