Archives of the TeradataForum

Message Posted: Sat, 09 Oct 2010 @ 09:03:19 GMT

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

Hi,

I am trying to load a binary file using fast load. But no data is getting inserted into the table.

Below is a snap shot of the log.

     0006 set record binary;
     **** 14:05:50 Now set to read 'BINARY' records
     **** 14:05:50 Command completed successfully
     0007 define file=/export/home/shvenugopal/sess_end_files/00.1285809680.sess;
     **** 14:05:50 FDL4803 DEFINE statement processed
     0008 begin loading ubi_w.ubi_session_end_ld_test
          errorfiles ubi_w.ET_ubi_session_end_ld_test,ubi_w.UV_ubi_session_end_ld_test
          indicators checkpoint 0;
     **** 14:05:50 Indicator mode is set to ON
     **** 14:05:51 Number of AMPs available: 144
     **** 14:05:51 BEGIN LOADING COMPLETE

          -------------------------------------------------------------------
          =                                                                 =
          =          Insert Phase                                           =
          =                                                                 =
          -------------------------------------------------------------------
     0009 insert into ubi_w.ubi_session_end_ld_test.*;
     **** 14:05:52 Number of recs/msg: 1212
     **** 14:05:52 Starting to send to RDBMS with record 1
     **** 14:05:52 Finished sending rows to the RDBMS

          -------------------------------------------------------------------
          =                                                                 =
          =          End Loading Phase                                      =
          =                                                                 =
          -------------------------------------------------------------------
     0010 end loading

          logoff;
     **** 14:05:52 END LOADING COMPLETE
          Total Records Read              =  0
          Total Error Table 1             =  0  ---- Table has been dropped
          Total Error Table 2             =  0  ---- Table has been dropped
          Total Inserts Applied           =  0
          Total Duplicate Rows            =  0
          Start:   Fri Oct  8 14:05:52 2010
          End  :   Fri Oct  8 14:05:52 2010
     **** 14:05:53 Warning: Extra text after command found.
                   The text 'logoff;' not processed.

     **** 14:05:53 Warning: EOF on INPUT stream.
          -------------------------------------------------------------------
          =                                                                 =
          =          Logoff/Disconnect                                      =
          =                                                                 =
          -------------------------------------------------------------------
     **** 14:05:53 Logging off all sessions
     **** 14:05:55 Total processor time used = '0.12 Seconds'
          .        Start : Fri Oct  8 14:05:47 2010
          .        End   : Fri Oct  8 14:05:55 2010
          .        Highest return code encountered = '4'.
     **** 14:05:55 FDL4818 FastLoad Terminated

Could you please tell me the possible reasons on why the data is not getting loaded.

Thanks,

Shankar

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