Cognos Event Agent Job on Hold or Doesn't work due to "LOCK" resource

Clean up the NC tables by performing the following steps:
1) Stop the Cognos services
2) Execute the following sql against the Notification store data
base:
ﾠ
TRUNCATE TABLE NC_TASK_ANCESTOR_STOREIDS;
TRUNCATE TABLE NC_TASK_HISTORY_DETAIL;
TRUNCATE TABLE NC_TASK_PROPERTY;
TRUNCATE TABLE NC_TASK_QUEUE;
TRUNCATE TABLE NC_TSE_STATE_MAP;
TRUNCATE TABLE NC_RESOURCE_LOCK;

3) Start Cognos services back up

Change CQM to JDBC data sources in Framework Manager model

1. Open CQM Framework Manager Project in Framework Manager.
2. Modify Data Source Connection properties as below:

    Change Interface variable OD to JDBC




   Select 'Project' and in property pane change "Query Mode" type to Dynamic mode

3. You will be prompted by a dialog; choose Yes;
By doing this, your query subjects will be pointing under the cover to the new DQ data source; Depending on the size of the model, it could take some time;

4) You can switch back from the DQM (JDBC) data source to the CQM one by following the above steps 1) 2) 3) and returning the Content Manager Data Source, Interface, and Query Modeproperties to their settings.