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.
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.
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.
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.
The original error about the filename being too long or invalid is very misleading, there is no hint of a permissions.