30.12 Troubleshooting User Attribute Retrieval and Transformation

This section discusses how to troubleshoot any issue occurred in User Attribute Retrieval and Transformation feature.

30.12.1 No Value Is Fetched from Attribute Source in Identity Server

In Identity Server, no Attribute Source value is fetched from the data source. However, the test functionality fetches the data and displays the correct result in Administration Console.

To troubleshoot this issue, check the error logs for any Data Source connection issues.

  • Linux: /opt/novell/nam/logs/idp/tomcat/catalina.out

  • Windows: \Program Files (x86)\Novell\Tomcat\logs\stdout.log

If the Data Source is a database, ensure that the driver jars are available in both Identity Server and Administration Console. If the Data Source is a secure LDAP connection, ensure that SSL certificate of the LDAP directory is imported in Identity Server’s trust store. Update all Identity Servers.

30.12.2 Error Message While Testing a Database Connection

Error 1:

While testing a database connection, if the error message displays: "Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept JDBC URL.....", then the issue can be due to the format of the specified URL.

To troubleshoot this issue, specify a correct format of the JDBC URL. You can refer to the example specified in the Edit Data Source interface.

Error 2:

While testing a database connection, if the error message displays: “driverClassName specified class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' could not be loaded”, or “driverClassName specified class 'oracle.jdbc.driver.OracleDrive' could not be loaded”, then the issue is with the respective drivers.

To troubleshoot this issue, add the corresponding database drivers in Administration Console and Identity Server respectively. Restart Administration Console and Identity Server.

Error 3:

While testing a data source connection, if the error message displays: "Exception during pool initialization", then the issue can be with the incorrect SID specified in the database URL or due to incorrect port or hostname.

To troubleshoot this issue, check the error logs for any data source connection issues:

  • Linux: /opt/novell/nam/logs/adminconsole/tomcat/catalina.out

  • Windows: \Program Files (x86)\Novell\Tomcat\logs\stdout.log

30.12.3 Regex Replace Error Message

While performing a regex replace function, if you specify /a, then, the following error message displays:

  • On Firefox browser: Incorrect syntax : invalid regular expression flag a

  • On Chrome browser: Incorrect syntax : Invalid flags supplied to RegExp constructor 'a'

To troubleshoot this issue, ensure that you specify a correct regular expression. For example: i (case insensitive), g (global search) are valid flags. A regular expression has the following format:

/pattern/modifiers. Example: var patt = /abc/i. Where, /abc/i is a regular expression and abc is a pattern (used in the search). i is a modifier (modifies the search to be case-insensitive).