Wednesday, July 27, 2016

Get Line Numbers In Exception Stack Trace

If you want to ensure you get line numbers in your Exception Stack Trace, you need to make sure your project is set up to provide "full" debug info on build. By default, for "Release" configuration, this is set to "pdb-only".

Steps to enable:

In Visual Studio...

1. Ensure your project is set to "Release" Solution Configuration (or whichever config you use for deployments)

2. Go to Project > Properties > Build

3. Click the Advanced Button in the bottom right.

4. Under Output > "Debug Info", choose "full" from the dropdown.

5. Save all settings and build your project. You will now see line numbers in Exception Stack Traces.


Hope this helps,
Aaron








Write Azure WebJob Logs to SQL

We've been working with Azure WebJobs recently (more info: here and here) and even though the built in logging to Azure Storage is great, it is difficult to query at times.

In more recent version of the WebJobs SDK, the team exposed a TraceWriter collection via the JobHost configuration that allows consumers to write logs to a custom repository.

The snippet linked below is a naive implementation of using that collection to write the logs to SQL Server. Feel free to adapt it to fit your needs (i.e. performance concerns, async, batching, etc.)

Write Azure WebJob Logs to SQL:
https://gist.github.com/aaronhoffman/3e319cf519eb8bf76c8f3e4fa6f1b4ae


Hope this helps,
Aaron