TPT extract failing - TPT10508: RDBMS error 5407: Invalid operation for DateTime or Interval

Tools
Enthusiast

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?

2 REPLIES
Teradata Employee

Re: TPT extract failing - TPT10508: RDBMS error 5407: Invalid operation for DateTime or Interval

Not much information to work with here.

Version of TPT?

Version of Teradata?

Copy of the SELECT statement?

DDL of the source table?

-- SteveF
Enthusiast

Re: TPT extract failing - TPT10508: RDBMS error 5407: Invalid operation for DateTime or Interval

This was due to the mismatch in the schema and it was bug in the code.

I fixed it and it worked fine.