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

[Anonymous]

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.

[TRF]

Share your component settings to complete your post

[Anonymous]

Edited original post to show component settings