@nshelke Were you able to run the select query to findout the problematic resource? select*from adminresourcetype where resource_type_id IN (select resource_type_id from adminresource where resource_id =58); . ... View more

@nshelke If you are using embedded postgres DB the you should try: # psql -U ambari ambari Password for user ambari: bigdata . psql => command -U ambari => is the username ambari => is the DB name It will ask for password, Where we can try using the ambari's default password as "bigdata" If the password is changed then we can check the file. # grep 'server.jdbc.user.passwd' /etc/ambari-server/conf/ambari.properties server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat # cat /etc/ambari-server/conf/password.dat bigdata . ... View more

@nshelke I corrected the respurce id as 58 in the command. resource_id in(58); ... View more

@nshelke Do you also see a NullPointerException something like following in your ambari server log? java.lang.NullPointerException at org.apache.ambari.server.security.authorization.PermissionHelper.getPermissionLabels . Can you please share the complete stackTrace in that case? ... View more

@Jay Goebel Sorry i missed to see your response. The Md5Sum results are listed in the Hortonworks WebSite for different installers: https://hortonworks.com/downloads/#sandbox - As the Sandbox size is large so sometimes while downloading it it might get corrupted. So checking the checksum before importing it to VirtualBox is always a good idea. Following is the way how we can check it. On MAC $ md5 HDP_2.6_virtualbox_19_04_2017_20_02_55_hdp_ambari_2_5_0_5_1.ov On Linux $ md5sum HDP_2.6_virtualbox_19_04_2017_20_02_55_hdp_ambari_2_5_0_5_1.ov . But as recommended earlier it will be best to try reimporting the sandbox to VirtualBox again can be a quick test. ... View more

@Sushant Also regarding your query on getting ambari CRITICAL alerts list please try: curl -u username:password -i -H 'X-Requested-By:ambari' -X GET http://erie1.example.com:8080/api/v1/clusters/ErieCluster/alerts?fields=*&Alert/state.in(CRITICAL) OR curl -u username:password -i -H 'X-Requested-By:ambari' -X GET http://erie1.example.com:8080/api/v1/clusters/ErieCluster/alerts?fields=*&Alert/state=CRITICAL . ... View more

@Sushant If the original query that you asked as part of this thread is resolved and the previously provided updates helped you in answering your query then please mark this thread as "Accept" , that way it helps the community users to find a specific query and it's specific answer quickly. I will suggest it will be great if oyu open a new Thread in HCC for your new query related to Alert. ... View more