topic Re: Prime 3.8.0 error when querying ClientDetails.json in Controllers

Prime 3.8.0 error when querying ClientDetails.json

orp — Mon, 03 May 2021 13:50:02 GMT

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

Re: Prime 3.8.0 error when querying ClientDetails.json

Alexander Stevenson — Tue, 11 May 2021 18:31:55 GMT

Hello,

I've searched for 'Prime Infrastructure' version 3.8 in the Cisco Bug Search Tool and 274 results were returned:

https://bst.cloudapps.cisco.com/bugsearch/search?kw=Prime%20Infrastructure&pf=prdNm&rls=3.8&sb=anfr&bt=custV

You may find your bug in that lot...

Re: Prime 3.8.0 error when querying ClientDetails.json

orp — Wed, 12 May 2021 08:40:20 GMT

Couldn't find anything related...

Re: Prime 3.8.0 error when querying ClientDetails.json

Olga Bozhko — Tue, 01 Jun 2021 09:27:15 GMT

Hello,

Can you please check xmpNbiFw.log and persistence.log once the exception occurs and share the full stack trace?

For now, it looks like the request to DB returns a null value for some entity's attribute. You might find the problematic entity by changing .maxResult or .firstResult and then check whether null is set for any attributes of this entity in DB.