mso-api-handlers/mso-api-handler-infra/src/main/java/org/onap/so/apihandlerinfra/OrchestrationRequests.java

   1 /*-
   2  * ============LICENSE_START=======================================================
   3  * ONAP - SO
   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
  12  *
  13  *      http://www.apache.org/licenses/LICENSE-2.0
  14  *
  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=========================================================
  21  */
  22
  23 package org.onap.so.apihandlerinfra;
  24
  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;
  30 import java.util.Map;
  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;
  75 import org.slf4j.MDC;
  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;
  87
  88 @Path("onap/so/infra/orchestrationRequests")
  89 @OpenAPIDefinition(info = @Info(title = "onap/so/infra/orchestrationRequests",
  90         description = "API Requests for Orchestration requests"))
  91
  92 @Component
  93 public class OrchestrationRequests {
  94
  95     private static Logger logger = LoggerFactory.getLogger(OrchestrationRequests.class);
  96     private static final String ERROR_MESSAGE_PREFIX = "Error Source: %s, Error Message: %s";
  97
  98     @Autowired
  99     private RequestsDbClient requestsDbClient;
 100
 101     @Autowired
 102     private MsoRequest msoRequest;
 103
 104     @Autowired
 105     private ResponseBuilder builder;
 106
 107     @Autowired
 108     private CamundaRequestHandler camundaRequestHandler;
 109
 110     @Autowired
 111     private Environment env;
 112
 113     @GET
 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)
 118     @Transactional
 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 {
 122
 123         GetOrchestrationResponse orchestrationResponse = new GetOrchestrationResponse();
 124
 125         InfraActiveRequests infraActiveRequest = null;
 126         List<org.onap.so.db.request.beans.RequestProcessingData> requestProcessingData = null;
 127
 128         if (!UUIDChecker.isValidUUID(requestId)) {
 129
 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();
 135         }
 136
 137         infraActiveRequest = infraActiveRequestLookup(requestId);
 138
 139         if (isRequestProcessingDataRequired(format)) {
 140             try {
 141                 requestProcessingData = requestsDbClient.getExternalRequestProcessingDataBySoRequestId(requestId);
 142             } catch (Exception e) {
 143                 logger.error(
 144                         "Exception occurred while communicating with RequestDb during requestProcessingData lookup ",
 145                         e);
 146                 ErrorLoggerInfo errorLoggerInfo =
 147                         new ErrorLoggerInfo.Builder(MessageEnum.APIH_DB_ACCESS_EXC, ErrorCode.AvailabilityError)
 148                                 .build();
 149
 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();
 154
 155                 throw validateException;
 156             }
 157         }
 158
 159         Request request = mapInfraActiveRequestToRequest(infraActiveRequest, includeCloudRequest, format, version);
 160
 161         if (null != requestProcessingData && !requestProcessingData.isEmpty()) {
 162             request.setRequestProcessingData(mapRequestProcessingData(requestProcessingData));
 163         }
 164         request.setRequestId(requestId);
 165         orchestrationResponse.setRequest(request);
 166
 167         return builder.buildResponse(HttpStatus.SC_OK, MDC.get(ONAPLogConstants.MDCs.REQUEST_ID), orchestrationResponse,
 168                 version);
 169     }
 170
 171     @GET
 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)
 176     @Transactional
 177     public Response getOrchestrationRequest(@Context UriInfo ui, @PathParam("version") String version,
 178             @QueryParam("includeCloudRequest") boolean includeCloudRequest, @QueryParam(value = "format") String format)
 179             throws ApiException {
 180
 181         MultivaluedMap<String, String> queryParams = ui.getQueryParameters();
 182
 183         List<InfraActiveRequests> activeRequests;
 184
 185         GetOrchestrationListResponse orchestrationList;
 186         Map<String, List<String>> orchestrationMap;
 187         String apiVersion = version.substring(1);
 188
 189         try {
 190             orchestrationMap = msoRequest.getOrchestrationFilters(queryParams);
 191             if (orchestrationMap.isEmpty()) {
 192                 throw new ValidationException("At least one filter query param must be specified");
 193             }
 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;
 202
 203         }
 204
 205         activeRequests = requestsDbClient.getOrchestrationFiltersFromInfraActive(orchestrationMap);
 206
 207         orchestrationList = new GetOrchestrationListResponse();
 208         List<RequestList> requestLists = new ArrayList<>();
 209
 210
 211         for (InfraActiveRequests infraActive : activeRequests) {
 212             RequestList requestList = new RequestList();
 213             Request request = mapInfraActiveRequestToRequest(infraActive, includeCloudRequest, format, version);
 214
 215             if (isRequestProcessingDataRequired(format)) {
 216                 List<RequestProcessingData> requestProcessingData =
 217                         requestsDbClient.getRequestProcessingDataBySoRequestId(infraActive.getRequestId());
 218                 if (null != requestProcessingData && !requestProcessingData.isEmpty()) {
 219                     request.setRequestProcessingData(mapRequestProcessingData(requestProcessingData));
 220                 }
 221             }
 222
 223             requestList.setRequest(request);
 224             requestLists.add(requestList);
 225         }
 226
 227         orchestrationList.setRequestList(requestLists);
 228         return builder.buildResponse(HttpStatus.SC_OK, MDC.get(ONAPLogConstants.MDCs.REQUEST_ID), orchestrationList,
 229                 apiVersion);
 230     }
 231
 232     @POST
 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)))))
 238     @Transactional
 239     public Response unlockOrchestrationRequest(String requestJSON, @PathParam("requestId") String requestId,
 240             @PathParam("version") String version) throws ApiException {
 241
 242         logger.debug("requestId is: {}", requestId);
 243         ServiceInstancesRequest sir;
 244
 245         try {
 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)
 252                             .build();
 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();
 257
 258             throw validateException;
 259
 260         }
 261         try {
 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)
 267                             .build();
 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;
 272         }
 273
 274         InfraActiveRequests infraActiveRequest = infraActiveRequestLookup(requestId);
 275
 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);
 283         } else {
 284
 285             ErrorLoggerInfo errorLoggerInfo =
 286                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_DB_ATTRIBUTE_NOT_FOUND, ErrorCode.DataError).build();
 287
 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)
 291                             .build();
 292
 293             throw validateException;
 294         }
 295         return Response.status(HttpStatus.SC_NO_CONTENT).entity("").build();
 296     }
 297
 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();
 302
 303         ObjectMapper mapper = new ObjectMapper();
 304
 305         request.setRequestId(iar.getRequestId());
 306         request.setRequestScope(iar.getRequestScope());
 307         request.setRequestType(iar.getRequestAction());
 308
 309         String originalRequestId = iar.getOriginalRequestId();
 310         if (originalRequestId != null) {
 311             request.setOriginalRequestId(originalRequestId);
 312         }
 313
 314         InstanceReferences ir = new InstanceReferences();
 315         if (iar.getNetworkId() != null)
 316             ir.setNetworkInstanceId(iar.getNetworkId());
 317         if (iar.getNetworkName() != null)
 318             ir.setNetworkInstanceName(iar.getNetworkName());
 319         if (iar.getServiceInstanceId() != null)
 320             ir.setServiceInstanceId(iar.getServiceInstanceId());
 321         if (iar.getServiceInstanceName() != null)
 322             ir.setServiceInstanceName(iar.getServiceInstanceName());
 323         if (iar.getVfModuleId() != null)
 324             ir.setVfModuleInstanceId(iar.getVfModuleId());
 325         if (iar.getVfModuleName() != null)
 326             ir.setVfModuleInstanceName(iar.getVfModuleName());
 327         if (iar.getVnfId() != null)
 328             ir.setVnfInstanceId(iar.getVnfId());
 329         if (iar.getVnfName() != null)
 330             ir.setVnfInstanceName(iar.getVnfName());
 331         if (iar.getVolumeGroupId() != null)
 332             ir.setVolumeGroupInstanceId(iar.getVolumeGroupId());
 333         if (iar.getVolumeGroupName() != null)
 334             ir.setVolumeGroupInstanceName(iar.getVolumeGroupName());
 335         if (iar.getInstanceGroupId() != null)
 336             ir.setInstanceGroupId(iar.getInstanceGroupId());
 337         if (iar.getInstanceGroupName() != null)
 338             ir.setInstanceGroupName(iar.getInstanceGroupName());
 339
 340         request.setInstanceReferences(ir);
 341
 342         RequestDetails requestDetails = null;
 343
 344         if (StringUtils.isNotBlank(requestBody)) {
 345             try {
 346                 if (requestBody.contains("\"requestDetails\":")) {
 347                     ServiceInstancesRequest sir = mapper.readValue(requestBody, ServiceInstancesRequest.class);
 348                     requestDetails = sir.getRequestDetails();
 349                 } else {
 350                     requestDetails = mapper.readValue(requestBody, RequestDetails.class);
 351                 }
 352                 if (requestDetails.getRequestInfo() != null && iar.getProductFamilyName() != null) {
 353                     requestDetails.getRequestInfo().setProductFamilyName(iar.getProductFamilyName());
 354                 }
 355                 if (requestDetails.getCloudConfiguration() != null && iar.getTenantName() != null) {
 356                     requestDetails.getCloudConfiguration().setTenantName(iar.getTenantName());
 357                 }
 358
 359             } catch (IOException e) {
 360                 logger.error("Exception occurred", e);
 361                 ErrorLoggerInfo errorLoggerInfo =
 362                         new ErrorLoggerInfo.Builder(MessageEnum.APIH_REQUEST_VALIDATION_ERROR, ErrorCode.SchemaError)
 363                                 .build();
 364                 ValidateException validateException =
 365                         new ValidateException.Builder("Mapping of request to JSON object failed : ",
 366                                 HttpStatus.SC_BAD_REQUEST, ErrorNumbers.SVC_BAD_PARAMETER).cause(e)
 367                                         .errorInfo(errorLoggerInfo).build();
 368
 369                 throw validateException;
 370             }
 371         }
 372         request.setRequestDetails(requestDetails);
 373
 374         if (iar.getStartTime() != null) {
 375             String startTimeStamp =
 376                     new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss").format(iar.getStartTime()) + " GMT";
 377             request.setStartTime(startTimeStamp);
 378         }
 379         if (iar.getEndTime() != null) {
 380             String endTimeStamp = new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss").format(iar.getEndTime()) + " GMT";
 381             request.setFinishTime(endTimeStamp);
 382         }
 383
 384         RequestStatus status = new RequestStatus();
 385
 386         if (iar.getModifyTime() != null) {
 387             String timeStamp = new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss").format(iar.getModifyTime()) + " GMT";
 388             status.setTimeStamp(timeStamp);
 389         }
 390
 391         status.setRequestState(mapRequestStatusToRequest(iar, format));
 392
 393         if (iar.getProgress() != null) {
 394             status.setPercentProgress(iar.getProgress().intValue());
 395         }
 396
 397         if (iar.getCloudApiRequests() != null && !iar.getCloudApiRequests().isEmpty() && includeCloudRequest) {
 398             iar.getCloudApiRequests().stream().forEach(cloudRequest -> {
 399                 try {
 400                     request.getCloudRequestData()
 401                             .add(new CloudRequestData(mapper.readValue(cloudRequest.getRequestBody(), Object.class),
 402                                     cloudRequest.getCloudIdentifier()));
 403                 } catch (Exception e) {
 404                     logger.error("Error reading Cloud Request", e);
 405                 }
 406             });
 407         }
 408
 409         mapRequestStatusAndExtSysErrSrcToRequest(iar, status, format, version);
 410
 411         request.setRequestStatus(status);
 412         return request;
 413     }
 414
 415     protected String mapRequestStatusToRequest(InfraActiveRequests iar, String format) {
 416         if (iar.getRequestStatus() != null) {
 417             boolean requestFormat = false;
 418             if (format != null) {
 419                 requestFormat = EnumUtils.isValidEnum(OrchestrationRequestFormat.class, format.toUpperCase());
 420             }
 421             if (requestFormat) {
 422                 return iar.getRequestStatus();
 423             } else {
 424                 if (Status.ABORTED.toString().equalsIgnoreCase(iar.getRequestStatus())
 425                         || Status.ROLLED_BACK.toString().equalsIgnoreCase(iar.getRequestStatus())
 426                         || Status.ROLLED_BACK_TO_ASSIGNED.toString().equalsIgnoreCase(iar.getRequestStatus())
 427                         || Status.ROLLED_BACK_TO_CREATED.toString().equalsIgnoreCase(iar.getRequestStatus())) {
 428                     return Status.FAILED.toString();
 429                 } else {
 430                     return iar.getRequestStatus();
 431                 }
 432             }
 433         }
 434         return null;
 435     }
 436
 437     protected void mapRequestStatusAndExtSysErrSrcToRequest(InfraActiveRequests iar, RequestStatus status,
 438             String format, String version) {
 439         String rollbackStatusMessage = iar.getRollbackStatusMessage();
 440         String flowStatusMessage = iar.getFlowStatus();
 441         String retryStatusMessage = iar.getRetryStatusMessage();
 442         String taskName = null;
 443
 444         if (daysSinceRequest(iar) <= camundaCleanupInterval()) {
 445             if (format == null || !format.equalsIgnoreCase(OrchestrationRequestFormat.SIMPLENOTASKINFO.toString())) {
 446                 if (flowStatusMessage != null && !flowStatusMessage.equals("Successfully completed all Building Blocks")
 447                         && !flowStatusMessage.equals("All Rollback flows have completed successfully")) {
 448                     taskName = camundaRequestHandler.getTaskName(iar.getRequestId());
 449                     if (taskName != null) {
 450                         flowStatusMessage = flowStatusMessage + " TASK INFORMATION: " + taskName;
 451                     }
 452                 }
 453             }
 454         }
 455
 456         String statusMessages = null;
 457         if (iar.getStatusMessage() != null) {
 458             if (StringUtils.isNotBlank(iar.getExtSystemErrorSource())) {
 459                 statusMessages = "STATUS: "
 460                         + String.format(ERROR_MESSAGE_PREFIX, iar.getExtSystemErrorSource(), iar.getStatusMessage());
 461             } else {
 462                 statusMessages = "STATUS: " + iar.getStatusMessage();
 463             }
 464         }
 465
 466         if (OrchestrationRequestFormat.STATUSDETAIL.toString().equalsIgnoreCase(format)) {
 467             if (flowStatusMessage != null) {
 468                 status.setFlowStatus(flowStatusMessage);
 469             }
 470             if (retryStatusMessage != null) {
 471                 status.setRetryStatusMessage(retryStatusMessage);
 472             }
 473             if (rollbackStatusMessage != null) {
 474                 status.setRollbackStatusMessage(rollbackStatusMessage);
 475             }
 476             if (version.matches("v[8-9]|v[1-9][0-9]")) {
 477                 if (iar.getResourceStatusMessage() != null) {
 478                     status.setResourceStatusMessage(iar.getResourceStatusMessage());
 479                 }
 480             }
 481
 482             status.setExtSystemErrorSource(iar.getExtSystemErrorSource());
 483             status.setRollbackExtSystemErrorSource(iar.getRollbackExtSystemErrorSource());
 484         } else {
 485
 486             if (flowStatusMessage != null) {
 487                 if (statusMessages != null) {
 488                     statusMessages = statusMessages + " " + "FLOW STATUS: " + flowStatusMessage;
 489                 } else {
 490                     statusMessages = "FLOW STATUS: " + flowStatusMessage;
 491                 }
 492             }
 493             if (retryStatusMessage != null) {
 494                 if (statusMessages != null) {
 495                     statusMessages = statusMessages + " " + "RETRY STATUS: " + retryStatusMessage;
 496                 } else {
 497                     statusMessages = "RETRY STATUS: " + retryStatusMessage;
 498                 }
 499             }
 500             if (rollbackStatusMessage != null) {
 501                 if (statusMessages != null) {
 502                     statusMessages = statusMessages + " " + "ROLLBACK STATUS: " + rollbackStatusMessage;
 503                 } else {
 504                     statusMessages = "ROLLBACK STATUS: " + rollbackStatusMessage;
 505                 }
 506             }
 507             if (iar.getResourceStatusMessage() != null) {
 508                 if (statusMessages != null) {
 509                     statusMessages = statusMessages + " " + "RESOURCE STATUS: " + iar.getResourceStatusMessage();
 510                 } else {
 511                     statusMessages = "RESOURCE STATUS: " + iar.getResourceStatusMessage();
 512                 }
 513             }
 514         }
 515
 516         if (statusMessages != null) {
 517             status.setStatusMessage(statusMessages);
 518         }
 519     }
 520
 521     public List<org.onap.so.serviceinstancebeans.RequestProcessingData> mapRequestProcessingData(
 522             List<org.onap.so.db.request.beans.RequestProcessingData> processingData) {
 523         List<org.onap.so.serviceinstancebeans.RequestProcessingData> addedRequestProcessingData = new ArrayList<>();
 524         org.onap.so.serviceinstancebeans.RequestProcessingData finalProcessingData =
 525                 new org.onap.so.serviceinstancebeans.RequestProcessingData();
 526         String currentGroupingId = null;
 527         HashMap<String, String> tempMap = new HashMap<>();
 528         List<HashMap<String, String>> tempList = new ArrayList<>();
 529         for (RequestProcessingData data : processingData) {
 530             String groupingId = data.getGroupingId();
 531             String tag = data.getTag();
 532             if (currentGroupingId == null || !currentGroupingId.equals(groupingId)) {
 533                 if (!tempMap.isEmpty()) {
 534                     tempList.add(tempMap);
 535                     finalProcessingData.setDataPairs(tempList);
 536                     addedRequestProcessingData.add(finalProcessingData);
 537                 }
 538                 finalProcessingData = new org.onap.so.serviceinstancebeans.RequestProcessingData();
 539                 if (groupingId != null) {
 540                     finalProcessingData.setGroupingId(groupingId);
 541                 }
 542                 if (tag != null) {
 543                     finalProcessingData.setTag(tag);
 544                 }
 545                 currentGroupingId = groupingId;
 546                 tempMap = new HashMap<>();
 547                 tempList = new ArrayList<>();
 548                 if (data.getName() != null && data.getValue() != null) {
 549                     tempMap.put(data.getName(), data.getValue());
 550                 }
 551             } else {
 552                 if (data.getName() != null && data.getValue() != null) {
 553                     tempMap.put(data.getName(), data.getValue());
 554                 }
 555             }
 556         }
 557         if (tempMap.size() > 0) {
 558             tempList.add(tempMap);
 559             finalProcessingData.setDataPairs(tempList);
 560         }
 561         addedRequestProcessingData.add(finalProcessingData);
 562         return addedRequestProcessingData;
 563     }
 564
 565     protected boolean isRequestProcessingDataRequired(String format) {
 566         if (StringUtils.isNotEmpty(format) && (format.equalsIgnoreCase(OrchestrationRequestFormat.SIMPLE.name())
 567                 || format.equalsIgnoreCase(OrchestrationRequestFormat.SIMPLENOTASKINFO.toString()))) {
 568             return false;
 569         } else {
 570             return true;
 571         }
 572     }
 573
 574     protected InfraActiveRequests infraActiveRequestLookup(String requestId) throws ApiException {
 575         InfraActiveRequests infraActiveRequest = null;
 576         try {
 577             infraActiveRequest = requestsDbClient.getInfraActiveRequestbyRequestId(requestId);
 578         } catch (Exception e) {
 579             logger.error("Exception occurred while communicating with RequestDb during InfraActiveRequest lookup ", e);
 580             ErrorLoggerInfo errorLoggerInfo =
 581                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_DB_ACCESS_EXC, ErrorCode.AvailabilityError).build();
 582
 583             ValidateException validateException = new ValidateException.Builder(
 584                     "Exception occurred while communicating with RequestDb during InfraActiveRequest lookup",
 585                     HttpStatus.SC_NOT_FOUND, ErrorNumbers.NO_COMMUNICATION_TO_REQUESTS_DB).cause(e)
 586                             .errorInfo(errorLoggerInfo).build();
 587
 588             throw validateException;
 589         }
 590
 591         if (infraActiveRequest == null) {
 592             ErrorLoggerInfo errorLoggerInfo =
 593                     new ErrorLoggerInfo.Builder(MessageEnum.APIH_BPEL_COMMUNICATE_ERROR, ErrorCode.BusinessProcessError)
 594                             .build();
 595
 596             ValidateException validateException = new ValidateException.Builder(
 597                     "Null response from RequestDB when searching by RequestId " + requestId, HttpStatus.SC_NOT_FOUND,
 598                     ErrorNumbers.SVC_DETAILED_SERVICE_ERROR).errorInfo(errorLoggerInfo).build();
 599
 600             throw validateException;
 601         }
 602         return infraActiveRequest;
 603     }
 604
 605     protected long daysSinceRequest(InfraActiveRequests request) {
 606         long startTime = request.getStartTime().getTime();
 607         long now = System.currentTimeMillis();
 608
 609         return TimeUnit.MILLISECONDS.toDays(now - startTime);
 610     }
 611
 612     protected int camundaCleanupInterval() {
 613         String cleanupInterval = env.getProperty("mso.camundaCleanupInterval");
 614         int days = 30;
 615         if (cleanupInterval != null) {
 616             days = Integer.parseInt(cleanupInterval);
 617         }
 618         return days;
 619     }
 620 }