A while ago I started getting an Internal Server Error when querying the ClientDetails.json endpopint.
We query all of the results with pagination, and the error appears on a different page each time, never the first one.
Full error:
<ClientResponse(https://<server-ip>:443/webacs/api/v4/data/ClientDetails.json?.full=true&.maxResults=250&.firstResult=37250) [500 ]>
<CIMultiDictProxy('Cache-Control': 'private', 'Expires': 'Thu, 01 Jan 1970 00:00:00 GMT', 'Set-Cookie': 'JSESSIONID=C57B4210C4DF0464E0F3396927C1F7DB; Path=/webacs; Secure; HttpOnly', 'Strict-Transport-Security': 'max-age=31622400; includeSubDomains', 'X-XSS-Protection': '1; mode=block', 'X-Content-Type-Options': 'nosniff', 'Content-Security-Policy': "default-src 'self' wss: https: data: 'unsafe-inline' 'unsafe-eval'", 'X-NBI-TIME': '327', 'X-Frame-Options': 'SAMEORIGIN', 'Date': 'Tue, 06 Apr 2021 22:26:18 GMT', 'Server-Timing': 'filters;dur=11;desc="Servlet filters"', 'Server-Timing': 'security;dur=288;desc="Authentication and authorization"', 'Server-Timing': 'cxf;dur=3;desc="CXF"', 'Server-Timing': 'nbi;dur=13;desc="NBI framework"', 'Server-Timing': 'db;dur=313;desc="Database access"', 'Server-Timing': 'marshalling;dur=1;desc="Response marshalling"', 'Server-Timing': 'total;dur=629;desc="Total time"', 'Content-Type': 'application/json', 'Content-Length': '363', 'Connection': 'close', 'Server': 'Prime')>
{"errorDocument":{"httpResponseCode":500,"httpMethod":"GET","message":"errorId=12,componentName=CRUD Error null identifier","exception":"com.cisco.xmp.web.query.PersistenceException: errorId=12,componentName=CRUD Error null identifier","uriPath":"data/ClientDetails","queryParams":"{.full=[true], .maxResults=[250], .firstResult=[37250]}","domain":"ROOT-DOMAIN"}}Exact prime version is-
3.8.0.0.310, PI 3.8 Update 02 version 2.0.0, PI 3.8.1 MaintenanceRelease 1.0.0
