609ny (609ny) asked a question.
Has anyone has any idea on E0000100 (Unable to perform search query.) error message. We are trying to extract all users from Okta using listUsers method, but we are just getting half of the user lists with error message -
HTTP -1, Okta E0000100 (Unable to perform search query.),
Can someone guide us how to resolve this issue?
Hi Bhima,
Thank you for contacting Okta Community! Can you let us know the exact API calls you are using?
If you are using the API for "List Users with Search", we do have a limit of 10,000 users for the search query. You would see the error "E0000100 (Unable to perform search query)" after getting 10000 users using pagination. Unfortunately, this had not been outlined in our documentation. We've connected with our docs team and they will be proceeding to update the docs.
If this does not apply to your use case, please open a Support case so we can dig into this issue.
Thanks,
Daisy Sun
Technical Support Engineer
Okta Global Customer Care
Hello Dailsy,
Thanks alot for the reply. I'm using listUsers method with a filter.
UserList usrList = client.listUsers(null, null, null, filter, null);
Usrit=usrList.iterator();
where filter is all active/lockedout/provisioned/staged associates from our organization.
listUsers extracts nearly 50K records. But we have more than a lakh. Please let me know if we have any solution for this issue.
Thanks,
Hi Bhima,
Thank you for the update. This is a known limitation in ElasticSearch that has never been implemented. I would recommend submitting this idea as a new feature via the following link https://support.okta.com/help/oktaideas. Features suggested in our community are reviewed and can be voted and commented on by other members of the community, therefore making it much easier for the team to understand the priorities that you have for feature requests.
Thanks,
Daisy Sun
Technical Support Engineer
Okta Global Customer Care
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
Hi Bhima,
Thank you for the update. This is a known limitation in ElasticSearch that has never been implemented. I would recommend submitting this idea as a new feature via the following link https://support.okta.com/help/oktaideas. Features suggested in our community are reviewed and can be voted and commented on by other members of the community, therefore making it much easier for the team to understand the priorities that you have for feature requests.
Thanks,
Daisy Sun
Technical Support Engineer
Okta Global Customer Care