After upgrading from 2.4 patch 9 to patch 12 we're receiving an error when using /admin/API/mnt/AuthStatus/MACAddress/
Testing with curl:
curl -kv -u <user>:<pwd> "https://10.x.x.x/admin/API/mnt/AuthStatus/MACAddress/<MAC>/0/1/0"
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<mnt-rest-result>
<http-code>500</http-code>
<cpm-code>34110</cpm-code>
<description>Server has encountered error while processing the REST request</description>
<module-name>MnT</module-name>
<internal-error-info>SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RESTAuthSearchMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RESTAuthSearchMap.getAuthStatus-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "RESPONSE": invalid identifier
</internal-error-info>
<requested-operation>Get By Type</requested-operation>
<resource-id>N/A</resource-id>
<resource-name>N/A</resource-name>
<resource-type>FullRESTAuthStatusOutputList</resource-type>
<status>SERVER_ERROR</status>
</mnt-rest-result>
I found a similiar bug (https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvs52031) but this was fixed in patch 12.