[
https://issues.apache.org/jira/browse/AMBARI-17350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nahappan Somasundaram resolved AMBARI-17350.
--------------------------------------------
Resolution: Duplicate
> If two users are created differing in case then no users are shown due to
> error
> -------------------------------------------------------------------------------
>
> Key: AMBARI-17350
> URL: https://issues.apache.org/jira/browse/AMBARI-17350
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 2.4.0
> Reporter: Nahappan Somasundaram
> Assignee: Nahappan Somasundaram
> Priority: Critical
> Fix For: 2.4.0
>
> Attachments: Screen Shot 2016-06-11 at 9.17.12 PM.png
>
>
> When usernames that differ only by case are created, no users are show in the
> when clicking the Users link in Ambari Management page due to the following
> error.
> The fix is to block creating usernames that differ only by case.
> {code}
> 12 Jun 2016 03:59:28,569 WARN [ambari-client-thread-559] ServletHandler:628
> - /api/v1/users/
> javax.persistence.NonUniqueResultException: More than one result was returned
> from Query.getSingleResult()
> at
> org.eclipse.persistence.internal.jpa.QueryImpl.throwNonUniqueResultException(QueryImpl.java:980)
> at
> org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:529)
> at
> org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
> at
> org.apache.ambari.server.orm.dao.UserDAO.findUserByName(UserDAO.java:69)
> at
> org.apache.ambari.server.orm.AmbariLocalSessionInterceptor.invoke(AmbariLocalSessionInterceptor.java:53)
> at
> org.apache.ambari.server.controller.internal.ActiveWidgetLayoutResourceProvider.getResources(ActiveWidgetLayoutResourceProvider.java:161)
> at
> org.apache.ambari.server.controller.internal.ClusterControllerImpl$ExtendedResourceProviderWrapper.queryForResources(ClusterControllerImpl.java:966)
> at
> org.apache.ambari.server.controller.internal.ClusterControllerImpl.getResources(ClusterControllerImpl.java:141)
> at
> org.apache.ambari.server.api.query.QueryImpl.doQuery(QueryImpl.java:512)
> at
> org.apache.ambari.server.api.query.QueryImpl.queryForSubResources(QueryImpl.java:464)
> ...
> {code}
> {code}
> select * from users ;
> ***(press return to proceed or enter x and return to
> cancel)********************
> user_id | principal_id | ldap_user | user_name | user_type |
> create_time | user_password
> | active | active
> _widget_layouts
> ---------+--------------+-----------+-----------+-----------+----------------------------+----------------------------------------------------------------------------------+--------+-------
> ----------------
> 1 | 1 | 0 | admin | LOCAL | 2016-06-11
> 16:08:51.300678 |
> 538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00
> | 1 | [{"id"
> :"6"}]
> 3 | 14 | 0 | Abcd | LOCAL | 2016-06-12
> 03:58:38.944 |
> ee677dc216a63092fd1e4dbb56c3661dcca0053feae5968bdf82e15cb95e9b83747f1b7d25c3badc
> | 1 |
> 4 | 15 | 0 | abcd | LOCAL | 2016-06-12
> 03:58:49.32 |
> f941a9570f1b42f2f74b164e9e419fb7d63660681e3ccd9e9313f0369c6d5d03e3249fcfc1fd835e
> | 1 |
> (3 rows)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
