none
Publicar relatório report server no sharepoint RRS feed

  • Pergunta

  • Olá,

     

    Meu sistema sharepoint está integrado com o Reporting Service. Estou tentando publicar um relatório que acessa uma base de dados OLAP do analysis service 2005 mas está ocorrendo o erro abaixo. O erro não ocorre para outros relatórios que acessa a base sql normal.

     

    An error has occurred during report processing. (rsProcessingAborted)

    • Cannot create a connection to data source 'dtsOLAPServer'. (rsErrorOpeningConnection)
    • For more information about this error navigate to the report server on the local server machine, or enable remote errors
    •                               

       

       

       

      Erro do Log:

      11/18/2008 14:37:03.56  w3wp.exe (0x2BE4)                        0x28CC Windows SharePoint Services    Database                       6f8g Unexpected Unexpected query execution failure, error code 282. Additional error information from SQL Server is included below. "The 'proc_GetTpWebMetaDataAndListMetaData' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead." Query text (if available): "{?=call proc_GetTpWebMetaDataAndListMetaData(?,'097E7772-F1D8-45B7-87DA-874BB7FE15EC',?,NULL,1,?,?,6187)}" 
      11/18/2008 14:37:04.51  w3wp.exe (0x2BE4)                        0x1FF4 Windows SharePoint Services    General                        8l1n High     An SPRequest object was not disposed before the end of this thread.  To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it.  This object will now be disposed.  Allocation Id: {97649AB7-FAF9-41B0-8775-7AA307146F8C}  This SPRequest was allocated at    at Microsoft.SharePoint.Library.SPRequest..ctor()     at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous)     at Microsoft.SharePoint.SPWeb.InitializeSPRequest()     at Microsoft.SharePoint.SPWeb.EnsureSPRequest()     at Microsoft.SharePoint.SPWeb.get_Request()     at Microsoft.SharePoint.SPWeb.GetFile... 
      11/18/2008 14:37:04.51* w3wp.exe (0x2BE4)                        0x1FF4 Windows SharePoint Services    General                        8l1n High     ...OrFolderProperties(String strUrl, ListDocsFlags listDocsFlags, Boolean throwException)     at Microsoft.SharePoint.SPFile.PropertiesCore(Boolean throwException)     at Microsoft.SharePoint.SPFile.get_Exists()     at Microsoft.ReportingServices.SharePoint.UI.RSViewerPage.get_FileExistsInDocLib()     at Microsoft.ReportingServices.SharePoint.UI.RSViewerPage.OnInit(EventArgs e)     at System.Web.UI.Control.InitRecursive(Control namingContainer)     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest()     at System.Web.UI.Page.ProcessRequest(HttpContext context)     at AS... 
      11/18/2008 14:37:04.51* w3wp.exe (0x2BE4)                        0x1FF4 Windows SharePoint Services    General                        8l1n High     ...P._layouts_reportserver_rsviewerpage_aspx.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)     at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)     at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)     at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)     at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)   
      11/18/2008 14:37:04.51  w3wp.exe (0x2BE4)                        0x1FF4 Windows SharePoint Services    General                        8l1n High     An SPRequest object was not disposed before the end of this thread.  To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it.  This object will now be disposed.  Allocation Id: {74305B4D-B70C-4E27-82D5-A775B1773C35}  This SPRequest was allocated at    at Microsoft.SharePoint.Library.SPRequest..ctor()     at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous)     at Microsoft.SharePoint.SPWeb.InitializeSPRequest()     at Microsoft.SharePoint.SPWeb.EnsureSPRequest()     at Microsoft.SharePoint.SPWeb.get_Request()     at Microsoft.SharePoint.SPWeb.GetFile... 
      11/18/2008 14:37:04.51* w3wp.exe (0x2BE4)                        0x1FF4 Windows SharePoint Services    General                        8l1n High     ...OrFolderProperties(String strUrl, ListDocsFlags listDocsFlags, Boolean throwException)     at Microsoft.SharePoint.SPFile.PropertiesCore(Boolean throwException)     at Microsoft.SharePoint.SPFile.get_Exists()     at Microsoft.ReportingServices.SharePoint.UI.WebParts.ReportViewerWebPart.GetReportDisplayName(String path)     at Microsoft.ReportingServices.SharePoint.UI.WebParts.ReportViewerWebPart.OnNewReport()     at Microsoft.ReportingServices.SharePoint.UI.WebParts.ReportViewerWebPart.OnPreRender(EventArgs e)     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Control.PreRenderRecursiveInternal()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfter... 
      11/18/2008 14:37:04.51* w3wp.exe (0x2BE4)                        0x1FF4 Windows SharePoint Services    General                        8l1n High     ...AsyncPoint)     at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest()     at System.Web.UI.Page.ProcessRequest(HttpContext context)     at ASP._layouts_reportserver_rsviewerpage_aspx.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)     at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)     at System.Web.HttpRuntime.ProcessRequ... 
      11/18/2008 14:37:04.51* w3wp.exe (0x2BE4)                        0x1FF4 Windows SharePoint Services    General                        8l1n High     ...estInternal(HttpWorkerRequest wr)     at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)     at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)   

    terça-feira, 18 de novembro de 2008 16:42