Archives of the TeradataForum

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

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

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>>