If you have upgraded or migrated to SAS Strategy Management 5.3, you might encounter the following error when you click any Alert link in the SAS Information Delivery Portal.

If you encounter this problem, perform the following steps:

Note: Back up the SAS Strategy Management database before you perform the following steps.

1. Log on to the tier that is running MySQL.
2. Open a command window.
3. Change directories to the MySQL bin directory (this directory is typically c:\mysql\bin).
4. Open the alertdirective.zip file and extract the alertdirective.sql file to the MySQL bin directory.
5. Submit this code to start the MySQL command line:
   mysql -h{HOST} -u{USERID} -p{PASSWORD} < alertdirective.sql

   In this code:
   

   
       {HOST} = the host on which MySQL is running
       {USERID} = the user name used to administer MySQL (the default user ID is sqladmin)
       {PASSWORD} = the password associated with the preceding user ID

Operating System and Release Information