Hi Marc,

This is getting invoked as part of retrieving campaign performance details from IH tables.On step5 of retrievedata, its trying to create the query and call VBD service.

there it was throwing the error.

Please find below code snippet where we could see multiple string manipulations and we could not find the culprit function for the error.

It would be great help if you could help here

Code snippet :

if (null == resultsPg) {
 resultsPg = tools.createPage("Embed-PegaMKT-Measurement-Definition-Interaction", "QueryResultsPage");
}

// Now switching to com.pega.decision package structure...
//get result
try {
 com.pega.decision.vbd.service.VBDService service = pega_decisionengine_vbd.pzGetVBDService(tools);
 com.pega.decision.vbd.query.QueryResult result = service.query(query);

 //print result
 if (result != null && result.hasValues()) {
  double[] resultArr = result.getValues();
  for (int i=0; i<resultArr.length; i++) {
   //Put the result into the measurement result map, keyed by name.
   double[] theResult = new double[1];
   theResult[0] = resultArr[i];
   measurementResultsMap.put("{" + measurementNameList.get(i) + "}", theResult);
  }
 }
 else if (result.entrySet() != null) {
  //We had grouped results - walk the QueryResult object's entries
  Iterator setIterator = result.entrySet().iterator();
  //for reference - this is the total tally of the requested measurements across all binned results
  double[] runningTally = new double[measurementNameList.size()];
  
  int binIndex = 0;
  ClipboardPage labelsPage = tools.findPage("D_MKTTimeIntervalLabels");

  while (setIterator.hasNext()) {
   try {
    com.pega.decision.vbd.query.QueryResult.ResultEntry myResult = (com.pega.decision.vbd.query.QueryResult.ResultEntry)setIterator.next();
    com.pega.decision.vbd.query.QueryResult myQueryResult = (com.pega.decision.vbd.query.QueryResult)myResult.getValue();
    com.pega.decision.vbd.client.GroupedValue myGroupedValue = (com.pega.decision.vbd.client.GroupedValue)myResult.getKey();
    //assuming a time binning as first grouping - grouped values will be in the format "default=x" where x is the number of bin intervals from start date
    String groupedValueIndex = (String)myGroupedValue.get("default");
    binIndex = Integer.parseInt(groupedValueIndex);    
    //keep track of the lowest bin interval - this will help us match up the proper label for displaying the results
    binOffset = binIndex + 1;

    String intervalLabel = "";
    String binLabel = "";
    ClipboardProperty labelsProp = null;
    if (labelsPage != null) {
     labelsProp = labelsPage.getProperty("TimeIntervalLabels");
    }
    if (null != labelsProp) {
     intervalLabel = labelsProp.getStringValue(binOffset);
     binLabel = intervalLabel;
     intervalLabel = intervalLabel.replaceAll(" ", "_").replaceAll("-", "");
    }
    if (intervalLabel.length() <= 0) {
     intervalLabel = "All";
     binLabel = intervalLabel;
    }
    //Year will be numeric - append a character to allow for use as PageGroup index
    else if ("Year".equals(intervalParam)) {
     intervalLabel = "Y" + intervalLabel;
    }
    //our results were only binned by time in this case - update runningTally and store the results indexed by the bin interval
    if (myQueryResult.hasValues()) {
     double[] myDouble = myQueryResult.getValues(myGroupedValue);
      
     for (int i = 0; i < myDouble.length; i++) {
      runningTally[i] = runningTally[i] + myDouble[i];

      ClipboardPage r1 = resultsPg.getPage("ResultsGroup(" + intervalLabel + ")");
      r1.putString("GlobalGroupingLabel", binLabel);
      ClipboardPage r2 = r1.getPage("ResultsGroup(" + measurementNameList.get(i) + ")");
      ClipboardProperty measure = r2.getProperty("Measure1");
      ClipboardProperty ordering = r2.getProperty("SortIndex");
      measure.setValue(myDouble[i]);
      ordering.setValue(binOffset);
     }
     //store the bin results indexed by bin interval, for further calculations
     
    } else if (myQueryResult.entrySet() != null) {
        // We have time & local grouping
     Iterator setIteratorInner = myQueryResult.entrySet().iterator();
     //for reference - this is the total tally of the requested measurements across all binned results
     double[] innerTally = new double[measurementNameList.size()];

     while (setIteratorInner.hasNext()) {
      try {
       com.pega.decision.vbd.query.QueryResult.ResultEntry innerResult = (com.pega.decision.vbd.query.QueryResult.ResultEntry)setIteratorInner.next();
       com.pega.decision.vbd.query.QueryResult innerQueryResult = (com.pega.decision.vbd.query.QueryResult)innerResult.getValue();
       com.pega.decision.vbd.client.GroupedValue innerGroupedValue = (com.pega.decision.vbd.client.GroupedValue)innerResult.getKey();
       //assuming a string-based binning as our inner/local binning - inner grouped results will be in format "levelParam=xyz"
       String groupedValueIndexInner = (String)innerGroupedValue.get(levelParam);
       //remove <> symbols; translate spaces to _ character for clarity
       groupedValueIndexInner = groupedValueIndexInner.replaceAll("<", "").replaceAll(">", "").replaceAll(" ", "_").replaceAll("-", "");

       //our results were only binned by time in this case - update runningTally and store the results indexed by the bin interval
       if (innerQueryResult.hasValues()) {
        double[] innerDouble = innerQueryResult.getValues(innerGroupedValue);
        ClipboardPage r1 = resultsPg.getPage("ResultsGroup(" + intervalLabel +")");
        r1.putString("GlobalGroupingLabel", binLabel);
        ClipboardPage r2 = r1.getPage("ResultsGroup(" + groupedValueIndexInner + ")");
        r2.putString("LocalGroupingLabel", (String)innerGroupedValue.get(levelParam));
        r2.putString("GlobalGroupingLabel", binLabel);
        
        for (int i = 0; i < innerDouble.length; i++) {
         innerTally[i] = innerTally[i] + innerDouble[i];
         ClipboardPage r3 = r2.getPage("ResultsGroup(" + measurementNameList.get(i) + ")");
         ClipboardProperty innerMeasure = r3.getProperty("Measure1");
         ClipboardProperty ordering = r3.getProperty("SortIndex");
         innerMeasure.setValue(innerDouble[i]);
         ordering.setValue(binOffset);
        }
       }
      }
      catch (Throwable t) {
       oLog.error("Not able to get the timeframe and locally grouped value from VBD");
       oLog.error("Error is " + t.toString());
      }
     }
    
    } else {
     oLog.info("myQueryResult has  NO values" );
    }
   } catch (Throwable t){
    oLog.error("Not able to get the timeframe grouped value from VBD");
    oLog.error("Error is " + t.toString());

   }
  } //while
 }
}
catch (Exception e) { oLog.error("Unable to query VBD: " + e.getMessage()); }

//This activity will recursively call itself to arrive at the calculated set of answers for the requested KPI (Operand)
paramPage.putObject("Expression", paramName);
StringMap keys = new HashStringMap();
keys.putString("pyActivityName", "CalculateKPIExpression");
tools.doActivity(keys, resultsPg, paramPage);