Search found 21 matches

by the_goat
Tue May 15, 2018 8:51 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Best practices for health checks against Clover Server / Execution History filters question
Replies: 4
Views: 1320

Re: Best practices for health checks against Clover Server / Execution History filters question

Come to think of it. You'll still need to authenticate, although if you'd upgrade to 4.7 onwards; you will be able to create Data Service (successor of Launch Service) which can be openned for any call w/o authentication.
by the_goat
Tue May 15, 2018 8:44 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Best practices for health checks against Clover Server / Execution History filters question
Replies: 4
Views: 1320

Re: Best practices for health checks against Clover Server / Execution History filters question

If I'm not mistaken, you can disable write-in to execution history from both launch services and scheduled jobs (because of exactly this reason - frequently running jobs). But in your case I would not bother and just check server's HTTP API, more specifically cluster_status ; if that one will get un...
by the_goat
Fri Mar 30, 2018 3:41 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Creating unique hash
Replies: 2
Views: 1072

Re: Creating unique hash

I do not believe so. But you can create your CTL function which will implement code you proposed.
Also, if you'd not require hash you may consider function

Code: Select all

randomUUID()
by the_goat
Tue Mar 13, 2018 1:25 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Looking for a better error output
Replies: 4
Views: 1376

Re: Looking for a better error output

Oh, thought we're talking about CSV files here. Let me think about a solution here, should be workaroundable. What kinds of errors those usually are? Conversion ones?
by the_goat
Mon Mar 12, 2018 2:23 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Looking for a better error output
Replies: 4
Views: 1376

Re: Looking for a better error output

If I understand correctly, you do not have this output from FlatFileReader/UniversalDataReader? Or you're talking about very different component here?

FFR_error.PNG
FFR_error.PNG (54.31 KiB) Viewed 1370 times
by the_goat
Mon Mar 05, 2018 4:33 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Str2Date problem
Replies: 2
Views: 1094

Re: Str2Date problem

Well, not sure where you're getting this error. But on both cases it is metadata configuration: [*] In case your reader is failing, make sure your Effective_Date does NOT have Format property set [*] In case your reformat is failing, make sure your Effective_Date is in fact "date" datatype...
by the_goat
Fri Feb 23, 2018 2:17 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: ExecuteGraph giving errors when trying to move from CloverETL Server version 4.1 to 4.7
Replies: 5
Views: 2125

Re: ExecuteGraph giving errors when trying to move from CloverETL Server version 4.1 to 4.7

Seems to me as an error in input/output/error mapping. I guess there's very little to tell without the "to be executed" graph and the execute component configuration (in/out metadata + aforementioned mapping), would you be able to share so I can take a look? This error message I believe is...
by the_goat
Thu Feb 15, 2018 3:05 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: HTTP POST text file
Replies: 5
Views: 2220

Re: HTTP POST text file

@sshrestha: yes, I absolutely do. Though if you choose to use this option (can provide different URL using Input Mapping property), the drawback would be; you have to have file available somewhere on filesystem. In case, you're using some sort of serialization (e.g. using JSONWriter) and you actuall...
by the_goat
Fri Feb 09, 2018 7:56 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Fuzzy Match Join
Replies: 2
Views: 1093

Re: Fuzzy Match Join

Hi Michael, well it depends a bit on what version of CloverETL do you have. I believe this component was deprecated for a moment but in later versions reinstated. Anyway, what you should have as well (behaves similarly and is easier to configure) is this: http://doc.cloveretl.com/documentation/UserG...
by the_goat
Tue Jan 30, 2018 6:52 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: 'hidden' parameters
Replies: 1
Views: 756

Re: 'hidden' parameters

Well, simplest way how to see all of them is to look into console log - at the very beginning there is a listing of all of them. Partial list with description can be found here: http://doc.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.server.docs/docs/graph-parameters.html Plus, you can ...
by the_goat
Mon Jan 29, 2018 5:01 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: HTTP POST text file
Replies: 5
Views: 2220

Re: HTTP POST text file

Not sure which particular example you're referring to. "Upload a File using Multipart Entities"? I do not believe you need to do that, just choosing input file in this simple case as you outline should be fine. My best guess would be, "Content-Length" header is not being sent alo...
by the_goat
Fri Jan 19, 2018 8:12 pm
Forum: IBM InfoSphere MDM
Topic: Error: AggregationException: Invalid mapping
Replies: 6
Views: 7592

Re: Error: AggregationException: Invalid mapping

Looking at the error message, I really am not that surprised it is not working. You can see Aggregate component as a SQL's GROUP BY statement, meaning what you configured is: SELECT firstnonnull(LASTACTIVITYDATE) as LASTACTIVITYDATE;firstnonnull(ECID) as ECID;firstnonnull(SOURCECODE) as SOURCECODE F...
by the_goat
Thu Jan 18, 2018 3:41 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Working With Multiple Files
Replies: 3
Views: 2268

Re: Working With Multiple Files

Are we talking about some BLOBs or CLOBs in that database? Or as I suspect, you need to have them parsed into fields/columns and then put to the database in some sort of format?
by the_goat
Wed Jan 10, 2018 9:33 am
Forum: Cookbook
Topic: Substring of Email Address
Replies: 7
Views: 2953

Re: Substring of Email Address

Oh, sorry. Instead of pop(), the function should be poll(), you want an element from beginning of list; not the end. Cannot edit the original post tho :(
by the_goat
Tue Jan 09, 2018 10:39 am
Forum: Cookbook
Topic: Substring of Email Address
Replies: 7
Views: 2953

Re: Substring of Email Address

Well, there are many ways. Best performing might be your "excel" way: addr = left($in.0.email,indexOf($in.0.email,"@")-1); Lazy way might be what Lukas proposed: addr = pop(split($in.0.email,"@")); Or similarly: addr = pop(find($in.0.email,"^([^@]+)",1));

cron