Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 31 Jan 2013 @ 14:41:22 GMT


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


Subj:   Fastload Error : NO RECORD OF THE LAST REQUEST WAS FOUND
 
From:   Bakthavachalam, Roopalini

Hi Forum,

One of the developers is running a Fastload job and he is getting the below error. Now, the error clearly mentions that there was a restart, however , I am not seeing anything related to a system getting restarted in my /var/log/messages. Could anyone please clarify?

Also , I believe the fastload sessions need to be killed as it has just "paused". Could anyone let me know the steps to kill the backend fastload job?

     **** 17:01:56 RDBMS error 2825: NO RECORD OF THE LAST REQUEST WAS FOUND
                   AFTER DBC RESTART

     **** 17:02:50 RDBMS error 2738: Employee_table already has Fastload
                   running

Below is part of log

     **** 17:01:56 RDBMS error 2825: NO RECORD OF THE LAST REQUEST WAS FOUND
                   AFTER DBC RESTART
     **** 17:01:56 FastLoad will attempt to retry this request 5 time(s)
     **** 17:02:01 Teradata Database Release: 13.10.05.08
     **** 17:02:01 Teradata Database Version: 13.10.05.08
     **** 17:02:01 Current CLI or RDBMS allows maximum row size: 64K
     **** 17:02:01 Character set for this job: ASCII
     **** 17:02:05 Number of FastLoad sessions requested = 22
     **** 17:02:05 Number of FastLoad sessions connected = 22
     **** 17:02:05 FDL4808 LOGON successful
     **** 17:02:06 The last checkpoint was taken at row: 0
     **** 17:02:06 FastLoad will now restart at row:     1
     **** 17:02:11 Starting row 100000
     **** 17:02:18 Starting row 200000
     **** 17:02:24 Starting row 300000
     **** 17:02:32 Starting row 400000
     **** 17:02:38 RDBMS error 2825: NO RECORD OF THE LAST REQUEST WAS FOUND
                   AFTER DBC RESTART
     **** 17:02:38 FastLoad will attempt to retry this request 4 time(s)
     **** 17:02:44 Teradata Database Release: 13.10.05.08
     **** 17:02:44 Teradata Database Version: 13.10.05.08
     **** 17:02:44 Current CLI or RDBMS allows maximum row size: 64K
     **** 17:02:44 Character set for this job: ASCII
     **** 17:02:50 Number of FastLoad sessions requested = 22
     **** 17:02:50 Number of FastLoad sessions connected = 22
     **** 17:02:50 FDL4808 LOGON successful
     **** 17:02:50 RDBMS error 2738: Employee_Table already has Fastload
                   running
          -------------------------------------------------------------------
          -                                                                 -
          -          Logoff/Disconnect                                      -
          -                                                                 -
          -------------------------------------------------------------------

     **** 17:02:50 Logging off all sessions
     **** 17:03:19 Total processor time used = '17.0821 Seconds'
          .        Start : Wed Jan 30 16:57:23 2013
          .        End   : Wed Jan 30 17:03:19 2013
          .        Highest return code encountered = '12'.
     **** 17:03:19 FastLoad Paused

Thanks

Roopalini



     
  <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: 27 Dec 2016