Novell Home

My Favorites

Close

Please to see your favorites.

How to stop stuck running reports in IDM Reporting

This document (7012333) is provided subject to the disclaimer at the end of this document.

Environment

NetIQ Identity Manager Roles Based Provisioning Module 4.0.x
NetIQ Identity Manager 4.0.x

Situation

In rare situations an report can end up in the situation where it does not finish, and will it consume all CPU resources on the server.

Restarting the the Server, Application Server, or the EAS will not resolve the issue.

Resolution

It is possible to stop an stuck running report manually:

1) Make a backup of reporting database.

2) Stop the Application Server that Reporting is deployed on

3) Connect to the PostgreSQL database within EAS as the dbauser

4) Go to Databases -> SIEM (database) -> Schemas -> idm_rpt_cfg -> Tables -> idmrpt_schedule

5) Return all rows

6) Find the row for the Report that they want to terminate
=> The display_name column may help

7) Copy the schedule_id value

8) Query the idmrpt_sched_dates table to make sure this same ID is not there.  If it is, it must be deleted from this table

DELETE FROM idm_rpt_cfg.idmrpt_sched_dates
WHERE schedule_id='%The-ID-Value%';

Example:
DELETE FROM idm_rpt_cfg.idmrpt_sched_dates
WHERE schedule_id='bbbc9825-e1e3-443f-a208-0d31b5db18d5';


9) Query the idmrpt_sched_parms table to make sure this same ID is not there.  If it is, it must be deleted from the table

DELETE FROM idm_rpt_cfg.idmrpt_rpt_sched_params
WHERE  schedule_id='%The-ID-Value%';

Example:
DELETE FROM idm_rpt_cfg.idmrpt_rpt_sched_params
WHERE  schedule_id='bbbc9825-e1e3-443f-a208-0d31b5db18d5';


10) Then delete the ID from the idmrpt_schedule Table

DELETE FROM idm_rpt_cfg.idmrpt_schedule
WHERE schedule_id='%The-ID-Value%';

Example:
DELETE FROM idm_rpt_cfg.idmrpt_schedule
WHERE schedule_id='bbbc9825-e1e3-443f-a208-0d31b5db18d5';


11) Restart the Application Server that the Reporting Module is deployed on

12) Login to Reporting and verify

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7012333
  • Creation Date:26-APR-13
  • Modified Date:17-SEP-13
    • NetIQIdentity Manager
      Identity Manager Roles Based Provisioning Module

Did this document solve your problem? Provide Feedback