topic Re: Prime Infrastructure 2.2 GET Radios API produce error in Controllers

Prime Infrastructure 2.2 GET Radios API produce error

choywy — Wed, 19 Aug 2015 11:35:03 GMT

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>

Re: Prime Infrastructure 2.2 GET Radios API produce error

Spencer Zier — Wed, 19 Aug 2015 15:07:42 GMT

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?

Re: Prime Infrastructure 2.2 GET Radios API produce error

choywy — Wed, 19 Aug 2015 21:29:50 GMT

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

Re: Prime Infrastructure 2.2 GET Radios API produce error

choywy — Wed, 19 Aug 2015 23:29:30 GMT

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

Re: Prime Infrastructure 2.2 GET Radios API produce error

choywy — Thu, 20 Aug 2015 12:25:03 GMT

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??

Re: Prime Infrastructure 2.2 GET Radios API produce error

Spencer Zier — Thu, 20 Aug 2015 17:37:42 GMT

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.