Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 17:21:03 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: BTEQ Export to Fastload in record mode is failing
 
From:   Donald Iuppa

Hi All,

I wrote a fastexport script to see if the problem was BTEQ related.

I am having the same problem with the fastload, so it must be something on the fastload side.

FASTLOAD ERROR:

     **** 13:05:38 Number of recs/msg: 355
     **** 13:05:38 Starting to send to RDBMS with record 1
     **** 13:05:38 Bad file or data definition.
     **** 13:05:38 The length of: LATA_OF_SWITCH_LOCATION in row: 1 was
                   greater than defined.
                   Defined: 5, Received: 13902

Same fastload script as before.

FASTEXPORT SCRIPT:

     cat <<-! >xxx.fastexport
             .LOGTABLE utillog ;
             .logon ${TenE_TER_MACHINE}/${TenE_MASTER_USER},${TenE_MASTER_PASSWORD};
             DATABASE ${TenE_LERG_DB};
             .BEGIN EXPORT
             SESSIONS 5;


             .EXPORT OUTFILE T_TEMPORAL_NPANXXX_LKUP.exp
             FORMAT FASTLOAD
             MODE RECORD;
             SELECT * FROM T_TEMPORAL_NPANXXX_LKUP sample 1000;
             .END EXPORT;
             .LOGOFF;
             .QUIT;
     !

     fexp &1 | tee $TenE_tmp/xxx.log

FAST EXPORT LOG:

     -------------------------------------------------------------------
     -                                                                 -
     -          FastExport Utility    Release FEXP.07.06.03.000        -
     -          Platform WIN32                                         -
     -                                                                 -
     -------------------------------------------------------------------
     -                                                                 -
     -     Copyright 1990-2003, NCR Corporation. ALL RIGHTS RESERVED.  -
     -                                                                 -
     -------------------------------------------------------------------
     **** 12:57:12 UTY2411 Processing start date: MON MAY 16, 2005

     -------------------------------------------------------------------
     -                                                                 -
     -          Logon/Connection                                       -
     -                                                                 -
     -------------------------------------------------------------------
     0001 .LOGTABLE utillog ;
     0002 .logon TENETEST/xxx,;
     **** 12:57:14 UTY8400 Default character set: ASCII
     **** 12:57:14 UTY8400 Maximum supported buffer size: 64K
     **** 12:57:15 UTY6211 A successful connect was made to the RDBMS.
     **** 12:57:15 UTY6217 Logtable 'EMMEDIATE.utillog' has been created.

     -------------------------------------------------------------------
     -                                                                 -
     -        Processing Control Statements                            -
     -                                                                 -
     -------------------------------------------------------------------
     0003 DATABASE LERG_2005_03;
     **** 12:57:15 UTY1016 'DATABASE' request successful.
     0004 .BEGIN EXPORT
          SESSIONS 5;


     0005 .EXPORT OUTFILE T_TEMPORAL_NPANXXX_LKUP.exp
          FORMAT FASTLOAD
          MODE RECORD;
     0006 SELECT * FROM T_TEMPORAL_NPANXXX_LKUP sample 1000;
     0007 .END EXPORT;

     -------------------------------------------------------------------
     -                                                                 -
     -          FastExport Initial Phase                               -
     -                                                                 -
     -------------------------------------------------------------------

     **** 12:57:15 UTY8700 Options in effect for this FastExport task:
          .       Sessions:    5 session(s).
          .                    Minimum of 1 export session(s) requested.
          .       Mode:        RECORD
          .       Blocksize:   64260 bytes.
          .       Outlimit:    No limit in effect.
     **** 12:57:15 UTY8715 FastExport is submitting the following request:
          Select NULL from EMMEDIATE.utillog where (LogType = 220) and (Seq 1) and
          (FExptSeq = 0);
     **** 12:57:16 UTY8705 EXPORT session(s) requested: 5.
     **** 12:57:16 UTY8706 EXPORT session(s) connected: 4.
     **** 12:57:16 UTY8715 FastExport is submitting the following request:
          BT;BEGIN FASTEXPORT;
     **** 12:57:16 UTY8715 FastExport is submitting the following request:
          SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER), MiscInt3 (INTEGER),FExptSeq
          (INTEGER), FExptCkpt (VARBYTE(1024)) from EMMEDIATE.utillog WHERE (LogType
          = 210) and (Seq = 1) and (FExptSeq IN (SELECT MAX(FExptSeq) from
          EMMEDIATE.utillog where (LogType = 210) and (Seq = 1)));
     **** 12:57:16 UTY8715 FastExport is submitting the following request:
          SELECT MiscInt1 (INTEGER), MiscInt2 (INTEGER), MiscInt3 (INTEGER), FExptSeq
          (INTEGER), FExptCkpt (VARBYTE(1024)) from EMMEDIATE.utillog WHERE (LogType
          = 212) and (Seq = 1) and (FExptSeq IN (SELECT MAX(FExptSeq) from
          EMMEDIATE.utillog where (LogType = 212) and (Seq = 1)));
     **** 12:57:16 UTY8715 FastExport is submitting the following request:
          SELECT * FROM T_TEMPORAL_NPANXXX_LKUP sample 1000;
     **** 12:57:16 UTY8724 Select request submitted to the RDBMS.
     **** 12:57:21 UTY8725 Select execution completed. 4 data blocks generated.
     **** 12:57:21 UTY8715 FastExport is submitting the following request:
          INS EMMEDIATE.utillog (LogType, Seq) VALUES (220, 1)
     **** 12:57:21 UTY8715 FastExport is submitting the following request:
          END FASTEXPORT;ET;
     **** 12:57:21 UTY8710 Processing complete for this FastExport task.

     -------------------------------------------------------------------
     -                                                                 -
     -          FastExport Task Complete                               -
     -                                                                 -
     -------------------------------------------------------------------
     **** 12:57:22 UTY1024 Session modal request, 'DATABASE', re-executed.
     **** 12:57:22 UTY8722 1000 total records written to output file.
     0008 .LOGOFF;

     -------------------------------------------------------------------
     -                                                                 -
     -          Logoff/Disconnect                                      -
     -                                                                 -
     -------------------------------------------------------------------
     **** 12:57:24 UTY6216 The restart log table has been dropped.
     **** 12:57:24 UTY6212 A successful disconnect was made from the RDBMS.
     **** 12:57:24 UTY2410 Total processor time used = '0.15625 Seconds'
          .       Start : 12:57:12 - MON MAY 16, 2005
          .       End   : 12:57:24 - MON MAY 16, 2005
          .       Highest return code encountered = '0'.

Don Iuppa
Engineering Development Director
10eSolutions LLC



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023