Question & Answer
Question
How to use NC_DROP script in Cognos Analytics 11 to correct issues with execution of scheduled reports.
Answer
Dropping the NC* tables removes records from the Cognos Analytics notification database tables so they can be reloaded with report schedules when Cognos Analytics is restarted.
Steps:
1. Stop the Cognos Analytics service
2. Perform a Content Store deployment backup and a physical backup of the Content Store or Notification database
3. Select the NC_DROP script for your content store database type from directories in <cognos analytics>/configuration/schemas/delivery/<dbtype>/
4. Connect to content store database using a database tool and with the same login as provided for content store in Cognos Configuration and run NC_DROP_<dbtype>.sql.
4. Restart the Cognos Analytics service.
Should dropping the NC* tables not resolve the issue, then restore the content or notification store from the last backup version.
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
26 April 2023
UID
swg22001203