HP SIM 7.5 - "View All Scheduled Tasks" & "View All Task Results" pages

[sknickhp]

Just wondering if anyone has seen this issue before & if you were able to work around it.  Thanks!

[ARK123 · Accepted solution]

It could be because too much of hpmxAutomationTaskResults getting filled up in the database.

Use mxconfigrepo -c and check the number.

you can run the below sql query against the DB instance to clear it up.

delete from hpmxAutomationTaskResults

before performing anything on DB, take backup.

[Andrew_Haak]

Can you still see the Customize link in the right corner when loading this page ? You can change the Number of results and/or number of days. Or in the globalsettings.props the the following :

MX_JOB_MAX_COMPLETED_JOB_AGE=30
MX_JOB_MAX_COMPLETED_JOBS_PER_TASK=10

In my case i changed it to 30 days and 10 results.

[sknickhp]

Looks like that variable only has 500+ entries.   There are some others with 10s of thousands though...should I try cleaning those up from the database?

19 Jun 2018 08:49:29,866 INFO [HPSIM_DEBUG] Checking for possible database corruption...
19 Jun 2018 08:49:30,007 INFO [HPSIM_DEBUG] Number of records in table 'devices': 2230
19 Jun 2018 08:49:30,007 INFO [HPSIM_DEBUG] Number of records in table 'notices': 1769
19 Jun 2018 08:49:30,022 INFO [HPSIM_DEBUG] Number of records in table 'tasks': 23
19 Jun 2018 08:49:30,038 INFO [HPSIM_DEBUG] Number of records in table 'hpmxJob': 99863
19 Jun 2018 08:49:30,038 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAutomationTaskResults': 518
19 Jun 2018 08:49:30,038 INFO [HPSIM_DEBUG] Number of records in table 'hpmxQuery': 100
19 Jun 2018 08:49:30,038 INFO [HPSIM_DEBUG] Number of records in table 'collections': 44
19 Jun 2018 08:49:30,038 INFO [HPSIM_DEBUG] Number of records in table 'hpmxUser': 15
19 Jun 2018 08:49:30,038 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAuthorization': 56
19 Jun 2018 08:49:30,038 INFO [HPSIM_DEBUG] Number of records in table 'consolidatedNodeAuths': 33450
19 Jun 2018 08:49:31,005 INFO [HPSIM_DEBUG] Completed database checking with no errors.
Completed repository corruption checking.

EDIT:  I ran 'delete from table' queries for these 2 against the database & restarted SIM, and that fixed it.  Thanks.

19 Jun 2018 08:49:30,038 INFO [HPSIM_DEBUG] Number of records in table 'hpmxJob': 99863
19 Jun 2018 08:49:30,038 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAutomationTaskResults': 518

delete from hpmxJob

delete from hpmxAutomationTaskResults

*Note the hpmx variable name is case sensitive & must match for the query to run & work.  Otherwise the debugger sits there & does nothing.

[sknickhp]

Unfortunately no, no part of the frame loads at all

[Andrew_Haak]

then change the setting in the config file i mentioned and restart SIM. That should help.