Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 24 Apr 2007 @ 13:02:18 GMT


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


Subj:   Error Message " Internal error: Please do not
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, April 24, 2007 04:32 -->

Hi All,

We are using a third party tool (we do not have its source code) which uses JDBC connection to connect to Teradata.

For one of the errors, while checking the log files of this tool, we found that it was trying to execute the following query;

     UPDATE DTA_RUL_TMP
     SET
     CATEGORY = 'default' ,
     DESCRIPTION = 'set Name to rahul' ,
     RULE_NAME = 'Update Name' ,
     STATUS = 'ACTIVE' ,
     RULE_ID = '4' ,
     RULE_EXPR = '
                    
                    
                    
                    
                    ' ,
     STRT_DATE_RNG = NULL ,
     END_DATE_RANGE = NULL ,
     TOUCH_DATE = '2007-04-24 12:07:41' ,
     P_RULE_EXPR_1 = 'update IN_DIMENSION T1
                      set
                          T1.Name = (''john'')'
     WHERE (RULE_ID = '4' )

And Teradata responded with following error message;

Internal error: Please do not resubmit the last request. SubCode, CrashCode: P_RULE_EXPR_1


Whereas when we tried to execute the same update query through "SQL Assitant" it ran properly;

Any suggestions on what may be the possible reasons for getting this error "Internal error: Please do not resubmit the last request. SubCode, CrashCode: P_RULE_EXPR_1"



     
  <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