I’m of the belief that the more information on errors I can put out there, the better we are all off. There is nothing more frustrating than searching for the solution for an error on the Internet and not getting any usable results. I recently configured Metalogix StoragePoint in an environment and after configuring it with the UNC paths of my file shares, I received the following error when trying to upload a file.
The URL 'filename’ is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.
I suspected this was a permissions issue so I went to my ULS logs to find the issue. I had to check both WFEs to find the errors. I soon saw errors like the one below.
Error encountered in EndPoint.ProviderStoreBinary.BlobSave(Adapter), Folder: FileName:. Error is Access to the path '\\fileserver\RBSCache\2011\04\14' is denied.
This confirmed my suspicion so I corrected the permissions issue on the file share. I tried to upload a file again and I still got the same URL is invalid error as before. After check the logs again, I found a new error.
Error encountered in Profile.ProviderStoreBinary.General. Error is The INSERT permission was denied on the object 'MigrateQueue', database 'StoragePoint', schema 'dbo'.
I knew this meant that my application pool account was lacking permissions in the StoragePoint database. I checked another server to see what permissions were assigned to the account. It turned out to be db_datareader and db_datawriter. When I went back to the server in question, I noticed that the db_datawriter role was missing. I granted the access and tried the upload again. Everything now worked smoothly and I could upload and view files as desired.