Category Archives: Big FIles

How to Handle big files in SharePoint 2010 and 2013

SharePoint 2010 and 2013 is having software boundary that we can’t upload file bigger than 2 GB, so what if we have bigger files?

To handle large files that are bigger than 2 GB there are few options you have:

  1. Use software to split files and then upload them and when you download them you will use the software to merge them again, there are available software to do the following
  2. Use File Share servers and from SharePoint create view to point to those file share servers.
  3. Upload files to cloud and inside SharePoint just add links to refer to those sites.
Advertisements
filename invalid or too long 1920x1080

filename invalid or too long SharePoint

Advertisements
Advertisements

The filename invalid or too long. Specify a different filename

"The filename invalid or too long Specify a different filename" error while opening document library in windows explorer mode.

File name invalid or too long

File name invalid or too long

For testing  I tried to upload a single file using browser but its generated error as below:

Sorry, something went wrong.The URL ‘Shared documents/Project budget.xlsx’ is invalid.

File name invalid or too long

File name invalid or too long

Actually filename is not very long at all, including the full path. I looked into the ULS logs (for the time i tried to upload file) and found log as as below:

Exception thrown storing stream in new SqlRemoteBlob: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> Microsoft.Data.SqlRemoteBlobs.BlobStoreException: There was a generic database error. For more information, see the included exception. —> System.Data.SqlClient.SqlException: RBS Error. Original Error: Number 297, Severity 16, State 1, Procedure rbs_fs_sp_check_pool_size, Line 31, Message: The user does not have permission to perform this action.  Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

I have RBS (Remote Blob Storage) enabled for this content database so it appears that, this has got messed up somehow.  After reading various other blog posts and TechNet articles I began some trial and error with the database permissions.

Solution :

So as to resolve this issue we need to grant the service account used by the application pool "db_owner" rights on the content database, in addition to the "db_rbs_* " permissions.

File name invalid or too long

File name invalid or too long

The original error about the filename being too long or invalid is very misleading, there is no hint of a permissions.

Advertisements
Advertisements