Clover Server Placeholders

Support questions related to CloverETL Server

impulse101587
Posts: 16
Joined: Mon Sep 28, 2015 6:10 pm

Clover Server Placeholders

Postby impulse101587 » Fri Nov 06, 2015 4:14 pm

Hello,

Does anyone have any reference to a list of the placeholders within the Clover Server. Ex. Placeholder ${port.totalRows} etc.?

impulse101587
Posts: 16
Joined: Mon Sep 28, 2015 6:10 pm

Re: Clover Server Placeholders

Postby impulse101587 » Thu Nov 12, 2015 5:10 pm

Nobody has any reference to any of these? Any Clover ETL admins on here have any input?

cholastal
Posts: 107
Joined: Tue Sep 01, 2015 1:22 pm

Re: Clover Server Placeholders

Postby cholastal » Wed Nov 18, 2015 12:05 pm

Hi Impulse

Unfortunately, there isn't a list of Server parameters in the documentation. So I compiled one for you, please see attachment. The placeholders starting with ${EVENT...} return values only when the job is started by Schedule or by Jobflow component (e.g. ExecuteGraph). Also, you can create your own Server properties which can be read by CTL code, for more information about this, please see our documentation.

However I don't understand what you mean by the ${port.totalRows} placeholder. Is it just an example? If you describe what you want to achieve, maybe I could assist you better.

Hope this helps.
Attachments
srvr_params.txt
(586 Bytes) Downloaded 73 times
---
Lukas Cholasta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support

impulse101587
Posts: 16
Joined: Mon Sep 28, 2015 6:10 pm

Re: Clover Server Placeholders

Postby impulse101587 » Wed Nov 18, 2015 4:20 pm

Thank you for your reply. The information will certainly help. The example i gave was pulled from the populated graph failure email that clover provides. I am trying to build a more purposeful failure email and am trying to find all the placeholders that can possibly be used.

impulse101587
Posts: 16
Joined: Mon Sep 28, 2015 6:10 pm

Re: Clover Server Placeholders

Postby impulse101587 » Wed Nov 18, 2015 4:24 pm

For example these placeholders:
runId ${run.id}
Sandbox: ${sandbox.code}
Graph: ${run.jobFile}

Result: ${run.status}
Started: ${run.startTime}
Finished: ${run.stopTime}

Error node: $!{run.errNode}
Error message: $!{run.errMessage}
Error exception: $!{run.errException}
Log file: $!{run.logLocation}

cholastal
Posts: 107
Joined: Tue Sep 01, 2015 1:22 pm

Re: Clover Server Placeholders

Postby cholastal » Fri Nov 20, 2015 3:54 pm

Hi

I'm sorry, I misunderstood what exactly you meant. The placeholders I sent you are intended to be used from within a graph in CTL2 code. However, there is not a complete list of all available Server placeholders anywhere, so I created an improvement proposal and I believe this matter will be resolved as soon as possible.

Best regards
---
Lukas Cholasta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support

impulse101587
Posts: 16
Joined: Mon Sep 28, 2015 6:10 pm

Re: Clover Server Placeholders

Postby impulse101587 » Sun Nov 22, 2015 6:21 pm

Fantastic. Thank you for the assistance.