Search found 18 matches

by hewills
Tue Apr 10, 2018 4:46 pm
Forum: CloverETL Server
Topic: No CPU load
Replies: 3
Views: 328

Re: No CPU load

Quick update... I've upgraded our CloverETL 4.5.1.3 version to 4.8.1, and now the CPU monitoring is showing activity. For some reason the Clover monitor wasn't showing CPU load before, which was confusing to me, as I could see activity when monitoring the server itself. Now at least it makes sense. ...
by hewills
Tue Feb 13, 2018 9:05 pm
Forum: CloverETL Server
Topic: No CPU load
Replies: 3
Views: 328

No CPU load

I realize this may be a more complex question, with a complex answer, but I'm curious if there is a quick answer for where to at least start troubleshooting. We are running database ETL jobs on a Linux server, running Tomcat, with 12 CPUs (1 core per socket), and our CPU% isn't budging past 0. Our h...
by hewills
Tue Feb 13, 2018 6:41 pm
Forum: CloverETL Support
Topic: EmailSender ignore send fail
Replies: 3
Views: 278

Re: EmailSender ignore send fail

Thank you, that's what I thought. I had an occurrence where our smtp server went down, so the EmailSender within our graph couldn't connect and failed. Even though I had this setting as "true", the graph ended with a status other than 'FINISHED_OK', because of the EmailSender failure. But ...
by hewills
Fri Feb 09, 2018 5:34 pm
Forum: CloverETL Support
Topic: EmailSender ignore send fail
Replies: 3
Views: 278

EmailSender ignore send fail

Does the "ignore send fail" option in the EmailSender mean that, when set to true, if the EmailSender fails, the graph stops?
And if set to false, the graph just fails, is that correct?

Thanks
by hewills
Fri Dec 15, 2017 10:30 pm
Forum: CloverETL Support
Topic: CTL function example
Replies: 2
Views: 370

Re: CTL function example

That makes sense. This is working just as I needed it, thanks!
by hewills
Thu Dec 14, 2017 7:36 pm
Forum: CloverETL Support
Topic: CTL function example
Replies: 2
Views: 370

CTL function example

Hi, I'm wanting to create my own simple function. I believe I can use CTL to do it, and don't need Java. Basically I'm hoping to wrap some CTL code into a function, so we can use it in many jobs easily. Example : function handle_null(record) is record a string? return '-' is record a number? return ...
by hewills
Wed Nov 15, 2017 6:32 pm
Forum: CloverETL Support
Topic: zeroDate returning 12/31/1969
Replies: 2
Views: 348

Re: zeroDate returning 12/31/1969

Ah, can't believe I missed that! Thanks, that worked great.
by hewills
Tue Nov 14, 2017 9:34 pm
Forum: CloverETL Support
Topic: Different results using str2date
Replies: 1
Views: 289

Different results using str2date

I get different dates returned depending on what date format I use in str2date. I'm using a str2date in Reformat, and it's being loaded into a date metadata field. The metadata is being formatted as yyyy-MM-dd HH:mm:ss , and my default local timezone. If I use str2date('01.01.1753','MM.dd.yyyy') It ...
by hewills
Tue Nov 14, 2017 7:00 pm
Forum: CloverETL Support
Topic: zeroDate returning 12/31/1969
Replies: 2
Views: 348

zeroDate returning 12/31/1969

Hi, I'm trying to use the function zeroDate(), which returns 1.1.1970. I'm using it in a Reformat object, then passing it into the metadata as a data field. When I inspect the data being passed into the metadata, it reads 12.31.1969. Do you know what could be causing this? The timezone and Locale is...
by hewills
Fri May 26, 2017 6:09 pm
Forum: CloverETL Server
Topic: Tomcat user running CloverETL
Replies: 1
Views: 716

Tomcat user running CloverETL

Currently we are using tomcat as our application server, and as such the tomcat user is running CloverETL. Since it's normally recommended to have tomcat as a user without login, it makes it tricky having Clover run shell scripts. Basically we have to have tomcat sudo as another user. Is there a rec...
by hewills
Thu May 25, 2017 7:54 pm
Forum: CloverETL Support
Topic: skip graph initialization
Replies: 1
Views: 576

skip graph initialization

I know there is a way to skip the graph configuration, using skip_check_config . But is there a way to have a graph skip the initialization, and just start running? Basically, I have a child graph with dynamic metadata using a sql query - SELECT * FROM SOURCE_TBL WHERE 1=0; Before running the graph,...
by hewills
Tue May 02, 2017 5:02 pm
Forum: CloverETL Server
Topic: Using allocation with DBInputTable
Replies: 5
Views: 1236

Re: Using allocation with DBInputTable

Thanks Pedro! I had a chance to use your design, and it sped up the graph as expected. As you said, using the 'ParallelPartition' seems to be key.
Using 'PARTITION' wouldn't be an option for the database we are currently working with. But I'll keep it in mind for the future.
by hewills
Tue Apr 25, 2017 11:42 pm
Forum: CloverETL Server
Topic: Setting number of executors to a jobflow
Replies: 5
Views: 1212

Re: Setting number of executors to a jobflow

Now that I understand how the executors work, I don't think the 'max_running_concurrently' parameter is needed. But it's nice to know in case we need it for a different scenario.
I setup the ExecuteGraph with dynamic table parameters and metadata, and so far it's working great. Thanks!
by hewills
Mon Apr 24, 2017 7:50 pm
Forum: CloverETL Server
Topic: Setting number of executors to a jobflow
Replies: 5
Views: 1212

Re: Setting number of executors to a jobflow

I decided to try setting up the "dynamic table load", where I feed a list of table names and parameters to one ExecuteGraph. This looks like a better solution for us.
by hewills
Fri Apr 21, 2017 6:07 pm
Forum: CloverETL Server
Topic: Using allocation with DBInputTable
Replies: 5
Views: 1236

Re: Using allocation with DBInputTable

Hi, thanks for taking a look. How many records are you processing? ~ 3,000,000 How long does this process usually take? 7.5 minutes What Database Server are you utilizing (vendor, version)? Oracle 12c database, on Red Hat 7.2 Clover Server is running on CentOS I don't have access to the source serve...