All Forums Tools
balaji.bgdev 11 posts Joined 05/14
05 Aug 2014
TPT extract failing - TPT10508: RDBMS error 5407: Invalid operation for DateTime or Interval

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?

feinholz 1234 posts Joined 05/08
05 Aug 2014

Not much information to work with here.
Version of TPT?
Version of Teradata?
Copy of the SELECT statement?
DDL of the source table?
 

--SteveF

balaji.bgdev 11 posts Joined 05/14
27 Aug 2014

This was due to the mismatch in the schema and it was bug in the code.
I fixed it and it worked fine.

You must sign in to leave a comment.