To perform the upgrade of Cognos Reports from version 12.1.0.0 to version 12.1.0.1,
complete the following steps.
Before you begin
Deliver reports must work on version 12.1.0 base
environment. You must take a backup of all Cognos reports and DeliverModel folder from
Cognos_Home\deployment. You must take Campaign and Platform
database backup as well.
Procedure
-
Copy and replace model folder from
Unica_home\ReportsPackCampaign\cognos11\DeliverModel to
Cognos_Home\depoyment\ folder.
-
Copy and replace "Unica Reports for Deliver.zip" from
Unica_home\ReportsPackCampaign\cognos11\DeliverModel to
Cognos_Home\depoyment\ folder.
-
Run
Unica_home\ReportsPackCampaign\cognos11\Deliver-ddl\<DBType>\
acer_scripts_<DBType>.sql
and
<DBType>\upgrade\upgrade121to12101.sql
in Campaign
system database
-
Run
Unica_home\ReportsPackCampaign\schema\templates_sql_load.sql
in Platform database
-
Log in to the application and navigate to Configuration > Report SQL
Generator > Select Deliver Reports.
-
Select the database type and download Deliver.sql.
-
Run the Deliver.sql in Campaign database.
-
Configure database job for the following SMS procedures. For how to configure
jobs, see the For Unica Deliver only: How to schedule and run stored procedures
section.
- SP_POPULATE_SMS_CONTACTS
- SP_POPULATE_SMS_RESPONSES