TPT export timeout issue

Tools & Utilities

TPT export timeout issue

A TPT extract that creates a very large extract (about 100GB uncompressed size) times out in approximately 1 hour after completing about 40% of the extract.  This has happened repeatedly with different number of instances and different buffer sizes.  This is the largest extract in our system.  We didn't have this issue with any other extracts.

The error is:

EXPORT_OPERATOR: sending SELECT request

EXPORT_OPERATOR: TPT10508: RDBMS error 2594: One of the FastExport session has been logged off

EXPORT_OPERATOR: TPT10508: RDBMS error 2594: One of the FastExport session has been logged off

EXPORT_OPERATOR: disconnecting sessions

Any idea how to fix this?  The database timeout is set to 20 minutes.  Even changing the database timeout to 60 minutes didn't solve the problem.

Any thoughts/suggestions?

Tags (1)
1 REPLY
Junior Contributor

Re: TPT export timeout issue

Hi Ravikumar,

there's no timeout on Teradata side, only for logons, otherwise it's always a restriction on client side.

But this might be due to a TASM rule automatically aborting prolonged idle sessions. 

You should check QueryLog what actaully happend and/or ask your DBA for help.