Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Anonymous_User Absent Member.
Absent Member.
110 views

Stopping a report

Hello,

I have managed to kick off a couple of reports that have been processing a
very very long time, 7 hours or so.

I wonder, is there any way to stop a report while it is being generated?

-Nicolai
Labels (1)
0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: Stopping a report

On 08/02/2012 07:47 PM, Nicolai Jensen wrote:
> Hello,
>
> I have managed to kick off a couple of reports that have been processing a
> very very long time, 7 hours or so.
>
> I wonder, is there any way to stop a report while it is being generated?
>
> -Nicolai
>

Greetings Nicolai,


1) Stop the Application Server that Reporting is deployed on

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

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

4) Return all rows

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

6) Copy the schedule_id value

7) Query the idmrpt_sched_dates table to make sure this same ID is not
there. If it is you must delete it 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';

😎 Query the idmrpt_sched_parms table to make sure this same ID is not
there. If it is, you must delete it from the is 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';

9) 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';

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

10) Login to Reporting and verify




--
Sincerely,
Steven Williams
Lead Software Engineer
NetIQ
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Stopping a report

On Fri, 03 Aug 2012 09:18:11 +0000, Steven Williams wrote:

> On 08/02/2012 07:47 PM, Nicolai Jensen wrote:
>> Hello,
>>
>> I have managed to kick off a couple of reports that have been
>> processing a very very long time, 7 hours or so.
>>
>> I wonder, is there any way to stop a report while it is being
>> generated?
>>
>> -Nicolai
>>

> Greetings Nicolai,
>
>
> 1) Stop the Application Server that Reporting is deployed on


Hello Steven,

Thank you very much.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.