191 views

DatabaseDataMonitor failed after 9.20 Upgrade with DB Oracle 10.2.0.4

Jump to solution

Hello Fellows,

I have upgraded NA from 7.60 to 9.20, OS is RHEL and DB is Oracle 10.2.0.4, but the DatabaseDataMonitor is failing.

Error from jboss_wrapper.log -> Could not find a reporting task.Could not find a pruner task.

Seems there is not a task attached to monitor an Oracle?

I will appreciate any help,

Best regards,

Ivonne

 

0 Likes
1 Solution

Accepted Solutions
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Hi,

 

The monitor is not failing. The message is a warning related to missing scheduled tasks:

- prunner task

- summary report task.

 

Please schedule them accordingly (prunner should be scheduled outside bushiness hours)

Prunner : NA > Tasks > New Tasks  > Data Prunner (i recommend 2 times per week for now)

Reports:  NA > Tasks > New Tasks  > Generate Summary Reports  (once per day)

 

Then rerun the monitor.

 

Regards,

Marius

Marius Herculea
HP SW Technical Consultant

Cloud and Automation Professional Services

View solution in original post

0 Likes
5 Replies
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Hi,

 

The monitor is not failing. The message is a warning related to missing scheduled tasks:

- prunner task

- summary report task.

 

Please schedule them accordingly (prunner should be scheduled outside bushiness hours)

Prunner : NA > Tasks > New Tasks  > Data Prunner (i recommend 2 times per week for now)

Reports:  NA > Tasks > New Tasks  > Generate Summary Reports  (once per day)

 

Then rerun the monitor.

 

Regards,

Marius

Marius Herculea
HP SW Technical Consultant

Cloud and Automation Professional Services

View solution in original post

0 Likes

Thanks Marius!

I will check that with customer and let you know if it works.

Best regards,

Ivonne

0 Likes
Cadet 1st Class Cadet 1st Class
Cadet 1st Class

Hello Marius, 

 

Thanks for this great response, 

 

Is there a negative impact if I do not have this task on HPNA system?

 

thanks 

 

mark 

0 Likes
Micro Focus Expert
Micro Focus Expert

Hi Mark,

 

Please note that if you do not periodically run the Data Prunner, your DB size will increase in time, and NA will encounter performance issues. 

 

Also regarding Generate Summary Reports, this is not mandatory, is just for reporting feature/audit.

 

Best reagards,

Paul 

0 Likes
Absent Member.. Absent Member..
Absent Member..

Hello Ivonne Nirich,

 

You may also want to keep in mind that the Oracle DBA will need to remove Large Object (LOB) data.


There exists a  Knowledge Document (KM907104) which will be helpful for assisting the DBA.

 

This should become part of the Database Administrator's (DBA's) regular DB maintenance tasks.

 

Thank you for your time and attention.

 

Have an Insouciant Day!

 

--SCRTSRCS

Stuart Sanders

Online Outreach Resource

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.