Thanks for the feedback. We used both QueryDatabaseTable and ExecuteSQL. The CLOB is large and our quick and dirty workaround is to create a view but I had to limit the column to 1000 (see below) as the processors still had an error with the max 4000 that Oracle could handle (converting a CLOB). DBMS_LOB.SUBSTR(TEXT_DOC, 1000, 1) ... View more

Thanks for the response. Any indication to when 3.0.2 is to be released? We don't have internet access, except via a proxy, so we can't get a list of jars and poms required. Any chance of doing a `ls` and sending those, or is that pushing things? ... View more

Excellent, thanks for the link Appreciated ... View more

Resolved with a work around only. Changed master to true in config on servers and restarted service on server. However if I restart elasticsearch via Ambari the same thing happens, that is it reverts to master false. A permanent fix would be nice. ... View more

Worked like a charm. Appreciated ... View more

Note Metrics Monitor starts but Metrics Collector doesn't. Version2.4.2.0 ... View more

I notice it launches 2 /usr/bin/python /usr/lib/python2.6/site-packages/ambari_agent/main.py scripts ?? [root@ec2-xxxxx ec2-user]# ps aux | grep ambari root 16253 0.0 0.1 385276 17736 ? Sl 04:19 0:00 /usr/bin/python /usr/lib/python2.6/site-packages/ambari_agent/main.py start --expected-hostname=ec2-xxxxx.ap-southeast-2.compute.amazonaws.com root 16344 0.0 0.0 112648 960 pts/3 S+ 04:39 0:00 grep --color=auto ambari [root@ec2-xxxx ec2-user]# ps aux | grep ambari root 16253 0.0 0.1 385276 17736 ? Sl 04:19 0:00 /usr/bin/python /usr/lib/python2.6/site-packages/ambari_agent/main.py start --expected-hostname=ec2-xxxx.ap-southeast-2.compute.amazonaws.com root 16346 0.0 0.0 112648 956 pts/3 S+ 04:39 0:00 grep --color=auto ambari ... View more

Checked https://community.hortonworks.com/questions/145/openssl-error-upon-host-registration.html And I'm using java 8 on both. Tried using ssh keys and also manual install of ambari-agent but no luck. I can get the server running and the agents on both servers but no luck via ambari installing HDP. I can see the agent startup when lauching from Ambari but then it can't connect to the server ... View more

Still having issue ========================== Creating target directory... ========================== Command start time 2016-12-28 04:19:41 Connection to ec2-54-206-122-4.ap-southeast-2.compute.amazonaws.com closed. SSH command execution finished host=ec2-xxxxxxx.ap-southeast-2.compute.amazonaws.com, exitcode=0 Command end time 2016-12-28 04:19:41 ========================== Copying ambari sudo script... ========================== Command start time 2016-12-28 04:19:41 scp /var/lib/ambari-server/ambari-sudo.sh host=ec2-xxxxxx.ap-southeast-2.compute.amazonaws.com, exitcode=0 Command end time 2016-12-28 04:19:41 ========================== Copying common functions script... ========================== Command start time 2016-12-28 04:19:41 scp /usr/lib/python2.6/site-packages/ambari_commons host=ec2-xxxxxx.ap-southeast-2.compute.amazonaws.com, exitcode=0 Command end time 2016-12-28 04:19:42 ========================== Copying OS type check script... ========================== Command start time 2016-12-28 04:19:42 scp /usr/lib/python2.6/site-packages/ambari_server/os_check_type.py host=ec2-xxxxxx.ap-southeast-2.compute.amazonaws.com, exitcode=0 Command end time 2016-12-28 04:19:42 ========================== Running OS type check... ========================== Command start time 2016-12-28 04:19:42 Cluster primary/cluster OS family is redhat7 and local/current OS family is redhat7 Connection to ec2-xxxxx.ap-southeast-2.compute.amazonaws.com closed. SSH command execution finished host=ec2-xxxxxx.ap-southeast-2.compute.amazonaws.com, exitcode=0 Command end time 2016-12-28 04:19:42 ========================== Checking 'sudo' package on remote host... ========================== Command start time 2016-12-28 04:19:42 Connection to ecxxxxxx.ap-southeast-2.compute.amazonaws.com closed. SSH command execution finished host=ec2-xxxxxx.ap-southeast-2.compute.amazonaws.com, exitcode=0 Command end time 2016-12-28 04:19:43 ========================== Copying required files... Ambari repo file not found: /etc/yum.repos.d/ambari.repo ========================== Copying setup script file... ========================== Command start time 2016-12-28 04:19:43 scp /usr/lib/python2.6/site-packages/ambari_server/setupAgent.py host=ec2-xxxxxxx.ap-southeast-2.compute.amazonaws.com, exitcode=0 Command end time 2016-12-28 04:19:43 ========================== Running setup agent script... ========================== Command start time 2016-12-28 04:19:43 ('INFO 2016-12-28 04:14:20,333 NetUtil.py:62 - Connecting to https://ec2-xxxxxxxxx.ap-southeast-2.compute.amazonaws.com:8440/ca WARNING 2016-12-28 04:14:20,334 NetUtil.py:93 - Failed to connect to https://ec2-xxxxxxx.ap-southeast-2.compute.amazonaws.com:8440/ca due to [Errno 111] Connection refused WARNING 2016-12-28 04:14:20,334 NetUtil.py:116 - Server at https://ec2-xxxxxxxx.ap-southeast-2.compute.amazonaws.com:8440 is not reachable, sleeping for 10 seconds... INFO 2016-12-28 04:14:20,334 HeartbeatHandlers.py:115 - Stop event received INFO 2016-12-28 04:14:20,334 NetUtil.py:122 - Stop event received INFO 2016-12-28 04:14:20,334 ExitHelper.py:53 - Performing cleanup before exiting... INFO 2016-12-28 04:14:20,334 ExitHelper.py:67 - Cleanup finished, exiting with code:0 INFO 2016-12-28 04:14:22,156 main.py:223 - Agent died gracefully, exiting. INFO 2016-12-28 04:14:22,157 ExitHelper.py:53 - Performing cleanup before exiting... INFO 2016-12-28 04:19:44,977 main.py:90 - loglevel=logging.INFO INFO 2016-12-28 04:19:44,977 main.py:90 - loglevel=logging.INFO INFO 2016-12-28 04:19:44,977 main.py:90 - loglevel=logging.INFO INFO 2016-12-28 04:19:44,978 DataCleaner.py:39 - Data cleanup thread started INFO 2016-12-28 04:19:44,979 DataCleaner.py:120 - Data cleanup started INFO 2016-12-28 04:19:44,980 DataCleaner.py:122 - Data cleanup finished INFO 2016-12-28 04:19:45,022 PingPortListener.py:50 - Ping port listener started on port: 8670 INFO 2016-12-28 04:19:45,023 main.py:349 - Connecting to Ambari server at https://ec2-xxxxxxxx.ap-southeast-2.compute.amazonaws.com:8440 (xxxxxxx) INFO 2016-12-28 04:19:45,023 NetUtil.py:62 - Connecting to https://ec2-xxxxxxx.ap-southeast-2.compute.amazonaws.com:8440/ca WARNING 2016-12-28 04:19:45,024 NetUtil.py:93 - Failed to connect to https://ec2-xxxxxxx.ap-southeast-2.compute.amazonaws.com:8440/ca due to [Errno 111] Connection refused WARNING 2016-12-28 04:19:45,025 NetUtil.py:116 - Server at https://ec2-xxxxxxx.ap-southeast-2.compute.amazonaws.com:8440 is not reachable, sleeping for 10 seconds... ', None) ('INFO 2016-12-28 04:14:20,333 NetUtil.py:62 - Connecting to https://ec2-xxxxxx.ap-southeast-2.compute.amazonaws.com:8440/ca WARNING 2016-12-28 04:14:20,334 NetUtil.py:93 - Failed to connect to https://ec2-xxxxx.ap-southeast-2.compute.amazonaws.com:8440/ca due to [Errno 111] Connection refused WARNING 2016-12-28 04:14:20,334 NetUtil.py:116 - Server at https://ec2-xxxxxx.ap-southeast-2.compute.amazonaws.com:8440 is not reachable, sleeping for 10 seconds... INFO 2016-12-28 04:14:20,334 HeartbeatHandlers.py:115 - Stop event received INFO 2016-12-28 04:14:20,334 NetUtil.py:122 - Stop event received INFO 2016-12-28 04:14:20,334 ExitHelper.py:53 - Performing cleanup before exiting... INFO 2016-12-28 04:14:20,334 ExitHelper.py:67 - Cleanup finished, exiting with code:0 INFO 2016-12-28 04:14:22,156 main.py:223 - Agent died gracefully, exiting. INFO 2016-12-28 04:14:22,157 ExitHelper.py:53 - Performing cleanup before exiting... INFO 2016-12-28 04:19:44,977 main.py:90 - loglevel=logging.INFO INFO 2016-12-28 04:19:44,977 main.py:90 - loglevel=logging.INFO INFO 2016-12-28 04:19:44,977 main.py:90 - loglevel=logging.INFO INFO 2016-12-28 04:19:44,978 DataCleaner.py:39 - Data cleanup thread started INFO 2016-12-28 04:19:44,979 DataCleaner.py:120 - Data cleanup started INFO 2016-12-28 04:19:44,980 DataCleaner.py:122 - Data cleanup finished INFO 2016-12-28 04:19:45,022 PingPortListener.py:50 - Ping port listener started on port: 8670 INFO 2016-12-28 04:19:45,023 main.py:349 - Connecting to Ambari server at https://ec2-xxxxx.ap-southeast-2.compute.amazonaws.com:8440 (54.206.122.4) INFO 2016-12-28 04:19:45,023 NetUtil.py:62 - Connecting to https://ec2-xxxxxx.ap-southeast-2.compute.amazonaws.com:8440/ca WARNING 2016-12-28 04:19:45,024 NetUtil.py:93 - Failed to connect to https://ec2-xxxxxx.ap-southeast-2.compute.amazonaws.com:8440/ca due to [Errno 111] Connection refused WARNING 2016-12-28 04:19:45,025 NetUtil.py:116 - Server at https://ec2-xxxxx.ap-southeast-2.compute.amazonaws.com:8440 is not reachable, sleeping for 10 seconds... ', None) Connection to ec2-xxxxx.ap-southeast-2.compute.amazonaws.com closed. SSH command execution finished host=ec2-xxxxx.ap-southeast-2.compute.amazonaws.com, exitcode=0 Command end time 2016-12-28 04:19:47 Registering with the server... Registration with the server failed. ... View more

Tried both public and private in GUI also in hosts file with no luck ... View more

yes I can even ssh key-less ... View more

This is the error - Registering with the server... Registration with the server failed. ... View more

Thanks for your reply. We are running on 2.5. We found the jars in the path issue and resolved the first issue. The select works fine. But something like count, which uses map-reduce just doesn't return. It works like a charm in the 'hive' shell. Any thoughts? ... View more

we are having the same issue. Any suggestions would be appreciated ... View more