Search found 20 matches

by jzhu
Tue Jun 29, 2021 11:00 am
Forum: CloverDX Server
Topic: Linux soft link stopped working for ListFiles on CloverDX 5.11.0
Replies: 1
Views: 10771

Linux soft link stopped working for ListFiles on CloverDX 5.11.0

Linux soft link works for ListFiles on CloverETL 4.3.0, but does not work on CloverDX 5.11.0 (not work on 5.10.1 either). The use case is to change data-in etc. in project sandbox to point to RAM disk with soft link. Error message: 2021-06-29 10:25:18,117 ERROR 3004 [WatchDog_3004] Component [ListFi...
by jzhu
Wed May 31, 2017 12:39 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to limit the total number of running instances of a file listener job flow
Replies: 2
Views: 3597

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

File listener is used to trigger a job flow. It takes a while to process each file (typically 15 minutes in our examples). There are lots of files, arriving at random time. In case of dozens (even hundreds) of such files arriving in a short time period, many instances of the job flow are fired up, p...
by jzhu
Wed Feb 08, 2017 12:45 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Conflict between EmailSender and 7-zip in parallel
Replies: 2
Views: 3366

Conflict between EmailSender and 7-zip in parallel

Just noticed the strange behavior. A job flow (A) calls another job flow (B), and sends the result through an email with attachment (in A). The procedure is repeated for multiple inputs (tar.gz files). (B) runs a script to decompress a tar.gz file using 7-zip and then process. In (A), if EmailSender...
by jzhu
Tue Dec 06, 2016 11:29 am
Forum: CloverDX (formerly CloverETL) Support
Topic: How to suppress empty array and null item in a array in JSONWriter output
Replies: 3
Views: 4763

Re: How to suppress empty array and null item in a array in JSONWriter output

Some examples. (1) Empty array: "phoneNumbers" : [] (2) Empty item in an array: "phoneNumbers": [{"phoneNumber": "0123456789", "type":""},{"phoneNumber": "0789123456", "type":"mobile"}] (3) Empty item...
by jzhu
Mon Dec 05, 2016 2:15 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to suppress empty array and null item in a array in JSONWriter output
Replies: 3
Views: 4763

How to suppress empty array and null item in a array in JSONWriter output

JSONWriter input port (not port 0) maps to an array in JSON. Some times the array is empty, or some items in the array is empty. How do I suppress the empty array or empty empty items in the array of the output JSON file? For empty items in the array, tried "Write null element", and it did...
by jzhu
Wed Nov 09, 2016 11:29 am
Forum: CloverDX (formerly CloverETL) Support
Topic: DBInputTable: compatibility with Microsoft SQL EXPRESS 2008 R2
Replies: 2
Views: 3331

Re: DBInputTable: compatibility with Microsoft SQL EXPRESS 2008 R2

This is now resolved. It is because one database needs sysadmin to access.
by jzhu
Tue Nov 08, 2016 7:43 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: DBInputTable: compatibility with Microsoft SQL EXPRESS 2008 R2
Replies: 2
Views: 3331

DBInputTable: compatibility with Microsoft SQL EXPRESS 2008 R2

What could cause "SQL query editor" of DBInputTable to show database objects etc. but no user table? I've two different database on Microsoft SQL EXPRESS 2008 R2, both restored from backup file on Microsoft SQL 2000. In "SQL query editor" of DBInputTable, when expand the database...
by jzhu
Wed Oct 26, 2016 12:16 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: JSONWriter: how to create a json file with root being a array
Replies: 2
Views: 4616

Re: JSONWriter: how to create a json file with root being a array

Thanks for the very quick reply, Pedro.
It is sorted! I did not realise I could delete the root.
by jzhu
Tue Oct 25, 2016 11:36 am
Forum: CloverDX (formerly CloverETL) Support
Topic: JSONWriter: how to create a json file with root being a array
Replies: 2
Views: 4616

JSONWriter: how to create a json file with root being a array

I need to create json files whose root are an array (starts with [), in the format as follows: [object, object, ...]. But for JSONWriter mapping, the root is an element (object) which starts with {. Is there any simple way to make JSON root to be an array instead? I could manually remove the root an...
by jzhu
Tue Sep 20, 2016 5:02 pm
Forum: CloverDX Server
Topic: CloverETL server fails to start after DB configuration change to Oracle 11g/12c
Replies: 1
Views: 4410

CloverETL server fails to start after DB configuration change to Oracle 11g/12c

Initially, the DB configuration (for both Oracle DB 11g/12c) worked after fiddling around with server v.4.2.1 (Tomcat). I restarted from fresh, in order: (1) stop and remove 4.2.1, (2) reinstall 4.3.0, (3) drop all (39) tables in the DB, (4) start 4.3.0, (5) add license (6) configure DB (Oracle), va...
by jzhu
Tue Sep 13, 2016 3:28 pm
Forum: CloverDX Server
Topic: Cannot access CloverETL server project from designer after changing server access credentials
Replies: 3
Views: 6592

Cannot access CloverETL server project from designer after changing server access credentials

I created a CloverETL server project on local server in CloverETL designer, and ticked remember password. The password is changed afterwords. Now I cannot open the project, because it uses the old password. Even if I manual change the password when open the project, it can establish the connection, ...
by jzhu
Mon Sep 12, 2016 3:08 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Is SMTP server etc. of EmailSender dynamically configurable on CloverETL server? How?
Replies: 2
Views: 3284

Re: Is SMTP server etc. of EmailSender dynamically configurable on CloverETL server? How?

Thanks, Pedro.

That is a solution, which will do for now.
But it is really inconvenient -- We'll have to create a few extra jobflows just for the SMTP server settings of EmailSender, for production/non-production and various local test environment. Hope it is better in the future.
by jzhu
Thu Sep 01, 2016 6:39 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Is SMTP server etc. of EmailSender dynamically configurable on CloverETL server? How?
Replies: 2
Views: 3284

Is SMTP server etc. of EmailSender dynamically configurable on CloverETL server? How?

I use EmailSender in JobFlow for Email notification of some particular errors/issues/scenarios. I need its parameters such as SMTP server to be configurable on the CLoverETL server -- when the JobFlow is triggered through event listener / scheduling, or just use the email configured in CloverETL ser...