ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Service Point Completed statutes not listed

book

Article ID: 226355

calendar_today

Updated On:

Products

CA Service Catalog

Issue/Introduction

Completed status from CA service catalog not appear in CA service point , all tickets closed any related to CA service catalog request not appear in closed ticket in service point.

Cause

This is a know issue and some code changes were identified i.e.

Checking application.conf in searchmicroservice/conf folder you can find
Default xFlow installed directory path:(environment specific) "C:\Program Files\CA\xFlow\APPS\Services\searchmicroservice-17.0.479\conf"

searchQueryInactive = """{
      "from":%d,
      "size": %d,
      "sort" : [
        { "open_dt": { "order": "desc" } }
      ],
      "query": {
        "bool": {
          "must": {
            "match": {
              "requested_for.id": "%s"
            }
          },
          "must_not": {
               "bool": {
                "should": [
                    {
                      "match": {
                        "request_name.asis": "-1"
                      }
                    }
                ]
              }
             },
            "must": {
               "bool": {
                "should": [
                    {
                      "terms": {
                        "status.code": ["2", "4"]
                      }
                    }
                ]
              }
             }
        }
      },
      "stored_fields": ["request_id",    "request_name",    "requested_by", "priority", "last_mod_dt", "open_dt", "resolve_dt", "status.code"]
    }""",

 

Environment

Release : 17.3

Component : Catalog - Service Point/BUI

Resolution

Work Around:
================

Update the entire block mentioned in the cause section to below code block

searchQueryInactive = """{
      "from":%d,
      "size": %d,
      "sort" : [
        { "open_dt": { "order": "desc" } }
      ],
  "query": {
   "bool": {
    "must_not": [
     {
      "match": {
       "request_name.asis": "-1"
      }
     }
    ],
    "must": [
     {
      "terms": {
       "status.code": ["2", "4"]
      }
     },
     {
      "match": {
       "requested_for.id": "%s"
      }
     }
    ]
   }
  },
      "stored_fields": ["request_id",    "request_name",    "requested_by", "priority", "last_mod_dt", "open_dt", "resolve_dt", "status.code"]
    }""",

Note: Recycle the Services of Catalog and xFlow services to clear any existing cache from old behavior.

Additional Information

This will be part of upcoming rollup patch as part of complete solution.