Search found 10 matches

by ramiro
Fri Sep 01, 2017 7:37 pm
Forum: CloverETL Server
Topic: How to turn off direct memory
Replies: 1
Views: 285

How to turn off direct memory

Hello, We are using cloverETL 4.2.0.9/9, and we hit the following issue in our production servers: https://bug.javlin.eu/browse/CLO-5651 We tried to disable Direct Memory, by putting "USE_DIRECT_MEMORY = false" into a new file in tomcat_dir/conf/engine.config Then adding a line to our clov...
by ramiro
Wed Sep 16, 2015 6:29 pm
Forum: CloverETL Server
Topic: troubleshooting a postgresql JNDI connection
Replies: 4
Views: 1495

Re: troubleshooting a postgresql JNDI connection

Thanks for the RedshiftWriter Subgraph recommendation Jan, it will be worth exploring, unfortunately we are stuck on version 3.5 of CloverETL for the moment, hopefully we can make DBEXEC graphs to work with JNDI instead. This is the particular SQL statement I am running (but in fact, it can be any s...
by ramiro
Wed Sep 16, 2015 4:53 pm
Forum: CloverETL Support
Topic: DBExecute graphs not working with JNDI connections
Replies: 2
Views: 737

Re: DBExecute graphs not working with JNDI connections

Hi Jan, Same issue. The reason I posted there first was because I though my JNDI setup was wrong. Later I realize the problem was the combination of a DBExecute graph and a JNDI connection that didn't work (all other graphs that involve db connections seem to be ok). So I was thinking I may have a b...
by ramiro
Sat Sep 12, 2015 12:06 am
Forum: CloverETL Support
Topic: DBExecute graphs not working with JNDI connections
Replies: 2
Views: 737

DBExecute graphs not working with JNDI connections

I am using CloverETL Server 3.5.2.12/12 When I link a DBExecute graph to a JNDI pool connection resource, the sql query doesn't get executed, and it just times out. If I switch to regular postgresql driver connections, the same sql works just fine. Looks like DBInputTable works just fine (with the s...
by ramiro
Sat Sep 12, 2015 12:02 am
Forum: CloverETL Server
Topic: troubleshooting a postgresql JNDI connection
Replies: 4
Views: 1495

Re: troubleshooting a postgresql JNDI connection

update on this issue: the JNDI setup is actually working, the problem is that the DBExecute clover graphs don't work with JNDI connections, they just timeout (CloverETL Server 3.5.2.12/12)

Does anybody know why?
by ramiro
Thu Sep 10, 2015 7:12 pm
Forum: CloverETL Server
Topic: troubleshooting a postgresql JNDI connection
Replies: 4
Views: 1495

troubleshooting a postgresql JNDI connection

Hello, I am trying to setup a new JNDI connection in my cloverETL server, I am running into some issues and I am not sure how to troubleshoot from there. I modified my tomcat/config/context.xml file as follows: <Resource name="redshift" auth="Container" type="javax.sql.DataS...
by ramiro
Fri Aug 14, 2015 11:48 pm
Forum: CloverETL Server
Topic: Manually kill a job that gets stuck forever
Replies: 5
Views: 2386

Re: Manually kill a job that gets stuck forever

Thanks for all the details! Yes, Amazon has a limited number of connections available, and yes, sometimes we do exceed them. So most likely that is the reason why the connection reminds open. Regarding the blue not turning to red, yes, we tried the refresh button, reloading the entire page, filterin...
by ramiro
Wed Aug 12, 2015 6:14 pm
Forum: CloverETL Server
Topic: Manually kill a job that gets stuck forever
Replies: 5
Views: 2386

Re: Manually kill a job that gets stuck forever

Hi imriskal, Thanks for the response. It is not always the same jobs, but the same db connection that fails. The database is an external, third party resource hosted in Amazon, and it works 90-95% of the time. We do run a lot of jobs though, so we see this connection error often. The error happens i...
by ramiro
Wed Aug 12, 2015 12:27 am
Forum: CloverETL Server
Topic: Manually kill a job that gets stuck forever
Replies: 5
Views: 2386

Manually kill a job that gets stuck forever

Looks like there are cases where a job fails, and throws an exception, but it just keeps running forever in the background. It happens to us a couple of times already. In the web UI interface the job indicator never change from blue (running) to red, even though when we click on the specific sub-job...
by ramiro
Fri Aug 08, 2014 1:18 am
Forum: CloverETL Support
Topic: Transactions across subgraphs
Replies: 1
Views: 857

Transactions across subgraphs

We are trying to setup database transactions across a couple of subgraphs. It works if all the graphs are in the same job flow, but if call subgraphs that contain sql, we can't get them to be part of the same transaction. We have tried setting the transaction set to never commit in all boxes, and we...