User profile for rgelb

@Jessica R I think I figured it out. Placing my assembly into LineLevelBlackList.xml was not necessary. Neither was increasing permissions on my assembly in AssemblyInfo.cs I just added HtmlAgilityPack into the file and that did the trick. The odd thing is that I do not have source code for this assembly. It's an open source library and I was just referencing the DLL. My LineLevelBlackList.xml now has these entries:  <assemblyName>Newtonsoft.Json</assemblyName> <assemblyName>log4net</assemblyName>  <assemblyName>HtmlAgilityPack</assemblyName> Perhaps you should add HtmlAgilityPack to the list of assemblies with known issues. / comments

@Jessica R I think I figured it out. Placing my assembly into LineLevelBlackList.xml was not necessary. Neither was increasing permissions on my assembly in AssemblyInfo.cs I just added HtmlAgi...

0 votes

@Jessica R I meant to get back to this earlier. I am back to the "Operation could destabilize the runtime" error. I've added the assembly, which contains the code in the screenshot lives, to the LineLevelBlacklist.xml and it seems to ignore the file. I've also downgraded to Ants Profiler 8.6 and it's showing the error there too. And I've added the assembly to %localappdata%\Red Gate\ANTS Performance Profiler 8\LineLevelBlacklist.xml. Is it possible that runtime destabilization happens somewhere else and the code that's displayed is a red herring? / comments

@Jessica R I meant to get back to this earlier. I am back to the "Operation could destabilize the runtime" error. I've added the assembly, which contains the code in the screenshot lives, to the...

0 votes

@Jessica R That worked! I added the Security rules attribute and it did the trick. Thank you very much. w3p.exe still crashes if Enable Inlining is checked, but I don't think I need that . I was also able to turn Async Awareness on. I'll have to look into that assembly and see what security settings might be going on. Any ideas of what I should be looking at? / comments

@Jessica R That worked! I added the Security rules attribute and it did the trick. Thank you very much. w3p.exe still crashes if Enable Inlining is checked, but I don't think I need that . I wa...

0 votes

@Jessica R So I tried suggestions you made. Unfortunately it didn't help. I disabled "Profile with async awareness" and disabled all options in "Additional profiler options". Alternatively I got either crashes or "Operation could destabilize the runtime" error. I am not sure what leads to this error. One thing that does work is line level profiling until the crash (which happens shortly after I press Start Profiling). So I am at a loss. Any other suggestions? [image] / comments

@Jessica R So I tried suggestions you made. Unfortunately it didn't help. I disabled "Profile with async awareness" and disabled all options in "Additional profiler options". Alternatively I got ...

0 votes

Hi @Jessica R I cleared out the event log and recreated the crash. Event log had the following entries: .NET Runtime version 4.0.30319.0 - The profiler was loaded successfully. Profiler CLSID: '{F487E236-8315-45AF-833E-DF0967B1E79A}'. Process ID (decimal): 364. Message ID: [0x2507]. The Open Procedure for service "BITS" in DLL "C:\Windows\System32\bitsperf.dll" failed. Performance data for this service will not be available. The first four bytes (DWORD) of the Data section contains the error code. The configuration information of the performance library "C:\Windows\System32\perfts.dll" for the "TermService" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted. Faulting application name: w3wp.exe, version: 10.0.15063.0, time stamp: 0xacce422f Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000 Exception code: 0xc00000fd Fault offset: 0x3636e10b Faulting process id: 0x16c Faulting application start time: 0x01d30fde87182b0a Faulting application path: C:\WINDOWS\SysWOW64\inetsrv\w3wp.exe Faulting module path: unknown Report Id: b7193eb4-f29b-47fa-bf35-5ba0de499542 Faulting package full name: Faulting package-relative application ID: I chose to debug the w3p crash using a new copy of Visual Studio and it pinpointed the following line with the Stack Overflow exception: result = engine.Invoke(outputType, renderOptions.ComponentName, properties).ToString(); [image] / comments

Hi @Jessica R I cleared out the event log and recreated the crash. Event log had the following entries: .NET Runtime version 4.0.30319.0 - The profiler was loaded successfully. Profiler CLSID: '{...

0 votes

Hi @Jessica R I cleared out the Event Viewer, repeated the test and it crashed again. The Event Viewer had the following things (separated by carriage returns): .NET Runtime version 4.0.30319.0 - The profiler was loaded successfully. Profiler CLSID: '{F487E236-8315-45AF-833E-DF0967B1E79A}'. Process ID (decimal): 364. Message ID: [0x2507]. The Open Procedure for service "BITS" in DLL "C:\Windows\System32\bitsperf.dll" failed. Performance data for this service will not be available. The first four bytes (DWORD) of the Data section contains the error code. The configuration information of the performance library "C:\Windows\System32\perfts.dll" for the "TermService" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted. Faulting application name: w3wp.exe, version: 10.0.15063.0, time stamp: 0xacce422f Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000 Exception code: 0xc00000fd Fault offset: 0x3636e10b Faulting process id: 0x16c Faulting application start time: 0x01d30fde87182b0a Faulting application path: C:\WINDOWS\SysWOW64\inetsrv\w3wp.exe Faulting module path: unknown Report Id: b7193eb4-f29b-47fa-bf35-5ba0de499542 Faulting package full name: Faulting package-relative application ID: I then selected to "debug" the w3p crash using a new copy of Visual Studio and it pinpointed this line of code in our code base: result = engine.Invoke(outputType, renderOptions.ComponentName, properties).ToString(); The error was Stack Overflow. [image] As I mentioned before none of these errors happen if I profile without line level stats. / comments

Hi @Jessica R I cleared out the Event Viewer, repeated the test and it crashed again. The Event Viewer had the following things (separated by carriage returns): .NET Runtime version 4.0.30319.0 - ...

0 votes

eddie davis wrote: Can you please check to see if you have the following SQL Prompt Options enabled? SQL Prompt 5 ->Options ->Format ->Data statements ->New Lines (to the right) ->Place the following on a new line: ->Join condition and Align join condition with JOIN. If you have "Join condition" and "Align join condition with JOIN" options enabled, can you please disable these options and recheck to see if your join statement follows the style you have set? Those items were already disabled. Just for fun, I re-enabled them, then disabled them again - unfortunately no result. / comments

eddie davis wrote: Can you please check to see if you have the following SQL Prompt Options enabled? SQL Prompt 5 ->Options ->Format ->Data statements ->New Lines (to the right) ->Place the foll...

0 votes

eddie davis wrote: Does the advice in this help ARTICLE provide the answer to your question? Eddie, that's the point. I messed around with styles but I couldn't get it not to throw the second compare of the join onto a separate line. Could you do it? / comments

eddie davis wrote: Does the advice in this help ARTICLE provide the answer to your question? Eddie, that's the point. I messed around with styles but I couldn't get it not to throw the seco...

0 votes

Doesn't have the elegance of visual studio (or even SSMS) snippets, but I guess, it gets the job done. / comments

Doesn't have the elegance of visual studio (or even SSMS) snippets, but I guess, it gets the job done.

0 votes

Brian, I am about to dump a lot of XML and code on you. If there is a better way, please let me know. Here is the Markup: <%@ ServiceHost Language="C#" Debug="true" Service="CC.AP.Services.Services.CalculationService" CodeBehind="CalculationService.svc.cs" %> Here is some of the code from the code behind of the service: [OperationReportServiceBehavior] public class CalculationService : ServiceBase, ICalculationService { #region Constructors public CalculationService() : base(LogManager.GetLogger("CalculationServiceSystemLog")) { } /// Public Methods } I didn't include any of the public methods since they are immaterial to this. The interface ICalculationService simply contains public methods that need to be implemented. Here is the web.config: <?xml version="1.0"?>  <configuration> <configSections>  <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" requirePermission="false"/> </configSections> <appSettings> <add key="ApDbConnection" value="Data Source=lani-dev3;Initial Catalog=AP_RT_Dev;User ID=svc_fusion;Password=svc_fusion"/> <add key="TallyURL" value="http://lani-radio007:8080/ArbitronTallyWebServices/tally"/> <add key="PreloadBooksOnStartup" value="true"/> <add key="WhatToLoadAtInterval" value="LastXMonths"/>  <add key="HowManyToLoadAtInterval" value="18"/>   <add key="MonitorCalculationServiceOps" value="true"/> <add key="MonitorMetadataServiceOps" value="true"/> </appSettings> <connectionStrings/> <log4net>   <appender name="CalculationServiceSystemLog" type="log4net.Appender.RollingFileAppender"> <file value="Logs\\CalculationServiceSystem.log"/> <appendToFile value="true"/> <rollingStyle value="Composite"/> <datePattern value="yyyyMMdd"/> <maxSizeRollBackups value="10"/> <maximumFileSize value="20MB"/> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%date [%thread] %-5level - %message%newline"/> </layout> </appender>  <logger name="CalculationServiceSystemLog"> <level value="ALL"/> <appender-ref ref="CalculationServiceSystemLog"/> </logger>  <appender name="CalculationServiceOpsLog" type="log4net.Appender.RollingFileAppender"> <file value="Logs\\ops\\CalculationServiceOps.log"/> <appendToFile value="true"/> <rollingStyle value="Composite"/> <datePattern value="yyyyMMdd"/> <maxSizeRollBackups value="10"/> <maximumFileSize value="20MB"/> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%date [%thread] %-5level - %message%newline"/> </layout> </appender>  <logger name="CalculationServiceOpsLog"> <level value="ALL"/> <appender-ref ref="CalculationServiceOpsLog"/> </logger>  <appender name="MetadataServiceSystemLog" type="log4net.Appender.RollingFileAppender"> <file value="Logs\\MetadataServiceSystem.log"/> <appendToFile value="true"/> <rollingStyle value="Composite"/> <datePattern value="yyyyMMdd"/> <maxSizeRollBackups value="10"/> <maximumFileSize value="20MB"/> <staticLogFileName value="true"/> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%date [%thread] %-5level - %message%newline"/> </layout> </appender>  <logger name="MetadataServiceSystemLog"> <level value="ALL"/> <appender-ref ref="MetadataServiceSystemLog"/> </logger>  <appender name="MetadataServiceOpsLog" type="log4net.Appender.RollingFileAppender"> <file value="Logs\\ops\\MetadataServiceOps.log"/> <appendToFile value="true"/> <rollingStyle value="Composite"/> <datePattern value="yyyyMMdd"/> <maxSizeRollBackups value="10"/> <maximumFileSize value="20MB"/> <staticLogFileName value="true"/> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%date [%thread] %-5level - %message%newline"/> </layout> </appender>  <logger name="MetadataServiceOpsLog"> <level value="ALL"/> <appender-ref ref="MetadataServiceOpsLog"/> </logger>  <appender name="TallyCacheManagerSystemLog" type="log4net.Appender.RollingFileAppender"> <file value="Logs\\TallyCacheManagerSystemLog.log"/> <appendToFile value="true"/> <rollingStyle value="Composite"/> <datePattern value="yyyyMMdd"/> <maxSizeRollBackups value="10"/> <maximumFileSize value="20MB"/> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%date [%thread] %-5level - %message%newline"/> </layout> </appender> <logger name="TallyCacheManagerSystemLog"> <level value="ALL"/> <appender-ref ref="TallyCacheManagerSystemLog"/> </logger> </log4net> <system.web>  <compilation debug="true" targetFramework="4.0"/>  <authentication mode="Windows"/>  <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/> </system.web>  <system.serviceModel> <serviceHostingEnvironment multipleSiteBindingsEnabled="true" /> <bindings> <basicHttpBinding> <binding name="XmlMessageBinding" maxReceivedMessageSize="2147483647" maxBufferPoolSize="2147483647" maxBufferSize="2147483647" closeTimeout="00:03:00" openTimeout="00:03:00" receiveTimeout="00:10:00" sendTimeout="00:03:00"> <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647" maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647" /> <security mode="None"/> </binding> </basicHttpBinding> </bindings> <services> <service behaviorConfiguration="CC.AP.Services.Services.MetadataServiceBehavior" name="CC.AP.Services.Services.MetadataService"> <endpoint address="" binding="basicHttpBinding" contract="CC.AP.WcfContracts.IMetadataService">  </endpoint> <endpoint address="ws" binding="wsHttpBinding" contract="CC.AP.WcfContracts.IMetadataService"/>  </service> <service behaviorConfiguration="CC.AP.Services.Services.CalculationServiceBehavior" name="CC.AP.Services.Services.CalculationService"> <endpoint address="" binding="basicHttpBinding" contract="CC.AP.WcfContracts.ICalculationService">  </endpoint> <endpoint address="ws" binding="wsHttpBinding" contract="CC.AP.WcfContracts.ICalculationService"/>  </service> </services> <behaviors> <endpointBehaviors> <behavior name="webBehavior"> <webHttp /> <dataContractSerializer maxItemsInObjectGraph="2147483647" /> </behavior> </endpointBehaviors> <serviceBehaviors> <behavior name="CC.AP.Services.Services.MetadataServiceBehavior"> <serviceMetadata httpGetEnabled="true" /> <serviceDebug includeExceptionDetailInFaults="true" /> <serviceThrottling maxConcurrentCalls="100" maxConcurrentSessions="200" maxConcurrentInstances="100" /> </behavior> <behavior name="CC.AP.Services.Services.CalculationServiceBehavior"> <serviceMetadata httpGetEnabled="true" /> <serviceDebug includeExceptionDetailInFaults="true" /> <serviceThrottling maxConcurrentCalls="100" maxConcurrentSessions="200" maxConcurrentInstances="100" /> </behavior> <behavior name=""> <serviceMetadata httpGetEnabled="true" /> <serviceDebug includeExceptionDetailInFaults="false" /> </behavior> </serviceBehaviors> </behaviors> </system.serviceModel> </configuration> / comments

Brian, I am about to dump a lot of XML and code on you. If there is a better way, please let me know. Here is the Markup: <%@ ServiceHost Language="C#" Debug="true" Service="CC.AP.Services.Service...

0 votes

How can we help you today?

rgelb

Comments