JDBC connection is configured with below Phoenix Driver and jdbc connection string: ;LOCAL;JDBC;URL=jdbc:phoenix:zk_server_fqdn:2181:/hbase-unsecure; DRIVER_NAME=org.apache.phoenix.jdbc.PhoenixDriver; When we use sqlline on HBASE server, we are able to connect using same credentials and able to list and access (read/write) all tables including system.catalog table however when we try to test connection from Cognos, we are getting below error: org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.CATALOG Hortonworks Hadoop environment is not using kerberos security, it is regular user password credentials. Versions: HDP 2.3.6, Hbase 1.1.2 Apache Phoenix 4.4.0 We are using following Jar files for HBASE with exact version as Hortonworks Hadoop environment has. We have required firewall ports open. netty-all-4.0.23.Final.jar htrace-core-3.1.0-incubating.jar phoenix-core-4.4.0.2.3.6.0-3796.jar antlr-runtime-3.4.jar hbase-server-1.1.2.2.3.6.0-3796.jar hbase-client-1.1.2.2.3.6.0-3796.jar hbase-common-1.1.2.2.3.6.0-3796.jar hbase-protocol-1.1.2.2.3.6.0-3796.jar hadoop-auth-2.7.1.2.3.6.0-3796.jar zookeeper-3.4.6.2.3.6.0-3796.jar Full Stack Trace of error in XQE logs: <event component="XQE" group="JDBC" level="ERROR" thread="63" timestamp="2017-05-09 10:24:50.170" contextId="7" requestId=" 9Ch2j92w889GyChwhGd82qGvd2CC4dyllMs9Mvs9" sessionId="-78446b4c: 15bee3039d3:-7f03"><![CDATA[Connection failed: org.apache.phoenix. schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.CATALOG]]></event> <event component="XQE" group="Exception" level="ERROR" thread="63" timestamp="2017-05-09 10:24:50.170" contextId="7" requestId=" 9Ch2j92w889GyChwhGd82qGvd2CC4dyllMs9Mvs9" sessionId="-78446b4c: 15bee3039d3:-7f03"><![CDATA[Caught error in V5QueryHandler: XQE-DS-0006 Unable to logon to the data source. at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection. mapConnectionException(JDBCConnection.java:1491) at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection. driverConnect(JDBCConnection.java:873) at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection. driverConnectKerberos(JDBCConnection.java:2753) at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.connect (JDBCConnection.java:987) at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnectionFactory. createConnection(JDBCConnectionFactory.java:120) at com.cognos.xqe.data.providers.relational.jdbc.JDBCDataProvider. testConnection(JDBCDataProvider.java:152) at com.cognos.xqe.data.providers.relational. TraceRelationalDataProvider.testConnection(TraceRelationalDataProvider. java:220) at com.cognos.xqebifw.bibushandler.ConnectionTester.doTestConnection (ConnectionTester.java:319) at com.cognos.xqebifw.bibushandler.ConnectionTester. testDataSourceConnection(ConnectionTester.java:162) at com.cognos.xqebifw.bibushandler. TestDataSourceConnectionWithInfoRequestAdapter.executeRequest (TestDataSourceConnectionWithInfoRequestAdapter.java:93) at com.cognos.xqebifw.cubingservices.V5QueryHandler. executeRequestInSequence(V5QueryHandler.java:725) at com.cognos.xqebifw.cubingservices.V5QueryHandler.execute (V5QueryHandler.java:544) at com.cognos.xqebifw.cubingservices.RequestWorker.processMessage (RequestWorker.java:298) at com.cognos.xqebifw.cubingservices.RequestWorker.processQueryInputMsg (RequestWorker.java:275) at com.cognos.xqebifw.cubingservices.RequestWorker.call(RequestWorker. java:146) at com.cognos.xqebifw.cubingservices.RequestWorker.call(RequestWorker. java:53) at java.util.concurrent.FutureTask.run(FutureTask.java:274) at java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1157) at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:627) at java.lang.Thread.run(Thread.java:798) Caused by: org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.CATALOG at org.apache.phoenix.query.ConnectionQueryServicesImpl. getAllTableRegions(ConnectionQueryServicesImpl.java:436) at org.apache.phoenix.query.ConnectionQueryServicesImpl. checkClientServerCompatibility(ConnectionQueryServicesImpl.java:939) at org.apache.phoenix.query.ConnectionQueryServicesImpl. ensureTableCreated(ConnectionQueryServicesImpl.java:860) at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable (ConnectionQueryServicesImpl.java:1174) at org.apache.phoenix.query.DelegateConnectionQueryServices.createTable (DelegateConnectionQueryServices.java:112) at org.apache.phoenix.schema.MetaDataClient.createTableInternal (MetaDataClient.java:1974) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient. java:770) at org.apache.phoenix.compile.CreateTableCompiler$2.execute (CreateTableCompiler.java:186) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement. java:305) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement. java:297) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation (PhoenixStatement.java:295) at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate (PhoenixStatement.java:1244) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call (ConnectionQueryServicesImpl.java:1850) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call (ConnectionQueryServicesImpl.java:1819) at org.apache.phoenix.util.PhoenixContextExecutor.call (PhoenixContextExecutor.java:77) at org.apache.phoenix.query.ConnectionQueryServicesImpl.init (ConnectionQueryServicesImpl.java:1819) at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices (PhoenixDriver.java:180) at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect (PhoenixEmbeddedDriver.java:132) at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java: 151) at com.ibm.cognos.jdbc.adaptor.AdaptorFactory.connect(AdaptorFactory. java:429) at com.ibm.cognos.jdbc.adaptor.ConnectionFactory. createAndWrapConnection(ConnectionFactory.java:170) at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection. driverConnect(JDBCConnection.java:851) ... 18 more ]]></event> <event component="XQE" group="RequestAdapter.V5Response" level="ERROR" thread="63" timestamp="2017-05-09 10:24:51.420" contextId="7" requestId="9Ch2j92w889GyChwhGd82qGvd2CC4dyllMs9Mvs9" sessionId="-78446 b4c:15bee3039d3:-7f03"><![CDATA[V5QueryHandler returning SOAP Fault for request type "testDataSourceConnectionWithInfo"]]></event> <event component="XQE" group="RequestAdapter.V5Response" level="ERROR" thread="63" timestamp="2017-05-09 10:24:51.420" contextId="7" requestId="9Ch2j92w889GyChwhGd82qGvd2CC4dyllMs9Mvs9" sessionId="-78446 b4c:15bee3039d3:-7f03"><![CDATA[<?xml version="1.0" encoding="UTF-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap. org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap. org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns: xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bus="http: //developer.cognos.com/schemas/bibus/3/" SOAP-ENV:encodingStyle="http: //schemas.xmlsoap.org/soap/encoding/"> <SOAP-ENV:Header> <bus:biBusHeader xsi:type="bus:biBusHeader"> <bus:tracking xsi:type="bus:tracking"/> </bus:biBusHeader> </SOAP-ENV:Header> <SOAP-ENV:Body> <SOAP-ENV:Fault> <faultcode>CQE-803</faultcode> <faultstring>XQE-DS-0006 Unable to logon to the data source. </faultstring> <detail> <bus:exception> <bus:message> <messageString>XQE-DS-0006 Unable to logon to the data source.</messageString> </bus:message> <bus:message> <messageString>ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.CATALOG</messageString> </bus:message> </bus:exception> </detail> <faultSubcode>99</faultSubcode> <faultSubstring>ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.CATALOG</faultSubstring> <faultDataSource value="TestDataSource"/> <faultConnection> <connectionString value="^User ID:^?Password:;LOCAL;JDBC; URL=jdbc:phoenix:zk_fqdn:2181:/hbase-unsecure; DRIVER_NAME=org.apache.phoenix.jdbc.PhoenixDriver;"/> </faultConnection> <faultSignon> <name value="TestSignon"/> </faultSignon> <dataSource> <name value="TestDataSource"/> <type value="JDBC"/> <connection> <name value="SimpleDataSourceConnection"/> <signon> <name value="TestSignon"/> </signon> </connection> </dataSource> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope> ]]></event> ... View more