tLogRow error - not displaying output due to some format ting issue

Anonymous — Wed, 19 Sep 2018 11:50:18 GMT

Hi,

I'm facing an issue within TOS data integration where I am unable to pass through data from a SQL database into tLogRow (just wanted to do some basic checks).

The issue is where I have variables with format “yyyy-MM-dd HH:mm:ss’Z’”. Whenever I have a variable with that format Talend throws up errors relating to syntax or how yyyy does not resolve to a variable. However, I know this isn't a formatting issue as I formatted these variables in Talend and uploaded tables to PostgresSQL with no issues (format is visible on the variables in the table).

If I change the format to remove the timezone this tLogRow issue does not occur.

The reason I happened upon this is I was attempting to calidate against the schema through tSchemaComplianceCheck and it did not work.

Is there anything that could be done to rectify this issue?

Thanks.

Re: tLogRow error - not displaying output due to some format ting issue

TRF — Wed, 19 Sep 2018 12:00:12 GMT

Share your component settings to complete your post

Re: tLogRow error - not displaying output due to some format ting issue

Anonymous — Wed, 19 Sep 2018 12:13:51 GMT

Edited original post to show component settings

topic tLogRow error - not displaying output due to some format ting issue in Talend Studio

tLogRow error - not displaying output due to some format ting issue

Re: tLogRow error - not displaying output due to some format ting issue

Re: tLogRow error - not displaying output due to some format ting issue