Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.