Search found 137 matches

by cholastal
Wed Jan 18, 2017 3:35 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: MySQL connection issues
Replies: 1
Views: 3826

Re: MySQL connection issues

Hi, The issue is probably caused by the target database connection interruption (most probably a MySQL instance ( 1 , 2 )). Here are some hints how to possibly overcome this issue. 1. The DBInputTable component has a default value of the Fetch size property set to 20 as you are reading hundred of th...
by cholastal
Mon Nov 28, 2016 3:05 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: A Palette is not available
Replies: 3
Views: 2844

Re: A Palette is not available

Hi daves,

As this issue relates to IBM products please do contact IBM support in this matter directly. They need to be informed about this issue and will work with us directly if needed. Thank you for your cooperation!

Best regards,
by cholastal
Mon Nov 28, 2016 2:30 pm
Forum: CloverDX for Java Programmers
Topic: Reading from mulitple xml files
Replies: 1
Views: 3631

Re: Reading from mulitple xml files

Hi Madan, If you want to filter some fields based on other fields, you need to use some other components such as ExtFilter , Validator or Reformat . Such filtering cannot be done directly in the XMLWriter component. If you want me to prepare an example for you, please provide me with valid input XML...
by cholastal
Fri Oct 21, 2016 6:34 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Geeting error while writing csv file to FTP server
Replies: 3
Views: 4456

Re: Geeting error while writing csv file to FTP server

Hi, I've consulted your issue with our developers and it is most probably in settings of the FTP server itself. The FlatFileWriter (or UniversalDataWriter) is using just a bare implementation of the java.net.URLConnection class to save the file to the FTP server. Also, while you're creating the file...
by cholastal
Mon Oct 17, 2016 12:18 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Geeting error while writing csv file to FTP server
Replies: 3
Views: 4456

Re: Geeting error while writing csv file to FTP server

Hi jagan, This issue may be caused by several reasons. 1. The port is not opened. 2. There is a user limit set on the FTP server. 3. You are using SFTP protocol instead of plain FTP. 4. There is a firewall on the FTP server or on your machine that is blocking the communication. Please try the follow...
by cholastal
Wed Oct 12, 2016 3:17 pm
Forum: CloverDX for Java Programmers
Topic: Writing raw data to an output port
Replies: 2
Views: 4102

Re: Writing raw data to an output port

Hi, The data you want to write to an output port has to have the form of a DataRecord. Every data flowing through a CloverETL graph has to be mapped to some metadata. This is the way you do it in a custom Java transformation. You don't have to parse the data yourself, you can create a metadata conta...
by cholastal
Wed Sep 14, 2016 2:39 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: In files with generic names, only one at a time
Replies: 14
Views: 7733

Re: In files with generic names, only one at a time

Hi, I was solving this use case with Heather via email but in case anyone else is interested in a solution, here it is. In case you don't control the transfer process, you need to setup a jobflow that will periodically check the size of the file and compare it to the size the file had during the las...
by cholastal
Wed Sep 07, 2016 2:58 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Escape single quote
Replies: 2
Views: 2584

Re: Escape single quote

Hi, I just tested a similar usage with no issues. In order to resolve your issue please provide me with the following. 1. Version of your Designer. 2. Version of your MS-SQL database. 3. Your graph file without any sensitive information. 4. Your console output when the error occurs. Just copy-paste ...
by cholastal
Tue Aug 30, 2016 2:57 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Metadata extraction failed
Replies: 2
Views: 2496

Re: Metadata extraction failed

Hi, Graphs in the Designer are running in an environment called Runtime. This Runtime runs as a separate Java process and communicates with the Designer via a port. The error message says that this port is blocked for some reason. The Runtime is needed to extract the metadata as it is the process wh...
by cholastal
Tue Aug 30, 2016 1:42 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Generate Dynamic Metadata from files
Replies: 5
Views: 6846

Re: Generate Dynamic Metadata from files

Hi Jigar, Please see the attached graph. It is using a Normalizer component with some CTL2 functions to create the metadata from the input record. After the metadata is created it is converted into a XML format and written to the HDD by the XMLWriter component. Using this file is as easy as using an...
by cholastal
Fri Aug 12, 2016 3:13 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: What comes out of the two ports on the DBOutputTable component?
Replies: 1
Views: 1874

Re: What comes out of the two ports on the DBOutputTable component?

Hi pintail, The DBoutputTable is autopropagating the metadata that is on input port to the error output port. There is no need to explicitly setting the error output metadata. So to answer your questions. 1. The ErrCode and ErrText fields are automatically added to the metadata coming through the in...
by cholastal
Wed Aug 03, 2016 12:54 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Http Connector Issue
Replies: 5
Views: 4100

Re: Http Connector Issue

Hi, It looks like you are mixing two different approaches together. 1. Passing CloverETL parameters as request parameters - If you have some CloverETL parameters defined (Designer -> Outline window -> Parameters), then you can pass them via ${PARAM} syntax. 2. Passing data from an edge as request pa...
by cholastal
Tue Aug 02, 2016 2:38 pm
Forum: CloverDX Server
Topic: How to increase CPU load on DBInputTable components
Replies: 1
Views: 3197

Re: How to increase CPU load on DBInputTable components

Hi, Here are some options how to possibly increase the CPU load: 1. Increase the value of the Fetch size property of the DBInputTable component. 2. Use more DBInputTable components (in single graph) and load only some part of the table in each of them (parallel loading). When the loading is done, yo...
by cholastal
Mon Jul 04, 2016 9:26 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Apache Kafka reader component.
Replies: 7
Views: 5788

Re: Apache Kafka reader component.

Hi, We have spent some time creating the example components and now they are finally here. The archive contains whole CloverETL project with everything that is needed to do a basic read and write from/to a Kafka topic. There are two subgraphs and one testing graph (among other things) in the project...
by cholastal
Tue Jun 28, 2016 1:19 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to use Json Extractor when records don't have all the same attributes
Replies: 3
Views: 3149

Re: How to use Json Extractor when records don't have all the same attributes

Hi mcomsto, You can parse the 'features' by a component called Normalizer and dynamic field access CTL functions. I attached a simple example graph which utilizes this approach. You mentioned that you cannot see the 'features' in the visual mapper of the JSONExtract component. I just copied your sam...