Progress openEdge DB integration using Identity Manager JDBC connector

  • Document ID:7011412
  • Creation Date:21-Nov-2012
  • Modified Date:07-Jun-2016
    • Micro Focus Products:
      Identity Manager

Environment

NetIQ Identity Manager 3.x
NetIQ Identity Manager 4.x

Situation

The NetIQ JDBC driver when connecting to a Progress / OpenEdge database will start fine and successfully reads the first batch of transactions. However while attempting to process the records (add/match) the queries from the shim to the database results in the following error

<description>Invalid association. Table 'V-IDM-USERS' is undefined or not a parent table.</description>

Resolution

1) Ensure that the JDBC shim is patched to the latest release.
2) The table that IDM references for user data should not have any dashes in the name. For Eg : VIDMUSERS

Cause

When hypens OpenEdge DB