Fix for “The schema for objectType: account is not configured for this connector” while onboarding JDBC (PostgreSQL) Applications using Application Builder

IdentityIQ (IIQ) IIQ Discussion and Questions
1

While onboarding multiple PostgreSQL applications using Application Builder with the JDBC connector, I encountered the following error:

[ ConnectorException ] 
[ Error details ] The server encountered an unexpected error while contacting target system. 
Please check the logs. The schema for objectType: account is not configured for this connector.

This error occurs when the Account Schema isn’t defined during bulk onboarding via CSV — even though the JDBC connection and queries are correct.

Column 1 Column 2 Column 3 Column 4 E F G H I J K L M
name user password url driverClass testConnSQL SQL Group.user Group.password Group.url Group.driverClass Group.SQL Group.getObjectSQL
Postgtresq1 postgres Admin@123 jdbc:postgresql://localhost:5432/postgres org.postgresql.Driver SELECT account_id AS identity, username, firstname, lastname, email, status FROM accounts; SELECT account_id AS identity, username, firstname, lastname, email, status
FROM accounts;
postgres Admin@123 jdbc:postgresql://localhost:5432/postgre org.postgresql.Driver SELECT group_id AS identity, group_name, description FROM gr; SELECT group_id AS identity, group_name, description FROM gr;
Postgtresq2 postgres Admin@123 jdbc:postgresql://localhost:5432/postgres org.postgresql.Driver SELECT account_id AS identity, username, firstname, lastname, email, status FROM accounts; SELECT account_id AS identity, username, firstname, lastname, email, status
FROM accounts;
postgres Admin@124 jdbc:postgresql://localhost:5432/postgre org.postgresql.Driver SELECT group_id AS identity, group_name, description FROM gr; SELECT group_id AS identity, group_name, description FROM gr;
Postgtresq3 postgres Admin@123 jdbc:postgresql://localhost:5432/postgres org.postgresql.Driver SELECT account_id AS identity, username, firstname, lastname, email, status FROM accounts; SELECT account_id AS identity, username, firstname, lastname, email, status
FROM accounts;
postgres Admin@125 jdbc:postgresql://localhost:5432/postgre org.postgresql.Driver SELECT group_id AS identity, group_name, description FROM gr; SELECT group_id AS identity, group_name, description FROM gr;
Postgtresq4 postgres Admin@123 jdbc:postgresql://localhost:5432/postgres org.postgresql.Driver SELECT account_id AS identity, username, firstname, lastname, email, status FROM accounts; SELECT account_id AS identity, username, firstname, lastname, email, status
FROM accounts;
postgres Admin@126 jdbc:postgresql://localhost:5432/postgre org.postgresql.Driver SELECT group_id AS identity, group_name, description FROM gr; SELECT group_id AS identity, group_name, description FROM gr;
2

As per your error, schema column is not configured in your csv file. That’s why this error is showing up. Please use the below schema :

This is sample schema for the application. Create your own schema object by referring the below.

<Schemas>
    <Schema displayAttribute="username" identityAttribute="username" instanceAttribute="" nativeObjectType="account" objectType="account">
      <AttributeDefinition name="username" remediationModificationType="None" required="true" type="string">
        <Description>Name of User</Description>
      </AttributeDefinition>
      <AttributeDefinition name="uid" remediationModificationType="None" type="string">
        <Description>The numerical value of the user's ID</Description>
      </AttributeDefinition>
      <AttributeDefinition name="home" remediationModificationType="None" type="string">
        <Description>Home Directory of User</Description>
      </AttributeDefinition>
      <AttributeDefinition name="pwdlastchg" remediationModificationType="None" type="string">
        <Description>The number of days since January 1st, 1970 when the password was last changed</Description>
      </AttributeDefinition>
      <AttributeDefinition name="pwdmin" remediationModificationType="None" type="string">
        <Description>Minimum number of days between password change</Description>
      </AttributeDefinition>
      <AttributeDefinition name="pwdmax" remediationModificationType="None" type="string">
        <Description>The maximum number of days during which a password is valid</Description>
      </AttributeDefinition>
      <AttributeDefinition name="pwdwarn" remediationModificationType="None" type="string">
        <Description>Number of days of warning before password expires</Description>
      </AttributeDefinition>
      <AttributeDefinition name="primgrp" remediationModificationType="None" type="string">
        <Description>Primary Group of User</Description>
      </AttributeDefinition>
      <AttributeDefinition name="comment" remediationModificationType="None" type="string">
        <Description>User's password file comment field</Description>
      </AttributeDefinition>
      <AttributeDefinition name="expiration" remediationModificationType="None" type="string">
        <Description>Set the date or number of days since January 1, 1970 on which the user's account will no longer be accessible</Description>
      </AttributeDefinition>
      <AttributeDefinition name="inactive" remediationModificationType="None" type="string">
        <Description>Set the number of days of inactivity after a password has expired before the account is locked</Description>
      </AttributeDefinition>
      <AttributeDefinition name="lastLogin" remediationModificationType="None" type="string">
        <Description>Last login time of User</Description>
      </AttributeDefinition>
      <AttributeDefinition name="shell" remediationModificationType="None" type="string">
        <Description>The name of the user's login shell</Description>
      </AttributeDefinition>
      <AttributeDefinition entitlement="true" managed="true" multi="true" name="groups" schemaObjectType="group" type="string">
        <Description>List of groups which the user is a member of</Description>
      </AttributeDefinition>
    </Schema>
    <Schema displayAttribute="name" featuresString="PROVISIONING" identityAttribute="name" instanceAttribute="" nativeObjectType="group" objectType="group">
      <AttributeDefinition name="name" remediationModificationType="None" required="true" type="string">
        <Description>Name of Group</Description>
      </AttributeDefinition>
      <AttributeDefinition name="groupid" remediationModificationType="None" required="true" type="string">
        <Description>The numerical value of the group's ID</Description>
      </AttributeDefinition>
    </Schema>
  </Schemas>
3

Also, If you are using OOTB application builder then schema is mandatory. Without adding schema in your csv file, error will come.

4

If you don’t have schema, then add the empty schema, like below:

<Schemas>
    <Schema displayAttribute="username" identityAttribute="username" instanceAttribute="" nativeObjectType="account" objectType="account">
    </Schema>
</Schemas>
5

Added the schema atrributte still it gave same error:

Error occurred in null. [ ConnectorException ][ Error details ] The server encountered an unexpected error while contacting target system. Please check the logs. The schema for objectType: account is not configured for this connector.sailpoint.connector.ConnectorException: [ ConnectorException ][ Error details ] The server encountered an unexpected error while contacting target system. Please check the logs. The schema for objectType: account is not configured for this connector.at jdk.internal.reflect.GeneratedConstructorAccessor364.newInstance(Unknown Source)at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)at java.base/java.lang.Class.newInstance(Class.java:584)
6

Use this account schema

7

Also unselect the option to do test connection and account aggregation.

8

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.