Could not execute statement WebServices

[kskendelis (Kestutis Skendelis)]

I have problem with groups aggregation in WebService application, getting error. From log I can see that it is related to entry duplication, but I dont know how to fix that.

Exception during aggregation of APPGRPAPP#342#APP#280#APPGRP#204. Reason: org.hibernate.exception.ConstraintViolationException: could not execute statement

[ismaelmoreno1 (Ismael Moreno)]

Hi @kskendelis

Are you using any aggregation rule in the connector.?
From other side, What method are you using in your web service connector to aggregate groups?

[kskendelis (Kestutis Skendelis)]

1. First I had only one group operation “Group aggregation” but for the some objects(records) I was getting error to add another operation “Get - Object Groups”, after adding I am getting current exception (which is shown above).

2. We using group aggregation refresh rule:

import sailpoint.tools.Util;
  
  accountGroup.setAttribute("extendedType",accountGroup.getAttribute("RType"));
  accountGroup.setAttribute("internalApplication",accountGroup.getAttribute("ESCode"));
  
  String uniqueId = accountGroup.getValue();
  String[] tokenList = uniqueId.split("#");
  
  List typeList = new ArrayList();
  
  boolean typeFound = false;
  String typeValue = "";
  for (String token : Arrays.asList(tokenList)) {
    if (typeFound) {
      if (!token.equals(typeValue)) {
        typeValue += "#"+token;
        typeList.add(typeValue);
        typeFound = false;
        typeValue = "";
      }
    } else {
      typeValue = token;
      typeFound = true;
    }
  }
  
  if (Util.nullSafeSize(typeList)>1) {
    accountGroup.setAttribute("RoleComponents",typeList);
  } else {
    accountGroup.setAttribute("RoleComponents",null); 
  }
  
  for (String entType : typeList){
    String[] typeSplit = entType.split("#");
    String entTypeName = typeSplit[0];
    String entTypeValue;
    if (typeSplit.length > 1) {
      entTypeValue = typeSplit[1];
    }
    accountGroup.setAttribute(entTypeName+"_Type",entTypeValue);
  }

  return accountGroup;