Search found 397 matches

by imriskal
Fri Sep 18, 2015 12:01 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Adding multiple batches to Salesforce Job
Replies: 1
Views: 1618

Re: Adding multiple batches to Salesforce Job

Hi Jesse, I am not sure whether SalesForce allows users to send more than one request using the same session ID but if it does, here is what you can do. I think the easiest way is to transform the whole graph into a jobflow. In the jobflow, you replace HTTPConnector in step 3 with ExecuteJobflow. In...
by imriskal
Thu Sep 17, 2015 1:33 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: What's the best wait to halt a graph if a certain component returns no rows/results?
Replies: 3
Views: 2314

Re: What's the best wait to halt a graph if a certain component returns no rows/results?

Hello Kyle, As you already discussed with my colleague via email, you can modify your SQL query and add a fake record in case the original query returns 0 records. See Getting SELECT to return a constant value even if zero rows match This fake record can contain an identifier and ExtFilter can redir...
by imriskal
Fri Sep 04, 2015 1:40 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: MySQL to Salesforce
Replies: 1
Views: 2164

Re: MySQL to Salesforce

Hello Jesse, If you don't like saving the CSV file, you don't have to. Just use UniversalDataWriter saving the records not into your file system but forwarding the csv via output port to HTTPConnector. Now you can set Input mapping in the HTTPConnector. Ignore $out.0.inputFileUrl and set $out.0.requ...
by imriskal
Thu Sep 03, 2015 10:10 am
Forum: CloverDX (formerly CloverETL) Support
Topic: clover etl fails to start after JRE update
Replies: 3
Views: 2732

Re: clover etl fails to start after JRE update

Just a side note, Java 8 will be officially supported in CloverETL 4.1.0 which should be released in a few weeks.
by imriskal
Tue Sep 01, 2015 11:57 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Error Creating Hadoop Connection
Replies: 3
Views: 3189

Re: Error Creating Hadoop Connection

Hi Virag, Could you please export your project and share it with me? Without any passwords, of course. Also, the screenshots you provided are too small for me to be able to read it. Could you provide me with some larger ones? Preferably with the "Edit Hadoop Connection" window visible. The...
by imriskal
Tue Sep 01, 2015 9:49 am
Forum: CloverDX (formerly CloverETL) Support
Topic: clover etl fails to start after JRE update
Replies: 3
Views: 2732

Re: clover etl fails to start after JRE update

Hi, This looks like Oracle Integrator and not CloverETL 3.1. I do not know which Java version is supported by Integrator but CloverETL can not run on Java 8 yet. We plan to add support for Java 8 in some of our future releases. I noticed that your ini file contains a relative path to javaw.exe while...
by imriskal
Fri Aug 14, 2015 1:39 pm
Forum: CloverDX Server
Topic: Manually kill a job that gets stuck forever
Replies: 5
Views: 6616

Re: Manually kill a job that gets stuck forever

One more note, there is a utility named gdb able to close file descriptor in Linux, see StackOverflow . If you find PID of Java process running the graph and file descriptors open by this process, you can close the descriptor using the mentioned utility which should allow CloverETL Server to stop th...
by imriskal
Thu Aug 13, 2015 2:30 pm
Forum: CloverDX Server
Topic: Manually kill a job that gets stuck forever
Replies: 5
Views: 6616

Re: Manually kill a job that gets stuck forever

Ramiro, Thank you for such a detailed report. I think max_graph_instance_age will not help you. max_graph_instance_age = Time interval in ms which specifies how long may transformation instance last in server's cache. 0 means that transformation is initialized and released for each execution. Transf...
by imriskal
Thu Aug 13, 2015 8:40 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Newbie 'Replace' Question
Replies: 4
Views: 2991

Re: Newbie 'Replace' Question

Hi Dave, Could you please share your graph and a sample of input file throwing the error? I would like to see the error you get for myself. A general advice I can give you right away is that you should be careful about the second argument of replace function. It is not a string as it might seem, it ...
by imriskal
Wed Aug 12, 2015 10:02 am
Forum: CloverDX Server
Topic: Manually kill a job that gets stuck forever
Replies: 5
Views: 6616

Re: Manually kill a job that gets stuck forever

Hi ramiro, I think we should focus on what causes the graphs to get stuck instead of trying to kill them afterwards. Could you please tell me more about the jobs? Any detail could be important. Are they always the same jobs? Can you share the graphs and the exceptions they throw with me? Are there a...
by imriskal
Tue Aug 11, 2015 1:13 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Create json records
Replies: 1
Views: 2144

Re: Create json records

Hi Micky, I am not exactly sure how the output should look like because the two output records are not valid JSON records. There are two issues in there: A) names and string values should be in double quotes, B) root element should not be named. I prepared an example where two approaches are used. O...
by imriskal
Thu Jun 11, 2015 2:51 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Graphs Not Running: 2 Errors "Can't load property definition from workspace.prm"
Replies: 1
Views: 1914

Re: Graphs Not Running: 2 Errors "Can't load property definition from workspace.prm"

Hello imujir,

As this issue relates to Endeca Data Integrator please do contact Oracle Endeca 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!
by imriskal
Mon Apr 20, 2015 2:47 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: UNC Support on 3.4.1?
Replies: 1
Views: 1978

Re: UNC Support on 3.4.1?

Hello, The first thing we need to realize is that we do not support UNC paths in CloverETL 3.4 in any way. The official support of UNC paths came in CloverETL 3.5 and File URLs should always start with prefix smb:// It may appear that 3.4 can also work with UNC paths because some of the required fun...
by imriskal
Thu Apr 09, 2015 11:07 am
Forum: CloverDX (formerly CloverETL) Support
Topic: How toation Read XML file as single string
Replies: 1
Views: 2031

Re: How toation Read XML file as single string

Hi Jagan,

You should read the whole file in one big field instead of trying to read it line by line. Just delete delimiters in your metadata, set the field to byte type and set "EOF as delimiter" to true. PFA your modified graph.

PayrollFileMove_modified.grf
(1.46 KiB) Downloaded 273 times
by imriskal
Wed Mar 18, 2015 9:05 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Clover Engine 4.0.4 and java version
Replies: 3
Views: 3127

Re: Clover Engine 4.0.4 and java version

The SourceForge release is universal, it depends on the Java used. If you want 64-bit, just use 64-bit JDK.

Regards,