Fast Export issue (Kindly Help)

Tools
Enthusiast

Fast Export issue (Kindly Help)

Hi All Teradata gurus!!

Need help regarding FAST EXPORT utility failure.

Below are the log file contents:

0003 .LOGTABLE ;
**** 08:20:22 UTY8400 Teradata Database Release: V2R.06.02.02.66
**** 08:20:22 UTY8400 Teradata Database Version: 06.02.02.64
**** 08:20:22 UTY8400 Default character set: ASCII
**** 08:20:22 UTY8400 Current RDBMS has UDT support
**** 08:20:22 UTY8400 Current RDBMS has Large Decimal support
**** 08:20:22 UTY8400 Maximum supported buffer size: 1M
**** 08:20:22 UTY8400 Data Encryption supported by RDBMS server
**** 08:20:23 UTY6211 A successful connect was made to the RDBMS.
**** 08:20:23 UTY6210 Logtable ' ' indicates that a restart is in
progress.
0004 .BEGIN EXPORT
SESSIONS 8;
0005 .EXPORT Outfile
MODE RECORD
FORMAT TEXT
;

0006
;

0007 .END EXPORT ;
========================================================================
= =
= FastExport Initial Phase =
= =
========================================================================
**** 08:20:23 UTY8700 Options in effect for this FastExport task:
. Sessions: 8 session(s).
. Mode: RECORD
. Blocksize: 64260 bytes.
. Outlimit: No limit in effect.
**** 08:20:23 UTY8715 FastExport is submitting the following request:
Select NULL from where (LogType = 220) and (Seq =
1) and (FExptSeq = 0);
**** 08:20:23 UTY8713 RDBMS failure, 5628: Column FExptSeq not found in
.
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 08:20:23 UTY1005 Script file has been altered at line 1 prior to restart.
**** 08:20:23 UTY6215 The restart log table has NOT been dropped.
**** 08:20:23 UTY1009 RDBMS warning: 0,
**** 08:20:23 UTY1009 RDBMS warning: 0,
**** 08:20:23 UTY2410 Total processor time used = '0.036678 Seconds'
. Start : 08:20:22 - WED MAR 25, 2009
. End : 08:20:23 - WED MAR 25, 2009
. Highest return code encountered = '12'.
------------------------------------------------------------------------------------------
Above details show that the LOG TABLE has not been dropped. But the LOG TABLE doesn't exist in the database where it is supposed to be created. I am unable to trace out the issue. Kindly help!!

Thanks in advance,
Sanjay.
3 REPLIES
Junior Contributor

Re: Fast Export issue (Kindly Help)

A typical reason for that error is a left-over logtable from a MLoad/TPump job, which has different columns.

But in your log file there's no name for the logtable. This script should fail with a syntax error.

Dieter
Enthusiast

Re: Fast Export issue (Kindly Help)

Hi Dieter!

Thanks for your reply. And sorry for the delayed reply.

A re-execution of the the fast export script had solved the problem for me.

Thanks,
Sanjay!
Enthusiast

Re: Fast Export issue (Kindly Help)

Hi Team,

need help regarding teradata fast export. i am getting restart in progress please see bold letter in log file.

0003 .LOGTABLE ERROR_T.test;

0004 .DATEFORM ANSIDATE;

**** 11:38:17 UTY1200 DATEFORM has been set to ANSIDATE.

0005 .LOGON tdSIT/raj_123,;

**** 11:38:17 UTY8400 Teradata Database Release: 14.10.03.04

**** 11:38:17 UTY8400 Teradata Database Version: 14.10.03.04

**** 11:38:17 UTY8601 Character set specified: UTF8

**** 11:38:17 UTY8400 Current RDBMS has UDT support

**** 11:38:17 UTY8400 Current RDBMS has Large Decimal support

**** 11:38:17 UTY8400 Current RDBMS has FEXP w/o Spooling support

**** 11:38:17 UTY8400 Current RDBMS has TASM support

**** 11:38:17 UTY8400 Maximum supported buffer size: 1M

**** 11:38:17 UTY8400 Data Encryption supported by RDBMS server

**** 11:38:17 UTY6211 A successful connect was made to the RDBMS.

**** 11:38:17 UTY6210 Logtable 'ERROR_T.test' indicates that a

     restart is in progress
.

     ========================================================================

     =                                                                      =

     =          Processing Control Statements                               =

     =                                                                      =

     ========================================================================

0006 .BEGIN EXPORT

     TENACITY 4

     SESSIONS 4

     SLEEP 6;

0007 .EXPORT OUTFILE

     '/u03/informatica/current/server/infa_shared/TgtFiles/fxp/test.out' FORMAT FASTLOAD MODE INDICATOR;

0008 Select table_vw.CUSTOMER_ID,

     table_vw.AGE,

     table_vw.address,

      FROM schema.table_vw;

0009 .END EXPORT;

     ========================================================================

     =                                                                      =

     =          FastExport Initial Phase                                    =

     =                                                                      =

     ========================================================================

Thanks in advance

raj