Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 22 Jan 2007 @ 22:01:46 GMT


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


Subj:   Modify Profile and Error 7547
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, January 22, 2007 16:55 -->

When trying to increase the spool space of a profile, I got the following error for my statement

     MODIFY PROFILE xxxx AS SPOOL = 62.5E9;

     Failure 7547 Target row updated by multiple source rows.

It looks Teradata was confused by the internal update process related to the Modify Profile statement.

I made a workaround by the following steps

1. Modify users to change their existing profile to null, works

2. run above Modify Profile statement, it works

3. Modify users to link them to the updated profile, works


Apparently a DBA would not prefer this kind of practice.

I am in V2R6.0.2. Anybody knows whether it is fixed in V2R6.1 or somewhere?


Cheers



     
  <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