Hortonworks.com
  • Explore
    • All Tags
    • All Questions
    • All Repos
    • All SKB
    • All Articles
    • All Ideas
    • All Users
    • All Badges
    • Leaderboard
  • Create
    • Ask a question
    • Add Repo
    • Create Article
    • Post Idea
  • Tracks
    • All Tracks
    • Community Help
    • Cloud & Operations
    • CyberSecurity
    • Data Ingestion & Streaming
    • Data Processing
    • Data Science & Advanced Analytics
    • Design & Architecture
    • Governance & Lifecycle
    • Hadoop Core
    • Sandbox & Learning
    • Security
    • Solutions
  • Login
HCC Hortonworks Community Connection
  • Home /
  • Solutions /
  • Home /
  • Solutions /
avatar image

Ranger Rest API provides partial output when run on a Ranger database with more than 250 users

Rishi created · Dec 07, 2017 at 08:40 AM
0

SupportKB

Problem Description:
When a Ranger database has huge number of users ( > 250 ), running the following REST API provides partial output and not the list of entire users:
# curl -u ${usercurl}:${passwordcurl} -X GET http://<ragner-host>:6080/service/xusers/users 
?xml version="1.0" encoding="UTF-8" standalone="yes"?><vxUserList><pageSize>200</pageSize>
<resultSize>200</resultSize><sortBy>id</sortBy><sortType>asc</sortType><startIndex>0</startIndex>
<totalCount>1238</totalCount><vXUsers><createDate>2016-10-11T14:23:11Z</createDate><id>1</id>
<owner>admin</owner><updateDate>2016-10-19T08:20:36Z</updateDate><updatedBy>ETA0458 ETA0458</updatedBy>
<description>ADMIN - add from Unix box</description><firstName>Admin</firstName><isVisible>1</isVisible>
<lastName></lastName><name>ADMIN</name><password>*****</password><userRoleList>ROLE_SYS_ADMIN</userRoleList>
<userSource>0</userSource></vXUsers><vXUsers><createDate>2016-10-11T14:23:11Z</createDate>

Cause:
This issue occurs because the Curl by default has pageSize set to 200. Hence, when there are more ( >200 ) users, the output is not listed. 
Solution:
To resolve this issue, modify the pageSize in Curl request as the following:
i.e
# curl -iv -u admin:admin "<ranger-host>:6080/service/xusers/users?pageSize=1250&startIndex=0"


About:
This article created by Hortonworks Support (Article: 000005881) on 2017-05-25 13:22
OS: Linux
Type: Performance
Version: n/a
Support ID: 000005881
thub.nodes.view.add-new-comment
solutionhwsupportRanger
Add comment
10 |6000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Follow

Follow

avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image

Related posts

Error "ERR_SSL_VERSION_OR_CIPHER_MISMATCH" occurs on the Chrome browser when browsing Ranger Web UI after an upgrade

Error: "org.apache.hadoop.security.authentication.client.AuthenticationException: Authentication failed" when accessing files in an encryption zone from Ambari File Views

ERROR:"java.security.cert.CertificateException: No subject alternative DNS name matching found.]; remaining name ''" when using Ranger Usersync after a Java upgrade

"Caused by: java.nio.channels.ClosedChannelException" Ranger tagsync fails to sync tags from Atlas

Error:"Caused by GSSException: No valid credentials provided (Mechanism level: Message stream modified (41))])" occurs during Ranger Audit

The ReportLineageToAtlas from HDF NiFi fails to connect to HDP Atlas when using Ranger

Error:"java.lang.Exception: HTTP 404" occurs when refreshing a Ranger plugin policy in multiple services

Issues with KMS at Ranger group level access

"com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure" occurs after changing the MySQL port for the Ranger database

How to write Ranger Audit logs to HDFS from a remote NiFi instance?

This website uses cookies for analytics, personalisation and advertising. To learn more or change your cookie settings, please read our Cookie Policy. By continuing to browse, you agree to our use of cookies.

HCC Guidelines | HCC FAQs | HCC Privacy Policy | Privacy Policy | Terms of Service

© 2011-2019 Hortonworks Inc. All Rights Reserved.

Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.

  • Anonymous
  • Login
  • Create
  • Ask a question
  • Add Repo
  • Create SupportKB
  • Create Article
  • Post Idea
  • Tracks
  • Community Help
  • Cloud & Operations
  • CyberSecurity
  • Data Ingestion & Streaming
  • Data Processing
  • Data Science & Advanced Analytics
  • Design & Architecture
  • Governance & Lifecycle
  • Hadoop Core
  • Sandbox & Learning
  • Security
  • Solutions
  • Explore
  • All Tags
  • All Questions
  • All Repos
  • All SKB
  • All Articles
  • All Ideas
  • All Users
  • Leaderboard
  • All Badges