Skip to Content

Analyzing Database Connection Problems.

This document is just a compiled list of most common connection problems.

Following next steps might save you a lot of troubles.

Resolving connection issues on machine where the IDM console is installed.

1. Check if the certain database client application is installed on same machine where the IDM is installed and access to the database server is granted (especially if you are using Oracle DB);

2. Check if client version (i.e. 32bit or 64bit) is compatible with installed IDM version.

3. Check if proper OLEDB provider was installed on same machine where the IDM is installed (especially if you are using Oracle DB);

4. Check if OLEDB provider version (i.e. 32bit or 64bit) is compatible with current IDM version.

5. Check if proper JAVA SDK version is installed according to installed IDM version documentation (i.e. 32bit or 64bit). It should be JAVA SDK version JAVA RT version will not be sufficient.

6. Do not forget to set the JAVA class path in IDM configuration to point to a proper JAVA SDK installation.

7. Depending on JAVA SDK installation version and type and DB type version and installation please configure IDM to point to a proper JDBC driver version.

8. If you are running any firewalls – check connection type, port and application availability on each machine (client & server);

9. If in your connection string you are using the short host name (i.e. only “hostname” from “hostname.company.com”), than first try to replace it with full host name, and if this still doesn’t help replace it with IP address of the host.

10. After each change please rebuild the dispatches scripts, stop all dispatchers, uninstall all dispatchers, install all dispatchers again and start all dispatchers. If you don’t follow this steps your changes may not be applied properly, so all your following tests might be performed with inconsistent DB connection configuration and at certain point of time some or all of them might stop working.

Resolving connection issues on remote dispatchers.

1. Follow the steps 1 through 9 from previous topic.

2. Change the path in the dispatcher configuration according changes you’ve made in previous step.

3. After the changes try to start the dispatcher in test mode with check configuration option.

4. If previous step were successful continue with next step, but if it failed analyze the error and return to step 1 or 2.

5. Now try to run the dispatcher in test mode.

6. If previous step were successful continue with next step, but if it failed some settings are still wrong or some of prerequisites are missing so return to step 1.

7. Stop the dispatcher, uninstall the dispatcher, install the dispatcher again and start the dispatcher. If you don’t follow this steps your changes may not be applied properly, so all your following tests might be performed with inconsistent DB connection configuration and at certain point of time some or all of them might stop working.

Hope I’ve been helpful, but still if you have something to add or you have any questions, please feel free to post them here. Let’s make this document better together. Feel free to share you experience.

Best regards,

Ivan

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Tero Virta

    Maybe add something about verifying the connectivity between the database and the IdM components exists. If SQL Plus has been installed (I am not sure if it’s part of the client installation anyway) with the Oracle client, it’s pretty straight forward to test the connectivity by logging in with mxmc-users and running a simple query against IdM views.. Same with Microsoft’s osql-command line utility if you’re using SQL Server. (Syntax for connecting in command line can be found from IdM’s installation scripts as SQL Plus or osql are used in installing the product.)

    (0) 
    1. Ivan Petrov Post author

      Well Tero, I didn’t add this check, because usually these tools are not installed on the same machine where the IDM is installed. Usually the installation of such tools is located on developer PC or laptop, so checking connection from there won’t help resolving the IDM do DB connection at all.

      Best regards,

      Ivan

      (0) 
      1. Tero Virta

        Matt, I know..The point was if it works on native tools then connection exists which would point out to something else wrong further up in the database client installation or DB parameters in MMC.

        (0) 
        1. Matt Pollicove

          Good point, however I know (and I think someone mentioned) that SQL tools are not always available in all environments and to all people working on IDM (Consultants, Non-DBAs, etc) So it is a good thing for people to know about.

          (0) 

Leave a Reply