Debugging managed UDF running under Sharepoint Excel services

Hot Topic

Data Transfer Objects and Collections
How to send synchronous message to the service?
Storing Session State
Office Automation in .NET
Return of the SmartPart
Accessing a SQL Server table using sql authentication as opposed to windows authentication
Physical seperation of layers - business layer -> data layer?
DataSet Performance issue
OHSBE Installation issue - Mapping Kerberos token to OHSBE services
Steps to upgrade wss2.0 to 3.0????

SharePoint Products

Where can I download the wss12.xsd file?
Stored procedure vs standard query
how to tackle Sharepoint Site contains an ASP.net site for master page
Master/Defail entities and architecture problem in ASP.NET
Software Development Lifecycle
Question about UI layer
MOSS2007 standalone no search results
Reference materials
WSS V3 - Vertical Scrollbar Web Part
CSF vs. WCF ("Indigo")

Debugging managed UDF running under Sharepoint Excel services

I am trying to debug a UDF running under sharepoint. I have attached to the right w3wp process under which the shared services is running.

When I attach to the process, it doesnt load the symbols for my UDF assembly. I have my PDB's in the same location as the UDF.

'w3wp.exe' (Managed): Loaded 'C:\Sharepoint UDF\ExcelSampleUDF.dll', No symbols loaded.

Why are not the symbols loaded


Answer this question

Debugging managed UDF running under Sharepoint Excel services

  • Rune Gulbrandsen

    You can mark your UDF as volatile, so that it will be called each time you explicitly calculate the workbook.

    http://blogs.msdn.com/cumgranosalis/archive/2006/09/12/VolatileUdfs.aspx

  • Kovalev Maxim

    I actually followed that already.. attaching to the correct w3wp process. the problem seems to be that a dll was not copied correctly.(Sorry about that)

    Now the other issue is I can get into debugging - step through, only when I republish for the first time. subsequently if I refresh or reload the workbook, it doesnt hit the breakpoints.
    So I think there is a caching results happening here.. how do I tweak those to always run my code and not cache the results


  • Mzladybug

    Did the above posts answer your question If so could you please mark it as the answer

    Otherwise let us know what you still need help with.

    Thanks!

    - Luis



  • Eric_Sun

    This blog post should help you out:

    http://blogs.msdn.com/cumgranosalis/archive/2006/07/12/DebugUDFs.aspx

    Most likely you are attaching to the wrong w3wp process.



  • Debugging managed UDF running under Sharepoint Excel services
Answer this question