IT42575: "RESOURCE NOT FOUND" GUI ERROR ON MICROSOFT SQL PIT RESTORE POINT SEARCH

APAR status

• Closed as program error.

Error description

• The IBM Spectrum Protect Plus restore wizard displays the
  following message on Microsoft SQL On-demand Point-In-Time (PIT)
  restore point search :
  
  Unhandled ErrorClose modal
  Error
  {     "headers": { "normalizedNames": {}, "lazyUpdate": null },
         "status": 404,
     "statusText": "OK",
            "url": https://<SPPAddress>/api/application/sql/
                   logbackupavailability?from=recovery
                   &resourceType=database,
             "ok": false,
           "name": "HttpErrorResponse",
        "message": "Http failure response for https://<SPPAddress>
                    /api/application/sql/logbackupavailability
                    ?from=recovery&resourceType=database: 404 OK",
          "error": { "id": "XSBResourceNotFound",
            "description": "Resource not found.",
                  "title": "A problem occurred while executing the
                            requested operation" },
        "request": { "url": https://<SPPAddress>:/api/application/
                            sql/logbackupavailability
                            ?from=recovery&resourceType=database,
                    "body": "{\"resourceIds\":[\"xxxxxxxxxxx\"],
                              \"startTime\":1668639600000,
                              \"endTime\":1668726000000,
                              \"location\":
                                 {\"type\":\"site\",
                                    \"id\":\"2103\"}}",
          "reportProgress": false,
         "withCredentials": false,
            "responseType": "json",
                  "method": "POST",
                 "headers": { "normalizedNames": {},
                                   "lazyUpdate": null,
                                      "headers": {},
                                     "lazyInit": null },
                  "params": { "updates": null, "cloneFrom": null,
                              "encoder": {}, "map": {} },
           "urlWithParams": https://<SPPAddress>:/api/application/
                            sql/logbackupavailability
                            ?from=recovery&resourceType=database}}
  
  On-demand snapshot restore is not affected.
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  
  Additional Keywords: SPP, SPPLUS, TS011316788 , wizard, OnDemand
  restore
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.12                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.13. Note that this is subject to change at the          *
  * discretion of IBM                                            *
  ****************************************************************
  

Problem conclusion

• This problem has been fixed so that SQL PIT "search backup"
  reports either valid backup time window, or "no backup" message,
  depending on the log backup completion status.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels