What is set in the parameters?
Depot => BMC Maintenance => BSA Recommended Database Cleanup Script.
Right-click => Open
Specifically interested to know about
It seems that you have to check the script parameters.
Please have a look on https://docs.bmc.com/docs/display/public/bsa82/Changing%20Database%20Cleanup%20script%20options%20and%20commands and assign proper parameters.
The Duration seems to be configured improperly.
DurationDistribution is empty, doesn't that mean it is using the recommended defaults?
The NSH script contains DURATION_DIST=DEFAULT
Was this working prior to 8.3.03?
If you get that error with all parameters set to default, please log a support issue for more detailed analysis.
This is a clean install of 8.3.03
Also check the Job:
Jobs => BMC Maintenance => BSA Recommended Database Cleanup Job.
Right-click => Open
Is that all defaults too?
If so, then I think the support issue will be best. Send the screen shots of the script and job parameters, the Job Run Log and the Application Server log for the time period when the Job was executed
Rajesh is helping me via WebEx at the moment, a workaround is to change
DURATION_DIST="JobRunEvent=8 AuditTrail=8 cleanupDatabase=50 hardDeleteAllSharedObjects=17 cleanupFileServer=17"
in the NSH script
the 8.3.03 version of the script should have parameter flags, which i don't see there. can you attach the nsh script that this job points to ?
I am about to upgrade this server, I'll report back if I have any issues after upgrading it
I might also try a new clean install as this is a test/evaluation application server
Hello, this appears to be fixed in 8.5
1 of 1 people found this helpful
After much pain and gnashing of teeth, we binned the supplied script and went back to the individual commands that are defined elsewhere in the docs. It still doesn't work 100%, but we do occasionally manage to run an automated cleanup (with some manual intervention!). This was definitely fixed in 8.3 SP2, and we certainly saw an improvement, and have been promised that it will be better in SP3. If you have any scheduled downtime on a regular basis, you can also look at the offline cleanup, as this seemed to work reasonably well.
Thank you John, I can confirm that the script in 8.5 works, however if I run into any issues I will (as advised) create my own