Previous Topic: SSL initialization failed: error -8174 (security library: bad database.)

Next Topic: OneView Monitor Troubleshooting

ODBC Policy Store Import Fails with UserDirectory Error

Symptom:

I receive an error message stating that the policy store failed operation "save" for object type "UserDirectory" when importing policy store data into an ODBC policy store.

Solution:

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

Do one of the following:

If you are trying to import policy data into a supported version of a MS SQL Server policy store:

  1. Open sm_mssql_ps.sql.

    Note: This schema script is located in policy_server_home\db\SQL.

  2. Search for the following text:

    CREATE TABLE smuserdirectory5

  3. Modify "server smstringreq512N," to one of the following depending on your needs:
  4. Re-import the policy store schema into the policy store.
  5. Import the policy store data.

If you are trying to import policy data into a supported version of an Oracle policy store:

  1. Open sm_oracle_ps.sql.

    Note: This schema script is located in policy_server_home\db\SQL.

  2. Search for the following text:

    CREATE TABLE smuserdirectory5

  3. Modify "server VARCHAR2(512) NOT NULL," to one of the following depending on your needs:
  4. Re-import the policy store schema into the policy store.
  5. Import the policy store data.


Copyright © 2010 CA. All rights reserved. Email CA about this topic