Search found 15 matches

by sshrestha
Tue Apr 03, 2018 5:27 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: MongodbWriter create ObjectId
Replies: 1
Views: 1190

MongodbWriter create ObjectId

Hi, I am trying to insert a new row into MongoDB using Mongodb Writer. When inserting I also need to generate ObjectId (maybe datetime as well). How can I achieve this? I tried the following json object below: { "product_id": new ObjectId(), "name": "foo", "categor...
by sshrestha
Fri Mar 30, 2018 6:25 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: MongoDBReader formatting issues
Replies: 1
Views: 970

MongoDBReader formatting issues

Hi, I am trying to read some data from MongoDB. An example data is below: { _id: "XXXXXXXXXXXX", name: "Foo", description: "bar", metadata: { info: "Hello World" } } If I read a document as shown above from MongoDB the document is returned as JSON Object which...
by sshrestha
Thu Mar 29, 2018 5:18 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Creating unique hash
Replies: 2
Views: 1375

Creating unique hash

Hi, I am trying to create a unique hash from some concatenated strings so that I can use the hash as a Primary Key in my database. It is preferable to have the hash as an alphanumeric value. To achieve this I was planning to use the code below. byte2hex(sha( "SOME_LONG_STRING_VALUE" )); I ...
by sshrestha
Wed Mar 28, 2018 9:55 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Getting RUN_ID
Replies: 2
Views: 1204

Re: Getting RUN_ID

That worked :). Thank you for you quick reply.

-Shubha
by sshrestha
Tue Mar 27, 2018 3:40 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Getting RUN_ID
Replies: 2
Views: 1204

Getting RUN_ID

Is there a way to get RUN_ID and ROOT_RUN_ID of a graph without converting the code to JAVA? The docs in this link http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/functions-reference-ctl2.html shows how to get RUN_ID using JAVA but I was hoping there's a...
by sshrestha
Thu Mar 22, 2018 5:37 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Finding difference between two datasets
Replies: 1
Views: 1138

Finding difference between two datasets

Hi, I am not sure how to achieve what I am trying to do. Could you please point me to the right direction. Let's say I have a table in database called products --------------------------- # | Name | Quantity | --------------------------- 1 | Bat | 10 | 2 | Ball | 5 | 3 | Chair | 3 | ----------------...
by sshrestha
Tue Feb 27, 2018 4:38 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Clover ETL Designer stuck in Synchronizing Projects
Replies: 1
Views: 995

Re: Clover ETL Designer stuck in Synchronizing Projects

I might have found a temporary fix for now. Turns out as soon as the designer opened, it was trying to connect to a server that was not available, which was returning 503 Internal Server Error. This caused the designer to get stuck in synchronization step. To fix this, I turned off the access to int...
by sshrestha
Fri Feb 23, 2018 8:20 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Clover ETL Designer stuck in Synchronizing Projects
Replies: 1
Views: 995

Clover ETL Designer stuck in Synchronizing Projects

Hi, When I open my Clover ETL Designer in my Macbook I see the progress tab as shown below: https://i.imgur.com/Gd7tyVY.png The designer is still usable at this point. But when I try to save any graph a new pop up shows up as shown below. https://i.imgur.com/3xIX3PD.png After this the designer is li...
by sshrestha
Mon Feb 05, 2018 6:21 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: HTTP POST text file
Replies: 5
Views: 2780

Re: HTTP POST text file

Thank you for your suggestions. You are absolutely right about the content-length not being sent in the header. I could not quite figure out how to figure out the content length of the file being sent. http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/http...
by sshrestha
Mon Feb 05, 2018 5:52 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Global Parameter
Replies: 4
Views: 2523

Re: Global Parameter

Thank you Eva, I had a MASTER_AUTH_KEY that I wanted available in any graph that wanted to use it. I put the key value pair in workspace.prm file since that file seems to be available in every graph with the same parameter values. However, your suggestions for db lookup seems to be more favorable fo...
by sshrestha
Wed Jan 24, 2018 6:24 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: HTTP POST text file
Replies: 5
Views: 2780

Re: HTTP POST text file

by sshrestha
Tue Jan 23, 2018 10:00 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: HTTP POST text file
Replies: 5
Views: 2780

HTTP POST text file

I am trying to send a POST request to HTTP endpoint along with a text file. I tried following the instructions in the help documentation provided http://127.0.0.1:63771/help/index.jsp?topic=%2Fcom.cloveretl.gui.docs%2Fdocs%2Fhttpconnector.html%23httpconnector-examples but nothing seems to work. I re...
by sshrestha
Tue Jan 23, 2018 4:51 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Global Parameter
Replies: 4
Views: 2523

Global Parameter

Is there a way to create a parameter that is available in a jobflow and any subgraphs or jobflows without having to pass it as a parameter to subgraphs every time. For Example, let's say I want to create a paramter called 'PI' whose value is 3.14, but I don't want to pass it as parameter every time ...
by sshrestha
Thu Jul 13, 2017 5:44 pm
Forum: CloverDX Server
Topic: JMS Event Listener with RabbitMQ
Replies: 3
Views: 3114

Re: JMS Event Listener with RabbitMQ

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. Thank you P...
by sshrestha
Tue Jul 11, 2017 8:33 pm
Forum: CloverDX Server
Topic: JMS Event Listener with RabbitMQ
Replies: 3
Views: 3114

JMS Event Listener with RabbitMQ

I am trying to create a JMS Event Listener using RabbitMQ. But it fails to activate the Event Listener with the following messages: Listener has been updated error Some library classes missing. Check whether the third party libraries are on the classpath. No definition for the class with the specifi...

cron