none
Unexpected error when running Timesheet Audit report RRS feed

  • Question

  • Hi all,

    I have the Project Server 2007 Report Pack on my server and one of the reports, Timesheet Audit, runs for a few minutes before failing with "An unexpected error has occurred".

    Here is the Sharepoint log:

    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(?,'C4CBFAE6-6AEB-4614-89A9-C931DD5BDB45',?,NULL,1,?,?,6187)}"     
    06/13/2011 16:00:19.92     w3wp.exe (0x18C4)                           0x1E08    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: {906B6900-6E90-4CB4-994C-727A610370A8}  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...     
    06/13/2011 16:00:19.92*    w3wp.exe (0x18C4)                           0x1E08    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...     
    06/13/2011 16:00:19.92*    w3wp.exe (0x18C4)                           0x1E08    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)       
    06/13/2011 16:00:19.92     w3wp.exe (0x18C4)                           0x1E08    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: {ED714B50-8494-43AC-84D5-EB147C025259}  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...     
    06/13/2011 16:00:19.92*    w3wp.exe (0x18C4)                           0x1E08    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...     
    06/13/2011 16:00:19.92*    w3wp.exe (0x18C4)                           0x1E08    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...     
    06/13/2011 16:00:19.92*    w3wp.exe (0x18C4)                           0x1E08    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)       
    06/13/2011 16:00:24.09     w3wp.exe (0x18C4)                           0x1E08    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: {DFCD74FC-5DB1-48E6-BE33-75C8FD9A493A}  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...     
    06/13/2011 16:00:24.09*    w3wp.exe (0x18C4)                           0x1E08    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...     
    06/13/2011 16:00:24.09*    w3wp.exe (0x18C4)                           0x1E08    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)       
    06/13/2011 16:00:24.09     w3wp.exe (0x18C4)                           0x1E08    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: {A570FFF0-A0C9-491C-917D-C18D49A9B46E}  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...     
    06/13/2011 16:00:24.09*    w3wp.exe (0x18C4)                           0x1E08    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.get_Title()     at Microsoft.SharePoint.WebPartPages.WebPart.LoadViewState(Object savedState)     at Microsoft.ReportingServices.SharePoint.UI.WebParts.ReportViewerWebPart.LoadViewState(Object savedState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecurs...     
    06/13/2011 16:00:24.09*    w3wp.exe (0x18C4)                           0x1E08    Windows SharePoint Services       General                           8l1n    High        ...ive(Object savedState)     at System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState)     at System.Web.UI.Control.LoadViewStateRecursive(Object savedState)     at System.Web.UI.Page.LoadAllState()     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 ASP._layouts_reportserver_rsviewerpage_aspx.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep...     
    06/13/2011 16:00:24.09*    w3wp.exe (0x18C4)                           0x1E08    Windows SharePoint Services       General                           8l1n    High        ...(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)       
    06/13/2011 16:00:25.07     OWSTIMER.EXE (0x0C10)                       0x18AC    Windows SharePoint Services       General                           0    Medium

     

    Here is the Reporting Services log:      

    webserver!ReportServer_0-3!1528!06/13/2011-16:15:40:: i INFO: Processed report. Report='http://can6800vm018/PWA/Reports/1.0 Timesheet Audit.rdl', Stream=''
    rshost!rshost!b38!06/13/2011-16:15:40:: e ERROR: WriteCallback(): failed to write in write callback.
    rshost!rshost!b38!06/13/2011-16:15:40:: e ERROR: Failed with win32 error 0x0016, pipeline=0x000000000572DCB0.
    rshost!rshost!1528!06/13/2011-16:15:40:: e ERROR: HttPipelineCallback::SendEntityBody(): failed async writing entity body.
    rshost!rshost!1528!06/13/2011-16:15:40:: e ERROR: Failed with win32 error 0x0016, pipeline=0x000000000572DCB0.
    httpruntime!ReportServer_0-3!1528!06/13/2011-16:15:40:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.Runtime.InteropServices.COMException (0x80070016): The device does not recognize the command. (Exception from HRESULT: 0x80070016)
       at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendEntityBody(Void* chunks, UInt16 chunkCount, Boolean finalWrite)
       at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
    library!ReportServer_0-3!1528!06/13/2011-16:15:40:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-3-129524641727863637. , RsWorkerRequest::FlushResponse.;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-3-129524641727863637.  ---> System.Runtime.InteropServices.COMException (0x80070016): The device does not recognize the command. (Exception from HRESULT: 0x80070016)
       at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
       at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
       --- End of inner exception stack trace ---                   

     

    The weird thing is that I can run the report from Report Server (http:\\can6800vm018\reportserver) without any issues.  I'm trying to get it working in PWA so it's easier for the users as they can go to PWA for everything they need.

     

    Please help!

     

    Thanks,

    Andre

    Monday, June 13, 2011 8:23 PM

All replies

  • Andre,

    I would first make sure you have "Access Across Domains" enable on IE browser.  I would also check that the http:\\can6800vm018 is a trusted site and try running again.

    If above fails, then I would run IE as administrator and see if it works.

    Cheers!


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    www.WhartonComputer.com
    Monday, June 13, 2011 8:28 PM
    Moderator
  • Hi Michael,

    Thanks for the reply!  I already had it as a trusted site but enabled "Access Across Domains" AND ran IE as an admin but it still didn't work...same error.  I guess I should also mention that I have everything installed on a single server, WIN2008, SQL2008 and MSPS2007.

    Seems to be some sort of error with SQL as both logs indicate a query failure...any other ideas?

     

    Thanks,

    Andre

    Tuesday, June 14, 2011 1:46 PM
  • Still not fixed...anyone else have any ideas?
    Wednesday, July 20, 2011 4:19 PM
  • I have the same problem, did you solve the it?
    Saturday, September 20, 2014 5:48 PM
  • Hi Filip,

    Unfortunately it was so long ago that I dont' remember and I don't think we use that report anymore.

    Sorry!

    Saturday, September 20, 2014 6:18 PM
  • Thanks for your response, although there was a negative response. :)

    Sunday, September 21, 2014 2:33 PM