Topic:
Project Upgrade fails.  Error in updating project user CName

Description:
        The log file below is from the failed upgrade:

[15:56:43] DBI-I-Info                  Created 600 of 661 Synonyms
[15:56:44] DBI-I-Info                  Created 661 of 661 Synonyms
[15:56:44] DBI-I-Info                  Creating Sequences
[15:56:44] DBI-I-Info                  Granting privileges
[15:56:57] PROJ-E-ErrorInfo            Error: Error in updating project user
CName 
[15:56:57] PROJ-E-ErrorInfo            Error: Error in updating GF project 

The project was in an 'unusable state' according to the gf_accounts list.  This
was a seismic master and still seemed to share properly to its slave interp
project.

Solution:
PROBLEM:  The project fails to upgrade due to null cname entries in the
          'project_user' Oracle table.  The project will now be in an 'unusable
          state' according to the gf_accounts list.  To verify the blank cname
          use the following SQL statement in a GeoFrame3.7 Xterm window:

 sqlplus projectname/password
 SQL>column cname format a20
 SQL>column name format a40
 SQL>set linesize 120
 SQL>select CNAME, NAME from project_user;

 CNAME                NAME
 -------------------- ----------------------------------------
                      gqs    <= notice blank cname
 ReadOnly             ReadOnly
 Public               Public
 Default              Default


SOLUTION: Null out the cname using the following SQL statment then complete 
          the upgrage using the proj_upgrade command.

          From a GeoFrame3.7 Xterm type:

  sqlplus projectname/password

  SQL>  delete from project_user where cname is NULL;
  SQL>  exit


  Run the upgrade from the command line as follows:
 
  > proj_update project password GF3_7    Do NOT use the -resume option.


 



Last Modified on: 27-JUL-00