8c919f0cf702b55ff1c68e728ec64e57fb42016b
[so.git] /
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.logging.filter.base.ErrorCode;
50 import org.onap.so.apihandler.common.ErrorNumbers;
51 import org.onap.so.apihandler.common.ResponseBuilder;
52 import org.onap.so.apihandlerinfra.exceptions.ApiException;
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.so.logger.MessageEnum;
62 import org.onap.so.serviceinstancebeans.CloudRequestData;
63 import org.onap.so.serviceinstancebeans.GetOrchestrationListResponse;
64 import org.onap.so.serviceinstancebeans.GetOrchestrationResponse;
65 import org.onap.so.serviceinstancebeans.InstanceReferences;
66 import org.onap.so.serviceinstancebeans.Request;
67 import org.onap.so.serviceinstancebeans.RequestDetails;
68 import org.onap.so.serviceinstancebeans.RequestList;
69 import org.onap.so.serviceinstancebeans.RequestStatus;
70 import org.onap.so.serviceinstancebeans.ServiceInstancesRequest;
71 import org.onap.so.utils.UUIDChecker;
72 import org.slf4j.Logger;
73 import org.slf4j.LoggerFactory;
74 import org.slf4j.MDC;
75 import org.springframework.beans.factory.annotation.Autowired;
76 import org.springframework.core.env.Environment;
77 import org.springframework.stereotype.Component;
78 import org.springframework.web.client.HttpClientErrorException;
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.getExternalRequestProcessingDataBySoRequestId(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         if (!version.matches("v[1-7]")) {
315             String workflowName = iar.getWorkflowName();
316             if (workflowName == null) {
317                 workflowName = iar.getRequestAction();
318             }
319             request.setWorkflowName(workflowName);
320
321             String operationName = iar.getOperationName();
322             if (operationName != null) {
323                 request.setOperationName(operationName);
324             }
325         }
326
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());
352
353         request.setInstanceReferences(ir);
354
355         RequestDetails requestDetails = null;
356
357         if (StringUtils.isNotBlank(requestBody)) {
358             try {
359                 if (requestBody.contains("\"requestDetails\":")) {
360                     ServiceInstancesRequest sir = mapper.readValue(requestBody, ServiceInstancesRequest.class);
361                     requestDetails = sir.getRequestDetails();
362                 } else {
363                     requestDetails = mapper.readValue(requestBody, RequestDetails.class);
364                 }
365                 if (requestDetails.getRequestInfo() != null && iar.getProductFamilyName() != null) {
366                     requestDetails.getRequestInfo().setProductFamilyName(iar.getProductFamilyName());
367                 }
368                 if (requestDetails.getCloudConfiguration() != null && iar.getTenantName() != null) {
369                     requestDetails.getCloudConfiguration().setTenantName(iar.getTenantName());
370                 }
371
372             } catch (IOException e) {
373                 logger.error(String.format("Failed to parse request (id: %s) : ", request.getRequestId()), e);
374             }
375         }
376         request.setRequestDetails(requestDetails);
377
378         if (iar.getStartTime() != null) {
379             String startTimeStamp =
380                     new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss").format(iar.getStartTime()) + " GMT";
381             request.setStartTime(startTimeStamp);
382         }
383         if (iar.getEndTime() != null) {
384             String endTimeStamp = new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss").format(iar.getEndTime()) + " GMT";
385             request.setFinishTime(endTimeStamp);
386         }
387
388         RequestStatus status = new RequestStatus();
389
390         if (iar.getModifyTime() != null) {
391             String timeStamp = new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss").format(iar.getModifyTime()) + " GMT";
392             status.setTimeStamp(timeStamp);
393         }
394
395         status.setRequestState(mapRequestStatusToRequest(iar, format));
396
397         if (iar.getProgress() != null) {
398             status.setPercentProgress(iar.getProgress().intValue());
399         }
400
401         if (iar.getCloudApiRequests() != null && !iar.getCloudApiRequests().isEmpty() && includeCloudRequest) {
402             iar.getCloudApiRequests().stream().forEach(cloudRequest -> {
403                 try {
404                     request.getCloudRequestData()
405                             .add(new CloudRequestData(mapper.readValue(cloudRequest.getRequestBody(), Object.class),
406                                     cloudRequest.getCloudIdentifier()));
407                 } catch (Exception e) {
408                     logger.error("Error reading Cloud Request", e);
409                 }
410             });
411         }
412
413         mapRequestStatusAndExtSysErrSrcToRequest(iar, status, format, version);
414
415         request.setRequestStatus(status);
416         return request;
417     }
418
419     protected String mapRequestStatusToRequest(InfraActiveRequests iar, String format) {
420         if (iar.getRequestStatus() != null) {
421             boolean requestFormat = false;
422             if (format != null) {
423                 requestFormat = EnumUtils.isValidEnum(OrchestrationRequestFormat.class, format.toUpperCase());
424             }
425             if (requestFormat) {
426                 return iar.getRequestStatus();
427             } else {
428                 if (Status.ABORTED.toString().equalsIgnoreCase(iar.getRequestStatus())
429                         || Status.ROLLED_BACK.toString().equalsIgnoreCase(iar.getRequestStatus())
430                         || Status.ROLLED_BACK_TO_ASSIGNED.toString().equalsIgnoreCase(iar.getRequestStatus())
431                         || Status.ROLLED_BACK_TO_CREATED.toString().equalsIgnoreCase(iar.getRequestStatus())) {
432                     return Status.FAILED.toString();
433                 } else {
434                     return iar.getRequestStatus();
435                 }
436             }
437         }
438         return null;
439     }
440
441     protected void mapRequestStatusAndExtSysErrSrcToRequest(InfraActiveRequests iar, RequestStatus status,
442             String format, String version) {
443         String rollbackStatusMessage = iar.getRollbackStatusMessage();
444         String flowStatusMessage = iar.getFlowStatus();
445         String retryStatusMessage = iar.getRetryStatusMessage();
446         String taskName = null;
447
448         if (daysSinceRequest(iar) <= camundaCleanupInterval()) {
449             if (format == null || !format.equalsIgnoreCase(OrchestrationRequestFormat.SIMPLENOTASKINFO.toString())) {
450                 if (flowStatusMessage != null && !flowStatusMessage.equals("Successfully completed all Building Blocks")
451                         && !flowStatusMessage.equals("All Rollback flows have completed successfully")) {
452                     taskName = camundaRequestHandler.getTaskName(iar.getRequestId());
453                     if (taskName != null) {
454                         flowStatusMessage = flowStatusMessage + " TASK INFORMATION: " + taskName;
455                     }
456                 }
457             }
458         }
459
460         String statusMessages = null;
461         if (iar.getStatusMessage() != null) {
462             if (StringUtils.isNotBlank(iar.getExtSystemErrorSource())) {
463                 statusMessages = "STATUS: "
464                         + String.format(ERROR_MESSAGE_PREFIX, iar.getExtSystemErrorSource(), iar.getStatusMessage());
465             } else {
466                 statusMessages = "STATUS: " + iar.getStatusMessage();
467             }
468         }
469
470         if (OrchestrationRequestFormat.STATUSDETAIL.toString().equalsIgnoreCase(format)) {
471             if (flowStatusMessage != null) {
472                 status.setFlowStatus(flowStatusMessage);
473             }
474             if (retryStatusMessage != null) {
475                 status.setRetryStatusMessage(retryStatusMessage);
476             }
477             if (rollbackStatusMessage != null) {
478                 status.setRollbackStatusMessage(rollbackStatusMessage);
479             }
480             if (version.matches("v[8-9]|v[1-9][0-9]")) {
481                 if (iar.getResourceStatusMessage() != null) {
482                     status.setResourceStatusMessage(iar.getResourceStatusMessage());
483                 }
484             }
485
486             status.setExtSystemErrorSource(iar.getExtSystemErrorSource());
487             status.setRollbackExtSystemErrorSource(iar.getRollbackExtSystemErrorSource());
488         } else {
489
490             if (flowStatusMessage != null) {
491                 if (statusMessages != null) {
492                     statusMessages = statusMessages + " " + "FLOW STATUS: " + flowStatusMessage;
493                 } else {
494                     statusMessages = "FLOW STATUS: " + flowStatusMessage;
495                 }
496             }
497             if (retryStatusMessage != null) {
498                 if (statusMessages != null) {
499                     statusMessages = statusMessages + " " + "RETRY STATUS: " + retryStatusMessage;
500                 } else {
501                     statusMessages = "RETRY STATUS: " + retryStatusMessage;
502                 }
503             }
504             if (rollbackStatusMessage != null) {
505                 if (statusMessages != null) {
506                     statusMessages = statusMessages + " " + "ROLLBACK STATUS: " + rollbackStatusMessage;
507                 } else {
508                     statusMessages = "ROLLBACK STATUS: " + rollbackStatusMessage;
509                 }
510             }
511             if (iar.getResourceStatusMessage() != null) {
512                 if (statusMessages != null) {
513                     statusMessages = statusMessages + " " + "RESOURCE STATUS: " + iar.getResourceStatusMessage();
514                 } else {
515                     statusMessages = "RESOURCE STATUS: " + iar.getResourceStatusMessage();
516                 }
517             }
518         }
519
520         if (statusMessages != null) {
521             status.setStatusMessage(statusMessages);
522         }
523     }
524
525     public List<org.onap.so.serviceinstancebeans.RequestProcessingData> mapRequestProcessingData(
526             List<org.onap.so.db.request.beans.RequestProcessingData> processingData) {
527         List<org.onap.so.serviceinstancebeans.RequestProcessingData> addedRequestProcessingData = new ArrayList<>();
528         org.onap.so.serviceinstancebeans.RequestProcessingData finalProcessingData =
529                 new org.onap.so.serviceinstancebeans.RequestProcessingData();
530         String currentGroupingId = null;
531         HashMap<String, String> tempMap = new HashMap<>();
532         List<HashMap<String, String>> tempList = new ArrayList<>();
533         for (RequestProcessingData data : processingData) {
534             String groupingId = data.getGroupingId();
535             String tag = data.getTag();
536             if (currentGroupingId == null || !currentGroupingId.equals(groupingId)) {
537                 if (!tempMap.isEmpty()) {
538                     tempList.add(tempMap);
539                     finalProcessingData.setDataPairs(tempList);
540                     addedRequestProcessingData.add(finalProcessingData);
541                 }
542                 finalProcessingData = new org.onap.so.serviceinstancebeans.RequestProcessingData();
543                 if (groupingId != null) {
544                     finalProcessingData.setGroupingId(groupingId);
545                 }
546                 if (tag != null) {
547                     finalProcessingData.setTag(tag);
548                 }
549                 currentGroupingId = groupingId;
550                 tempMap = new HashMap<>();
551                 tempList = new ArrayList<>();
552                 if (data.getName() != null && data.getValue() != null) {
553                     tempMap.put(data.getName(), data.getValue());
554                 }
555             } else {
556                 if (data.getName() != null && data.getValue() != null) {
557                     tempMap.put(data.getName(), data.getValue());
558                 }
559             }
560         }
561         if (tempMap.size() > 0) {
562             tempList.add(tempMap);
563             finalProcessingData.setDataPairs(tempList);
564         }
565         addedRequestProcessingData.add(finalProcessingData);
566         return addedRequestProcessingData;
567     }
568
569     protected boolean isRequestProcessingDataRequired(String format) {
570         if (StringUtils.isNotEmpty(format) && (format.equalsIgnoreCase(OrchestrationRequestFormat.SIMPLE.name())
571                 || format.equalsIgnoreCase(OrchestrationRequestFormat.SIMPLENOTASKINFO.toString()))) {
572             return false;
573         } else {
574             return true;
575         }
576     }
577
578     protected InfraActiveRequests infraActiveRequestLookup(String requestId) throws ApiException {
579         InfraActiveRequests infraActiveRequest = null;
580         try {
581             infraActiveRequest = requestsDbClient.getInfraActiveRequestbyRequestId(requestId);
582         } catch (HttpClientErrorException e) {
583             ValidateException validateException = getValidateExceptionFromHttpClientErrorException(e);
584             throw validateException;
585         } catch (Exception e) {
586             ValidateException validateException = getValidateExceptionForInternalServerError(e);
587             throw validateException;
588         }
589
590         if (infraActiveRequest == null) {
591             ValidateException validateException = getValidateExceptionForNotFound(requestId);
592             throw validateException;
593         }
594         return infraActiveRequest;
595     }
596
597     private ValidateException getValidateExceptionForNotFound(String requestId) {
598         ErrorLoggerInfo errorLoggerInfo =
599                 new ErrorLoggerInfo.Builder(MessageEnum.APIH_BPEL_COMMUNICATE_ERROR, ErrorCode.BusinessProcessError)
600                         .build();
601
602         ValidateException validateException =
603                 new ValidateException.Builder("Null response from RequestDB when searching by RequestId " + requestId,
604                         HttpStatus.SC_NOT_FOUND, ErrorNumbers.SVC_DETAILED_SERVICE_ERROR).errorInfo(errorLoggerInfo)
605                                 .build();
606         return validateException;
607     }
608
609     private ValidateException getValidateExceptionForInternalServerError(Exception e) {
610         logger.error("Exception occurred while communicating with RequestDb during InfraActiveRequest lookup ", e);
611         ErrorLoggerInfo errorLoggerInfo =
612                 new ErrorLoggerInfo.Builder(MessageEnum.APIH_DB_ACCESS_EXC, ErrorCode.AvailabilityError).build();
613
614         ValidateException validateException = new ValidateException.Builder(
615                 "Exception occurred while communicating with RequestDb during InfraActiveRequest lookup",
616                 HttpStatus.SC_INTERNAL_SERVER_ERROR, ErrorNumbers.SVC_GENERAL_SERVICE_ERROR).cause(e)
617                         .errorInfo(errorLoggerInfo).build();
618         return validateException;
619     }
620
621     private ValidateException getValidateExceptionFromHttpClientErrorException(HttpClientErrorException e) {
622         logger.error("Exception occurred while communicating with RequestDb during InfraActiveRequest lookup ", e);
623         ErrorLoggerInfo errorLoggerInfo =
624                 new ErrorLoggerInfo.Builder(MessageEnum.APIH_DB_ACCESS_EXC, ErrorCode.AvailabilityError).build();
625
626         ValidateException validateException = new ValidateException.Builder(
627                 "Exception occurred while communicating with RequestDb during InfraActiveRequest lookup",
628                 e.getRawStatusCode(), ErrorNumbers.NO_COMMUNICATION_TO_REQUESTS_DB).cause(e).errorInfo(errorLoggerInfo)
629                         .build();
630         return validateException;
631     }
632
633     protected long daysSinceRequest(InfraActiveRequests request) {
634         long startTime = request.getStartTime().getTime();
635         long now = System.currentTimeMillis();
636
637         return TimeUnit.MILLISECONDS.toDays(now - startTime);
638     }
639
640     protected int camundaCleanupInterval() {
641         String cleanupInterval = env.getProperty("mso.camundaCleanupInterval");
642         int days = 30;
643         if (cleanupInterval != null) {
644             days = Integer.parseInt(cleanupInterval);
645         }
646         return days;
647     }
648 }