All Forums Teradata Applications
ulrich 816 posts Joined 09/09
07 Feb 2014
TPT export and error code 2595

Hi,
we are getting with an TPT export the error code 2595.
Explanation:
2595 The FastExport select request has been aborted.
Explanation: The current Select request has been aborted.
Generated By: LCTExpSt
For Whom: End user
Remedy: Examine the reason of the abort, do whatever necessary to correct the problem and then resubmit the Select
request.
So far we had not been able to find out the reason.
The export is a plain table export and the SQL against this table is working fine.
Did anybody had seen this error before?
Any idea where to look for?
Ulrich

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud
ulrich 816 posts Joined 09/09
07 Feb 2014

P.S. the error does not occur at TPT startup. There is already some GB of data retrieved...

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

abhijitvyas 51 posts Joined 08/06
14 Feb 2014

Hi Ulrich
were you able to identidy the fix for this ?
Appreciated
 
Thanks
Abhijit
 
 

abhijitvyas 51 posts Joined 08/06
16 Feb 2014

We have also seen similar issue with TPT Export running through JDBC via windows host.What is also strange that the error does not come up at a certain file size. It varies from some 10 to 40 GigaBytes on the drive. (There is also an “order by” in the view, to make sure records always come in a same order). this is around 100 Million export however user were able to extract 1.5 Billion Row on some other table on same database. This is on 14.00.03 (SLS11) 

tomnolan 594 posts Joined 01/08
17 Feb 2014

abhijitvyas, TPT Export doesn't use the Teradata JDBC Driver. I'm not sure what you meant here. Did you mean you're using ODBC with TPT? Or did you mean you are using the Teradata JDBC Driver's JDBC FastExport feature?

abhijitvyas 51 posts Joined 08/06
17 Feb 2014

Sorry if that confuses you but this is typical TPT script running from custom java wrapper on windows server 2008. 

tomnolan 594 posts Joined 01/08
18 Feb 2014

OK, abhijitvyas, then you're not using JDBC at all.

abhijitvyas 51 posts Joined 08/06
18 Feb 2014

Yes that's right. Now that's clarified that there is no JDBC involvement can you kindly share any inputs on how this can be addressed ?
 
Thanks
Abhijit

DiEgoR 33 posts Joined 08/06
19 May 2015

It would be appreciated if somebody could give us a hint as to where to start debugging when getting the 2595 error. It is three years already since we saw this problem and it keeps coming up for big tables.

input output putput

Fred 1096 posts Joined 08/04
20 May 2015

Check DBC.Software_Event_LogV for any messages around the time of the error, which may indicate the reason for abort.

You must sign in to leave a comment.