2  * ============LICENSE_START=======================================================
 
   4  * ================================================================================
 
   5  * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
 
   6  * ================================================================================
 
   7  * Modifications Copyright (c) 2019 Samsung
 
   8  * ================================================================================
 
   9  * Licensed under the Apache License, Version 2.0 (the "License");
 
  10  * you may not use this file except in compliance with the License.
 
  11  * You may obtain a copy of the License at
 
  13  *      http://www.apache.org/licenses/LICENSE-2.0
 
  15  * Unless required by applicable law or agreed to in writing, software
 
  16  * distributed under the License is distributed on an "AS IS" BASIS,
 
  17  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 
  18  * See the License for the specific language governing permissions and
 
  19  * limitations under the License.
 
  20  * ============LICENSE_END=========================================================
 
  23 package org.onap.so.apihandlerinfra;
 
  25 import java.io.IOException;
 
  26 import java.text.SimpleDateFormat;
 
  27 import java.util.ArrayList;
 
  28 import java.util.HashMap;
 
  29 import java.util.List;
 
  31 import java.util.concurrent.TimeUnit;
 
  32 import javax.transaction.Transactional;
 
  33 import javax.ws.rs.Consumes;
 
  34 import javax.ws.rs.GET;
 
  35 import javax.ws.rs.POST;
 
  36 import javax.ws.rs.Path;
 
  37 import javax.ws.rs.PathParam;
 
  38 import javax.ws.rs.Produces;
 
  39 import javax.ws.rs.QueryParam;
 
  40 import javax.ws.rs.core.Context;
 
  41 import javax.ws.rs.core.MediaType;
 
  42 import javax.ws.rs.core.MultivaluedMap;
 
  43 import javax.ws.rs.core.Response;
 
  44 import javax.ws.rs.core.UriInfo;
 
  45 import org.apache.commons.lang.StringUtils;
 
  46 import org.apache.commons.lang3.EnumUtils;
 
  47 import org.apache.http.HttpStatus;
 
  48 import org.onap.logging.ref.slf4j.ONAPLogConstants;
 
  49 import org.onap.so.apihandler.common.ErrorNumbers;
 
  50 import org.onap.so.apihandler.common.ResponseBuilder;
 
  51 import org.onap.so.apihandlerinfra.exceptions.ApiException;
 
  52 import org.onap.so.apihandlerinfra.exceptions.ContactCamundaException;
 
  53 import org.onap.so.apihandlerinfra.exceptions.ValidateException;
 
  54 import org.onap.so.apihandlerinfra.logging.ErrorLoggerInfo;
 
  55 import org.onap.so.constants.OrchestrationRequestFormat;
 
  56 import org.onap.so.constants.Status;
 
  57 import org.onap.so.db.request.beans.InfraActiveRequests;
 
  58 import org.onap.so.db.request.beans.RequestProcessingData;
 
  59 import org.onap.so.db.request.client.RequestsDbClient;
 
  60 import org.onap.so.exceptions.ValidationException;
 
  61 import org.onap.logging.filter.base.ErrorCode;
 
  62 import org.onap.so.logger.MessageEnum;
 
  63 import org.onap.so.serviceinstancebeans.CloudRequestData;
 
  64 import org.onap.so.serviceinstancebeans.GetOrchestrationListResponse;
 
  65 import org.onap.so.serviceinstancebeans.GetOrchestrationResponse;
 
  66 import org.onap.so.serviceinstancebeans.InstanceReferences;
 
  67 import org.onap.so.serviceinstancebeans.Request;
 
  68 import org.onap.so.serviceinstancebeans.RequestDetails;
 
  69 import org.onap.so.serviceinstancebeans.RequestList;
 
  70 import org.onap.so.serviceinstancebeans.RequestStatus;
 
  71 import org.onap.so.serviceinstancebeans.ServiceInstancesRequest;
 
  72 import org.onap.so.utils.UUIDChecker;
 
  73 import org.slf4j.Logger;
 
  74 import org.slf4j.LoggerFactory;
 
  76 import org.springframework.beans.factory.annotation.Autowired;
 
  77 import org.springframework.core.env.Environment;
 
  78 import org.springframework.stereotype.Component;
 
  79 import com.fasterxml.jackson.databind.ObjectMapper;
 
  80 import io.swagger.v3.oas.annotations.OpenAPIDefinition;
 
  81 import io.swagger.v3.oas.annotations.Operation;
 
  82 import io.swagger.v3.oas.annotations.info.Info;
 
  83 import io.swagger.v3.oas.annotations.media.ArraySchema;
 
  84 import io.swagger.v3.oas.annotations.media.Content;
 
  85 import io.swagger.v3.oas.annotations.media.Schema;
 
  86 import io.swagger.v3.oas.annotations.responses.ApiResponse;
 
  88 @Path("onap/so/infra/orchestrationRequests")
 
  89 @OpenAPIDefinition(info = @Info(title = "onap/so/infra/orchestrationRequests",
 
  90         description = "API Requests for Orchestration requests"))
 
  93 public class OrchestrationRequests {
 
  95     private static Logger logger = LoggerFactory.getLogger(OrchestrationRequests.class);
 
  96     private static final String ERROR_MESSAGE_PREFIX = "Error Source: %s, Error Message: %s";
 
  99     private RequestsDbClient requestsDbClient;
 
 102     private MsoRequest msoRequest;
 
 105     private ResponseBuilder builder;
 
 108     private CamundaRequestHandler camundaRequestHandler;
 
 111     private Environment env;
 
 114     @Path("/{version:[vV][4-8]}/{requestId}")
 
 115     @Operation(description = "Find Orchestrated Requests for a given requestId", responses = @ApiResponse(
 
 116             content = @Content(array = @ArraySchema(schema = @Schema(implementation = Response.class)))))
 
 117     @Produces(MediaType.APPLICATION_JSON)
 
 119     public Response getOrchestrationRequest(@PathParam("requestId") String requestId,
 
 120             @PathParam("version") String version, @QueryParam("includeCloudRequest") boolean includeCloudRequest,
 
 121             @QueryParam(value = "format") String format) throws ApiException {
 
 123         GetOrchestrationResponse orchestrationResponse = new GetOrchestrationResponse();
 
 125         InfraActiveRequests infraActiveRequest = null;
 
 126         List<org.onap.so.db.request.beans.RequestProcessingData> requestProcessingData = null;
 
 128         if (!UUIDChecker.isValidUUID(requestId)) {
 
 130             ErrorLoggerInfo errorLoggerInfo =
 
 131                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_VALIDATION_ERROR, ErrorCode.SchemaError)
 
 132                             .errorSource(Constants.MODIFIED_BY_APIHANDLER).build();
 
 133             throw new ValidateException.Builder("Request Id " + requestId + " is not a valid UUID",
 
 134                     HttpStatus.SC_BAD_REQUEST, ErrorNumbers.SVC_BAD_PARAMETER).errorInfo(errorLoggerInfo).build();
 
 137         infraActiveRequest = infraActiveRequestLookup(requestId);
 
 139         if (isRequestProcessingDataRequired(format)) {
 
 141                 requestProcessingData = requestsDbClient.getExternalRequestProcessingDataBySoRequestId(requestId);
 
 142             } catch (Exception e) {
 
 144                         "Exception occurred while communicating with RequestDb during requestProcessingData lookup ",
 
 146                 ErrorLoggerInfo errorLoggerInfo =
 
 147                         new ErrorLoggerInfo.Builder(MessageEnum.APIH_DB_ACCESS_EXC, ErrorCode.AvailabilityError)
 
 150                 ValidateException validateException = new ValidateException.Builder(
 
 151                         "Exception occurred while communicating with RequestDb during requestProcessingData lookup",
 
 152                         HttpStatus.SC_NOT_FOUND, ErrorNumbers.NO_COMMUNICATION_TO_REQUESTS_DB).cause(e)
 
 153                                 .errorInfo(errorLoggerInfo).build();
 
 155                 throw validateException;
 
 159         Request request = mapInfraActiveRequestToRequest(infraActiveRequest, includeCloudRequest, format, version);
 
 161         if (null != requestProcessingData && !requestProcessingData.isEmpty()) {
 
 162             request.setRequestProcessingData(mapRequestProcessingData(requestProcessingData));
 
 164         request.setRequestId(requestId);
 
 165         orchestrationResponse.setRequest(request);
 
 167         return builder.buildResponse(HttpStatus.SC_OK, MDC.get(ONAPLogConstants.MDCs.REQUEST_ID), orchestrationResponse,
 
 172     @Path("/{version:[vV][4-8]}")
 
 173     @Operation(description = "Find Orchestrated Requests for a URI Information", responses = @ApiResponse(
 
 174             content = @Content(array = @ArraySchema(schema = @Schema(implementation = Response.class)))))
 
 175     @Produces(MediaType.APPLICATION_JSON)
 
 177     public Response getOrchestrationRequest(@Context UriInfo ui, @PathParam("version") String version,
 
 178             @QueryParam("includeCloudRequest") boolean includeCloudRequest, @QueryParam(value = "format") String format)
 
 179             throws ApiException {
 
 181         MultivaluedMap<String, String> queryParams = ui.getQueryParameters();
 
 183         List<InfraActiveRequests> activeRequests;
 
 185         GetOrchestrationListResponse orchestrationList;
 
 186         Map<String, List<String>> orchestrationMap;
 
 187         String apiVersion = version.substring(1);
 
 190             orchestrationMap = msoRequest.getOrchestrationFilters(queryParams);
 
 191             if (orchestrationMap.isEmpty()) {
 
 192                 throw new ValidationException("At least one filter query param must be specified");
 
 194         } catch (ValidationException ex) {
 
 195             logger.error("Exception occurred", ex);
 
 196             ErrorLoggerInfo errorLoggerInfo =
 
 197                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_REQUEST_VALIDATION_ERROR, ErrorCode.DataError).build();
 
 198             ValidateException validateException =
 
 199                     new ValidateException.Builder(ex.getMessage(), HttpStatus.SC_BAD_REQUEST,
 
 200                             ErrorNumbers.SVC_GENERAL_SERVICE_ERROR).cause(ex).errorInfo(errorLoggerInfo).build();
 
 201             throw validateException;
 
 205         activeRequests = requestsDbClient.getOrchestrationFiltersFromInfraActive(orchestrationMap);
 
 207         orchestrationList = new GetOrchestrationListResponse();
 
 208         List<RequestList> requestLists = new ArrayList<>();
 
 211         for (InfraActiveRequests infraActive : activeRequests) {
 
 212             RequestList requestList = new RequestList();
 
 213             Request request = mapInfraActiveRequestToRequest(infraActive, includeCloudRequest, format, version);
 
 215             if (isRequestProcessingDataRequired(format)) {
 
 216                 List<RequestProcessingData> requestProcessingData =
 
 217                         requestsDbClient.getRequestProcessingDataBySoRequestId(infraActive.getRequestId());
 
 218                 if (null != requestProcessingData && !requestProcessingData.isEmpty()) {
 
 219                     request.setRequestProcessingData(mapRequestProcessingData(requestProcessingData));
 
 223             requestList.setRequest(request);
 
 224             requestLists.add(requestList);
 
 227         orchestrationList.setRequestList(requestLists);
 
 228         return builder.buildResponse(HttpStatus.SC_OK, MDC.get(ONAPLogConstants.MDCs.REQUEST_ID), orchestrationList,
 
 233     @Path("/{version: [vV][4-7]}/{requestId}/unlock")
 
 234     @Consumes(MediaType.APPLICATION_JSON)
 
 235     @Produces(MediaType.APPLICATION_JSON)
 
 236     @Operation(description = "Unlock Orchestrated Requests for a given requestId", responses = @ApiResponse(
 
 237             content = @Content(array = @ArraySchema(schema = @Schema(implementation = Response.class)))))
 
 239     public Response unlockOrchestrationRequest(String requestJSON, @PathParam("requestId") String requestId,
 
 240             @PathParam("version") String version) throws ApiException {
 
 242         logger.debug("requestId is: {}", requestId);
 
 243         ServiceInstancesRequest sir;
 
 246             ObjectMapper mapper = new ObjectMapper();
 
 247             sir = mapper.readValue(requestJSON, ServiceInstancesRequest.class);
 
 248         } catch (IOException e) {
 
 249             logger.error("Exception occurred", e);
 
 250             ErrorLoggerInfo errorLoggerInfo =
 
 251                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_REQUEST_VALIDATION_ERROR, ErrorCode.SchemaError)
 
 253             ValidateException validateException =
 
 254                     new ValidateException.Builder("Mapping of request to JSON object failed : " + e.getMessage(),
 
 255                             HttpStatus.SC_BAD_REQUEST, ErrorNumbers.SVC_BAD_PARAMETER).cause(e)
 
 256                                     .errorInfo(errorLoggerInfo).build();
 
 258             throw validateException;
 
 262             msoRequest.parseOrchestration(sir);
 
 263         } catch (Exception e) {
 
 264             logger.error("Exception occurred", e);
 
 265             ErrorLoggerInfo errorLoggerInfo =
 
 266                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_REQUEST_VALIDATION_ERROR, ErrorCode.SchemaError)
 
 268             ValidateException validateException =
 
 269                     new ValidateException.Builder("Error parsing request: " + e.getMessage(), HttpStatus.SC_BAD_REQUEST,
 
 270                             ErrorNumbers.SVC_BAD_PARAMETER).cause(e).errorInfo(errorLoggerInfo).build();
 
 271             throw validateException;
 
 274         InfraActiveRequests infraActiveRequest = infraActiveRequestLookup(requestId);
 
 276         String status = infraActiveRequest.getRequestStatus();
 
 277         if (Status.IN_PROGRESS.toString().equalsIgnoreCase(status) || Status.PENDING.toString().equalsIgnoreCase(status)
 
 278                 || Status.PENDING_MANUAL_TASK.toString().equalsIgnoreCase(status)) {
 
 279             infraActiveRequest.setRequestStatus(Status.UNLOCKED.toString());
 
 280             infraActiveRequest.setLastModifiedBy(Constants.MODIFIED_BY_APIHANDLER);
 
 281             infraActiveRequest.setRequestId(requestId);
 
 282             requestsDbClient.save(infraActiveRequest);
 
 285             ErrorLoggerInfo errorLoggerInfo =
 
 286                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_DB_ATTRIBUTE_NOT_FOUND, ErrorCode.DataError).build();
 
 288             ValidateException validateException = new ValidateException.Builder(
 
 289                     "Orchestration RequestId " + requestId + " has a status of " + status + " and can not be unlocked",
 
 290                     HttpStatus.SC_BAD_REQUEST, ErrorNumbers.SVC_DETAILED_SERVICE_ERROR).errorInfo(errorLoggerInfo)
 
 293             throw validateException;
 
 295         return Response.status(HttpStatus.SC_NO_CONTENT).entity("").build();
 
 298     protected Request mapInfraActiveRequestToRequest(InfraActiveRequests iar, boolean includeCloudRequest,
 
 299             String format, String version) throws ApiException {
 
 300         String requestBody = iar.getRequestBody();
 
 301         Request request = new Request();
 
 303         ObjectMapper mapper = new ObjectMapper();
 
 305         request.setRequestId(iar.getRequestId());
 
 306         request.setRequestScope(iar.getRequestScope());
 
 307         request.setRequestType(iar.getRequestAction());
 
 309         String originalRequestId = iar.getOriginalRequestId();
 
 310         if (originalRequestId != null) {
 
 311             request.setOriginalRequestId(originalRequestId);
 
 314         if (!version.matches("v[1-7]")) {
 
 315             String workflowName = iar.getWorkflowName();
 
 316             if (workflowName == null) {
 
 317                 workflowName = iar.getRequestAction();
 
 319             request.setWorkflowName(workflowName);
 
 321             String operationName = iar.getOperationName();
 
 322             if (operationName != null) {
 
 323                 request.setOperationName(operationName);
 
 327         InstanceReferences ir = new InstanceReferences();
 
 328         if (iar.getNetworkId() != null)
 
 329             ir.setNetworkInstanceId(iar.getNetworkId());
 
 330         if (iar.getNetworkName() != null)
 
 331             ir.setNetworkInstanceName(iar.getNetworkName());
 
 332         if (iar.getServiceInstanceId() != null)
 
 333             ir.setServiceInstanceId(iar.getServiceInstanceId());
 
 334         if (iar.getServiceInstanceName() != null)
 
 335             ir.setServiceInstanceName(iar.getServiceInstanceName());
 
 336         if (iar.getVfModuleId() != null)
 
 337             ir.setVfModuleInstanceId(iar.getVfModuleId());
 
 338         if (iar.getVfModuleName() != null)
 
 339             ir.setVfModuleInstanceName(iar.getVfModuleName());
 
 340         if (iar.getVnfId() != null)
 
 341             ir.setVnfInstanceId(iar.getVnfId());
 
 342         if (iar.getVnfName() != null)
 
 343             ir.setVnfInstanceName(iar.getVnfName());
 
 344         if (iar.getVolumeGroupId() != null)
 
 345             ir.setVolumeGroupInstanceId(iar.getVolumeGroupId());
 
 346         if (iar.getVolumeGroupName() != null)
 
 347             ir.setVolumeGroupInstanceName(iar.getVolumeGroupName());
 
 348         if (iar.getInstanceGroupId() != null)
 
 349             ir.setInstanceGroupId(iar.getInstanceGroupId());
 
 350         if (iar.getInstanceGroupName() != null)
 
 351             ir.setInstanceGroupName(iar.getInstanceGroupName());
 
 353         request.setInstanceReferences(ir);
 
 355         RequestDetails requestDetails = null;
 
 357         if (StringUtils.isNotBlank(requestBody)) {
 
 359                 if (requestBody.contains("\"requestDetails\":")) {
 
 360                     ServiceInstancesRequest sir = mapper.readValue(requestBody, ServiceInstancesRequest.class);
 
 361                     requestDetails = sir.getRequestDetails();
 
 363                     requestDetails = mapper.readValue(requestBody, RequestDetails.class);
 
 365                 if (requestDetails.getRequestInfo() != null && iar.getProductFamilyName() != null) {
 
 366                     requestDetails.getRequestInfo().setProductFamilyName(iar.getProductFamilyName());
 
 368                 if (requestDetails.getCloudConfiguration() != null && iar.getTenantName() != null) {
 
 369                     requestDetails.getCloudConfiguration().setTenantName(iar.getTenantName());
 
 372             } catch (IOException e) {
 
 373                 logger.error("Exception occurred", e);
 
 374                 ErrorLoggerInfo errorLoggerInfo =
 
 375                         new ErrorLoggerInfo.Builder(MessageEnum.APIH_REQUEST_VALIDATION_ERROR, ErrorCode.SchemaError)
 
 377                 ValidateException validateException =
 
 378                         new ValidateException.Builder("Mapping of request to JSON object failed : ",
 
 379                                 HttpStatus.SC_BAD_REQUEST, ErrorNumbers.SVC_BAD_PARAMETER).cause(e)
 
 380                                         .errorInfo(errorLoggerInfo).build();
 
 382                 throw validateException;
 
 385         request.setRequestDetails(requestDetails);
 
 387         if (iar.getStartTime() != null) {
 
 388             String startTimeStamp =
 
 389                     new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss").format(iar.getStartTime()) + " GMT";
 
 390             request.setStartTime(startTimeStamp);
 
 392         if (iar.getEndTime() != null) {
 
 393             String endTimeStamp = new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss").format(iar.getEndTime()) + " GMT";
 
 394             request.setFinishTime(endTimeStamp);
 
 397         RequestStatus status = new RequestStatus();
 
 399         if (iar.getModifyTime() != null) {
 
 400             String timeStamp = new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss").format(iar.getModifyTime()) + " GMT";
 
 401             status.setTimeStamp(timeStamp);
 
 404         status.setRequestState(mapRequestStatusToRequest(iar, format));
 
 406         if (iar.getProgress() != null) {
 
 407             status.setPercentProgress(iar.getProgress().intValue());
 
 410         if (iar.getCloudApiRequests() != null && !iar.getCloudApiRequests().isEmpty() && includeCloudRequest) {
 
 411             iar.getCloudApiRequests().stream().forEach(cloudRequest -> {
 
 413                     request.getCloudRequestData()
 
 414                             .add(new CloudRequestData(mapper.readValue(cloudRequest.getRequestBody(), Object.class),
 
 415                                     cloudRequest.getCloudIdentifier()));
 
 416                 } catch (Exception e) {
 
 417                     logger.error("Error reading Cloud Request", e);
 
 422         mapRequestStatusAndExtSysErrSrcToRequest(iar, status, format, version);
 
 424         request.setRequestStatus(status);
 
 428     protected String mapRequestStatusToRequest(InfraActiveRequests iar, String format) {
 
 429         if (iar.getRequestStatus() != null) {
 
 430             boolean requestFormat = false;
 
 431             if (format != null) {
 
 432                 requestFormat = EnumUtils.isValidEnum(OrchestrationRequestFormat.class, format.toUpperCase());
 
 435                 return iar.getRequestStatus();
 
 437                 if (Status.ABORTED.toString().equalsIgnoreCase(iar.getRequestStatus())
 
 438                         || Status.ROLLED_BACK.toString().equalsIgnoreCase(iar.getRequestStatus())
 
 439                         || Status.ROLLED_BACK_TO_ASSIGNED.toString().equalsIgnoreCase(iar.getRequestStatus())
 
 440                         || Status.ROLLED_BACK_TO_CREATED.toString().equalsIgnoreCase(iar.getRequestStatus())) {
 
 441                     return Status.FAILED.toString();
 
 443                     return iar.getRequestStatus();
 
 450     protected void mapRequestStatusAndExtSysErrSrcToRequest(InfraActiveRequests iar, RequestStatus status,
 
 451             String format, String version) {
 
 452         String rollbackStatusMessage = iar.getRollbackStatusMessage();
 
 453         String flowStatusMessage = iar.getFlowStatus();
 
 454         String retryStatusMessage = iar.getRetryStatusMessage();
 
 455         String taskName = null;
 
 457         if (daysSinceRequest(iar) <= camundaCleanupInterval()) {
 
 458             if (format == null || !format.equalsIgnoreCase(OrchestrationRequestFormat.SIMPLENOTASKINFO.toString())) {
 
 459                 if (flowStatusMessage != null && !flowStatusMessage.equals("Successfully completed all Building Blocks")
 
 460                         && !flowStatusMessage.equals("All Rollback flows have completed successfully")) {
 
 461                     taskName = camundaRequestHandler.getTaskName(iar.getRequestId());
 
 462                     if (taskName != null) {
 
 463                         flowStatusMessage = flowStatusMessage + " TASK INFORMATION: " + taskName;
 
 469         String statusMessages = null;
 
 470         if (iar.getStatusMessage() != null) {
 
 471             if (StringUtils.isNotBlank(iar.getExtSystemErrorSource())) {
 
 472                 statusMessages = "STATUS: "
 
 473                         + String.format(ERROR_MESSAGE_PREFIX, iar.getExtSystemErrorSource(), iar.getStatusMessage());
 
 475                 statusMessages = "STATUS: " + iar.getStatusMessage();
 
 479         if (OrchestrationRequestFormat.STATUSDETAIL.toString().equalsIgnoreCase(format)) {
 
 480             if (flowStatusMessage != null) {
 
 481                 status.setFlowStatus(flowStatusMessage);
 
 483             if (retryStatusMessage != null) {
 
 484                 status.setRetryStatusMessage(retryStatusMessage);
 
 486             if (rollbackStatusMessage != null) {
 
 487                 status.setRollbackStatusMessage(rollbackStatusMessage);
 
 489             if (version.matches("v[8-9]|v[1-9][0-9]")) {
 
 490                 if (iar.getResourceStatusMessage() != null) {
 
 491                     status.setResourceStatusMessage(iar.getResourceStatusMessage());
 
 495             status.setExtSystemErrorSource(iar.getExtSystemErrorSource());
 
 496             status.setRollbackExtSystemErrorSource(iar.getRollbackExtSystemErrorSource());
 
 499             if (flowStatusMessage != null) {
 
 500                 if (statusMessages != null) {
 
 501                     statusMessages = statusMessages + " " + "FLOW STATUS: " + flowStatusMessage;
 
 503                     statusMessages = "FLOW STATUS: " + flowStatusMessage;
 
 506             if (retryStatusMessage != null) {
 
 507                 if (statusMessages != null) {
 
 508                     statusMessages = statusMessages + " " + "RETRY STATUS: " + retryStatusMessage;
 
 510                     statusMessages = "RETRY STATUS: " + retryStatusMessage;
 
 513             if (rollbackStatusMessage != null) {
 
 514                 if (statusMessages != null) {
 
 515                     statusMessages = statusMessages + " " + "ROLLBACK STATUS: " + rollbackStatusMessage;
 
 517                     statusMessages = "ROLLBACK STATUS: " + rollbackStatusMessage;
 
 520             if (iar.getResourceStatusMessage() != null) {
 
 521                 if (statusMessages != null) {
 
 522                     statusMessages = statusMessages + " " + "RESOURCE STATUS: " + iar.getResourceStatusMessage();
 
 524                     statusMessages = "RESOURCE STATUS: " + iar.getResourceStatusMessage();
 
 529         if (statusMessages != null) {
 
 530             status.setStatusMessage(statusMessages);
 
 534     public List<org.onap.so.serviceinstancebeans.RequestProcessingData> mapRequestProcessingData(
 
 535             List<org.onap.so.db.request.beans.RequestProcessingData> processingData) {
 
 536         List<org.onap.so.serviceinstancebeans.RequestProcessingData> addedRequestProcessingData = new ArrayList<>();
 
 537         org.onap.so.serviceinstancebeans.RequestProcessingData finalProcessingData =
 
 538                 new org.onap.so.serviceinstancebeans.RequestProcessingData();
 
 539         String currentGroupingId = null;
 
 540         HashMap<String, String> tempMap = new HashMap<>();
 
 541         List<HashMap<String, String>> tempList = new ArrayList<>();
 
 542         for (RequestProcessingData data : processingData) {
 
 543             String groupingId = data.getGroupingId();
 
 544             String tag = data.getTag();
 
 545             if (currentGroupingId == null || !currentGroupingId.equals(groupingId)) {
 
 546                 if (!tempMap.isEmpty()) {
 
 547                     tempList.add(tempMap);
 
 548                     finalProcessingData.setDataPairs(tempList);
 
 549                     addedRequestProcessingData.add(finalProcessingData);
 
 551                 finalProcessingData = new org.onap.so.serviceinstancebeans.RequestProcessingData();
 
 552                 if (groupingId != null) {
 
 553                     finalProcessingData.setGroupingId(groupingId);
 
 556                     finalProcessingData.setTag(tag);
 
 558                 currentGroupingId = groupingId;
 
 559                 tempMap = new HashMap<>();
 
 560                 tempList = new ArrayList<>();
 
 561                 if (data.getName() != null && data.getValue() != null) {
 
 562                     tempMap.put(data.getName(), data.getValue());
 
 565                 if (data.getName() != null && data.getValue() != null) {
 
 566                     tempMap.put(data.getName(), data.getValue());
 
 570         if (tempMap.size() > 0) {
 
 571             tempList.add(tempMap);
 
 572             finalProcessingData.setDataPairs(tempList);
 
 574         addedRequestProcessingData.add(finalProcessingData);
 
 575         return addedRequestProcessingData;
 
 578     protected boolean isRequestProcessingDataRequired(String format) {
 
 579         if (StringUtils.isNotEmpty(format) && (format.equalsIgnoreCase(OrchestrationRequestFormat.SIMPLE.name())
 
 580                 || format.equalsIgnoreCase(OrchestrationRequestFormat.SIMPLENOTASKINFO.toString()))) {
 
 587     protected InfraActiveRequests infraActiveRequestLookup(String requestId) throws ApiException {
 
 588         InfraActiveRequests infraActiveRequest = null;
 
 590             infraActiveRequest = requestsDbClient.getInfraActiveRequestbyRequestId(requestId);
 
 591         } catch (Exception e) {
 
 592             logger.error("Exception occurred while communicating with RequestDb during InfraActiveRequest lookup ", e);
 
 593             ErrorLoggerInfo errorLoggerInfo =
 
 594                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_DB_ACCESS_EXC, ErrorCode.AvailabilityError).build();
 
 596             ValidateException validateException = new ValidateException.Builder(
 
 597                     "Exception occurred while communicating with RequestDb during InfraActiveRequest lookup",
 
 598                     HttpStatus.SC_NOT_FOUND, ErrorNumbers.NO_COMMUNICATION_TO_REQUESTS_DB).cause(e)
 
 599                             .errorInfo(errorLoggerInfo).build();
 
 601             throw validateException;
 
 604         if (infraActiveRequest == null) {
 
 605             ErrorLoggerInfo errorLoggerInfo =
 
 606                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_BPEL_COMMUNICATE_ERROR, ErrorCode.BusinessProcessError)
 
 609             ValidateException validateException = new ValidateException.Builder(
 
 610                     "Null response from RequestDB when searching by RequestId " + requestId, HttpStatus.SC_NOT_FOUND,
 
 611                     ErrorNumbers.SVC_DETAILED_SERVICE_ERROR).errorInfo(errorLoggerInfo).build();
 
 613             throw validateException;
 
 615         return infraActiveRequest;
 
 618     protected long daysSinceRequest(InfraActiveRequests request) {
 
 619         long startTime = request.getStartTime().getTime();
 
 620         long now = System.currentTimeMillis();
 
 622         return TimeUnit.MILLISECONDS.toDays(now - startTime);
 
 625     protected int camundaCleanupInterval() {
 
 626         String cleanupInterval = env.getProperty("mso.camundaCleanupInterval");
 
 628         if (cleanupInterval != null) {
 
 629             days = Integer.parseInt(cleanupInterval);