Member since
09-01-2016
27
Posts
4
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
4825 | 12-28-2016 09:54 AM | |
2123 | 09-19-2016 07:06 AM |
11-09-2017
08:59 PM
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
11-09-2017
02:18 AM
Hi, I have an Oracle table that has a CLOB. I can't pull them back using any of the processors that I try. Any way around this other than using SQOOP? NiFI version 1.2.0.3.0.1.1-5 Cheers
... View more
Labels:
- Labels:
-
Apache NiFi
12-30-2016
05:02 AM
Worked like a charm. Appreciated
... View more
12-29-2016
11:53 PM
Note Metrics Monitor starts but Metrics Collector doesn't. Version2.4.2.0
... View more
12-29-2016
11:45 PM
Tried to start ambari metric service after install but it errors saying a missing directory, see below. ls /usr/lib/ams-hbase conf docs hbase-webapps lib But no bin directory? raise Fail("Applying %s failed, parent directory %s doesn't exist" % (self.resource, dirname)) resource_management.core.exceptions.Fail: Applying File['/usr/lib/ams-hbase/bin/hadoop'] failed, parent directory /usr/lib/ams-hbase/bin doesn't exist
... View more
Labels:
- Labels:
-
Apache Ambari
12-28-2016
09:54 AM
Ok sorted yum remove ambari-agent on the servers where I did a manual install and rerun using Ambari
... View more
12-28-2016
09:42 AM
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
12-28-2016
09:34 AM
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
12-28-2016
09:31 AM
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
12-26-2016
11:15 AM
Tried both public and private in GUI also in hosts file with no luck
... View more