Guest

Preview Tool

Cisco Bug: CSCvs52031 - MACAdress API is not working(API/mnt/Session/MACAddress)

Last Modified

Sep 03, 2020

Products (1)

  • Cisco Identity Services Engine

Known Affected Releases

2.4(0.910)

Description (partial)

Symptom:
Following error on the API Connection:

<?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>Error in generating XML output. Error message = SqlMapClient operation;
bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RESTSDSearch.xml.
--- The error occurred while applying a parameter map.
--- Check the RESTSDSearch.getFullSess-InlineParameterMap. 
--- Check the statement (query failed).
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
</internal-error-info>
 <requested-operation>Get By Type</requested-operation>
 <resource-id>N/A</resource-id>
 <resource-name>N/A</resource-name>
 <resource-type>RESTSDStatus</resource-type>
 <status>SERVER_ERROR</status>
</mnt-rest-result>

Conditions:
REST API call url consists of:  admin/API/mnt/Session/MACAddress/[calling-station-id]/

[calling-station-id] being a MAC Address used for the lookup

Related Community Discussions

AuthStatus MACAdress API is not working (/admin/API/mnt/AuthStatus/MACAddress/) in 2.4.0.357-Patch12
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 &lt;user&gt;:&lt;pwd&gt; &quot;https://10.x.x.x/admin/API/mnt/AuthStatus/MACAddress/&lt;MAC&gt;/0/1/0&quot; &lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; standalone=&quot;yes&quot;?&gt; &lt;mnt-rest-result&gt; &lt;http-code&gt;500&lt;/http-code&gt; &lt;cpm-code&gt;34110&lt;/cpm-code&gt; &lt;description&gt;Server has encountered error while processing the REST request&lt;/description&gt; &lt;module-name&gt;MnT&lt;/module-name&gt; &lt;internal-error-info&gt;SqlMapClient ...
Latest activity: May 29, 2020
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.