If you get an error in the log that looks like this:
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: Invalid format specification: ‘%hs does not exist.)’ while attempting ‘NtCreateFile’ on ‘D:\SQLRBSWSS_Content13bc3f57-1564-4b1d-98db-dc6008bd7d2366c4d9d9-94d2-4e91-9495-4ac5d4898801000031a-000018f4-0012
Check to make sure the destination folders exist. Mine did not.
My RBS works fine for my root site collection, but I got errors when uploading larger files within a non-root site collection.
I’m suspecting that the RBS Provider (or whatever actually creates the folder structure) didn’t create the necessary subfolders when I created the non-root site collections.
Once I manually created the folders, I was able to upload larger files with no issues.

2 Replies to “SQL RBS Error”

  1. Hi Chris, have you found the root cause for your environment?

    We’re experiencing it in our environment as well. Manually creating the folders solves the upload issue for us also but it impacts the existing files because it cannot be loaded anymore. Apart from that, we cannot just continue to manually create folders each time this occurs.

    1. We never did. I always suspected it was a file-system permission issue, but we never tracked it down.

Leave a Reply