Search found 79 matches

by bartonv
Mon Mar 05, 2018 4:16 pm
Forum: CloverETL Support
Topic: Str2Date problem
Replies: 2
Views: 349

Re: Str2Date problem

Hello Mike, I have tried to manufacture a situation when I would get the same error message but I did not manage to do that. In my case, the code in the Reformat component works as expected and no error is thrown by the system. I am attaching a graph showing my data transformation along with a demon...
by bartonv
Mon Mar 05, 2018 3:19 pm
Forum: CloverETL Support
Topic: Delimited FlatFile reader - Question from New User
Replies: 4
Views: 3577

Re: Delimited FlatFile reader - Question from New User

Hi Mukunku, I have noticed your post concerning this topic and it appears that this thread is more than 10 years old. The good news is that Clover has evolved since then and the functionality that handles RFC 4180 compliant CSV files is now there. Feel free to review the attached example graph as a ...
by bartonv
Mon Mar 05, 2018 2:02 pm
Forum: CloverETL Support
Topic: ExecuteGraph giving errors when trying to move from CloverETL Server version 4.1 to 4.7
Replies: 5
Views: 536

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

Hi Sid, I would like to follow up on this post to see if we could take a closer look at the answers to the aforementioned questions. Furthermore, I was wondering if you could perform a simple test of running your job in Clover version 4.8.x. There was a known bug discovered in version 4.7.x that dem...
by bartonv
Mon Mar 05, 2018 1:26 pm
Forum: CloverETL Support
Topic: Denormlizer Help For New User
Replies: 1
Views: 245

Re: Denormlizer Help For New User

Hello Jcatoe, as you rightly indicated, such transformation would require a bit more complex CTL coding. However, the component that would ‘do the trick’ is called Normalizer as the input data shown in your post is, in fact, denormalized. Attached is an example graph demonstrating the usage of the N...
by bartonv
Fri Mar 02, 2018 4:05 pm
Forum: CloverETL Support
Topic: ExecuteGraph giving errors when trying to move from CloverETL Server version 4.1 to 4.7
Replies: 5
Views: 536

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

Hi Sid, I agree with the_goat that it does look like a mapping issue so a general advice I could provide is to look for a solution by inspecting the ExecuteGraph component in terms of input, output and/or error mapping. However, if you would like to have us inspect it on our end, please provide us w...
by bartonv
Fri Mar 02, 2018 2:47 pm
Forum: CloverETL Server
Topic: No CPU load
Replies: 3
Views: 469

Re: No CPU load

Hi Hewills, as you rightly anticipated, the answer to your question would be rather extent in its scope. First of all, let me clarify that there is no simple direct or indirect proportion between CPU and memory usage. In other words, you cannot substitute the usage of memory by the usage of CPU as b...
by bartonv
Fri Feb 23, 2018 9:43 am
Forum: CloverETL Support
Topic: EmailSender ignore send fail
Replies: 3
Views: 389

Re: EmailSender ignore send fail

Hello Hewills, as you rightly said, the ‘Ignore send fail’ property only applies to certain types of failures. The designed logic of this property in the code is applied only after a successful connection to the SMTP server is established. Therefore, if the connection is not established successfully...
by bartonv
Tue Feb 20, 2018 10:36 am
Forum: CloverETL Support
Topic: How to replace back slash in CTL2
Replies: 1
Views: 341

Re: How to replace back slash in CTL2

Hi Mukunku, try changing your code to the following: replace(myString, "\\\\", "/"); The reason why 4 backslashes are needed to reference one is that there are 2 levels of interpretation: ⋅ At first, CloverETL interprets the “\\\\” string as 2 backslashes (each one esca...
by bartonv
Mon Feb 12, 2018 3:04 pm
Forum: CloverETL Support
Topic: EmailSender ignore send fail
Replies: 3
Views: 389

Re: EmailSender ignore send fail

Hi Hewills, if the ‘Ignore send fail’ property of the EmailSender component is set to ‘false’ (by default), the whole graph execution will fail in case an email sending fails. If it is set to ‘true’, the graph execution will continue despite a failed email sending. For instance, let’s assume that a ...
by bartonv
Mon Feb 12, 2018 10:18 am
Forum: CloverETL Support
Topic: Fuzzy Match Join
Replies: 2
Views: 356

Re: Fuzzy Match Join

Hi Mike, as the_goat already mentioned, the Aspell Lookup feature looks like a good candidate for your case (in consideration of the memory consumption as stated above). Let me provide you with an example project where the usage of the Aspell Lookup is demonstrated. ⋅ The idea is to first ...
by bartonv
Fri Jan 26, 2018 3:32 pm
Forum: CloverETL Support
Topic: https over UniversalFileWriter
Replies: 2
Views: 451

Re: https over UniversalFileWriter

Hello Ramiro, a recommended way of reading data from Amazon S3 in CloverETL is by using the “s3://” prefix in the particular reader component URL. By modifying your submitted URL as an example, it would look like this: gzip:(s3://${S3_ACCESS_KEY}:${S3_SECRET_KEY}@s3.amazonaws.com/${S3_BUCKET}/${S3_F...
by bartonv
Fri Jan 19, 2018 1:46 pm
Forum: IBM InfoSphere MDM
Topic: Error: AggregationException: Invalid mapping
Replies: 6
Views: 1085

Re: Error: AggregationException: Invalid mapping

Hi Listsos, based on the submitted details, this engine behavior can have multiple reasons: ⋅ the obsolete version of CloverETL ⋅ the OEM partner (IBM in this case) is allowed to change many things in CloverETL during bundling some of which might affect the way CloverETL engine w...
by bartonv
Wed Jan 17, 2018 1:41 pm
Forum: IBM InfoSphere MDM
Topic: Error: AggregationException: Invalid mapping
Replies: 6
Views: 1085

Re: Error: AggregationException: Invalid mapping

Hello Listsos, I have tried to replicate the reported issue on my end by using the snippet of your graph source code but I could not manufacture a situation when the same graph would run fine in the GUI but failed when running via command line. Having said that, I would like to ask you for additiona...
by bartonv
Thu Dec 21, 2017 2:28 pm
Forum: CloverETL Support
Topic: 2 x replace functions in one entry?
Replies: 2
Views: 360

Re: 2 x replace functions in one entry?

Hi all, thank you for the question as well as the answer. Using the ‘switch’ statement is indeed one of the possible options how to deal with such replacement. If you want to stick to the ‘replace’ statement that you demonstrated in your issue description, you could also use the following piece of C...
by bartonv
Mon Dec 18, 2017 10:20 am
Forum: IBM InfoSphere MDM
Topic: Write SUCCESS flag to Database After Successful DB Output
Replies: 4
Views: 616

Re: Write SUCCESS flag to Database After Successful DB Output

Hello Listsos, the DBOutputTable is capable of returning records that were successfully inserted into a database, as well as returning those that failed. You could take advantage of one of these features to achieve the desired result. Attached is an example solution of how this can be approached. Th...