Updating the DB hostname in DB; adding user store connections in SiteMinder SSO and IDM

Products

• CA Identity Suite

Issue/Introduction

We have increased the number of user directory LDAP connections in SiteMinderSSO and we are trying to update the information in the IDM DB, however we got the error of hostname is being truncated error.

We are wondering how you can assist in making the best decision in term of solution. This is what we are doing below:

 update [IMObject].[dbo].[IM_DIR_CONNECTION]
  set HOSTNAME=dirname3:389 dirname4:389 dirname4:389 dirname3:389,dirname3:389 dirname4:389 dirname4:389 dirname3:389,dirname3:389 dirname4:389 dirname4:389 dirname3:389,dirname3:389 dirname4:389 dirname4:389 dirname3:389,dirname3:389 dirname4:389 dirname4:389 dirname3:389,dirname3:389 dirname4:389 dirname4:389 dirname3:389,dirname3:389 dirname4:389 dirname4:389 dirname3:389,dirname3:389 dirname4:389 dirname4:389 dirname3:389'

  where UNIQUE_NAME='28'

 

 

Resolution

We don't really support updating the IM object store directly in the database. The supported way of modifying the configuration is by exporting the directory.xml from the management console (/iam/immanage) editing it as needed, and re-importing it.

On the IDM side, you can add additional ldap connections you created in Siteminder. However, there is a size limit to the HOSTNAME value which is why you are getting the truncated error, but there is no need to add as many ldap connections as in the above example. Try adding just a few additional connections if your intention is to improve performance.