none
[Urgente] Localizar uma Store Procedore com erro RRS feed

  • Pergunta

  • Pessoal, tudo bem?

     

    Tenho um relatório no Reporting Services que faz a chamada de uma store procedure no SQL Server 2008 através de um código .Net.

     

    Problema: Esse relatório está dando um erro, há alguns meses fizeram uma alteração nessa Store Procedure, mas não foi documentado qual foi alterada e ninguém tem o código fonte .Net para ver qual procedure é chamada pelo programa. 

     

    Pergunta: Existe alguma forma de eu descobrir qual procedure está sendo executada e dando erro?

     

    No Event Viewer do windows eu achei esse erro, mas não sei se tem relação com o erro desse proc:

    Event Type:	Warning
    Event Source:	ASP.NET 2.0.50727.0
    Event Category:	Web Event 
    Event ID:	1309
    Date:		1/5/2012
    Time:		5:14:41 PM
    User:		N/A
    Computer:	ACOL11
    Description:
    Event code: 3005 
    Event message: An unhandled exception has occurred. 
    Event time: 1/5/2012 5:14:41 PM 
    Event time (UTC): 1/5/2012 7:14:41 PM 
    Event ID: 7fd03424d8d649149ed2c4afbe6f0dc1 
    Event sequence: 6 
    Event occurrence: 1 
    Event detail code: 0 
     
    Application information: 
        Application domain: /LM/W3SVC/799452330/root/R-1-129702643015781250 
        Trust level: RosettaMgr 
        Application Virtual Path: /R 
        Application Path: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\ 
        Machine name: ACOL11 
     
    Process information: 
        Process ID: 15152 
        Process name: w3wp.exe 
        Account name: NT AUTHORITY\NETWORK SERVICE 
     
    Exception information: 
        Exception type: ReportServerException 
        Exception message: Execution 'ufkl2l55qzdx4b3xd2zkkiuh' cannot be found (rsExecutionNotFound) 
     
    Request information: 
        Request URL: http://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thuhttp://www.allbags.com.br:81/R/Reserved.ReportViewerWebControl.axd?ReportSession=ufkl2l55qzdx4b3xd2zkkiuh&ControlID=7d408d493dc748b7bca0ab79780c083e&Culture=1046&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl144TouchSession0&CacheSeed=Thu%20Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200Jan%2005%202012%2017%3A18%3A53%20GMT-0200 
        Request path: %21 
        User host address: %22 
        User: %23 
        Is authenticated: %24 
        Authentication Type: %25 
        Thread account name: %26 
     
    Thread information: 
        Thread ID: %27 
        Thread account name: %28 
        Is impersonating: %29 
        Stack trace: %30 
     
    Custom event details: 
    %14
    
    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    


    Se alguém puder dar um help... pq ta foda!

     

    Um abraço!

    quinta-feira, 5 de janeiro de 2012 23:34

Respostas

  • Você pode usar a ferramenta SQL Server Profiler ela basicamente vai "escanear" todos os comandos enviados ao banco.

    Você pode filtrar pela sua aplicação e começar a escanear antes de chamar o relatório. Quando o relatório chamar a procedure ele vai ser registrado no Sql Server profiler.

    Segue abaixo 3 links contendo mais informações do que é e como utilizar.

    http://msdn.microsoft.com/pt-br/library/cc580638.aspx

    http://msdn.microsoft.com/pt-br/library/ms173799.aspx

    http://www.macoratti.net/vbn_mcn1.htm

    • Sugerido como Resposta David Silva sexta-feira, 6 de janeiro de 2012 13:16
    • Marcado como Resposta Eder Costa terça-feira, 7 de fevereiro de 2012 13:02
    sexta-feira, 6 de janeiro de 2012 11:05
  • Bruno,

    A coluna EventClass informa pra você o tipo de evento que ocorreu, se uma transação iniciou, se iniciou uma chamada de proc, se um bloco finalizou etc...

    Procure no seu profile na coluna EventClass pelo evento SQL:BatchStarting e SP:Starting na coluna TextData você vai ver o script e na coluna ObjectName o nome da procedure.

    Só que atente também para o horário em que você está reproduzindo o erro para facilitar sua busca.

    Quando iniciar seu Trace, troque o template para TSQL_SPs para facilitar.


    David Silva MCP | MCTS | ITILF Blog: http://tilive.wordpress.com
    • Marcado como Resposta Eder Costa terça-feira, 7 de fevereiro de 2012 13:02
    sexta-feira, 6 de janeiro de 2012 14:04

Todas as Respostas

  • Você pode usar a ferramenta SQL Server Profiler ela basicamente vai "escanear" todos os comandos enviados ao banco.

    Você pode filtrar pela sua aplicação e começar a escanear antes de chamar o relatório. Quando o relatório chamar a procedure ele vai ser registrado no Sql Server profiler.

    Segue abaixo 3 links contendo mais informações do que é e como utilizar.

    http://msdn.microsoft.com/pt-br/library/cc580638.aspx

    http://msdn.microsoft.com/pt-br/library/ms173799.aspx

    http://www.macoratti.net/vbn_mcn1.htm

    • Sugerido como Resposta David Silva sexta-feira, 6 de janeiro de 2012 13:16
    • Marcado como Resposta Eder Costa terça-feira, 7 de fevereiro de 2012 13:02
    sexta-feira, 6 de janeiro de 2012 11:05
  • Augusto, obrigado pela ajuda.

     

    Eu extrai o log do profiler, mas vem muita informação cara, teoricamente na coluna EventClass deveria vir qual informação se a Store Procedure der erro? Tens ideia? Os informações que aparecem nas colunas agora são SP:StmtCompleted, SP:StmtStarting, etc.... deveria vir alguma coisa como SP:StmtError ou SP:StmtWarning, sei lá.

     

    Abraços!

    sexta-feira, 6 de janeiro de 2012 12:47
  • Sugiro também que você utilize o profiler do sql pra tentar achar a chamada da proc, já que não tem o código fonte .net , o problema é que a exceção que está sendo lançada é uma exceção não tratada no código, uma "UnhandledException", talvez o problema nem seja na procedure.

    Boa sorte.


    David Silva MCP | MCTS | ITILF Blog: http://tilive.wordpress.com
    sexta-feira, 6 de janeiro de 2012 13:21
  • Entendi, eu levantei essa hipótese com o pessoal de Dev.

     

    Mas a minha dúvida agora David é que, caso uma proc minha dê erro, qual deve ser a informação contida na coluna EventClass?

     

    Abraços e Obrigado.

    sexta-feira, 6 de janeiro de 2012 13:44
  • Bruno,

    A coluna EventClass informa pra você o tipo de evento que ocorreu, se uma transação iniciou, se iniciou uma chamada de proc, se um bloco finalizou etc...

    Procure no seu profile na coluna EventClass pelo evento SQL:BatchStarting e SP:Starting na coluna TextData você vai ver o script e na coluna ObjectName o nome da procedure.

    Só que atente também para o horário em que você está reproduzindo o erro para facilitar sua busca.

    Quando iniciar seu Trace, troque o template para TSQL_SPs para facilitar.


    David Silva MCP | MCTS | ITILF Blog: http://tilive.wordpress.com
    • Marcado como Resposta Eder Costa terça-feira, 7 de fevereiro de 2012 13:02
    sexta-feira, 6 de janeiro de 2012 14:04