I have a python API client making changes to ISE endpoints (create, update and delete) using the Open API endpoint bulk API. I am aware that the ERS bulk API has a restriction on bulk request sizes - 500 (full endpoint data) or 5000 (endpoint ID only). I couldn't find any information about a similar limit on Open API so for the moment I'm assuming the same.
The client is working correctly in that it can successfully send bulk requests to the Open API (create, update and delete), and those requests are being correctly processed by the ISE server.
The only issue is that I have started seeing errors like the example below, when doing a bulk create, and these can occur whether the request contains 1000 endpoints or 200 (well below the ERS limit if indeed that even applies to Open API):
org.h2.jdbc.JdbcSQLException: Order by expression "98302081" must be in the result list in this case; SQL statement:
SELECT identityGroupID, identityGroupName, parentID FROM IdentityGroupDetails ORDER BY ? [90068-196]
I have the idea this might have something to do with performance, because it seems random, rather than being caused by any particular uploaded endpoint data structure. I can say this because I am testing the API client with a static endpoint dataset (a standard profiler_endpoints.csv export from the ISE Server) so endpoints are processed in the same order every time. Yet these errors can occur at any point in the bulk operation.
My client retrieves all the group names and IDs from the ISE server when it starts, so the endpoint names can be translated to valid IDs before endpoints are created or updated. So I also find it unlikely that the error message is a result of a bad group ID.
Cisco ISE version is 3.2.0.401
Server version is 3.2.0.542 patch 3,5,6
Any help or guidance understanding this would be greatly appreciated.
Thanks
