Project number on the backup does not match the project number created for project restoration

Problem:Solution

This is what to do to update the project number on the ES when the project number on the backup does not match the project number created for project restoration:

Open an hpterm window

> su - cape

> sqlplus admin/admin

SQL> select * from projects;

SQL> desc projects

SQL> update projects set pro_no=# (* # is what you want it to be *)

J where pro_shortname='project_name'; (* project being changed *)

I row updated.

SQL> commit;

Commit complete.

SQL> select * from users;

SQL> desc users

SQL> update users set pro_no=# (* # is what you want it to be *)

J where pro_no=#; (* # of the project being changed *)

I row updated.

SQL> commit;

Commit complete.

SQL>quit

You will be returned to the hp prompt

Change the link in /products/data/standard/FMS/WC00/50/DB## to point to the database that is being used.

ln -s /proj/project_name /products/data/standard/FMS/WC00/50/DB##

--------------------------------------

for Canandaigua and later:

You get constraint violations when you try to do the SQL*Plus updates of the PRO_NO field.

Procedure to disable the constraint:

ln -s /proj/project_name /home/opt/advant/FMS/WC00/50/DB##