I am building out custom clean up actions for Datacap Maintenance Manager for Taskstats/Audit/Debug tables. I am trying to run them using the Datacap Maintenance Manager client, but upon every execution I see errors in the loading of Datacap.Libraries.Nenu.dll and our custom actions .dlls.

I just want to make sure that it is possible to execute other custom actions that were built out with Maintenance Manager. Since these actions are executed differently than the regular Datacap application's actions, I am not sure and I have not seen any documentation related to this. Thoughts on whether or not this is possible?

I have never use a custom action for Nenu. The out of the box Nenu action library is more than what I need. I don't see a reason why not. Test out the custom action in dstudio but find dStudtio is very forgiving. A real test would be with dcDesktop to see if the action will work. Essentially creating a nenu apps and run it for testing. Call your custom dll and test. Perhaps play with one batch to see if the custom nenu action works.

Nenu is to clean up the relational DB. Here is a link that impact Datacap performance as a hole if it's too big. If you can reduce these table, it will keep the DB nice a clean for optimization.

https://www.ibm.com/support/pages/db-tuning-recommendation-and-best-practice-datacap-enterprise-setup-0

Yes, we had been using the built in Maintenance actions for cleanup, but due to the volume of content we process, it is causing odd performance issues within our applications. We are trying to get it set up to run a nightly job with a custom retention on the table. Since built in audit and debug cleanup just wipe the whole table, there is no way to retain the content we want in the tables. We do have a workaround for the connection string encryption issues that many experience when trying to run custom queries on the DBs, but as far as executing the custom actions written in C#, I have not been able to get that working. I just wanted to know if anyone else had ever gotten those custom actions working in any way from a Maintenance Manager perspective. I don't want to waste a ton of time building out something that may not be possible.

Thanks

Can your DBA copy the audit and debug table out and then wipe?

To answer you question I have not done so not sure. Perhaps someone has done this before.

In our situation that isn't a viable option. These tables fill up too fast and we can't be having this handled manually on a daily basis. If we can get our custom actions working from a Maintenance Manager perspective, that will open a ton of doors for us as far a custom DB cleanup as well.