I am getting following error while doing TPT extract.
EXPORT_OPERATOR: connecting sessions
EXPORT_OPERATOR: TPT10508: RDBMS error 5407: Invalid operation for DateTime or Interval.
EXPORT_OPERATOR: disconnecting sessions
Problem is only when I export the SQL in the SelectStmt, only for timestamp columns, it is giving this error.
Has anyone faced the same issue and let me know the resolution for the same?
Not much information to work with here.
Version of TPT?
Version of Teradata?
Copy of the SELECT statement?
DDL of the source table?
This was due to the mismatch in the schema and it was bug in the code.
I fixed it and it worked fine.