Project number on the backup does not match the project number created for project restoration
- Changing Database Number
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##
Problems "Project number on the backup does not match the project number created for project restoration" resolves the following:
- Trouble updating the project number on the ES
- Article imported from the previous version of KnowledgeBank
Add new comment