[Urgente] Localizar uma Store Procedore com erro

Question

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!

Answer 1

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

Answer 2

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!

Answer 3

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

Answer 4

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.

Answer 5

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