Report Builder fails to open outside the server

%3CLINGO-SUB%20id%3D%22lingo-sub-2027466%22%20slang%3D%22en-US%22%3EReport%20Builder%20fails%20to%20open%20outside%20the%20server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2027466%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20running%20SSRS%20with%20Project%20Server%202016.%20Here's%20the%20situation%3A%3C%2FP%3E%3CP%3EI%20can%20execute%20Report%20Builder%20from%20inside%20the%20server%20and%20edit%20the%20reports%20successfully%2C%20but%20when%20try%20to%20open%20the%20report%20builder%20from%20my%20PC%20(I%20am%20in%20the%20admin%20group%20of%20the%20project%20server)%2C%20I%20am%20facing%20below%20error%20logged%20in%20logs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESystem.Runtime.InteropServices.COMException%3A%20The%20file%20you%20are%20attempting%20to%20save%20or%20retrieve%20has%20been%20blocked%20from%20this%20Web%20site%20by%20the%20server%20administrators.%3CBR%20%2F%3Eat%20Microsoft.SharePoint.Library.SPRequestInternalClass.GetFileAndMetaInfo(String%20bstrUrl%2C%20Byte%20bPageView%2C%20Byte%20bPageMode%2C%20Byte%20bGetBuildDependencySet%2C%20String%20bstrCurrentFolderUrl%2C%20Int32%20iRequestVersion%2C%20Byte%20bMainFileRequest%2C%20Boolean%26amp%3B%20pbCanCustomizePages%2C%20Boolean%26amp%3B%20pbCanPersonalizeWebParts%2C%20Boolean%26amp%3B%20pbCanAddDeleteWebParts%2C%20Boolean%26amp%3B%20pbGhostedDocument%2C%20Boolean%26amp%3B%20pbDefaultToPersonal%2C%20Boolean%26amp%3B%20pbIsWebWelcomePage%2C%20String%26amp%3B%20pbstrSiteRoot%2C%20Guid%26amp%3B%20pgSiteId%2C%20UInt32%26amp%3B%20pdwVersion%2C%20String%26amp%3B%20pbstrTimeLastModified%2C%20String%26amp%3B%20pbstrContent%2C%20UInt32%26amp%3B%20pdwPartCount%2C%20Object%26amp%3B%20pvarMetaData%2C%20Object%26amp%3B%20pvarMultipleMeetingDoclibRootFolders%2C%20String%26amp%3B%20pbstrRedirectUrl%2C%20Boolean%26amp%3B%20pbObjectIsList%2C%20Guid%26amp%3B%20pgListId%2C%20UInt32%26amp%3B%20pdwItemId%2C%20Int64%26amp%3B%20pllListFlags%2C%20Boolean%26amp%3B%20pbAccessDenied%2C%20Guid%26amp%3B%20pgDocid%2C%20Byte%26amp%3B%20piLevel%2C%20UInt64%26amp%3B%20ppermMask%2C%20Object%26amp%3B%20pvarBuildDependencySet%2C%20UInt32%26amp%3B%20pdwNumBuildDependencies%2C%20Object%26amp%3B%20pvarBuildDependencies%2C%20String%26amp%3B%20pbstrFolderUrl%2C%20String%26amp%3B%20pbstrContentTypeOrder%2C%20Guid%26amp%3B%20pgDocScopeId)%3CBR%20%2F%3Eat%20Microsoft.SharePoint.Library.SPRequest.GetFileAndMetaInfo(String%20bstrUrl%2C%20Byte%20bPageView%2C%20Byte%20bPageMode%2C%20Byte%20bGetBuildDependencySet%2C%20String%20bstrCurrentFolderUrl%2C%20Int32%20iRequestVersion%2C%20Byte%20bMainFileRequest%2C%20Boolean%26amp%3B%20pbCanCustomizePages%2C%20Boolean%26amp%3B%20pbCanPersonalizeWebParts%2C%20Boolean%26amp%3B%20pbCanAddDeleteWebParts%2C%20Boolean%26amp%3B%20pbGhostedDocument%2C%20Boolean%26amp%3B%20pbDefaultToPersonal%2C%20Boolean%26amp%3B%20pbIsWebWelcomePage%2C%20String%26amp%3B%20pbstrSiteRoot%2C%20Guid%26amp%3B%20pgSiteId%2C%20UInt32%26amp%3B%20pdwVersion%2C%20String%26amp%3B%20pbstrTimeLastModified%2C%20String%26amp%3B%20pbstrContent%2C%20UInt32%26amp%3B%20pdwPartCount%2C%20Object%26amp%3B%20pvarMetaData%2C%20Object%26amp%3B%20pvarMultipleMeetingDoclibRootFolders%2C%20String%26amp%3B%20pbstrRedirectUrl%2C%20Boolean%26amp%3B%20pbObjectIsList%2C%20Guid%26amp%3B%20pgListId%2C%20UInt32%26amp%3B%20pdwItemId%2C%20Int64%26amp%3B%20pllListFlags%2C%20Boolean%26amp%3B%20pbAccessDenied%2C%20Guid%26amp%3B%20pgDocid%2C%20Byte%26amp%3B%20piLevel%2C%20UInt64%26amp%3B%20ppermMask%2C%20Object%26amp%3B%20pvarBuildDependencySet%2C%20UInt32%26amp%3B%20pdwNumBuildDependencies%2C%20Object%26amp%3B%20pvarBuildDependencies%2C%20String%26amp%3B%20pbstrFolderUrl%2C%20String%26amp%3B%20pbstrContentTypeOrder%2C%20Guid%26amp%3B%20pgDocScopeId)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20in%20this%20regard%20would%20be%20really%20appreciated.%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2027466%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EProject%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ereporting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

We are running SSRS with Project Server 2016. Here's the situation:

I can execute Report Builder from inside the server and edit the reports successfully, but when try to open the report builder from my PC (I am in the admin group of the project server), I am facing below error logged in logs.

 

System.Runtime.InteropServices.COMException: The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.
at Microsoft.SharePoint.Library.SPRequestInternalClass.GetFileAndMetaInfo(String bstrUrl, Byte bPageView, Byte bPageMode, Byte bGetBuildDependencySet, String bstrCurrentFolderUrl, Int32 iRequestVersion, Byte bMainFileRequest, Boolean& pbCanCustomizePages, Boolean& pbCanPersonalizeWebParts, Boolean& pbCanAddDeleteWebParts, Boolean& pbGhostedDocument, Boolean& pbDefaultToPersonal, Boolean& pbIsWebWelcomePage, String& pbstrSiteRoot, Guid& pgSiteId, UInt32& pdwVersion, String& pbstrTimeLastModified, String& pbstrContent, UInt32& pdwPartCount, Object& pvarMetaData, Object& pvarMultipleMeetingDoclibRootFolders, String& pbstrRedirectUrl, Boolean& pbObjectIsList, Guid& pgListId, UInt32& pdwItemId, Int64& pllListFlags, Boolean& pbAccessDenied, Guid& pgDocid, Byte& piLevel, UInt64& ppermMask, Object& pvarBuildDependencySet, UInt32& pdwNumBuildDependencies, Object& pvarBuildDependencies, String& pbstrFolderUrl, String& pbstrContentTypeOrder, Guid& pgDocScopeId)
at Microsoft.SharePoint.Library.SPRequest.GetFileAndMetaInfo(String bstrUrl, Byte bPageView, Byte bPageMode, Byte bGetBuildDependencySet, String bstrCurrentFolderUrl, Int32 iRequestVersion, Byte bMainFileRequest, Boolean& pbCanCustomizePages, Boolean& pbCanPersonalizeWebParts, Boolean& pbCanAddDeleteWebParts, Boolean& pbGhostedDocument, Boolean& pbDefaultToPersonal, Boolean& pbIsWebWelcomePage, String& pbstrSiteRoot, Guid& pgSiteId, UInt32& pdwVersion, String& pbstrTimeLastModified, String& pbstrContent, UInt32& pdwPartCount, Object& pvarMetaData, Object& pvarMultipleMeetingDoclibRootFolders, String& pbstrRedirectUrl, Boolean& pbObjectIsList, Guid& pgListId, UInt32& pdwItemId, Int64& pllListFlags, Boolean& pbAccessDenied, Guid& pgDocid, Byte& piLevel, UInt64& ppermMask, Object& pvarBuildDependencySet, UInt32& pdwNumBuildDependencies, Object& pvarBuildDependencies, String& pbstrFolderUrl, String& pbstrContentTypeOrder, Guid& pgDocScopeId)

 

Any help in this regard would be really appreciated.

Thanks in advance.

1 Reply

Hello @RizwanAkhtar ,

This query is related to SSRS, I think it would best to post this query in the SQL Server community: https://techcommunity.microsoft.com/t5/sql-server/ct-p/SQL-Server

Paul