Hi @Gevorg KHACHATURYAN java.sql.SQLException: org.apache.hadoop.hbase.client.RetriesExhaustedException: Can't get the location for replica 0 at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2492) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2384) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76) at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2384) at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255) at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150) at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) at com.petpe.util.PhoenixConnection.getConnnection(PhoenixConnection.java:26) at com.petpe.hbase.utill.ManageAccessMangement.getHbaseUser(ManageAccessMangement.java:363) at com.petpe.users.action.UsersAction.userLogin(UsersAction.java:541) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) I am getting database connectivity issue and i checked all the configurations and properties,still i am facing this issue.what else i need to do. Can u suggest me???? Thanks in advance. ... View more

Hey Apoorva, You performance stats are pretty good. My Cluster load is like it takes 400,000 records in 1min through Phoenix. I have made some config changes but didn't achieve what I need. Can you please help me out. I use a 3 Node Cluster with 64GB RAM and 8 Core processor. Please help me out. ... View more

No still working on it. ... View more

@Geoffrey Shelton Okot Ok! Thank You for your suggestions. Is there any way to recover the system back in my present situation?? ... View more

@Geoffrey Shelton Thank you for your response. As i said unexpectedly it is showing above attached page .i.e., it is a displaying a page that when we open ambari UI on 8080 port for the 1st time immediately after setting up the ambari-server . we didn't took the ambari database backup previously .will it help if we do it now. ... View more

Both the servers are in different security groups and VPC's. ... View more

I am trying to connect from a server in AWS in one security group to server in AWS which is in another security group. I am using public FQDN in phoenix jdbc url and I opened corresponding port in AWS. -->i am able to ping and telnet with port i am using to corresponding host which i am connecting to . ... View more

I have posted the related details U have asked for can u kindly refer that n provide some suggestions. I have uploaded the error logs please find the post in answers above ... View more

@Geoffrey Shelton Okot We are using 3 -node cluster out of 2 are edge node and 1 is master node . i am trying to connect to phoenix using edge node using JDBC connection to a server which is in another network but i'm unable to connect to Phoenix and getting TimOutException and SQL exception. Can u please help me in resolving this issue.. Thanks, Teja ... View more

Can we install pheonix client in different server where hbase is not installed ?if yes how to install? ... View more

Can you please explain the solution in detail? ... View more