IT42965: "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 :
   
  { "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: 10.1.13
  
   
  Additional Keywords    TS011497535 IT42575 SPP SPPLUS WIZARD
  ONDEMAND
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.12, 10.1.13.            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * currently projected to be fixed in BM Spectrum Protect Plus  *
  * level 10.1.14. 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" will
  work for databases of high log sequence number.
  

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:

Modules/Macros

• SQL
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels