Search found 99 matches

by vazquezrosariop
Thu Sep 14, 2017 4:59 pm
Forum: CloverETL Support
Topic: Realocation of CloverBuffer failed error with FlatFileReader reading multiple text files within zip file
Replies: 2
Views: 51

Re: Realocation of CloverBuffer failed error with FlatFileReader reading multiple text files within zip file

Hi Heather, This type of error is misleading, and there are two possibilities that might have cause this: ⋅ CloverBuffer fails because the data stored in the field exceeds the maximum capacity (in which case the property on the engine configuration will need to changed) ⋅ There i...
by vazquezrosariop
Wed Aug 30, 2017 3:10 pm
Forum: Cookbook
Topic: Pulling Content from a Node (XML files)
Replies: 1
Views: 140

Re: Pulling Content from a Node (XML files)

Hi leefate If I understand your question correctly, you want to extract a particular Element from multiple XML Files. If that's the case, you can accomplish this using the XMLExtract component and use a wild card in the URL . Assuming that all the XML files are the same structure, you will need to c...
by vazquezrosariop
Wed Aug 23, 2017 2:42 pm
Forum: IBM InfoSphere MDM
Topic: Escape Pipe Characters In Extract
Replies: 2
Views: 113

Re: Escape Pipe Characters In Extract

Hi litsos, I wanted to ask you some follow up questions to gain a greater understanding of your use case: ⋅ Are you able to parse the data correctly or are you reading the data as one big string? ⋅ Are the string quoted? ⋅ Are you looking to completely replace the | cha...
by vazquezrosariop
Tue Aug 22, 2017 3:46 pm
Forum: IBM InfoSphere MDM
Topic: Escape Pipe Characters In Extract
Replies: 2
Views: 113

Re: Escape Pipe Characters In Extract

Hi litsos,

You can try the following code to remove the pipe from any particular string:

Code: Select all

$0.Firstname := $Firstname.replace("\\|","");


Please let me know if this worked for you
by vazquezrosariop
Thu Aug 03, 2017 6:42 pm
Forum: CloverETL Support
Topic: Read Specified file .zip file - no error raised if file does not exist in zip?
Replies: 2
Views: 76

Re: Read Specified file .zip file - no error raised if file does not exist in zip?

Hi Heather, Thank you for reporting this issue, I have taken the liberty of creating a ticket in our system and our Developers are currently working on establishing a fix for our next CloverETL release. In the meantime, I have created a workaround that will cause the graph to fail if the specified f...
by vazquezrosariop
Wed Jul 26, 2017 2:48 pm
Forum: CloverETL Server
Topic: JMS Event Listener with RabbitMQ
Replies: 3
Views: 203

Re: JMS Event Listener with RabbitMQ

I have taken the liberty of attaching the example RabbitMQ graph, please look through it and let me know if you have any questions. Some notes about the graph: ⋅ RabbitMQ Reader and RabbitMQ Ack are both CustomJava components, and please look over the code in the trans folder. ⋅ ...
by vazquezrosariop
Wed Jul 12, 2017 8:26 pm
Forum: CloverETL Server
Topic: JMS Event Listener with RabbitMQ
Replies: 3
Views: 203

Re: JMS Event Listener with RabbitMQ

Hi sshrestha, From the stack trace you included, it appears that the RabbitMQ Java client library is not specified in the application server that CloverETL Server is stored. If so, please download the rabbitmq.jar file and add it to the following path <TOMACAT_HOME>/lib folder and restart the server.
by vazquezrosariop
Thu Jun 01, 2017 5:53 pm
Forum: CloverETL Support
Topic: How to limit the total number of running instances of a file listener job flow
Replies: 2
Views: 120

Re: How to limit the total number of running instances of a file listener job flow

Hi jzhu, CloverETL does have a way to limit the total number of running instances. You can achieve this via Job Config Properties on the Sandbox (Server Console - Sandboxes - CloverETLProject - Config Properties). The two properties you want to set are max_running_concurrently = <the amount of Jobfl...
by vazquezrosariop
Fri May 19, 2017 8:04 am
Forum: CloverETL Support
Topic: Anyone have a working web service client component on linux that needs to go through a proxy server
Replies: 1
Views: 133

Re: Anyone have a working web service client component on linux that needs to go through a proxy server

Hi Pintail,

Our team is aware of this issue and a ticket was created in our ticketing system. We will inform our developers that this is a priority issue and they will look into resolving it in a future release of CloverETL. We are quite sorry for the inconvenience.
by vazquezrosariop
Wed May 10, 2017 9:35 am
Forum: CloverETL Support
Topic: Fail Column Header Not Found in Output MetaData with SpreadsheetDataReader
Replies: 1
Views: 109

Re: Fail Column Header Not Found in Output MetaData with SpreadsheetDataReader

Hi Imohtep86,

Unfortunately, there is no automatic way to accomplish this use case, I would recommend manually accessing SpreadSheetReader mapping and if a new column is present adding the field to your current metadata or ignoring it if you do not wish to include it.
by vazquezrosariop
Wed May 10, 2017 8:39 am
Forum: CloverETL Support
Topic: Reading Column Headers from an Incoming CSV file
Replies: 1
Views: 106

Re: Reading Column Headers from an Incoming CSV file

Imohtep86, You mentioned that you are reading the Column headers and extracting data from a CSV file: ⋅ Are you using the the FlatFileReader component to read this File? ⋅ Are you creating the metadata manually or are you using the Extract metadata? ⋅ If possible please...
by vazquezrosariop
Fri Apr 21, 2017 8:18 pm
Forum: CloverETL Server
Topic: Using allocation with DBInputTable
Replies: 5
Views: 330

Re: Using allocation with DBInputTable

Hi hewills, After looking over your graph, I have a few suggestions that will improve the overall performance: ⋅ I would recommend using a Normalizer component to be able to create multiple queries ⋅ I would recommend removing the ParallelGather and adding a ParallelPartition bef...
by vazquezrosariop
Fri Apr 21, 2017 2:27 pm
Forum: CloverETL Support
Topic: ComplexDataReader Java Issue
Replies: 6
Views: 321

Re: ComplexDataReader Java Issue

Hi dflkid,

Our sales team will look to contact you directly and go over next steps to be able to resolve your issue.

Thank You,
by vazquezrosariop
Thu Apr 20, 2017 7:53 pm
Forum: CloverETL Server
Topic: Using allocation with DBInputTable
Replies: 5
Views: 330

Re: Using allocation with DBInputTable

Hi hewills, Could you please provide me with following information: ⋅ How many records are you processing? ⋅ How long does this process usually take? ⋅ What Database Server are you utilizing (vendor, version)? ⋅ Can you please provide me with your graph, I wou...
by vazquezrosariop
Wed Apr 19, 2017 6:43 pm
Forum: CloverETL Support
Topic: Nested JSON Extract
Replies: 2
Views: 157

Re: Nested JSON Extract

Hi TimoCHH, As anyeone mentioned the Denormalizer component would be the best suited for merging records together, unfortunately Community Version of CloverETL does not include this component. If possible can you please share you project an we can look for a possible alternative solution to your use...

cron