For eMessage, you must run specific scripts after you install or upgrade reporting templates. You must run the SQL scripts against the Campaign database.
The Campaign_reportspack_home\cognos10\emessage-ddl directory is located on the server that hosts the IBM®Cognos® Content Manager, and contains the following database scripts for Oracle, IBM®DB2®, and Microsoft™ SQL Server: