topic Re: Stat & Logs in Talend Studio

Stat & Logs

_AnonymousUser — Sat, 16 Nov 2024 12:37:24 GMT

Hello
I've a problem using the project's stats and logs.
I want to save all the log in a database but I can't use my context variable to set the connection.
I've an error message :
Exception in component connectionStatsLogs
org.postgresql.util.PSQLException: La tentative de connexion a échoué. (connection failed)
How can I do to use my context's variable on the Stats and logs ?
Thanks !

Re: Stat & Logs

djugal — Mon, 17 Oct 2011 11:17:23 GMT

Try using Implicit context load property along with it.

Re: Stat & Logs

_AnonymousUser — Mon, 17 Oct 2011 12:23:53 GMT

The value of my contextes variables are set in a file. I think that's the reason why I can't use my contexte variable in the stat / log and in the implicit context ...
Is there a solution for that ? Or I have to set my variable in the context ?

Re: Stat & Logs

Anonymous — Mon, 17 Oct 2011 12:47:45 GMT

Hi,
I don't know if it helps, but we use --context_param with key/value pairs when running jobs to fill the context for the database connection which is used for stats and logs. Maybe you can use a similar approach.
Good luck,
Arno

Re: Stat & Logs

djugal — Mon, 17 Oct 2011 12:54:24 GMT

I had the same problem, solution is:
1. Project settings, Implicit context load - load your context file
2. In file path you can now write: context.path
3. in your job you have to create a new context variable path
Your job is done.

Re: Stat & Logs

Anonymous — Mon, 17 Oct 2011 14:01:30 GMT

Thanks a lot for your help
I use the solution of djugal and it works fine