[jira] [Commented] (AMBARI-20936) Users are not able to login to ambari UI after Ambari upgrade from 2.4.x to 2.5.0

["Nitiraj Singh Rathore (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AMBARI-20936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15997145#comment-15997145 ] 

Nitiraj Singh Rathore commented on AMBARI-20936:
------------------------------------------------

The reason was that there some left over entries of zeppline view in adminprivilege table.
The proposed work around of the problem.

SELECT adminresource.resource_id 
FROM   adminresource 
       LEFT OUTER JOIN viewinstance USING (resource_id) 
WHERE  adminresource.resource_type_id > 5 
       AND viewinstance.view_instance_id IS NULL; 

If this returns any resources, those are orphaned are causing the NPE. You'll have to remove them.

DELETE FROM adminresources WHERE  resource_id IN (<ids>);

DELETE FROM adminprivilege WHERE  resource_id IN (<ids>);

CC: [~u39kun]

> Users are not able to login to ambari UI after Ambari upgrade from 2.4.x to 2.5.0
> ---------------------------------------------------------------------------------
>
>                 Key: AMBARI-20936
>                 URL: https://issues.apache.org/jira/browse/AMBARI-20936
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-views
>    Affects Versions: 2.5.0
>         Environment: LDAP is configured.
> Zeppline view is created and USE permission is given to users.
>            Reporter: Nitiraj Singh Rathore
>            Assignee: Nitiraj Singh Rathore
>             Fix For: 2.5.0
>
>         Attachments: error.log
>
>
> After upgrade from Ambari 2.4 to Ambari 2.5 when LDAP users try to login they get error and are not able to login.
> Attached is log snippet.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)