10-18-2016 02:06 PM
We have a number of tables in our database that have had significant growth. Some to the point that they are effecting the Database teams ability to run the sampling process. Below are some tables in question. Can anyone share how they are handling archiving? We do not want to purge this data without archiving to another location outside of the production database first.
wftransactionlog
wftransactionmsg
transactionxlog
itemdatapage
itemdata
dfcytxlog
wflog
keyitem584
keyitem299
keyitem306
keyitem301
keyitem300
keyitem305
keyxitem125
chartxitemdata
securitylog
keyitem588
keyitem583
keyitem585
10-18-2016 02:28 PM
Hi Robert,
I would recommend reaching out to your First Line of Support for assistance with this question.
Purging data directly from the OnBase database is not permitted under the maintenance agreement and would be significantly detrimental given some of the tables you have listed.
Your First Line of Support can also assist with recommendations on maintenance jobs on these larger tables to allow your maintenance plans to complete.
Ansley
10-25-2016 09:53 AM
10-19-2016 01:28 PM
I agree with the posts above about checking the various reference guides as a starting point. The only thing that I would add is there are built-in mechanisms through the Thick Client for purging the various log tables (Transaction, Workflow, Security, Scanning, etc.). A lot of times this is an easy place to start before looking at your document retention process. These are covered in the System Admin and Workflow MRGs and you can get pretty granular as far as purging by date range, specific actions or workflows, etc. For instance you might decide that you just want to get rid of Platter Management errors older than X number of years. I'd always recommend running through the Thick Client purge processes in Staging first before trying in production.
I hope this helps.
Nick McElheny
10-21-2016 08:46 AM
10-21-2016 09:50 AM
10-24-2016 11:20 AM
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.