Hello,
We just inherited a customer from another VAR and of course, on day 1, we're running into an urgent issue.
They're running SQL Express, and their Forms database has reached the maximum size. After looking into it, it appears they have a ton of old instance data, as well as a Form that accepts a file upload, and those files are taking up almost 4 GB of space. I have made modifications in the Data Maintenance section of Forms Administration, as well as created a volume on the server for these uploads rather than storing them in the database (and pointed the Forms process to this volume rather than the database).
I tried changing the Clearing Time in Data Maintenance to the soonest 30 minute interval possible, but nothing happened when I hit that time - still the same number of old instances, database is still the same size. I'm basically looking for a way to manually kick off the deleting of old instances to get them back up and running. Any insight?
Question
Question
Forms file uploads and deleting past instance data
Answer
Hi Jacob,
Is there any error reported during data maintenance or volume migration?
If not, could you try shrink the database and restart SQL server according to 'Reducing overhead after migrating to volume storage' section?
Replies
If you set data maintenance to run in the admin section at a specific time, it should run at that time. Maybe give it a few minute buffer, but that would be the easiest way to trigger it.
That's what I thought, too, but nothing seemed to happen at that time, or a few minutes after. I'm currently sitting at 15 minutes after it was supposed to run (3:00 PM CDT), and nothing seems to have changed. I manually deleted a bunch of old instances for this form with the file upload but I still haven't seen the size of the Forms database go down.
Under Process Options for this same form, I can see that the "Total Storage Used" under the "File Storage Location" header has decreased from 3.6 GB to 2.1 GB. So that's an improvement, but it's not reflected in the size of the database, yet.
I'll get it changed to 3:30 PM CDT soon to give it another shot.
Ran a disk usage report by top tables and the cf_bp_attachment_data table is taking up the most space by far. The same form in question seems to be occupying every single row within that table. However, I've deleted every past instance of that form (since it just submits the files to Laserfiche), as well as configured the attachments to go to the volume location instead.
Data maintenance has ran (I found the relevant events in Event Viewer) but this table is still full of these attachments. Can I safely delete these rows?