IBM Support

CNC-MON-0024 Monitor Service paging error: Invalid column name 'TENANT_ID'

Troubleshooting


Problem

This error is seen under Current Activities in Cognos Administration.

Symptom

CNC-MON-0024 Monitor Service paging error: Invalid column name 'TENANT_ID' seen inCognos Administration-> Status -> Current Activities

Cause

Corruption in the data present in NC tables.

Environment

Windows

Resolving The Problem

Dropping the NC tables that use the NC_DROP_<Database>.sql script resolves the issue.


Note: - If you have configured a notification database, then you must follow these steps in the notification database and not in the content store. So whatever steps are mentioned for content store needs to be done for Notification database

The following are the steps for dropping the NC tables:

1- Stop Cognos Service
2- Have the Database Administrator back up the Complete Cognos content store database.
3- Connect to content store database using a database tool and with the same login as provided for Content store in Cognos configuration run the NC_DROP script found in the appropriate location depending on the database on which your content store is:

<Install Location>\configuration\schemas\delivery\oracle\NC_DROP_ORA.sql
<Install Location>\configuration\schemas\delivery\db2\NC_DROP_DB2.sql
<Install Location>\configuration\schemas\delivery\sqlserver\NC_DROP_MS.sql

You should not receive any error message in the script that you execute.

4- Start the Cognos service from within Cognos Configuration.  This will recreate all the NC tables.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22000976