Group Aggregation Failure for JDBC application "Index value for [GUID] on new object was null."

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Hi all

I am getting a group Aggregation failure with the below error.

2024-12-17T17:17:25,502 ERROR QuartzScheduler_Worker-5 sailpoint.connector.JDBCConnector:3184 - ConnectorException in getNext method
sailpoint.connector.ConnectorException: Index value for [GUID] on new object was null.

[GUID] is the identity Attribute for account
The Account aggregation is working but not sure why getting this error for Group Aggregation
I am running both the tasks using API

Thank you

2

Also the group type preview is working fine

Its only the aggregation is failing

I am also trying to update the index column in Data needs to be merged for accounts using a script

Can that be an issue ?

3

Hi @mgupta403,

probabily you have a record with null value on guid or with spaces. You can resolve adding a where condition guid is not null on query or, better, change the identity attribute.

4

Hi @enistri_devo,

Its working with direct correlation config object but failing while using a rule

I cannot update the stored procedure but can I update my rule to add a condition ?

I am using the below correlation rule

  Identity identity = null;

  if(link != null) {
    log.info("Link is not null");
    returnMap.put("identity", link.getIdentity());
  } else if(null != correlationConfigObject @and null != application) {
    
    List appList = correlationConfigObject.get(application.getName());
    
    if(appMap != null) {

      for(String idenAtt : appList){
        log.info(" idenAtt= "+idenAtt);

        identity = context.getUniqueObject(Identity.class, Filter.eq(idenAtt, account.getAttribute(accountAttribute)));
        log.info("identity = "+identity);
        if(identity != null) {
          log.info("Identity: " + identity);
          returnMap.put("identity", identity);
          break;
        }
      }

    }
  }
5

ok, you can managed it in a customization rule where you can work an account before, IIQ save it.

You can read all the proprietes and manage this case.

1 Like
6

Hi

I checked the object from the application in the customization rule but there is no space or null value

So the problem is I am using Application Builder to configure the application from scratch and using the rule to add correlation and to add tasks for account and group and initiate them

When I run this altogether, I get the error

But if I create the application and just update the application with any change (for example adding a rule using UI) and then run the other rule to run the account and group aggregation, its working with no issue

7

Maybe on the process that you use on scratch some configurations are missing. Check difference between the application that you have created from scratch and the application that you have created into IIQ and fix the process

2 Likes