How To Get More Descriptive Error Messages In SSIS,Programatically?

Apr 28, 2008



hi all,
I am developing an application in C# which creates SSIS package programatically.These packages perform various activities like transfering data from one server to another,extract data from table,transfering data from sql to msaccess etc.Here I am using the following code to get the description of the SSIS errorcode.




Code Snippet
Public static String GetErrMesg(IDTSComponentMetaData90 MD,Exception Err)
{
try
{
COMException comEx=Err as COMException;
return MD.GetErrorDescription(comEx.ErrorCode);
}
Catch
{
return Err.Message;
}




For example if the error code is 0xC0204018,the application shows its equivalent description as
"The "%1!s!" has a precision that is not valid. The precision must be between %2!ld! and %3!ld! "


But the actual error message is "The Output column "fund" has a precision that is not valid. The precision must be between 1 and 18"

My question is how to show more descriptive error message..like how to replace "%1!s!" to the actual field.


Please give ur suggestions...


View 1 Replies


ADVERTISEMENT

Execute Process Task - Error/Return Code Listing With Descriptive Messages?

May 28, 2008



I'm having a hard time locating a listing of potential error codes and the meanings for the Execute Process Task component...can someone assist?

Thanks

View 1 Replies View Related

SSIS Error In SQL Agent Job Not Very Descriptive

Mar 14, 2008

Hi there,

I hope I'm posting this in the right section but I have a few SSIS packages that run as SQL Agent jobs that bomb out and does not give me much of a description as why it did. I only get a message that the package failed.

On a different machine, a sql cluster more specific, the job history use to be more elaborate and told me exactly which component errored out.

Is there a setting that I must set somewhere to get a more descriptive error message in the job history?

Thanks in advance
Mike

View 10 Replies View Related

Need More Descriptive Error Message

Aug 17, 2007

Hi,

Currently I have an event handler on my package that executes a script task on the "OnError" event (at the package level).

One of the error handler's script task's job is to capture the "System::ErrorDescription" and store it to a user variable which is then later sent in an email. That part works fine.

But what I am wondering is, there a way to make the error description more descriptive?? I would like to send a custom error message from one of the tasks in my package, if possible. The task is a script task.

Currently, the "System::ErrorDescription" is just:
The Script returned a failure result.

Which isn't too terribly descriptive! But this is the default error description.

Is there something I can do to change the default error message for my script task?? Is there a way I can set the "System::ErrorDescription" on this script task, perhaps? Or is there another way?

Thanks much

View 3 Replies View Related

Cryptic And Useless SSIS Error Messages

Aug 22, 2007

First of all, please let me prefix this by saying AAARRRRRGGGGGHH!!!

Troubleshooting an SSIS package is not even close to easy. The error messages are incredibly cryptic and are anything but useful. It is absurd that for most of the errors that I get, I find myself putting the error codes into Google to find out what they mean and how to address them. Since there is indeed an known exception, why not include a "descriptive" description of the error?

Okay, enough with the venting. Sorry about that...

What I really came here to ask is this, what in the world does this error message REALLY mean? I have found nothing useful on the Internet so far. The resulting forums and blogs with the error code do not apply to what I am doing.

Error: The attempt to send a row to SQL Server failed with error code 0x80004005.

- - - -
- Will -
- - - -
http://www.strohlsitedesign.com
http://blog.strohlsitedesign.com/
http://skins.strohlsitedesign.com/

View 20 Replies View Related

Package Fails Without Descriptive Error Message

Sep 18, 2007

The following error occurred but did not provide any additional info.

[DTS.Pipeline] Error: The PrimeOutput method on component "Pgrs - tr_hist" (14596) returned error code 0xC02090F5. 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.

For this package I am trying to use DataDirect's ODBC driver for a Progress OpenEdge Database version 9.1E to move data to SQL Server 2005 in order to make use of SQL's BI suite. I have consulted the DataDirect and have that the driver is functioning properly. The driver works perfectly from another application. They suggest that the problem is in the the datareader's or the connection manager's implementation of the driver.

Please tell me what is the cause of this or at least how to troubleshoot this problem.

View 18 Replies View Related

Strange Error Messages Running SSIS Package

May 18, 2006

This package which is a child package has been running successfully for quite some time now. All of a sudden we are getting these intermittant error messages. Does anyone have any ideas what to do or check for?

thanks

===========================

Error portion

Error: 0xC0047012 at CF-DFT Oracle Sales Fact, DTS.Pipeline: A buffer failed while allocating 100483760 bytes.

Error: 0xC02020C4 at CF-DFT Oracle Sales Fact, order line id [1]: The attempt to add a row to the Data Flow task buffer failed with error code 0x8007000E.

Error: 0xC0047011 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The system reports 30 percent memory load. There are 8587960320 bytes of physical memory with 5972680704 bytes free. There are 2147352576 bytes of virtual memory with 1324290048 bytes free. The paging file has 12673945600 bytes with 10005012480 bytes free.

Error: 0xC0047038 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The PrimeOutput method on component "order line id" (1) returned error code 0xC02020C4. 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.

Error: 0xC0047056 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The Data Flow task failed to create a buffer to call PrimeOutput for output "Union All" (13359) on component "Union All Output 1" (13361). This error usually occurs due to an out-of-memory condition.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "SourceThread1" has exited with error code 0xC0047038.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread2" has exited with error code 0x8007000E.

Error: 0xC0047039 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread3" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047039 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread3" has exited with error code 0xC0047039.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread1" has exited with error code 0xC0047039.

Error: 0xC0047039 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.

====================================================

Complete child package log

Executing ExecutePackageTask: D:ssissrwpackagesSRW_ORACLE_SALES_FTBL.dtsx

Information: 0x40016041 at SRW_ORACLE_SALES_FTBL: The package is attempting to configure from the XML file "D:SSISconfigurationCONFIG-STAGE1.dtsConfig".

Information: 0x40016040 at SRW_ORACLE_SALES_FTBL: The package is attempting to configure from SQL Server using the configuration string ""MSSQL-CONFIG";"[dbo].[SSIS_Configurations]";"System Configuration Settings";".

Information: 0x40016040 at SRW_ORACLE_SALES_FTBL: The package is attempting to configure from SQL Server using the configuration string ""MSSQL-CONFIG";"[dbo].[SRW_SSIS_Configurations]";"SRW Main Configurations";".

Information: 0x4004300A at CF-DFT Oracle Sales Fact, DTS.Pipeline: Validation phase is beginning.

Warning: 0x802092A7 at CF-DFT Oracle Sales Fact, TEMP OUTPUT [998]: Truncation may occur due to inserting data from data flow column "IC_ORDER" with a length of 240 to database column "IC_ORDER" with a length of 1.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "SERIAL_NUMBER" (2680) on output "Sort Output" (2453) and component "Sort 1" (2451) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "ORG_ID" (13377) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "CUST_TRX_TYPE_ID" (13428) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "Data Conversion 1.Copy of CUST_TRX_TYPE_ID" (13443) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "GL_ID_REV" (13449) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "Copy of GL_ID_REV" (13458) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Information: 0x4004300A at CF-DFT Oracle Sales Fact, DTS.Pipeline: Validation phase is beginning.

Warning: 0x802092A7 at CF-DFT Oracle Sales Fact, TEMP OUTPUT [998]: Truncation may occur due to inserting data from data flow column "IC_ORDER" with a length of 240 to database column "IC_ORDER" with a length of 1.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "SERIAL_NUMBER" (2680) on output "Sort Output" (2453) and component "Sort 1" (2451) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "ORG_ID" (13377) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "CUST_TRX_TYPE_ID" (13428) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "Data Conversion 1.Copy of CUST_TRX_TYPE_ID" (13443) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "GL_ID_REV" (13449) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "Copy of GL_ID_REV" (13458) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Information: 0x4004300A at CF-DFT Oracle Sales Fact, DTS.Pipeline: Validation phase is beginning.

Warning: 0x802092A7 at CF-DFT Oracle Sales Fact, TEMP OUTPUT [998]: Truncation may occur due to inserting data from data flow column "IC_ORDER" with a length of 240 to database column "IC_ORDER" with a length of 1.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "SERIAL_NUMBER" (2680) on output "Sort Output" (2453) and component "Sort 1" (2451) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "ORG_ID" (13377) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "CUST_TRX_TYPE_ID" (13428) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "Data Conversion 1.Copy of CUST_TRX_TYPE_ID" (13443) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "GL_ID_REV" (13449) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Warning: 0x80047076 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The output column "Copy of GL_ID_REV" (13458) on output "Union All Output 1" (13361) and component "Union All" (13359) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Information: 0x40043006 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Prepare for Execute phase is beginning.

Information: 0x40043007 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Pre-Execute phase is beginning.

Information: 0x400490F4 at CF-DFT Oracle Sales Fact, REV GL SEGS [307]: component "REV GL SEGS" (307) has cached 780 rows.

Information: 0x400490F4 at CF-DFT Oracle Sales Fact, get oper unit [813]: component "get oper unit" (813) has cached 12 rows.

Warning: 0x802090E4 at CF-DFT Oracle Sales Fact, get oper unit [813]: The Lookup transformation encountered duplicate reference key values when caching reference data. The Lookup transformation found duplicate key values when caching metadata in PreExecute. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.

Information: 0x400490F4 at CF-DFT Oracle Sales Fact, get header txn type for IC flag [13685]: component "get header txn type for IC flag" (13685) has cached 768 rows.

Information: 0x4004300C at CF-DFT Oracle Sales Fact, DTS.Pipeline: Execute phase is beginning.

Information: 0x4004800D at CF-DFT Oracle Sales Fact, DTS.Pipeline: The buffer manager failed a memory allocation call for 100484768 bytes, but was unable to swap out any buffers to relieve memory pressure. 83 buffers were considered and 83 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.

Error: 0xC0047012 at CF-DFT Oracle Sales Fact, DTS.Pipeline: A buffer failed while allocating 100484768 bytes.

Error: 0xC0047011 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The system reports 31 percent memory load. There are 8587960320 bytes of physical memory with 5869387776 bytes free. There are 2147352576 bytes of virtual memory with 1223802880 bytes free. The paging file has 12673945600 bytes with 9901600768 bytes free.

Information: 0x4004800D at CF-DFT Oracle Sales Fact, DTS.Pipeline: The buffer manager failed a memory allocation call for 100483760 bytes, but was unable to swap out any buffers to relieve memory pressure. 162 buffers were considered and 162 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.

Error: 0xC0047012 at CF-DFT Oracle Sales Fact, DTS.Pipeline: A buffer failed while allocating 100483760 bytes.

Error: 0xC02020C4 at CF-DFT Oracle Sales Fact, order line id [1]: The attempt to add a row to the Data Flow task buffer failed with error code 0x8007000E.

Error: 0xC0047011 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The system reports 30 percent memory load. There are 8587960320 bytes of physical memory with 5972680704 bytes free. There are 2147352576 bytes of virtual memory with 1324290048 bytes free. The paging file has 12673945600 bytes with 10005012480 bytes free.

Error: 0xC0047038 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The PrimeOutput method on component "order line id" (1) returned error code 0xC02020C4. 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.

Error: 0xC0047056 at CF-DFT Oracle Sales Fact, DTS.Pipeline: The Data Flow task failed to create a buffer to call PrimeOutput for output "Union All" (13359) on component "Union All Output 1" (13361). This error usually occurs due to an out-of-memory condition.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "SourceThread1" has exited with error code 0xC0047038.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread2" has exited with error code 0x8007000E.

Error: 0xC0047039 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread3" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047039 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread3" has exited with error code 0xC0047039.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread1" has exited with error code 0xC0047039.

Error: 0xC0047039 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.

Information: 0x40043008 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Post Execute phase is beginning.

Information: 0x402090DF at CF-DFT Oracle Sales Fact, TEMP OUTPUT [998]: The final commit for the data insertion has started.

Information: 0x402090E0 at CF-DFT Oracle Sales Fact, TEMP OUTPUT [998]: The final commit for the data insertion has ended.

Information: 0x40043009 at CF-DFT Oracle Sales Fact, DTS.Pipeline: Cleanup phase is beginning.

Information: 0x4004300B at CF-DFT Oracle Sales Fact, DTS.Pipeline: "component "TEMP OUTPUT" (998)" wrote 0 rows.

Task failed: CF-DFT Oracle Sales Fact

Warning: 0x80019002 at SRW_ORACLE_SALES_FTBL: The Execution method succeeded, but the number of errors raised (15) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

Task failed: CF-EPGT SRW_ORACLE_SALES_FTBL

Warning: 0x80019002 at CF-SQC Facts: The Execution method succeeded, but the number of errors raised (15) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

Warning: 0x80019002 at SRW_MAIN: The Execution method succeeded, but the number of errors raised (15) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "SRW_Main.dtsx" finished: Failure.

View 9 Replies View Related

Developing SSIS Pacakges Programatically Using .NET

Oct 22, 2007

Hi,

I have .NEt web application where i have to tranfer large number of records (50,000 to 1,00,000) from one DB to another DB.I want to use ssis pacakge to do this task , but my requirement is to build this ssis pacakge dynamically using .NET framework.

Is it possible to develop SSIS pacakge from scratch using .net programming?
Suggest me any other alternative options if you have ?

Thanks,
Vaishali

View 5 Replies View Related

How To Launch Programatically A SSIS Package?

May 22, 2006

Dear all,

I wrote this post others times but the answer did not satisfied so that I'd like to know if really anyone has ever used or experienced with this possibility. No by .Net language rather than Vb 6.0 or ASP or even instanciacing DMO library.

According this link http://support.microsoft.com/?kbid=817248 it seems possible but I haven't idea if possible keeping in mind that it has been made by yourself no for others... So that, I mean, these assemblies comes along with Sql Server 2005 installation.

Thanks a lot for your support,

View 13 Replies View Related

How To Get Rowcount In A Programatically Created SSIS Package

Oct 22, 2007

Hi,

I created a SSIS Package programatically based on the few threads here in this forum. This package just has a data flow task, during data transfer for every 1000 rows or so I want to update the status in a table in the database.

How do I achieve this?

As of now I just have a source and a destination, no transformations in between the flow. I'm not sure if rowcount will help, when I tried it using a onprogress even handler it always showed up as zero.

Thanks

View 6 Replies View Related

Executing An SSIS Package Programatically Through Excel VBA?

Jan 29, 2008

Hi Everyone:

Is it possible to create a package through the SQL Server Business Intelligence Studio, and then execute that package through an Excel file (by calling the package through VBA?).

I need some advice on the ways I can execute the package other than via command line utilities. Can you use Visual Basic 6.0? .NET?

Please advise,
Jason

View 5 Replies View Related

Suppress Messages In SSIS

Nov 28, 2007

Hi,

I am running SSIS package using command line. However I want to suppress the messages that come and I want to display my own messages. How can I do that?

For eg: I am using File System task to transfer a file from source to destination. How will i tell this to the user who is seeing this executed at the command line?

thanks.

View 1 Replies View Related

Error Adding Two OledbCommands To A Package Programatically

Dec 11, 2006

Hi,

I need to add two oledbcommand tranformations in my package.

i add the commands like this:

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

this.OledbCommand1 = this.dataflow.ComponentMetaDataCollection.New();

this.OledbCommand1.ComponentClassID = "DTSTransform.OleDBCommand.1";

this.OledbCommand1.Name = "ChangingColumnAttribute";

this.OledbCommand1.Description = "ChangingColumnAttribute";

CManagedComponentWrapper oledbinstance = this.OledbCommand1.Instantiate();

oledbinstance.ProvideComponentProperties();

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

this.OledbCommand2 = this.dataflow.ComponentMetaDataCollection.New();

this.OledbCommand2.ComponentClassID = "DTSTransform.OleDBCommand.1";

this.OledbCommand2.Description = "UpdateHistoryColumnAttribute";

OledbCommand2.Name = "OleDBCommand2";

CManagedComponentWrapper oledbinstance1 = this.OledbCommand2.Instantiate();

oledbinstance1.ProvideComponentProperties();

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

i get the following error message during package validation:

OnError
ErrorCode -1073451000
Source DataFlow
SubComponent DTS.Pipeline
Description The package contains two objects with the duplicate name of "compone
nt "OLE DB Command" (719)" and "component "OLE DB Command" (701)".



Please advice.

View 5 Replies View Related

Function Problem (Sorry Thats Not Very Descriptive)

Mar 11, 2004

Hiya Peeps,
Got a basic update table:

CREATE PROCEDURE CraigSource2Dest AS
INSERT INTO TCraigDest(
MyCertN
,MyResult
,MySpec)
SELECT
TOP 10 dbo.TCertResults.ICertResultsN
,dbo.TCertResults.ICertValue
,dbo.fx_source2dest(dbo.TCertResults.ICertValue)
FROM dbo.TCertResults
GO

As you can see theres a function in the middle of select statement, that returns a value based on what passed into it. The procedure above works fine.

The problem I have is this, can I use the value that the function returns later in the SELECT statement. As an example lets say the table had 4 columns and in the fourth column I wanted to insert the value that the function returned + the word 'TEST'.

I've tried 2 methods of doing this the first :
CREATE PROCEDURE CraigSource2Dest AS
INSERT INTO TCraigDest
(
MyCertN,
MyResult,
MySpec,
MyDerivedColumn
)
SELECT TOP 10 dbo.TCertResults.ICertResultsN
,dbo.TCertResults.ICertValue
,dbo.fx_source2dest(dbo.TCertResults.ICertValue) AS MyNewValue
,MyNewValue + 'TEST'
FROM dbo.TCertResults
GO

When I try this I get the error that MyNewValue is not a valid column name.

And the 2nd method was to try to assign the value returned from the function to a variable. Something like this

CREATE PROCEDURE CraigSource2Dest AS
DECLARE @MyNewValue AS VARCHAR(65)
INSERT INTO TCraigDest
(
MyCertN
,MyResult
,MySpec
,MyDerivedColumn)
SELECT TOP 10 dbo.TCertResults.ICertResultsN
,dbo.TCertResults.ICertValue
,@MyNewValue = dbo.fx_source2dest(dbo.TCertResults.ICertValue)
,@MyNewValue + 'TEST'
FROM dbo.TCertResults
GO

This way gives me ERROR 141 : A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

Bit stumped really up to the point that I don't even know what to search for to look for help.

Any help would be grand.

View 2 Replies View Related

SSIS Retrieving Output Messages

Aug 29, 2007

Hi,
I am designing a simple SSIS package that tests database connectivity. To use the same connection for each database, I am changing the "InitialCatalog" property of the Connection Manager object to test each database in a server.

When the connection fails, I can capture a generic error message from the exception in a Try...Catch block, but it doesn't tell me why a connection attempt failed. I have tried Package Logging as well and that was actually less helpful.

I would have stopped there except the Output Window and Progress/Execution Results tabs BOTH show that the reason for the error was a login failure. I am trying to capture the message that appears in either of these windows as they are the most helpful.

Has anyone been able to programmatically capture these messages?

Thanks!!!

View 5 Replies View Related

Urgent : DB-Library Error 10007: General SQL Server Error: Check Messages From The SQL

Jul 20, 2005

DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh

View 1 Replies View Related

Creating Dynamic Email Messages On SSIS

Jul 20, 2007

Do you guys have any good links or suggestions relative to this?

View 1 Replies View Related

Friendly Way To Look At Sqlagent Ssis Messages Without Exporting Rest Of Log

Apr 13, 2008

I just started playing with sqlagent and am finding that viewing a specific message from an ssis step is cumbersome when other entries are also in the log. Exporting seems only able to export all history entries. Viewing right in the log viewer leads to a series of boundary expansions and right scrolls that dont seem convenient for quick identification of a problem in a medium sized ssis message. Right clicking on the message in the viewer seems like it is preparing the message for possible copy but it seems to end there. I'm already familiar with the different levels of verbosity available in the command line. Dont see anything useful on the web.

Is there a user friendly way to copy the contents of a specific message for perhaps pasting to notepad , so that problem identification is facilitated? Is there a not so user friendly way available, one taht doest involve 1st exporting the entire log?

View 7 Replies View Related

No Help From The Error Messages

Dec 4, 2007

I am writing a tracking system. There is a table in the Sql Server 2000 database that contains a column for the user's ntid, the page they visited, the date of the last visit, a column each to track hits for the current year and a previous year column (basically for archiveing and reporting purposes), and 12 columns for hits per month (obviously, one per column). To record a hit, my unit determined we would only track one hit per day, so basically, there are 3 possible outcomes I needed to account for :
1) A user had never hit the page before, so I need to record the user's ID, the page they hit for the first time (since it won't exist yet), increment the year counter for that user on that page, and then determine what month column counter should be incremented as well.
2) A user had hit the page before, but not on this same day, so I need to update the row for that user on that page, changing the last visit field to reflect the current date, and icnrementing the appropriate counters.
3) A user had hit the page already on the same day, so basically, nothing should be changed whatsoever. No action should be taken.
I wrote a stored procedure to attempt to accomplish that logic, and though it's probably not very pretty, I was surprised at how few errors I got on my first Syntax check. Here's the stored procedure :
CREATE PROCEDURE sp_hitMe@ntid varchar(10),@page varchar(50),@thisHit datetimeASSET NOCOUNT ON
DECLARE @tempDate datetimeDECLARE @yearCount intDECLARE @monthCount intDECLARE @inMonth varchar(20)DECLARE @monthColumn varchar(10)SET @inMonth = DATENAME(mm, @thisHit)SET @monthColumn =  CASE   WHEN @inMonth = 'January' THEN 'hitsInJan'  WHEN @inMonth = 'February' THEN 'hitsInFeb'  WHEN @inMonth = 'March' THEN 'hitsInMar'  WHEN @inMonth = 'April' THEN 'hitsInApr'  WHEN @inMonth = 'May' THEN 'hitsInMay'  WHEN @inMonth = 'June' THEN 'hitsInJun'  WHEN @inMonth = 'July' THEN 'hitsInJul'  WHEN @inMonth = 'August' THEN 'hitsInAug'  WHEN @inMonth = 'September' THEN 'hitsInSep'  WHEN @inMonth = 'October' THEN 'hitsInOct'  WHEN @inMonth = 'November' THEN 'hitsInNov'  WHEN @inMonth = 'December' THEN 'hitsInDec'  END DECLARE @insString varchar(500)DECLARE @updString varchar(500)SET @insString = 'INSERT INTO tblTracking (ntid, page, lastVisit, hitsThisYear, ' + @monthColumn + ') VALUES (' + @ntid + ', ' + @page + ', ' + @thisHit + ', 1, 1)'
if exists(select * from tblTracking where ntid = @ntid and @page = page) begin  if exists(select * from tblTracking where lastVisit = @thisHit)   begin    -- DO NOTHING!   end  else   begin    DECLARE @theColumn varchar (100)    SET @theColumn = 'SELECT ' + @monthColumn + ' FROM tblTracking WHERE ntid = @ntid AND @page = page'    SET @yearCount = (SELECT hitsThisYear FROM tblTracking WHERE ntid = @ntid AND @page = page) + 1    SET @monthCount = (Exec @theColumn)    SET @monthCount = @monthCount + 1    SET @updString = 'UPDATE tblTracking SET lastVisit = ' + @thisHit + ', hitsThisYear = ' + @yearCount + ', ' + @monthColumn + ' = ' + @monthCount + ' WHERE ntid = @ntid AND @page = page'    Exec @updString   end endelse begin  Exec @insString endGO
And to my surprise, the only 3 errors I got were :
Server: Msg 156, Level 15, State 1, Procedure sp_hitMe, Line 39Incorrect syntax near the keyword 'end'.Server: Msg 156, Level 15, State 1, Procedure sp_hitMe, Line 45Incorrect syntax near the keyword 'Exec'.Server: Msg 156, Level 15, State 1, Procedure sp_hitMe, Line 50Incorrect syntax near the keyword 'end'.
However, these are of course so vague as to be useless to me. What's wrong with the procedure? What have I missed?

View 9 Replies View Related

SQL Error Messages

Mar 9, 1999

Is there a way to return the SQL Native error to a Visual Basic program?

View 3 Replies View Related

Error Messages

Mar 3, 1999

Hey everyone,

Here is what I'm doing:

exec xp_sendmail @recipients = 'ampx@hotmail.com',
@query = 'select * from information where recid <= 10',
@subject = 'Query test',
@message = 'hello',
@attach_results = 'TRUE',
@width = 250

I get this error:

Msg 2812, Level 16, State 4
Stored procedure 'xp_sendmail' not found.

Anyone know why? isn't xp_sendmail a function of SQL?

Thanks

View 1 Replies View Related

*** DTS Error Messages ***

Jul 20, 2005

Hello,I'd like to know if I use DTS. If I use it immediately, I can see the errorin the dialog box, instead, if I use it with scheduling, where Can I checkthe error ?ThanksSaimon(Florence)

View 2 Replies View Related

Looking Up Error Messages

Mar 10, 2008



Greetings
I'm learning SSIS and BIDS. I have extreme difficulty making sense of the error messages that come out.

First of all, what do the numbers mean? Each column, error, etc. is assigned a number that obviously means something yet I cannot relate them to anything. For example: The output column Name (713) on output Test (15) and Component (15) -- My table doesn't have 713 columns in it...

Then there are the error codes that obviously contain something useful. For example:

DTS Error: Microsoft.SqlServer.Dts.Runtime.TaskHost/QueueFuzzyName [33]SIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (46)" failed because error code 0xC020907D occurred, and the error row disposition on "input "OLE DB Destination Input" (46)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.


Where would I look up: DTS_E_INDUCEDTRANSFORMFAILUREONERROR and 0xC020907D? I understand that it tried to convert a value in something numbered 46 (no idea what that is) and the conversion failed. But that's it. How do I transmogrify 46 to something I can look at. I'm a little fuzzy on what a Destination Input is. Isn't an output a destination?

Or this one:

Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors"
Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.

I have absolutely no idea what this means except that many things happened, one of them failed, I have an error of some sort and it's error code is 0x80040E21. It must be important, it's in there twice, but what does it mean?

I'm thinking that in the help somewhere all these error messages are listed and I can look them up, but I can't seem to find it anywhere. Am I supposed to be converting them to decimal first?

Any advice from you experts would be much appreciated.

View 5 Replies View Related

SqlBulkCopy Error Messages

Sep 6, 2006

I'm using SqlBulkCopy.  Does anyone know how I can output what row (its column names) are throwing a duplicate primary key message when I bulkCopy.WriteToServer(datatable1)?Thanks 

View 1 Replies View Related

Dynamic SQL Error Messages!

Mar 3, 2008

Have this dynamic sql statement that I'm working on.  It works fine outside the execute (running the query by iteself) and prints fine but when I execute it, I get errors.  Spacing is good.  Here is the SQL statement.
 set @sql = 'insert into #participantInfo (strfirstname,strlastname,strindividualfk,strusername,dtelastlogin,blninactive,fk_intrightid,imgPhoto, stre_mail,strmiddleinitial,straddress1,straddress2,strcity,fk_intlocationid,strpostalcode,strhomephone,strbusinessphone,strmiscinfo1, strmiscinfo2,strsecretquestion,dteDateOfBirth,intgender,strsecretanswer)  select p.strfirstname,p.strlastname,p.strindividualfk,l.strusername,l.dtelastlogin,p.blninactive,r.fk_intrightid,p.imgPhoto, p.stre_mail,p.strmiddleinitial,p.straddress1,p.straddress2,p.strcity,p.fk_intlocationid,p.strpostalcode,p.strhomephone,p.strbusinessphone, p.strmiscinfo1,p.strmiscinfo2,l.strsecretquestion,p.dteDateOfBirth,p.intgender,l.strsecretanswer  from tblparticipants p inner join  tblparticipantrights r on p.strindividualfk = r.strindividualfk inner join  tblparticipantlogin l on p.strindividualfk = l.strindividualfk  where p.fk_strsubgroupid = ''' +  @strsubgroupid + ''''
exec (@sql)
Error messages are:
Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'tblparticipants'.Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'tblparticipantrights'.Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'tblparticipantlogin'. 
Anyone see what may be the cause?
 thanks ^_^

View 6 Replies View Related

Error Messages To A File?

Aug 23, 2001

How to write the error messages generated in a job to a file?Thanks.

View 1 Replies View Related

How To Get More Info For Error Messages

Jul 10, 2000

So far I have not been able to figure out how to get more info
regarding the sql server errors. For example, I get this error
from sql server query analyzer (this just an example):

-----------
Server: Msg 128, Level 15, State 1, Line 5
The name 'does' is not permitted in this context.
Only constants, expressions, or variables allowed here.
Column names are not permitted.
-----------


Is there a way to find more information regarding this error, or
like Oracle has MeataLink, where you can search, if someone else
already got this error and how it got resolved?

Or how you folks go about resolving errors you get? Is it based
on trail and error, or experience (like already encountered this
type before) etc.?

View 1 Replies View Related

Dbcc Error Messages

Sep 23, 1999

If you find error messages in the dbcc results, how do you find out which table it is according to the ID number 875696?

ie:

Checking 875696
The number of data pages in this table is .....

View 3 Replies View Related

SQL Server Error Messages

Jul 30, 2007

Hi All,

I was wondering if anybody knows where to get a complete list of SQL Server error messages. I am writing a stored procedure that scans SQL Server Logs for errors and if there are errors in the logs, I get paged.

Thanks.

View 2 Replies View Related

Logging Error Messages

May 7, 2002

Hi,

How can I avoid certain messages from SQL Server being recorded into the Event viewer ?
For example, every time I truncate the transaction log with 'Backup log with truncate_only', It is being recorded into the Event viewer as an Error. But, I know that it is not an error.
How can I avoid this ?

Thanks

View 1 Replies View Related

PLEASE HELP!!! Multiple Error Messages

Jan 3, 2008

I have a SS2K5 stored procedure that executes 2 others stored procedures
sp_zero1 and sp_zero2
sp_zero1 and sp_zero2 do the same thing ... raises an Divide by zero error
I need to (print / select into a database) both error messages using just one
try catch block instead of 2 blocks like in the next example:


-- THIS IS THE WORKING CODE THAT I DONT WANT
BEGIN TRY
exec sp_zero1
END TRY
BEGIN CATCH
PRINT ERROR_MESSAGE()
PRINT ERROR_PROCEDURE()
END CATCH
BEGIN TRY
exec sp_zero2
END TRY
BEGIN CATCH
print ERROR_MESSAGE()
print ERROR_PROCEDURE()
END CATCH



if I try the next code

--THIS IS THE NON WORKING CODE
BEGIN TRY
exec sp_zero1
exec sp_zero2
END TRY
BEGIN CATCH
print ERROR_MESSAGE()
print ERROR_PROCEDURE()
END CATCH

only the first error message is printed and the execution is stopped

This is a generic example ... in reality I have a stored procedure that executes tens and hundreds of other stored procedures ... so thats the reason I need just one block of try catch instead of hundreds of blocks

thank you

View 6 Replies View Related

Reading The Error Messages

May 22, 2006

when a statement fails and it tell me for example

Server: Msg 137, Level 15, State 2, Procedure spinsertnew, Line 266
Must declare the variable '@'.

How can I find which line it is using query manager?

View 13 Replies View Related

Weird Messages In Error Log

Mar 28, 2008

Hi,
I am getting these messages in error log. What do I needd to do?

2008-03-27 09:34:54.76 spid74 Using 'dbghelp.dll' version '4.0.5'
2008-03-27 09:34:54.76 spid74 ***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0014.txt
2008-03-27 09:34:54.76 spid74 SqlDumpExceptionHandler: Process 74 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2008-03-27 09:34:54.76 spid74 * *******************************************************************************
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 * BEGIN STACK DUMP:
2008-03-27 09:34:54.76 spid74 * 03/27/08 09:34:54 spid 74
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 * Exception Address = 7C80EEF0 Module(ntdll+0000EEF0)
2008-03-27 09:34:54.76 spid74 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2008-03-27 09:34:54.76 spid74 * Access Violation occurred reading address 00000001
2008-03-27 09:34:54.76 spid74 * Input Buffer 87 bytes -
2008-03-27 09:34:54.76 spid74 * C a m s _ V a l 15 00 43 00 61 00 6d 00 73 00 5f 00 56 00 61 00 6c 00
2008-03-27 09:34:54.76 spid74 * i d a t e P a s s 69 00 64 00 61 00 74 00 65 00 50 00 61 00 73 00 73 00
2008-03-27 09:34:54.76 spid74 * w o r d § 77 00 6f 00 72 00 64 00 00 00 00 00 a7 0f 00 09 04 00
2008-03-27 09:34:54.76 spid74 * 2 JFINCH § 01 32 06 00 4a 46 49 4e 43 48 00 00 a7 20 00 09 04 00
2008-03-27 09:34:54.76 spid74 * 2 JFINCH & 01 32 06 00 4a 46 49 4e 43 48 00 01 26 04 00
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 * MODULE BASE END SIZE
2008-03-27 09:34:54.76 spid74 * sqlservr 01000000 02C09FFF 01c0a000
2008-03-27 09:34:54.76 spid74 * ntdll 7C800000 7C8BFFFF 000c0000
2008-03-27 09:34:54.76 spid74 * kernel32 77E40000 77F41FFF 00102000
2008-03-27 09:34:54.76 spid74 * MSVCR80 78130000 781CAFFF 0009b000
2008-03-27 09:34:54.76 spid74 * msvcrt 77BA0000 77BF9FFF 0005a000
2008-03-27 09:34:54.76 spid74 * MSVCP80 7C420000 7C4A6FFF 00087000
2008-03-27 09:34:54.76 spid74 * ADVAPI32 77F50000 77FEAFFF 0009b000
2008-03-27 09:34:54.76 spid74 * RPCRT4 77C50000 77CEEFFF 0009f000
2008-03-27 09:34:54.76 spid74 * Secur32 76F50000 76F62FFF 00013000
2008-03-27 09:34:54.76 spid74 * USER32 77380000 77410FFF 00091000
2008-03-27 09:34:54.76 spid74 * GDI32 77C00000 77C47FFF 00048000
2008-03-27 09:34:54.76 spid74 * CRYPT32 761B0000 76242FFF 00093000
2008-03-27 09:34:54.76 spid74 * MSASN1 76190000 761A1FFF 00012000
2008-03-27 09:34:54.76 spid74 * MSWSOCK 71B20000 71B60FFF 00041000
2008-03-27 09:34:54.76 spid74 * WS2_32 71C00000 71C16FFF 00017000
2008-03-27 09:34:54.76 spid74 * WS2HELP 71BF0000 71BF7FFF 00008000
2008-03-27 09:34:54.76 spid74 * USERENV 76920000 769E1FFF 000c2000
2008-03-27 09:34:54.76 spid74 * opends60 333E0000 333E6FFF 00007000
2008-03-27 09:34:54.76 spid74 * NETAPI32 71C40000 71C96FFF 00057000
2008-03-27 09:34:54.76 spid74 * SHELL32 7C8D0000 7D0CEFFF 007ff000
2008-03-27 09:34:54.76 spid74 * SHLWAPI 77DA0000 77DF1FFF 00052000
2008-03-27 09:34:54.76 spid74 * comctl32 77420000 77522FFF 00103000
2008-03-27 09:34:54.76 spid74 * psapi 76B70000 76B7AFFF 0000b000
2008-03-27 09:34:54.76 spid74 * instapi 48060000 48069FFF 0000a000
2008-03-27 09:34:54.76 spid74 * sqlevn70 4F610000 4F7B8FFF 001a9000
2008-03-27 09:34:54.76 spid74 * SQLOS 344D0000 344D4FFF 00005000
2008-03-27 09:34:54.76 spid74 * rsaenh 68000000 68034FFF 00035000
2008-03-27 09:34:54.76 spid74 * AUTHZ 76C40000 76C53FFF 00014000
2008-03-27 09:34:54.76 spid74 * MSCOREE 79000000 79045FFF 00046000
2008-03-27 09:34:54.76 spid74 * ole32 77670000 777A8FFF 00139000
2008-03-27 09:34:54.76 spid74 * msv1_0 76C90000 76CB6FFF 00027000
2008-03-27 09:34:54.76 spid74 * iphlpapi 76CF0000 76D09FFF 0001a000
2008-03-27 09:34:54.76 spid74 * kerberos 629A0000 629F7FFF 00058000
2008-03-27 09:34:54.76 spid74 * cryptdll 766E0000 766EBFFF 0000c000
2008-03-27 09:34:54.76 spid74 * schannel 76750000 76776FFF 00027000
2008-03-27 09:34:54.76 spid74 * COMRES 77010000 770D5FFF 000c6000
2008-03-27 09:34:54.76 spid74 * XOLEHLP 62A60000 62A65FFF 00006000
2008-03-27 09:34:54.76 spid74 * MSDTCPRX 62A70000 62AE8FFF 00079000
2008-03-27 09:34:54.76 spid74 * OLEAUT32 77D00000 77D8AFFF 0008b000
2008-03-27 09:34:54.76 spid74 * msvcp60 62AF0000 62B54FFF 00065000
2008-03-27 09:34:54.76 spid74 * MTXCLU 62B60000 62B78FFF 00019000
2008-03-27 09:34:54.76 spid74 * VERSION 77B90000 77B97FFF 00008000
2008-03-27 09:34:54.76 spid74 * WSOCK32 71BB0000 71BB8FFF 00009000
2008-03-27 09:34:54.76 spid74 * CLUSAPI 62B80000 62B91FFF 00012000
2008-03-27 09:34:54.76 spid74 * RESUTILS 62BA0000 62BB2FFF 00013000
2008-03-27 09:34:54.76 spid74 * DNSAPI 76ED0000 76EF9FFF 0002a000
2008-03-27 09:34:54.76 spid74 * winrnr 76F70000 76F76FFF 00007000
2008-03-27 09:34:54.76 spid74 * WLDAP32 76F10000 76F3DFFF 0002e000
2008-03-27 09:34:54.76 spid74 * rasadhlp 76F80000 76F84FFF 00005000
2008-03-27 09:34:54.76 spid74 * security 62FF0000 62FF3FFF 00004000
2008-03-27 09:34:54.76 spid74 * msfte 637D0000 63A28FFF 00259000
2008-03-27 09:34:54.76 spid74 * dbghelp 63A40000 63B54FFF 00115000
2008-03-27 09:34:54.76 spid74 * WINTRUST 76BB0000 76BDAFFF 0002b000
2008-03-27 09:34:54.76 spid74 * imagehlp 76C10000 76C37FFF 00028000
2008-03-27 09:34:54.76 spid74 * dssenh 68100000 68126FFF 00027000
2008-03-27 09:34:54.76 spid74 * hnetcfg 63DA0000 63DF9FFF 0005a000
2008-03-27 09:34:54.76 spid74 * wshtcpip 71AE0000 71AE7FFF 00008000
2008-03-27 09:34:54.76 spid74 * NTMARTA 77E00000 77E20FFF 00021000
2008-03-27 09:34:54.76 spid74 * SAMLIB 7E020000 7E02EFFF 0000f000
2008-03-27 09:34:54.76 spid74 * ntdsapi 766F0000 76703FFF 00014000
2008-03-27 09:34:54.76 spid74 * xpsp2res 63F40000 64204FFF 002c5000
2008-03-27 09:34:54.76 spid74 * CLBCatQ 777B0000 77832FFF 00083000
2008-03-27 09:34:54.76 spid74 * sqlncli 64210000 64433FFF 00224000
2008-03-27 09:34:54.76 spid74 * COMCTL32 77530000 775C6FFF 00097000
2008-03-27 09:34:54.76 spid74 * comdlg32 762B0000 762F8FFF 00049000
2008-03-27 09:34:54.76 spid74 * SQLNCLIR 007C0000 007F2FFF 00033000
2008-03-27 09:34:54.76 spid74 * msftepxy 64670000 64684FFF 00015000
2008-03-27 09:34:54.76 spid74 * xp_ctnhashproc 62910000 6292EFFF 0001f000
2008-03-27 09:34:54.76 spid74 * xplog70 63360000 6336BFFF 0000c000
2008-03-27 09:34:54.76 spid74 * xplog70 63380000 63382FFF 00003000
2008-03-27 09:34:54.76 spid74 * sqlvdi 645D0000 645F1FFF 00022000
2008-03-27 09:34:54.76 spid74 * xpstar90 630B0000 630F8FFF 00049000
2008-03-27 09:34:54.76 spid74 * SQLSCM90 633C0000 633C8FFF 00009000
2008-03-27 09:34:54.76 spid74 * ODBC32 64450000 6448CFFF 0003d000
2008-03-27 09:34:54.76 spid74 * BatchParser90 64490000 644AEFFF 0001f000
2008-03-27 09:34:54.76 spid74 * ATL80 7C630000 7C64AFFF 0001b000
2008-03-27 09:34:54.76 spid74 * odbcint 64DC0000 64DD6FFF 00017000
2008-03-27 09:34:54.76 spid74 * xpstar90 65330000 65355FFF 00026000
2008-03-27 09:34:54.76 spid74 * xpsqlbot 64DE0000 64DE5FFF 00006000
2008-03-27 09:34:54.76 spid74 * msxmlsql 78800000 788D4FFF 000d5000
2008-03-27 09:34:54.76 spid74 * msxml2 66030000 660DEFFF 000af000
2008-03-27 09:34:54.76 spid74 * msxml3 67040000 67156FFF 00117000
2008-03-27 09:34:54.76 spid74 * dbghelp 68930000 68A44FFF 00115000
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 * Edi: 62930000: 000000C8 00000187 EEFFEEFF 00001002 00000000 0000FE00
2008-03-27 09:34:54.76 spid74 * Esi: 1C3C2EE8: 010A50E8 00000001 1C3C2490 0000D333 1C3C2F10 1C3C2F08
2008-03-27 09:34:54.76 spid74 * Eax: 010A50E8: 010B7A71 01659AC6 01659ACE 018484D0 018484D8 01659ADE
2008-03-27 09:34:54.76 spid74 * Ebx: 00000000:
2008-03-27 09:34:54.76 spid74 * Ecx: 00000001:
2008-03-27 09:34:54.76 spid74 * Edx: 62930608: 00127668 FFFFFFFE 00000001 00000430 00000000 00000FA0
2008-03-27 09:34:54.76 spid74 * Eip: 7C80EEF0: 503B118B 56850F04 3B00031E 4E850FD6 8900031E 04488901
2008-03-27 09:34:54.76 spid74 * Ebp: 656DCD84: 00000020 6291ED76 62930000 00000000 1C3C2F08 3910C3B0
2008-03-27 09:34:54.76 spid74 * SegCs: 0000001B:
2008-03-27 09:34:54.76 spid74 * EFlags: 00010207: 47004900 5F005700 4F004C00 3D004300 3A004300 50005C00
2008-03-27 09:34:54.76 spid74 * Esp: 656DCCB4: 1C3C2F08 1C3C2F08 654E05E0 0100469B 656DCD74 78132C78
2008-03-27 09:34:54.76 spid74 * SegSs: 00000023:
2008-03-27 09:34:54.76 spid74 * *******************************************************************************
2008-03-27 09:34:54.76 spid74 * -------------------------------------------------------------------------------
2008-03-27 09:34:54.76 spid74 * Short Stack Dump
2008-03-27 09:34:54.77 spid74 7C80EEF0 Module(ntdll+0000EEF0)
2008-03-27 09:34:54.77 spid74 6291ED76 Module(xp_ctnhashproc+0000ED76)
2008-03-27 09:34:54.77 spid74 62911184 Module(xp_ctnhashproc+00001184)
2008-03-27 09:34:54.77 spid74 01660FEC Module(sqlservr+00660FEC)
2008-03-27 09:34:54.77 spid74 01662FCD Module(sqlservr+00662FCD)
2008-03-27 09:34:54.77 spid74 01662984 Module(sqlservr+00662984)
2008-03-27 09:34:54.77 spid74 01661920 Module(sqlservr+00661920)
2008-03-27 09:34:54.77 spid74 01661E2E Module(sqlservr+00661E2E)
2008-03-27 09:34:54.77 spid74 01C1BF0C Module(sqlservr+00C1BF0C)
2008-03-27 09:34:54.77 spid74 014B3FE1 Module(sqlservr+004B3FE1)
2008-03-27 09:34:54.77 spid74 012389B6 Module(sqlservr+002389B6)
2008-03-27 09:34:54.77 spid74 0123882D Module(sqlservr+0023882D)
2008-03-27 09:34:54.77 spid74 012386C2 Module(sqlservr+002386C2)
2008-03-27 09:34:54.77 spid74 010227F3 Module(sqlservr+000227F3)
2008-03-27 09:34:54.77 spid74 010293B5 Module(sqlservr+000293B5)
2008-03-27 09:34:54.77 spid74 010286DC Module(sqlservr+000286DC)
2008-03-27 09:34:54.77 spid74 01032A36 Module(sqlservr+00032A36)
2008-03-27 09:34:54.77 spid74 0102F1F4 Module(sqlservr+0002F1F4)
2008-03-27 09:34:54.77 spid74 010077A6 Module(sqlservr+000077A6)
2008-03-27 09:34:54.77 spid74 010078CC Module(sqlservr+000078CC)
2008-03-27 09:34:54.77 spid74 010075DC Module(sqlservr+000075DC)
2008-03-27 09:34:54.77 spid74 010B94A5 Module(sqlservr+000B94A5)
2008-03-27 09:34:54.77 spid74 010B939C Module(sqlservr+000B939C)
2008-03-27 09:34:54.77 spid74 010B9064 Module(sqlservr+000B9064)
2008-03-27 09:34:54.79 spid74 010B9201 Module(sqlservr+000B9201)
2008-03-27 09:34:54.79 spid74 781329BB Module(MSVCR80+000029BB)
2008-03-27 09:34:54.79 spid74 78132A47 Module(MSVCR80+00002A47)
2008-03-27 09:34:54.79 spid74 Stack Signature for the dump is 0xD5652648
2008-03-27 09:34:56.31 spid74 External dump process return code 0x20002001.
The error information has been submitted to Watson error reporting.

2008-03-27 09:34:56.31 spid74 Error: 18002, Severity: 20, State: 1.
2008-03-27 09:34:56.31 spid74 Exception happened when running extended stored procedure 'xp_ctnhash' in the library 'xp_ctnhashproc.dll'. SQL Server is terminating process 74. Exception type: Win32 exception; Exception code: 0xc0000005.

View 5 Replies View Related







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