Prime Infrastructure 2.2 GET Radios API produce error

[choywy]

Hi,

I've this PI v2.2.2 and when I perform a GET Radios API (https://x.x.x.x/webacs/api/v1/data/Radios) on it, it has the following error.....There are no problem on others API, only this GET Radios have this problem.....Can I know what error is this and how to fix it?

<errorDocument><httpResponseCode>500</httpResponseCode><httpMethod>GET</httpMethod><message>could not execute query; SQL [select count(*) as y0_ from Radios this_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query</message><exception>org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select count(*) as y0_ from Radios this_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query</exception><uriPath>data/Radios</uriPath><queryParams>{}</queryParams></errorDocument>

[Spencer Zier]

This looks like CSCus50208 (https://tools.cisco.com/bugsearch/bug/CSCus50208).  That issue was fixed in the 2.2.1 maintenance release.  The 2.2.2 patch being a cumulative patch, the issue should've been fixed by installing 2.2.2 either onto 2.2.1 or 2.2.0.

Can you please confirm that the 2.2.2 patch is installed on the appliance you've seen this issue on?

[choywy]

I did install the 2.2.2 patch after the 2.2 installation....I can do a screenshot...

[choywy]

Below is the screenshot of my PI version....with 2.2.2 maintenance release installed...

[choywy]

I even install the latest patch "pi222_Update_04-3.ubf"....But still unable to GET the Radios summary API...

From the error message...Is it something to do with the SQL nested statement? It throws a "nested exception" error??

[Spencer Zier]

Okay.  Please contact me via email (my address is in my profile).  We'll need to setup a meeting to debug the issue to figure out why the 2.2.2 patch didn't resolve it for you.