Release Notes › Upgrade Considerations › Run the SQL Upgrade Script

Run the SQL Upgrade Script

After the upgrade, the first time you start the CA IdentityMinder server, a script executes. It updates the Task Persistence table runtimeStatusDetail12 Description column size to 2000 characters.

If the script fails to run, follow these steps:

1. Do one of the following:
   • Microsoft SQL Server: Open the Query Analyzer tool and select the script you need.
   • Oracle: Open the SQL prompt for the script you need.
2. Select one of the following scripts:
   • Microsoft SQL Server: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db\taskpersistence\sqlserver\archive_db_sqlserver_upgrade_to126sp2.sql
   • Oracle on Windows: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db\taskpersistence\oracle9i\archive_db_oracle_upgrade_to126sp2.sql
   • Oracle on UNIX: /opt/CA/IdentityManager/IAM_Suite/Identity_Manager/tools/db/taskpersistence/oracle9i/archive_db_derby_upgrade_to126sp2.sql
3. Run the script file.
4. Verify that no errors appeared when you ran the script.