You are viewing limited content. For full access, please sign in.

Question

Question

cf_bp_attachment_data table size

Forms Mobile
Updated September 13, 2017
asked on September 12, 2017

My customer uploads a ton of pictures with each form they submit using the mobile app. They want to keep the instance data for reporting purposes but can we delete the entries in the cf_bp_attachment_data table to clear up all that space? Will that cause issues? How can I go about this in a safe manner? I did see a post where there was a script to delete based on instance id but I'd rather just wipe that table if possible. 

0 0

Replies

replied on September 12, 2017

Hi Alex,

I tried deleting the entire entries: the instance page load would fail because it could not find related file entries.

So if you don't need the file content but need to keep instances, the entries need to be kept while the [attachment] column could be cleared. Run SQL query like this:

update [cf_bp_attachment_data] set attachment = CAST('' AS varbinary)

The effect of this change is that, if you try to download the uploaded files, the downloaded file size is 0.

replied on September 13, 2017

Rui Deng, Thanks for the help that script worked to clear out the space from the table. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...