Error From Sys.dm_db_index_physical_stats No Exceptions Should Be Raised By This Code

Sep 20, 2006

I'm setting up a routine to do some reindexing. To get the info I need I'm trying to use the new function. The DB I think is causing the problem does pass DBCC CHECKDB. I'm not sure why I'm getting this but can not find anyone else that is getting this same error.

When I run this....

SELECT *

FROM sys.dm_db_index_physical_stats (NULL, NULL, NULL, NULL, 'detailed')

I get this....

Location: qxcntxt.cpp:954

Expression: !"No exceptions should be raised by this code"

SPID: 236

Process ID: 1060

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

If I run only for the DB I think is causing the problem I get this...

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

View 6 Replies


ADVERTISEMENT

SQLServer JDBC Exceptions :Controlling Exceptions Text Format

Sep 28, 2006

Hi,

Using RAISERROR from within a stored prcedure will result in a SQLException being thrown at the client side of a JDBC connection.
I am trying to provide a meaningfull error message to be shown to the end user. However, all exceptions thrown will inevitably start with : "[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]". The following questions then arise :

- Is there a way of configuring SQL Server not to display this header ?

alternatively,

- Is there another way of conveying error messages to the client through JDBC ?

Thank you for your answers,
Ben

View 1 Replies View Related

VB6 ADO 2.7 SQL 6.5 Error Not Raised If Execute Produces A Warning First

May 15, 2002

I am running an environment as below

ADO 2.7
SQL Sever OLE DB Provider
VB 6
SQL Server 6.5 SP 5 A Update

If I run a stored procedure that contains a Print statement or gives a warning. Then any error that occurs after that is ignored. No error state is raised in VB and the Errors collection only contains the print or warning.

Can anyone tell me why?

Thanks

Chris

View 1 Replies View Related

EXCEPTION_ACCESS_VIOLATION Raised - Critical Error Has Occured - Help !?!

Dec 4, 1998

SQL Server has stopped a critical task, with the following error log. I have executed the task again and the same symptons occur.

--
EXCEPTION_ACCESS_VIOLATION raised, attempting to create sympton dump
***BEGIN STACK TRACE***
0x0040DC1A in SQLSERVR.EXE, ubfree() + 0x009A
...
...
--

Has anyone any had a simliar experience or have any suggestions for investigation?
Cheers

Jasper

View 1 Replies View Related

Transact SQL :: Program To Catch Transaction Raised Error At The Very End

Aug 11, 2015

I am new to T-SQL programming. I need to write a main procedures to execute multiple transactions. How could I structure the program so that each transaction will not abort if failed. Instead, the next transaction will keep running. At the very end the procedure will output the error and report them back to the main program in the output parameters. Looking for pseudo code.

View 6 Replies View Related

OLEDB TRANSACTION MAKING DIFFERENCE And Error Is Raised

May 14, 2007

OLEDB transaction is making difference in my migrated application powerbuilder 10.5 which has new oledb driver which is replaced by MSS driver in previous Powerbuilder version.



1.)I am facing the below error on update/save this was not faced during my previous versino drive MSS in powerbuilder.This is oocure only after the change to oledb driver.

"Row change between retrieve and update.".

in front end of my application the error is poped as
"(STD1007) This row has been modified by another user. Save is canceled! ".



Please help to resolve this error.







View 1 Replies View Related

Formview - Exception Handling A Sql Server Raised Error On Insert

Dec 2, 2005

I'm trying to get to grips with the formview control and have a problem regarding where an exception is raised if SQL server raises an error when an insert is taking place. I am new to both asp.net & c#
I have put the following code in the SqlDataSource2_Inserted & Formview1_Inserted  events as a way of determining where the exception is raised:
if (e.ExceptionHandled){   string exceptionmessage = e.Exception.Message;   lblStatus.Text = exceptionmessage;}
These two events are the only one's that have the ExceptionHandled and Exception properties.
I run the code with data that will raise a duplicate key error from SQL Server but the error is not being caught by either of these two handlers. All I get is a page that starts with
 Server Error in '/SourceCode' Application.


Violation of UNIQUE KEY constraint 'IX_reftblAntigens'. Cannot insert duplicate key in object 'reftblAntigens'.The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_reftblAntigens'. Cannot insert duplicate key in object 'reftblAntigens'.The statement has been terminated....
 Is there somewhere else I should be looking to handle this sort of thing? I thought using the databound controls would make life easier but I'm actually finding it more of a pain than coding everything myself.

View 4 Replies View Related

How To Catch An Error Raised In The Forach Loop Container And Perform Cleanup Jobs Accordingly?

Nov 29, 2007

Hello everyone,

I have a package that should accomplish the following task:
- Loop on all files in a given directory.
- Before proccessing the current file in the Enumerator, it should be moved to a folder called "importing"
- Load the content of the file into a destination DB.
- After a successfull load, the file is moved from the "importing" to the "success" folder.
- If anything went wrong during the load process, the file should be moved from the "importing" to the "error" folder and an e-mail should be sent out to a certain admin account.

What I have done so far:
My control flow looks like this:
Foreach Loop containing the following tasks:
- File System Task: moving the current file from its original path to the "importing" folder
- Data Flow Task1: performing some transformations and insertions into the DB and raw files.
- Data Flow Task2: performing some transformations and insertions into the DB and raw files.
- Data Flow Task3: performing some transformations and final insertions into the DB.
- File System Task: moving the current file from the "importing" to the "success" folder

Question:
I do not know how to catch the event that one of my three Data Flow Tasks has failed and in this case perform two simple tasks, namely...
- File System Task: moving the current file from the "importing" to the "error" folder
- Send Mail Task: sending a configured e-mail message to a ceratin administrator.

Thanks in advance...

Regards,
Samar

View 8 Replies View Related

Error Messages Versus Exceptions

Jan 19, 2008

I am using .NET v2.0 and SqlServer2005 SB in 90 compatibility mode.

From my brief experience it appears that if I try to subscribe to SB with incorrect SQL or wrong names .NET will immediately throw an exception. However, if my code is correct but there is an error on the server (for example incorrect options as per http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=883992&SiteID=1) then SB will immediately fire the notification message but with €œerror€? instead of €œupdate€? content. How do I detect this?

My code is based on the http://msdn2.microsoft.com/en-us/library/3ht3391b(vs.80).aspx example. (I had too much trouble with the SqlDependency class, including overflowing error logs. So unlike the post at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=903713&SiteID=1 I am NOT receiving an SqlNotificationEventArgs object. I wish I were getting one!) I€™ve included my Listen() method below.

The debug portion of this code gives me message body that looks like the following when everything is good. What should it look like, if for example my SET OPTIONS (first link above) were wrong?

messageBody: <qn:QueryNotification xmlns:qn="http://schemas.microsoft.com/SQL/Notifications/QueryNotification" id="129" type="change" source="data" info="update" database_id="23" sid="0xF4F50461FD43CA4191A1173B9350632A"><qn:Message>7fd415c7-2986-411d-abfd-615cbce0af28</qn:Message></qn:QueryNotification>

Thanks. Code follows:


private void Listen()
{
// infinite loop on this thread: keep listening even after
// receiving notification
while( true )
{
// connects to SqlServer queue and sleeps until a notification msg arrives
using( SqlConnection conn = new SqlConnection( _connect ) )
{
WriteMessage( "RequestNotification: Listen connection opened." );
using( SqlCommand cmd = conn.CreateCommand() )
{
int msgBodyId = InvalidSubscriptionId;
cmd.CommandText = waitFor;
cmd.CommandTimeout = 0; // _notificationTimeout + 100;
try
{
conn.Open();
// the thread is blocked until the waitfor event occurs.
SqlDataReader reader = cmd.ExecuteReader();
// the waitfor has triggered when we've reached here.
WriteMessage( "RequestNotification: Notification received." );
// there may be mulitple notifications waiting, but there seems only
// ever to be a single record to read, but we still use the while
// construct to ensure we get them all...
while( reader.Read() )
{
// the messageBody is actually XML with a GUID embedded as the msgId, eg:
// <qn:Message>82120744-f2bf-4c62-a17c-867cc6eb040e</qn:Message>
String messageBody = FixupMessageText( System.Text.ASCIIEncoding.ASCII.GetString( (byte[]) reader.GetValue( 13 ) ).ToString() );
msgBodyId = MessageBodyId( messageBody );
// doesn't work, sqlbinary...
// String messageBody = reader.GetSqlXml( 13 ).ToString();
#if __dbg
// used for debugging
// messageText = System.Text.ASCIIEncoding.ASCII.GetString( (byte[]) reader.GetValue( 13 ) ).ToString();
Byte status = reader.GetByte( 0 );
Byte priority = reader.GetByte( 1 );
Int64 queuingOrder = reader.GetInt64( 2 );
Guid conversationGroupId = reader.GetGuid( 3 );
Guid conversationHandle = reader.GetGuid( 4 );
Int64 messageSeqNo = reader.GetInt64( 5 );
String serviceName = reader.GetString( 6 );
Int32 serviceId = reader.GetInt32( 7 );
String serviceContractName = reader.GetString( 8 );
Int32 serviceContractId = reader.GetInt32( 9 );
String messageTypeName = reader.GetString( 10 );
Int32 messageTypeId = reader.GetInt32( 11 );
String validation = reader.GetString( 12 );
StringBuilder sb = new StringBuilder( "MESSAGE", 1024 );
sb.AppendLine();
sb.Append( " " );
sb.Append( BuildMessage( "status", status ) );
sb.Append( BuildMessage( "priority", priority ) );
sb.Append( BuildMessage( "queuingOrder", queuingOrder ) );
sb.Append( BuildMessage( "conversationGroupId", status ) );
sb.Append( BuildMessage( "conversationHandle", conversationHandle ) );
sb.Append( BuildMessage( "messageSeqNo", messageSeqNo ) );
sb.Append( BuildMessage( "serviceName", serviceName ) );
sb.Append( BuildMessage( "serviceId", serviceId ) );
sb.Append( BuildMessage( "serviceContractName", serviceContractName ) );
sb.Append( BuildMessage( "serviceContractId", serviceContractId ) );
sb.Append( BuildMessage( "messageTypeName", messageTypeName ) );
sb.Append( BuildMessage( "messageTypeId", messageTypeId ) );
sb.Append( BuildMessage( "validation", validation ) );
sb.AppendLine();
sb.Append( " " );
sb.Append( BuildMessage( "messageBody", messageBody ) );
WriteMessage( sb.ToString() );
#endif
}
reader.Close();
// and now we need to hand things back to the user's passed delegate.
// orphan notifications can be left behind from previous runs,
// determine if this notification is one we want to pass on
if( _subscriptionId == msgBodyId )
{
WriteMessage( "Message " + msgBodyId.ToString() + " calling delegate." );
// see http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlnotificationinfo.aspx
SqlNotificationEventArgs e = new SqlNotificationEventArgs( SqlNotificationType.Change, SqlNotificationInfo.AlreadyChanged, SqlNotificationSource.Database );
_delegate( this, e );
}
else
{
WriteMessage( "Message " + msgBodyId.ToString() + " ignored." );
}
}
catch( SqlException )
{
// if the queue name doesn't match one in the db an exception will be thrown
throw;
}
finally
{
conn.Close();
}
}
}
WriteMessage( "RequestNotification: Listen connection closed." );
}
}

View 7 Replies View Related

Handling A SQL Exceptions And Custom Error Messages

Aug 6, 2007

Hello guys,I need some ideas on how to handle an exception or a user defined error message.I have a procedure that creates a new user. Lets say if the e-mail address entered is already in use. What are some of the best practices for notifying the user that the e-mail address is already in use?This is what I was thinking....Solution #1--------------My proc will raise an error with a message id that is great than 50000, then my DAL will recognize this is a user defined error and spit back to the user instead of trapping it.Solution #2--------------The proc should have an output param ( @CreationStatus CHAR(1) ).If the @CreationStatus has a value for example "E", I will have lookup the value for "E" in my app and spit back that custom error message. I don't really like this option because it is too concrete.What are some of the ways you deal with this situation?Your suggestions are greatly appreciated.Thank you!

View 2 Replies View Related

Displaying SQL PRINT ERROR MESSAGES For Missing Parameters Or Exceptions.

Jan 28, 2008

Does anyone know of a way to capture in C# SQL PRINT ERROR MESSAGES generated from stored procedures? Any help would be greatly appreciated.
 

View 6 Replies View Related

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB Error Has Occurred. Error Code: 0x8000FFFF.

Jan 28, 2008

Hi All,

Recently in an SSIS package I am getting the following error for a particular Data flow task.





Error: 2008-01-25 12:01:48.58

Code: 0xC0202009

Source: Import Datasynapse Data User Events Source [3017]

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF.

End Error

Error: 2008-01-25 12:01:48.73

Code: 0xC004701A

Source: Import Datasynapse Data DTS.Pipeline

Description: component "User Events Source" (3017) failed the pre-execute phase and returned error code 0xC0202009.

End Error

Our guess is when the data size of User Events table is more it throws this error. If we try to transfer small subset of data it succeeds. What could be reason for this error?

Since this is very urgent, immediate response would be very much appreciated.

Thanks & Regards,
Prakash Srinivasan

View 4 Replies View Related

Help With 1205 Not Raised

Jul 23, 2005

Hi,I have an application that causes a dead lock at random. The issue I amhaving is, when the deadlock occurs, my applications is not recievingany errors from the DB. ie, during the deadlock SQLServer is returningan empty recordset and user is seeing a blank screen. The app logicdoes not go into the Try Catch statment in the C# code. I can'tunderstand why my app is not receiveing 1205 error from SQL server whendead lock occurs.Any ides why this is happening?Thanks_GJK

View 3 Replies View Related

Trap The Sql Errors Raised By Sql Server In Asp.net

Dec 8, 2006

hi i am running a stored procedure and i want to trap the error of that stored procedure and pass it on the user in the asp.net prog.
 
my stored procedure are running thru a class library using C#. i tried various options of creating a new sql connnection with out using the classlibrary, but i dont get any errors. the code s
used is as follows Dim conn As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("dbconnection1"))

Dim cmd As New SqlCommand("usp_ImportPlanDetails", conn)

cmd.CommandType = CommandType.StoredProcedure'cmd.Parameters.AddWithValue("@ClientId", Session("ClientId"))

AddHandler conn.InfoMessage, New SqlInfoMessageEventHandler(AddressOf MessageEventHandler)

conn.Close()





Private Sub MessageEventHandler(ByVal sender As System.Object, ByVal e As SqlInfoMessageEventArgs)

Dim strMessage As String

For Each sqle As SqlError In e.Errors

strMessage = "Message:" + sqle.Message + "Number:" + sqle.Number + "Procedure:" + sqle.Procedure + "Server:" + sqle.Server + "Source:" + sqle.Source + "State:" + sqle.State + "Line Number:" + sqle.LineNumber

' strMessage = String.Format("Message: {1}, Number: {2}, Procedure: {3}, Server: {4}, Source: {5}, State: {6}, Line Number: {7}" , new Object[]{sqle.Message, sqle.Number, sqle.Server, sqle.Source, sqle.State, sqle.LineNumber})

'Console.WriteLine(strMessage)

lblErrorMsg.Visible = True

lblErrorMsg.Text = strMessage

and also tried doing this  oImportPlan = New ImportPlan(System.Configuration.ConfigurationManager.AppSettings(APPSETTINGS_CONNECTION))


With oImportPlan
Try
.ClientID = Session("ClientId")
' .FileName = strFilePath1
.save()
Catch sqlex1 As SqlException
LogException(sqlex1)
End Try

End With
Catch sqlex As SqlException
LogException(sqlex)
End Try
Catch ex As Exception
lblErrorMsg.Text = "Error: Import Failed" + ex.Message
lblErrorMsg.Visible = True

End Try  but have no luck in displaying the errors, My stored procedure has raiseerrors, Please help me out 

View 2 Replies View Related

Event Notifications Don't Fire When Raised By Activated Procedure

Oct 23, 2006

I have an activated SP that is issuing PRINT statements.

These are raised as ErrorLog and EventLog events when using SQLProfiler

However if you attach an event notification for ERRORLOG and EVENTLOG, nothing appears in the queue. Any other ERRORLOG or EVENTLOG event caught by profiler is caught by the event notification as expected.

View 2 Replies View Related

Exec Pkg Task: Error 0xC0202009 While Preparing To Load The Package. An OLE DB Error Has Occurred. Error Code: 0x%1!8.8X!.

Feb 21, 2007

I cannot execute a package by using Execute Package task.
I supplied sa credentials to connection manager, and it shows the list of Packages on SQL Server but when running the task it says

Error 0xC0202009 while preparing to load the package. An OLE DB error has occurred. Error code: 0x%1!8.8X!.



Any clue ?


Thanks,
Fahad

View 1 Replies View Related

Transactions And Exceptions

Nov 1, 2006

if i have a loop that runs through records in a dataset like thisfor(int i=0;i<ds.Tables[0].Rows.Count;++i) and in this loop i have several sql commands that run as a transaction in a try / catch block like : try{ // do stuff}catch{    trans.RollBack();}how can i keep the loop going even if a transaction failed.  So the transaction works for each individual row.  if row 100 fails for whatever i would like the loop to continue running, do i just simply remove the "throw" and it will continue looping ? my catch block currently looks like catch(Exception ex){transaction.Rollback();activity.Log("Transaction aborted, rolling back. Error Message: " + ex.Message + " Stack Trace: " + ex.StackTrace.ToString());throw; }thanks,mcm

View 4 Replies View Related

Unknown Exceptions

Jan 22, 2008

I'm sure that the try part of following code are all executedand the session("isLogin") has set to Truebut it always catch a exceptionand redirect to error1.aspx can't figure it out 1 Try
2 mySqlCon = New SqlConnection(strMySqlCon)
3 mySqlCmd = New SqlCommand(strMySqlCmd, mySqlCon)
4
5 mySqlCon.Open()
6 myDataReader = mySqlCmd.ExecuteReader()
7
8 If myDataReader.Read() = True Then
9
10
11 webPwdMd5 = System.Web.Security.FormsAuthentication. _
12 HashPasswordForStoringInConfigFile(Me.TextBox1.Text, "MD5")
13
14 If webPwdMd5 = myDataReader.Item("password") Then
15 Session("isLogin") = True
16 'Me.TextBox1.Text = "ppp"
17 Response.Redirect("main.aspx")
18 Else
19 Session("islogin") = False
20 Me.Label1.Visible = True
21 End If
22 Else
23 Session("isLogin") = False
24 Me.Label1.Visible = True
25 End If
26
27 mySqlCon.Close()
28
29 Catch Myexception As Exception
30 Session("isLogin") = False
31 Response.Redirect("error1.aspx")
32
33 Finally
34
35 End Try
 

View 2 Replies View Related

Transactions And Exceptions

Dec 10, 2005

I am a novice with SQL, and I am failing to understand an aspect of Transactions.
The following is the code I have created, having referred to a handful of resources including MSDN documentation.
    public void CreateSection(Section section)    {        string sql =             @"INSERT INTO sectiontable (nodeid, title)              VALUES (@nodeid, @title)              SELECT Scope_Identity() FROM sectiontable";        SqlConnection connection = new SqlConnection(this.connectionString);        SqlCommand command = new SqlCommand(sql, connection);        command.Parameters.AddWithValue("@nodeid", section.Node.Id);        command.Parameters.AddWithValue("@title", section.Title);
        connection.Open();        SqlTransaction transaction = connection.BeginTransaction();        try        {            command.Transaction = transaction;            object result = command.ExecuteScalar();            if (result == null)                throw new DataException("Returned identity was invalid.");            section.Id = Convert.ToInt32(result);            transaction.Commit();        }        catch (Exception exception)        {            string message = "Could not create section.";            try            {                transaction.Rollback();                message += " Transaction was reversed.";            }            catch (SqlException booboo)            {                message += " An exception of type " + booboo.GetType();                message += " occurred while attempting to roll back the transaction.";            }            // Note: DataAccessException below is a custom class.            throw new DataAccessException(message, exception);        }        finally        {            connection.Close();        }    }        What seems clumsy is that we must have connection.Open() outside the try-catch block. The following cannot work, because the compiler notes the "Use of unassigned local variable 'transaction'" at the location shown below:
        SqlConnection connection = new SqlConnection(this.connectionString);        SqlTransaction transaction;        try        {            connection.Open();            transaction = connection.BeginTransaction();            // commands execute            transaction.Commit();        }        catch (Exception exception)        {            transaction.Rollback(); // <-- Compiler notes use of unassigned variable.                                    // (First testing the variable does not help.)            // handle exception.        }        finally        {            connection.Close();        }                The following also does not work, as the BeginTransaction() method must be called against an open connection.
        SqlConnection connection = new SqlConnection(this.connectionString);        SqlTransaction transaction = connection.BeginTransaction();        try        {            connection.Open();            // commands execute            transaction.Commit();        }        catch (Exception exception)        {            transaction.Rollback();            // handle exception.        }        finally        {            connection.Close();        }       
So, in MSDN documentation, the connection.Open() method is called outside the try-catch block (as shown in my full code). Yet, that same documentation notes that this method can lead to two types of exceptions. So it seems that the use of transactions forces an exception-throwing method to be used outside of a try-catch block. My question, then: is this unavoidable?

View 3 Replies View Related

Exceptions In Sql Server

Aug 23, 2001

we are converting Informix Stored procedures to SQL Server stored
procedures..
In Informix they have handled the exceptions as shown below,
ON EXCEPTION
LET @l_status = 1;
RETURN @l_delete,@l_status;
END EXCEPTION

We have to convert this to the corresponding SQL server statements..
How to ahbdle exceptions in SQL Server.

View 1 Replies View Related

Exceptions Info

Jan 11, 2007

Vikas writes "can any one help me in getting the list of exceptions and there types and how to tackle them."

View 1 Replies View Related

Migration Exceptions

Nov 29, 2006

Hi,
How should one deal with exceptions generated by the DTS to SSIS conversion wizard in sql server 2005?
Thanks

View 1 Replies View Related

Custom Sql Exceptions Through The CLR

Jan 9, 2006

Friends,

First off, congrats and thank you to everyone at Microsoft for all of the hard work they have put into Sql Server 2005 and .NET 2.0 - it is simply amazing technology.

On that note, I was wondering if it was possible to create my own custom exceptions that I can throw in my stored procedures and then catch in my application code?

For example, say I wanted to create a Custom Sql Exception called "DuplicateEmailInSqlDatabaseTableException" and then, within a stored procedure where data is being attempted to be inserted, I could check for a duplicate email record and then throw the exception.  At that point, I would like to be able to catch that exception in my C# data layer and work from there.

Is this possible?  I feel like it could be but am unsure where to start.

Shaun C McDonnell

View 5 Replies View Related

Self Join- Exceptions

Jan 3, 2008

I am trying to write a query that will only give me the data that is not in both queries. I need a query that will give me the data that is in the first query but not in the second query. I tried a union but that does not work. The date and PosType are important.






SELECT Symbol,PosType,HistDate

FROM EntityView

WHERE Histdate >'01/01/07' and PosType = 'S'

union



SELECT Symbol,PosType,HistDate
FROM EntityView

WHERE Histdate >'01/01/07' and PosType = 'S' and EntityCode = 'HIS'


View 3 Replies View Related

Want To Log CLR Exceptions In SQL Table

Jul 22, 2006

So I have some SQLCLR stored procedures, that use some .NET classes. I have a table in the database for exceptions, and I want to log all exceptions (except SqlExceptions of course) to that table.

I have the following example:



public partial class UserDefinedFunctions

{



[Microsoft.SqlServer.Server.SqlFunction(FillRowMethodName = "FillRow2", DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.Read,



TableDefinition = "fld_colname NVARCHAR(4000)")]

public static IEnumerable ExceptionTest()

{

// Some example from a website

List<string> names = new List<string>();

using (SqlConnection connection = new SqlConnection("context connection=true"))

{

connection.Open();

SqlCommand sqlCommand = connection.CreateCommand();

sqlCommand.CommandText = "select NAME from dbo.SYSCOLUMNS";

SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); // No exceptions

while (sqlDataReader.Read())

{

names.Add(sqlDataReader.GetValue(0).ToString()); // This works fine

}

Exception e = new Exception("foo");

MyExceptionLoggingClass.Log(e,connection); // This doesn't

}

return names;

}

public static void FillRow2(object row, out string str2)

{

str2 = (string)row;

}

}



public class MyExceptionLoggingClass

{

public static void Log(Exception ex, SqlConnection conn)

{

LogException(ex, conn);

}

private static void LogException(Exception ex, SqlConnection connection)

{



SqlCommand cmd = new SqlCommand("LogException", connection);



cmd.CommandType = System.Data.CommandType.StoredProcedure;



SqlParameter param = new SqlParameter("@message", ex.Message);

cmd.Parameters.Add(param);

param = new SqlParameter("@stackTrace", "test");

cmd.Parameters.Add(param);

param = new SqlParameter("@localtime", DateTime.UtcNow);

cmd.Parameters.Add(param);

try

{

cmd.ExecuteNonQuery(); // always throws IOE, as does SqlContext.Pipe.ExecuteAndSend(cmd);

}

catch (InvalidOperationException)

{

return;

}



}



The exception is: _COMPlusExceptionCode = -532459699 (couldn't find anything useful on that)



Ideally I don't want to be passing the connection to my class all the time, which is why I wanted to have overloaded methods, some that take the connection, others that don't, and open their own. Neither scenario works unfortunately.

If I run the code under LogException in my caller class (ExceptionTest) it works fine (I mean doesn't throw this exception, but I can't call from a SqlFunction - different issue, SQLCLR restriction).

I've been trying to debug this for a while now, and I'm running out of ideas, so any suggestion(s) would be highly appreciated.



Thanks!

View 17 Replies View Related

Upgrading From SP1 To SP2 Causes Setup Program To Terminate With MSP Error: 29527 / Error Code 1603

Apr 24, 2007



Trying to update my local developer version of SQL Server 2005 SP1 to SP2. The setup program terminates with the following information dumped from the logs. Not sure if it is related, but I recently installed the SQL Server 2005 Compact Edition (tools, runtime, etc) on the same development machine. It is a little too deep for me to figure out



Darryl



Here are the last few lines of the HotFix.Log



04/24/2007 14:46:48.374 MSP Error: 29527 The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is : Source File Name: datastorecachedpropertycollection.cpp

Compiler Timestamp: Wed Jun 14 16:27:59 2006

Function Name: CachedPropertyCollection::findProperty

Source Line Number: 138

----------------------------------------------------------

Failed to read property "InstallIds" {"MachineConfiguration", "", "DUTTONDARRYL1"} from cache

Source File Name: datastorecachedpropertycollection.cpp

Compiler Timestamp: Wed Jun 14 16:27:59 2006

Function Name: CachedPropertyCollection:etProperty

Source Line Number: 164

----------------------------------------------------------

Unable to write property into cache: IsClustered

Source File Name: datastoredatastorecacheschema.cpp

Compiler Timestamp: Wed Jun 14 16:28:00 2006

Function Name: DataStoreCacheSchema::writeProperty

Source Line Number: 115

----------------------------------------------------------

Unable

04/24/2007 14:46:48.694 MSP returned 1603: A fatal error occurred during installation.

04/24/2007 14:46:48.790 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"

04/24/2007 14:46:48.790 Registry: Cannot read registry key value "Debug"

04/24/2007 14:46:48.806 Copy Engine: Error, unable to install MSP file: c:f01fc31fd0988e3807HotFixSQLFilessqlrun_sql.msp

04/24/2007 14:46:48.822 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/24/2007 14:46:48.822 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800



******************************************************

Now the SQL9_Hotfix_KB921896_sqlrun_sql.msp.log shows this as the last few lines



MSI (s) (A4:38) [14:46:48:630]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server Database Services 2005 ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log.

MSI (s) (A4:38) [14:46:48:630]: Note: 1: 1729
MSI (s) (A4:38) [14:46:48:630]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:630]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A4:38) [14:46:48:646]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:646]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:646]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A4:38) [14:46:48:646]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:646]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A4:38) [14:46:48:646]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:646]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A4:38) [14:46:48:646]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:646]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A4:38) [14:46:48:662]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:678]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:678]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A4:38) [14:46:48:678]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:678]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A4:38) [14:46:48:678]: Transforming table Error.

MSI (s) (A4:38) [14:46:48:678]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A4:38) [14:46:48:678]: Product: Microsoft SQL Server 2005 -- Configuration failed.

MSI (s) (A4:38) [14:46:48:678]: Attempting to delete file c:WINDOWSInstaller6749ee3.msp
MSI (s) (A4:38) [14:46:48:678]: Unable to delete the file. LastError = 32
MSI (s) (A4:38) [14:46:48:694]: Cleaning up uninstalled install packages, if any exist
MSI (s) (A4:38) [14:46:48:694]: MainEngineThread is returning 1603
MSI (s) (A4:2C) [14:46:48:694]: Destroying RemoteAPI object.
MSI (s) (A4:04) [14:46:48:694]: Custom Action Manager thread ending.
=== Logging stopped: 4/24/2007 14:46:48 ===
MSI (c) (58:E4) [14:46:48:694]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (58:E4) [14:46:48:694]: MainEngineThread is returning 1603
=== Verbose logging stopped: 4/24/2007 14:46:48 ===



*************************************************************

The Summary.txt looks like this



Time: 04/24/2007 14:46:48.854
KB Number: KB921896
Machine: DUTTONDARRYL1
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Failed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Database Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 DEVELOPER
Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 DEVELOPER
Reporting Services (MSSQLSERVER) ENU SP1 9.00.2047.00 x86 DEVELOPER
Notification Services ENU SP1 9.00.2047.00 x86 DEVELOPER
Integration Services ENU SP1 9.00.2047.00 x86 DEVELOPER
SQL Server Native Client ENU 9.00.2047.00 x86
Client Components ENU SP1 9.1.2047 x86 DEVELOPER
MSXML 6.0 Parser ENU 6.00.3890.0 x86
SQLXML4 ENU 9.00.2047.00 x86
Backward Compatibility ENU 8.05.1704 x86
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : In Progress
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29527



View 8 Replies View Related

Error: The ProcessInput Method On Component OLE DB Destination (513) Failed With Error Code 0xC0202009

Mar 22, 2007

I'm trying to create a simple Data transfermation. I have a flat file that came of a unix server.. it's 177 bytes wide.. thought it was 175, but when I created the flat file connector, I could see some extra characters on the end.



My output is going to be an excel spreadsheet, I only want two columns from the input. I created an oledb jet 4.0 connection. and followed instructions from here :

http://aspalliance.com/889_Extracting_Data_from_a_Flat_File_with_SQL_Server_2005_Integration_Services

to create my datafow.



On my first attempt to dataflow, I ran into unicode errors and had to do this:



ran into a problem with unicode errors. went to the source for the flat file. for the output column in question changed to Unicode string [DT_WSTR].



When I run , here are the errors I get:

[OLE DB Destination [513]] Error: An OLE DB error has occurred. Error code: 0x80040E09. [DTS.Pipeline]

Error: The ProcessInput method on component "OLE DB Destination" (513) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.

[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0202009.

[GanchoFileSource [1]] Information: The total number of data rows processed for file "\ammia01dev04D$JCPcpmgancho_venta_20070321.sal" is 19036.

[GanchoFileSource [1]] Error: Setting the end of rowset for the buffer failed with error code 0xC0047020.

[DTS.Pipeline] Error: The PrimeOutput method on component "GanchoFileSource" (1) returned error code 0xC0209017. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.


View 4 Replies View Related

SQL Server 2005 Startup Error - TDSSNIClient... Error 0x5... Code 0x51

Jul 13, 2006

Hi,My SQL Server 2005 won't start - can anyone provide some help? Thisseems to be the most significant error:- TDSSNIClient initialization failed with error 0x5, status code 0x51.There was some info here, but the reg key described looks okay:- http://blogs.msdn.com/sql_protocols/I am running SQL Server 2005 64-bit Standard Edition. The server inquestion is the first node of an Active/Active Cluster. This firststarted happening while I was trying to add a share as a clusteredresource of the other node (not to this node's resources).I have not yet reinstalled SQL Server 2005 because I am hoping for moreexplanation of the problem and a possible fix.Thanks,Tom

View 1 Replies View Related

Error Handling In MSSQL - If Error During Call Remote Stored Prcedure I Need SQL Code To Continue...

Jul 20, 2005

Hi All,I want to catch the next MSSQL error in my SQL code with following continuecalculationsServer: Msg 17, Level 16, State 1, Line 1SQL Server does not exist or access denied.If REMOTE_SERVER_1 is inaccessible (as in (a) below) the executing of SQLwill not continue with (b) - I need the code in (b) to run despite whetherthe previous exec was successful or not - Any ideas?begin transaction(a) exec REMOTE_SERVER_1...bankinsert '1' , '1' , 1 , 0 , 0(b) print @@errorcommit transactionwhere REMOTE_SERVER_1 is link to server created byEXEC sp_addlinkedserver @server = 'REMOTE_SERVER_1', @srvproduct = '',@provider = 'SQLOLEDB', @datasrc = 'MYCOMP1', @catalog = 'mirror2'EXEC sp_addlinkedsrvlogin @rmtsrvname = 'REMOTE_SERVER_1', .....Exec sp_serveroption 'REMOTE_SERVER_1', 'data access', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc out', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'collation compatible', 'true'Any help will be greatly appreciated

View 1 Replies View Related

SSIS Error: The Connection Does Not Support Enlisting In Distributed Transaction. Error Code: 0x8000FFFF

Feb 29, 2008



Hi all,

can anyone tell me if an oleDb connection (provider is Jet 4.0 to Access database) can be enlisted in a Distributed Transaction?

The goal is to copy data from SqlServer to Access within a transaction.

Pier

View 10 Replies View Related

When I Use SSIS For Extract From OLAP Database, Then The Error Random Occurred,Error Code = 0x80040E05

May 10, 2007



I have tired for this!

When I use SSIS for extract data from ssas, that means,I use mdx query.

then random error occured.



Hope some one can understand my poor English....



And the Error Info show below.






Code Snippet

Error: 0xC0202009 at Data Flow Task - For Individual User Tech Points, OLE DB Source 1 1 [31]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E05.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Analysis Services 2005" Hresult: 0x00000001 Description: "Error Code = 0x80040E05, External Code = 0x00000000:.".
Error: 0xC004701A at Data Flow Task - For Individual User Tech Points, DTS.Pipeline: component "OLE DB Source 1 1" (31) failed the pre-execute phase and returned error code 0xC0202009.

View 6 Replies View Related

MS SQL Server Maintenance Plan Failed: Error Code 0x534. [SQLSTATE 42000] (Error 15404))

May 3, 2008



hello,

we have changed the name of MS SQL server 2005 from XYZ to ABC using


sp_dropserver <old_name>

GO

sp_addserver <new_name>, local

GO


Now our maitenance plan is getting failed we are not able to execute backup jobs we are getting following error


Date 03.05.2008 16:00:00
Log Job History (ADM_AdminDB_TP_Backup.Subplan_1)

Step ID 0
Server ABC
Job Name ADM_AdminDB_TP_Backup.Subplan_1
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
The job failed. Unable to determine if the owner (XYZSQLServer) of job ADM_AdminDB_TP_Backup.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'XYZSQLServer', error code 0x534. [SQLSTATE 42000] (Error 15404)).

please help us in this issue

View 13 Replies View Related

[ActiveX Script Task] Error: Retrieving The File Name For A Component Failed With Error Code 0x001B6438.

Jul 28, 2006

This error occurs when the ActiveX task tries to execute:

[ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x001B6438.

Anybody know how to troubleshoot these errors? I can't find anything on this error code. The same script works in DTS.







View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved