Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 23 Dec 2005 @ 12:15:50 GMT

  <Prev Next>  

Subj:   Internal Error when adding / dropping ranges from
From:   Anomy Anom

<-- Anonymously Posted: Thursday, December 22, 2005 16:32 -->


I am trying to add / drop partition using BTEQ / IMPORT-USING variable, Please see the SQL below

     .IMPORT REPORT FILE = .\daterange.txt ;          /*** Daterange.txt
     contains just one record [2005-12-012005-12-23]  ***/
     using (dropDate char(10), adddate char(10))
     alter table mytable modify primary index
     drop range between :DropDate and :DropDate each interval '1' day
     add  range between :AddDate  and :AddDate  each interval '1' day

      *** Growing buffer to 65473
      *** Failure 3610 Internal error: Please do not resubmit the last request.
                     Statement# 1, Info =173
      *** Total elapsed time was 12 seconds.
      *** Warning: Last request caused a problem on the DBC.
                   Do NOT resubmit the last request.

The same sql with the hard coded date values works fine in SQL Assistant...

Is this a known issue ? Does anyone have encountered this before and have any remedy (DR)?


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