Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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?


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