@RajeshLuckky  If you follow the original post,  you need the ssl key and cert in the jdbc string.   "At Nifi level make sure the cert file(s) are owned to nifi user".   For example, if you create the cert and key files in the folder /etc/nifi/ssl/ then you would execute: chown -R nifi:nifi /etc/nifi/ssl/   This will own the files to nifi so the nifi user can read them.  ... View more

@math23    No,  you can also just copy the service directly into your ambari.  I suggest this way if you can't easily get a newer cluster.      I tried to point you at how to install the custom service in the accepted solution.    A management pack just makes that task a lil easier, as well as being applicable to different stack versions.     ... View more

Thanks a Lot Steven , will go through the same . Will come back to you by any chance If i have any doubt  . ... View more

Thank you it worked. I also used "1" for the number to make it work but it indeed worked. ... View more

<edit> Sorry I thought this was a new post.  @guido please do not respond to old posts with new solutions.   Ambari 2.6.0 Bug is not applicable here.     @apappu The version on the end of the package is how they handled having multiple versions available in the repos as well as facilitating the upgrade process from one version to another.   Using the variable scope in the python allowed ambari code to be dynamic across all the different versions, environments, etc.   If your repos are setup right, this should not be an issue.  I have seen some failure in the public repos lately, slow to respond, or blocked by certain cloud providers causing the "no package found" errors.     If you are running your own private repos and have an issue like this, you can just create the packages you need in the version you want using the rpmrebuild command on an existing rpm.  ... View more

Thank you @stevenmatison appreciate the pointers provided.   We are not using conventional nginx as load-balancer but instead have BigIP F5. And after examining configuration there we have identified connection limit parameter which was the culprit. We have updated it and this has made some difference in the user experience.    We are looking to increase the number of Hue and HS2 instances in the cluster to boost the overall and query performance.   Many thanks.  ... View more

Hi Steven, I've send you a private message. thank you! ... View more