.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh
Post New Web Links

Help Troubleshoot "Could not find Type in assembly"

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I am attempting to create a CLR Procedure.  I was able to create the assembly, but I am unable to create a procedure on the assembly.  This is the error I receive: Msg 6505, Level 16, State 1, Procedure DINEServiceProc, Line 2 Could not find Type 'DINEServiceProc' in assembly 'DINEService' Here is the VB code to create the class: <code> Imports System Imports System.Data Imports System.Data.Sql Imports System.Data.SqlClient Imports System.Data.SqlTypes Imports Microsoft.SqlServer.Server Partial Public Class DINEServiceProc <Microsoft.SqlServer.Server.SqlProcedure()> _ Public Shared Sub ServiceProc(ByVal iMsg As String, ByVal iMsgType As String) Dim conn As SqlConnection 'Create an in-process connection to the instance of SQL Server conn = New SqlConnection("Context Connection=True") Dim DINEService As New DINEService Try conn.Open() DINEService.ProcessStartRequest(iMsg, iMsgType) Catch sqe As SqlException 'Console.WriteLine(sqe.Message) Return Finally conn.Close() End Try End Sub End Class </code> And here is the code to create the assembly and the procedure: <code> USE [ServiceBrokerTest] GO /****** Object: SqlAssembly [DINEService] Script Date: 01/03/2006 10:38:00 ******/ CREATE ASSEMBLY [DINEServiceProc] AUTHORIZATION [dbo] FROM 'D:\EHIT\ServiceBroker\DINEService\DINEService\bin\Debug\DINEService.dll' WITH PERMISSION_SET = SAFE

View Complete Post

More Related Resource Links

How to troubleshoot a SharePoint 2010 error

When an error occurs within Microsoft SharePoint Foundation 2010 a Correlation ID will be displayed in the error message: This Correlation ID is logged within the SharePoint log files and you can use it to find out more details about the error that occurred.  The two pieces of information you will need from the error message above are the Correlation ID and the date and time of the error.  Once you have those two pieces of information, browse to the SharePoint log files on your SharePoint server located at: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS The log files will be labeled with a date time stamp so find the one that corresponds to the time frame of the error and then open this log file in Notepad (or the text editor of your choice) and search for the Correlation ID.  You will probably find it listed in several places, from the beginning GET request to when the error occurred, and finally to when the logging of correlation data stops.  Of course you are probably most interested in the error message but there will be more information in the log associated with the Correlation ID to help you find the root cause of the error.

Troubleshoot Microsoft Connector 1.0 for SAP BI

I have installed the Microsoft Connector 1.0 for SAP BI (April 2009 feature pack) on a Windows 2008 R2 server with SQL 2008 SP1 (Cum Update 6). I have established an SAP BI Connection and SAP BI Data Source. The Data Source is able identify the OHS_Destination, Process Chain, and respective Columns. Confirm that the librfc32.dll is installed correctly. The Output of the Data Source is connected to a simple OLEDB destination. When executing the package, it fails at the SAP BI Data Source with the following errors: [SAP BI Source] Error: Microsoft.SqlServer.Dts.SapBw.Connectivity.ERPException: FAILED Execution failed.    at Microsoft.SqlServer.Dts.SapBw.Connectivity.RFCFunction.Execute()    at Microsoft.SqlServer.Dts.SapBw.Components.OHSExtractor.ExtractNow(Boolean InRuntimeMode, String GatewayHost, String GatewayService, String ProgramID, String ProcessChain, String DestinationName, String ExecutionMode, String PropertyRequestID, Int32 Timeout) [SAP BI Source [61]] Error: Microsoft.SqlServer.Dts.SapBw.Connectivity.ERPException: FAILED Execution failed.    at Microsoft.SqlServer.Dts.SapBw.Components.OHSExtractor.ExtractNow(Boolean InRuntimeMode, String GatewayHost, String GatewayService, String ProgramID, String ProcessChain, String DestinationName, String ExecutionMode, String PropertyRequestID, Int32 Timeout)    at Mic

How to troubleshoot apparently contradictory states in a WCF proxy's State property

I am terribly confused here and the information on the subject that I have been able to find online doesn't seem to quite solve this problem.  I have created a WCF Service; it is small and only has about a dozen operation contracts.  Then I created the client proxy; also quite small.  But I am having issues connecting the clients to the host.  Here is what appears to be happening: Public Sub Start() Try SyncLock syncObj Dim context As New InstanceContext(Me) m_proxy = New AwarenessSR.AwarenessWCFServiceClient(context, "NetTcpBinding_IAwarenessWCFService", m_endpointAddress) AddHandler m_proxy.InnerDuplexChannel.Faulted, AddressOf InnerDuplexHandler AddHandler m_proxy.InnerDuplexChannel.Closed, AddressOf InnerDuplexHandler Dim check As Boolean = False For i As Integer = 0 To 10 check = ValidateConnection() If check Then Exit For End If Next End SyncLock Catch ex As Exception ' Some error handling that I won't bother to copy End Try End Sub Public Function ValidateConnection(Optional ByVal autoRepair As Boolean = True) As Boolean Dim bIsValid As Boolean bIsValid = False SyncLock syncObj If autoRepair = True Then If m_proxy.State = ServiceModel.CommunicationState.Closed Or _

SQLBROWSER runs, but 'netstat -ano' doesnt show UDP 1434 (how to troubleshoot)

i have been running sqlexpress2005 sp3 successfully (installed as a named instance) to a stand alone computer. i just noticed today that when i run...   netstat -ano | findstr 1434 nothing is listed!!!  if i go to services.msc and stop and restart sqlbrowser, it says its able to be controlled, and stopped, and started. i would like to know how to troubleshoot this... is there a way to know for sure if sqlbrowser is actually binding to UPD port 1434? or is there some problem on my system that prevents this port from showing up in netstat.  here is what netstat -ano reveals... C:\Program Files\Support Tools>netstat -ano Active Connections   Proto  Local Address          Foreign Address        State           PID  TCP                LISTENING       1208  TCP                LISTENING       4  TCP

Troubleshoot sitemanager.aspx problem

On the Site Content and Structure page for my site collection (sitemanager.aspx), there is one site that results in "There was an error in the callback" when trying to expand the plus sign in fron of it in the left tree.  If I just click on the site name, it errors out with the following:   Error   Cannot complete this action. Please try again.   at Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemWorkflowsAsSafeArray(String bstrUrl, String bstrListName, Int32 lItemI, Guid& pWorkflowInstanceId, Guid& pGuidTemplateId, Int32 inclusiveFilterState, Int32 exclusiveFilterState, UInt32& pdwColCount, UInt32& pdwRowCount, Object& pvarDataSet)    at Microsoft.SharePoint.Library.SPRequest.GetListItemWorkflowsAsSafeArray(String bstrUrl, String bstrListName, Int32 lItemI, Guid& pWorkflowInstanceId, Guid& pGuidTemplateId, Int32 inclusiveFilterState, Int32 exclusiveFilterState, UInt32& pdwColCount, UInt32& pdwRowCount, Object& pvarDataSet)    Has anyone ever encountered this error?  There's no workflow in this site.

How to troubleshoot locking LOCK_M_IX



I have batches of timeouts in SQL and system_health contains around 20 entries all waiting on LCK_M_IX. Majority of entries does not have SQL text entry associated with it ("Unable to retrieve SQL text").

I can run profiler and wait for next occurance (couple of time a day) but this is heavily used server and hence I can not log a lot of information. So which counter with which thresholds I need to put to find out why those locks are acquired and held?

How do I troubleshoot SSIS package hanged for running?


[This is just for sharing information for those common asked questions collected from forums. If you have any better way or feedback, please directly reply in this thread so that community users can benefit from your answers.]

My SSIS package is running in a SQL Server Agent job, but when it is running, it hangs. I could not see error messages from the job history. What is the problem?
There might be various reasons to cause a SSIS package hanged for running and generally for a hang issue, there is no log information helpful for diagnostics. These are the difficulties of troubleshooting hang issues. In this FAQ, we would like to give you three common aspects to help you perform self-troubleshooting:
1. Resource bottleneck
2. Blocking or Deadlock
3. Poor performance query

Resource Bottleneck
Generally resource bottleneck includes bottlenecks of memory, processor, physical disk or network interface. You can run Performance Monitor (perfmon.exe) to collect the trace with the following counters:
Processor: %Processor Time
Processor: %DPC Time
Processor: %Privileged Time
Processor: Interrupts/sec
Memory: Available Bytes
Memory: Pages/sec
Memory: Page Faults/sec
Memory: Committed Bytes

how to troubleshoot peoplepicker lag with NetMon


We have a significant issue with delay in performing a peoplepicker find/browse operation in order to apply security to sites/objects in MOSS2007.  This has been a bit of a pain since launch (24+ months) in both prod and dev systems, but was only a problem previously for admins.  as we open provisioning to our general population this is becoming a major headache as the first search operation can take upward of 1:30 minutes to return results, with subsequent queries being very very responsive. 

I have already ruled out configuration at the peoplepicker property level (ie. -pn peoplepicker-searchadforest -pv "forest:myforest;domain:mytrusteddomainpartners") and those options do not resolve any issue for me.  Please, no more suggestions for doing that.  :-)  I have also used nltest.exe and ldap.exe to test connectivity to the GCs and those look good as well.  And I've also run the search operation while capturing traffic with NetMon 3.4.  So this is what I need help with:

(1) how do I read through the NetMon capture file to verify I don't have a DC/GC that is causing response issues (not seen with LDP tool)?

(2) the whole thing feels very much like an ASP.NET warm-up issue as

  • if I load the main page where I need to assign perms (

    Troubleshoot Maintenance Plan (backup) Long Running



    Sql Server 2005 SP2
    Small databases

    I have a maintenance plan to perform CHECKDB, Reindex, Backup, Cleanup tasks in that order. Lately, its been running very very long. For more than 2 days. Initially it was because of a bunch of reasons i.e. disk ran out of space, TRN and BAK jobs running on top of each other, etc. But now, I created a new plan with just backup. Even that runs forever. Just simple backup, nothing else (small database).

    Now, if I create a job with T-Sql command and run it, it runs fast in under a second. But if I create a Maintenance Plan on the same database it takes forever. How do I troubleshoot this? I do not get any errors because, I stop the job after running for a few hours.

    Any ideas,

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend