How Do I Prevent A SQL Error Terminating My Package?

Jan 26, 2007

I am getting the ubiquitous error....

"The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I have a stored procedure that performs a task on a loop. Sometime it fails, somtimes it succeeds and that's just fine, the errors are handled within the stored procedure and I return counts of success and failures.

The trouble is that the package execution terminates when even one of the task fails. I don't want it to, I just want it to continue as the pakage should then go on to extract the source of the failues and post them back where they came from.

Any ideas how I can achieve this?

I have tinkered with the MaximumErrorCount setting, but I get the same result regardless of whether this is set to 0, 1, or 99999.

I also have a 'failure' path leading from the SQL task, but the package does not follow it.

I'm using an OLE DB connection and when none of the tasks fail, the process works perfectly.

Any ideas, most appreciated.

View 8 Replies


ADVERTISEMENT

RESTORE FILELIST Is Terminating Abnormally Error When Running A DTS Package In SQL 2005. Works Fine In SQL 2000

Oct 10, 2007

Currently I receive the following error when executing script within a DTS package in SQL 2005 (it seems to be working in SQL 2000):


Processed 27008 pages for database 'Marketing', file 'Marketing_Data' on file 5.

Processed 1 pages for database 'Marketing', file 'Marketing_Log' on file 5.

BACKUP DATABASE successfully processed 27009 pages in 15.043 seconds (14.708 MB/sec).

(5 row(s) affected)

Msg 213, Level 16, State 7, Line 1

Insert Error: Column name or number of supplied values does not match table definition.

Msg 3013, Level 16, State 1, Line 1

RESTORE FILELIST is terminating abnormally.

The code I am using is:


-- the original database (use 'SET @DB = NULL' to disable backup)

DECLARE @DB varchar(200)

SET @DB = 'Marketing'

-- the backup filename

DECLARE @BackupFile varchar(2000)

SET @BackupFile = 'C:SQL2005 dbsMarketing.dat'

-- the new database name

DECLARE @TestDB2 varchar(200)

SET @TestDB2 = datename(month, dateadd(month, -1, getdate())) + convert(varchar(20), year(getdate())) + 'Inst1'

-- the new database files without .mdf/.ldf

DECLARE @RestoreFile varchar(2000)

SET @RestoreFile = 'C:SQL2005 dbs' + @TestDB2

DECLARE @RestoreLog varchar (2000)

SET @RestoreLog = 'C:SQL2005 dbs' + @TestDB2

-- ****************************************************************

-- no change below this line

-- ****************************************************************

DECLARE @query varchar(2000)

DECLARE @DataFile varchar(2000)

SET @DataFile = @RestoreFile + '.mdf'

DECLARE @LogFile varchar(2000)

SET @LogFile = @RestoreLog + '.ldf'

IF @DB IS NOT NULL

BEGIN

SET @query = 'BACKUP DATABASE ' + @DB + ' TO DISK = ' + QUOTENAME(@BackupFile, '''')

EXEC (@query)

END

-- RESTORE FILELISTONLY FROM DISK = 'C: empackup.dat'

-- RESTORE HEADERONLY FROM DISK = 'C: empackup.dat'

-- RESTORE LABELONLY FROM DISK = 'C: empackup.dat'

-- RESTORE VERIFYONLY FROM DISK = 'C: empackup.dat'







IF EXISTS(SELECT * FROM sysdatabases WHERE name = @TestDB2)

BEGIN

SET @query = 'DROP DATABASE ' + @TestDB2

EXEC (@query)

END

RESTORE HEADERONLY FROM DISK = @BackupFile

DECLARE @File int

SET @File = @@ROWCOUNT

DECLARE @Data varchar(500)

DECLARE @Log varchar(500)

SET @query = 'RESTORE FILELISTONLY FROM DISK = ' + QUOTENAME(@BackupFile , '''')

CREATE TABLE #restoretemp

(

LogicalName varchar(500),

PhysicalName varchar(500),

type varchar(10),

FilegroupName varchar(200),

size int,

maxsize bigint

)

INSERT #restoretemp EXEC (@query)

SELECT @Data = LogicalName FROM #restoretemp WHERE type = 'D'

SELECT @Log = LogicalName FROM #restoretemp WHERE type = 'L'

PRINT @Data

PRINT @Log

TRUNCATE TABLE #restoretemp

DROP TABLE #restoretemp

IF @File > 0

BEGIN

SET @query = 'RESTORE DATABASE ' + @TestDB2 + ' FROM DISK = ' + QUOTENAME(@BackupFile, '''') +

' WITH MOVE ' + QUOTENAME(@Data, '''') + ' TO ' + QUOTENAME(@DataFile, '''') + ', MOVE ' +

QUOTENAME(@Log, '''') + ' TO ' + QUOTENAME(@LogFile, '''') + ', FILE = ' + CONVERT(varchar, @File)

EXEC (@query)

END





View 1 Replies View Related

About Programmatically Disabling The Tasks, Manually Terminating Further Flow In A Package

Apr 19, 2007

Hi folks,

I have come across a situation where there 10 tasks. The second task on the flow is a script task which disables all further tasks based on a condition. I thought that the logic would be better if we force terminate the package successfully at this stage itself. How can this be done.



Thanks

Subhash Subramanyam

View 4 Replies View Related

Temp Tables Not Dropped On Batch-terminating Error

Dec 28, 2007



If a stored procedure creates a temporary table and then has a batch-terminating error -- either a fatal error or a non-fatal error in "xact_abort on" mode -- the temp table does not get dropped even though it goes out of scope:


create proc px as

create table #z(z1 int primary key)

insert #z values ('x')

go

exec px

go

select * from tempdb.sys.tables where name like '#z%' --returns row for #z

drop table #z --fails because #z out of scope


or:


create proc px as

set xact_abort on

create table #z(z1 int primary key)

insert #z values (0)

insert #z values (0)

go

exec px

go

select * from tempdb.sys.tables where name like '#z%' --returns row for #z

drop table #z --fails because #z out of scope

Is this behavior by design? It does not appear to be documented properly if so, since BOL states that "Temporary tables are automatically dropped when they go out of scope".

In any case, is there a way to delete leftover temp tables from tempdb without restarting SQL Server?

Thanks,
Ron

View 2 Replies View Related

DTS Package - How To Prevent A 0 Byte File?

Feb 18, 2004

I've created a DTS package -- that uses a query to export to a .txt file. My question is -- if the results of this query are zero (no results returned within the package ) -- how can I tell the package not to export a zero byte file. Any thoughts on that? Any help you could give would be greatly appreciated. Thanks!

View 3 Replies View Related

Prevent Simultaneous Package Executions

Oct 23, 2007

How can I prevent a package, or a section of a package, from being run more than once simultaneously? The package makes use of a staging database table, and if two copies of this package are run at the same time, there will be a race condition and possible corruption of the data in the database table. I have also noticed that the SSIS logging gets messed up and starts overwriting itself if I have more than one of these packages run at the same time.

What I am thinking of should work the same way as a serializable transaction lock on a normal query, where one query has to wait if another query has a lock on the table. I don't want the package to throw an error, I want it to wait until the other one is done.

I have been trying to use transactions in a test SSIS package, but they are not quite doing what I want them to do. I put various SSIS steps in a sequence container and require a serializable transaction. I have also tried putting the transaction at the package level, but that is not preventing simultaneous package runs.

Is there a built-in way to do this that is easy to implement? Otherwise, what I could do is insert a flag into the database indicating that a package is running, then make sure to reset the flag on any error or on completion. It seems like this alternate method could be error-prone though.

I am using SP2.

View 8 Replies View Related

Analysis :: Errors In SSAS Dimension Prevent From Starting / Debugging SSIS Package

Jul 24, 2015

I have an SSIS and SSAS project in the same solution.  I need to debug the SSIS package regardless if there is an error or two in the SSAS project.  Is there a way to ignore the SSAS project while I debug the SSIS package?

View 2 Replies View Related

Log File Is Full Error: How To Prevent This Happening?

Feb 9, 2007

"The log file for database is full. Back up the transaction log forthe database to free up some log space."Now I only know this way to deal with that manually,Step1. in option , chance Recovery model from FULL to Simple.Step2: go to task to manually shrink the log fileStep3: Change recovery model back from simple to FULL.But by this way, I could get same problem again, the log file is fill,and need free up.Could you give an idea how to prevent this from happening? what andhow should I do???Thanks a lot in advance for your help.

View 3 Replies View Related

Prevent Error Being Thrown When No Messages Exist

Nov 22, 2007

I am using the following code to check whether a message exists on the specified queue:




Code Block
DECLARE @RecvReplyMsg NVARCHAR(100);
DECLARE @RecvReplyDlgHandle UNIQUEIDENTIFIER;
BEGIN TRANSACTION;
RECEIVE TOP(1)
@RecvReplyDlgHandle = conversation_handle,
@RecvReplyMsg = message_body
FROM TargetQueue;
END CONVERSATION @RecvReplyDlgHandle;
SELECT @RecvReplyMsg AS ReceivedReplyMsg;
COMMIT TRANSACTION;
GO


How can I prevent errors being thrown when there are no messages waiting on the queue? For example, if I send a message to the queue and run the above twice I get the following:


Msg 8418, Level 16, State 1, Line 11

The conversation handle is missing. Specify a conversation handle.


Thanks

View 3 Replies View Related

Error Creating Package - Failed To Save Package File ... Emp EmpD4B.tmp With Error 0x80040154 Class Not Registered

May 19, 2006

I had just installed SQL 2005 dev on my laptop and got an error message when I tried to create a package using the BI IDE. I received the same error using VS2005 IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again, but with an option to view the error details.

Following is the text of the error details:

TITLE: Microsoft Visual Studio
------------------------------

Error creating package

------------------------------
ADDITIONAL INFORMATION:

Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".


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

Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".


------------------------------
BUTTONS:

OK
------------------------------
I found a similar post that suggested that they try the following:


regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll

But msxml6.dll could not be found.

I did get a copy of this file from a coworker, and after copying it and registering it, I was able to add a package to the project.

My concern now is what is the likelyhood of this being the only file missing from the installation.

I'm wondering if I should reinstall, or (if it exists) do a repair on the installation.

Thanks.

Marshall

View 12 Replies View Related

SQL Server Terminating

Jun 29, 1999

Has anyone come across SQL server terminating unexpectably and then proceeding to restart itself. There is no alerts set to restart the process, there are no errors in SQL errorlog, in NT Event log there is a error that SQL terminated unexpectably , and then 1 second later a message that it is restarting as normal. Any clues or encounters of this behaivour before and fixes would be appreciated

View 3 Replies View Related

Load A SSIS Package Via Web Service: The Package Failed To Load Due To Error 0xC0011008 Error Loading From XML.WHAT IS THAT?

May 19, 2006

Hello,

I have a big problem and i'm not able to find any hint on the Network.

I have a window2000 pc, VS2005,II5 and SQLServer 2005(dev edition)

I created an SSIS Package (query to DB and the result is loaded into an Excel file) that works fine.

I imported the dtsx file inside my "Stored Packages".

I would like to load and run the package programmatically on a Remote Scenario using the web services.

I created a solution with web service and web page that invoke the web service.

When my code execute:
Microsoft.SqlServer.Dts.Runtime.Application.LoadFromDtsServer(packagePath, ".", Nothing)

I got the Error:
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.

The error message doesn't help so much and there is nothing on the www to give me and advice....

Is it a SSIS problem???

Thank you for any help!!

Marina B.



View 10 Replies View Related

Restoration Terminating Abnormally

Dec 5, 2000

Hi,

This is the problem which we face now and then. There is an automated job that run everyday night to restore the Database for reporting purposes. Before running that job an NT Task Schedular stop starts the sql server. This is to make sure that all the connections are closed. Nobody uses it at Night. But some times the job fails with bellow error message...

"Database in use. The system administrator must have exclusive use of the database to run the restore operation. [SQLSTATE 42000] (Error 3101) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013) Associated statement is not prepared [SQLSTATE HY007] (Error 0). The step failed."

Should I make the DB option set to single user mode. I don't think that is the problem.. because it runs fine most of the time..but sometime it fails.
Please help.. Thanks in advance :-)

Shyam.

View 2 Replies View Related

SQL Server Connections Not Terminating

Nov 4, 1999

We have an application that runs against SQL Server 6.5 or 7.0. At one location that was recently upgraded from 6.5 to 7.0 we have a problem with the user connections to SQL Server not terminating when the user terminates the application. At some point, after several days, they are forced to bounce the server to eliminate the errant connections becasue SQL Server tells them they have the maximum number of connections. This only happens at one site and it happened under 6.5 as well. At all other sites, the connections terminate when the application terminates. Any ideas????

View 1 Replies View Related

BACKUP LOG Is Terminating Abnormally

May 12, 2008

Hi! I have a db with Full recovery model, when i try to run Transaction Log Backup, i get this error- sometimes sooner than reaching 90 percent, in spite of friendly working that i had before.

10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
Msg 3202, Level 16, State 2, Line 1
Write on "D:Simaap_BackupSimaapFullBackup_870218" failed: 112(error not found)
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

Any solution would be appreciated!!
Thanks!

View 6 Replies View Related

RESTORE FILELIST Is Terminating Abnormally

Jun 21, 2007

'm a noob, using MS SQL 2005. Trying to use a stored procedure I got from SQL 2000 DB integrity to work with 2005. Receiving:


Message
Executed as user: MMCRSDOM eletracksql. Insert Error: Column name or number of supplied values does not match table definition. [SQLSTATE 21S01] (Error 213) RESTORE FILELIST is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

Please help.

View 2 Replies View Related

SQL Server Is Terminating Due To 'stop' Request Fr

Apr 26, 2006

Hiya

Since yesterday the sqlserver service has been falling over, my error logs says the below?

006-04-26 11:28:41.64 spid51 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'sp_MSgetversion'.
2006-04-26 11:28:41.92 spid51 Error: 15457, Severity: 0, State: 1
2006-04-26 11:28:41.92 spid51 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2006-04-26 11:28:42.04 spid51 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
2006-04-26 14:44:08.92 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.

What do I need to do? Is is just a matter of running the reconfigure script? Yesterday night we had some monitoring installed on the server. Can anyone help?

Thanks

View 9 Replies View Related

RESTORE DATABASE Is Terminating Abnormally.

Apr 19, 2007

Hello,I am getting the rather odd error below; hope you can help.RESTORE DATABASE is terminating abnormally. File 'C:Program FilesMicrosoftSQL ServerMSSQL.1MSSQLData rial_44testingc' is claimed by'sysft_KB_SearchAssetsCatalog'(65540) and 'sysft_KB_SearchCatalog'(65537).The WITH MOVE clause can be used to relocate one or more files.I get this from an app our company uses to programatically restoredatabases. Below are the queries we are using:Create database trial_44testingcselect COUNT(*) as TOTAL from sysdatabases where name = 'trial_44testingc'RESTORE FILELISTONLY FROM disk ='C:HostedTrialManagementAppSourcedb43_trialmas ter'RESTORE DATABASE trial_44testingc FROM disk ='C:HostedTrialManagementAppSourcedb43_trialmas ter' WITH RECOVERY , MOVE'43_trialmaster' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc.mdf', MOVE '43_trialmaster_log'TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc.ldf', MOVE'sysft_KB_SearchCatalog' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc', MOVE'sysft_KB_SearchTicketsCatalog' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc', MOVE'sysft_KB_SearchTicketsCatalog2' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc', MOVE'sysft_KB_SearchAssetsCatalog' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc'This had been working great until I made some updates to the table structureof the db and created a new backup.Any ideas?TIAJake

View 1 Replies View Related

BACKUP DATABASE Is Terminating Abnormally

May 8, 2008

I am receiving an error

"Database 'MyDatabase' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. BACKUP DATABASE is terminating abnormally."

each time I click on the button code below.




Code Snippet
Private Sub BACK_UP_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BACK_UP.Click


cmd = New SqlCommand("BACKUP DATABASE" & Me.cbdatabase.Text & "TO DISK = 'Documents and SettingsMy DocumentsPERSONAL DOCUMENTSfilename.bak' ", conn);
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()

End Sub

The VB application is running from an Open SQL Server 2005 user account - ie No user account has been created for it. Do anyone know how I can resolve this issue from VB 2005 Express.

View 9 Replies View Related

I Have DTS Package Even I Getting Error Error String: The Specified DTS Package ('Name = 'ERP_Mater_Encript_Data_Move'; ID.Ver

Mar 4, 2008

Hi

My Server having DTS package even Job failing saying
"Error string: The specified DTS Package ('Name = 'ERP_Mater_Encript_Data_Move'; ID.VersionID = {[not specified]}.{T0I37w32-AB51-1SA4-9495-AcE6SSS4a321}') does not exist"




Please help regarding.

View 3 Replies View Related

ODBC Connection Not Terminating After Client Diconnects

Jan 9, 2001

Hi,

We have SQLSERVER 7.0 in one of the production.
The clients r connected thru ODBC.
The clients doesn't gets disconnected after a task result in
increase in sqlserver log.

Can anyone advice me .

Thanks in advance
Anu

View 2 Replies View Related

HELP: SQL Server Is Terminating Because Of Fatal Exception C0000005

Feb 28, 2008



Hi,

We're using SQL Server 2005 SP2, and got an error message of:

SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).

Does anyone know what is the cause of this error and how to fix it.

Thanks in advance, Maxim

View 7 Replies View Related

SQL Server Is Terminating Because Of Fatal Exception C0000005.

Jun 30, 2007

Hello

My Server is restarting every time a OLAP process a cube dimension...

The query's are generated by the OLAP engine and are selecting from views that are depended on AS400 linked server.

I' m posting the log and dump

SQL Server Log

/*--------------------------------------------------------------*/

Date,Source,Severity,Message
06/30/2007 19:20:51,spid7s,Unknown,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
06/30/2007 19:20:51,spid70,Unknown,SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception<c/> or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error<c/> restart the server (unless SQLAgent is configured to auto restart).
06/30/2007 19:20:51,spid70,Unknown,Error: 17311<c/> Severity: 16<c/> State: 1.
06/30/2007 19:20:51,spid70,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
06/30/2007 19:20:49,spid70,Unknown,Stack Signature for the dump is 0x943A0CDA
06/30/2007 19:20:49,spid70,Unknown,78132A36 Module(MSVCR80+00002A36)
06/30/2007 19:20:49,spid70,Unknown,781329AA Module(MSVCR80+000029AA)
06/30/2007 19:20:49,spid70,Unknown,0146753D Module(sqlservr+0046753D)
06/30/2007 19:20:49,spid70,Unknown,01466761 Module(sqlservr+00466761)
06/30/2007 19:20:49,spid70,Unknown,014676D8 Module(sqlservr+004676D8)
06/30/2007 19:20:49,spid70,Unknown,014677E1 Module(sqlservr+004677E1)
06/30/2007 19:20:49,spid70,Unknown,01006F3B Module(sqlservr+00006F3B)
06/30/2007 19:20:49,spid70,Unknown,01006D4C Module(sqlservr+00006D4C)
06/30/2007 19:20:49,spid70,Unknown,01006C26 Module(sqlservr+00006C26)
06/30/2007 19:20:49,spid70,Unknown,0104A331 Module(sqlservr+0004A331)
06/30/2007 19:20:49,spid70,Unknown,0104AB65 Module(sqlservr+0004AB65)
06/30/2007 19:20:49,spid70,Unknown,01028C01 Module(sqlservr+00028C01)
06/30/2007 19:20:49,spid70,Unknown,01029D74 Module(sqlservr+00029D74)
06/30/2007 19:20:49,spid70,Unknown,010297DA Module(sqlservr+000297DA)
06/30/2007 19:20:49,spid70,Unknown,0103D211 Module(sqlservr+0003D211)
06/30/2007 19:20:49,spid70,Unknown,0103CEF9 Module(sqlservr+0003CEF9)
06/30/2007 19:20:49,spid70,Unknown,0103CFBA Module(sqlservr+0003CFBA)
06/30/2007 19:20:49,spid70,Unknown,0109DD66 Module(sqlservr+0009DD66)
06/30/2007 19:20:49,spid70,Unknown,0109FB6C Module(sqlservr+0009FB6C)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E7DE Module(sqlservr+0034E7DE)
06/30/2007 19:20:49,spid70,Unknown,0138B3AB Module(sqlservr+0038B3AB)
06/30/2007 19:20:49,spid70,Unknown,010420A3 Module(sqlservr+000420A3)
06/30/2007 19:20:49,spid70,Unknown,01042083 Module(sqlservr+00042083)
06/30/2007 19:20:49,spid70,Unknown,01041E15 Module(sqlservr+00041E15)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E8EC Module(sqlservr+0034E8EC)
06/30/2007 19:20:49,spid70,Unknown,0134E600 Module(sqlservr+0034E600)
06/30/2007 19:20:49,spid70,Unknown,0104019A Module(sqlservr+0004019A)
06/30/2007 19:20:49,spid70,Unknown,0104E95A Module(sqlservr+0004E95A)
06/30/2007 19:20:49,spid70,Unknown,014E7287 Module(sqlservr+004E7287)
06/30/2007 19:20:49,spid70,Unknown,01E53EEB Module(sqlservr+00E53EEB)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E7DE Module(sqlservr+0034E7DE)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134EE0E Module(sqlservr+0034EE0E)
06/30/2007 19:20:49,spid70,Unknown,013513CB Module(sqlservr+003513CB)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E7DE Module(sqlservr+0034E7DE)
06/30/2007 19:20:49,spid70,Unknown,0138B3AB Module(sqlservr+0038B3AB)
06/30/2007 19:20:49,spid70,Unknown,010420A3 Module(sqlservr+000420A3)
06/30/2007 19:20:49,spid70,Unknown,01042083 Module(sqlservr+00042083)
06/30/2007 19:20:49,spid70,Unknown,01041E15 Module(sqlservr+00041E15)
06/30/2007 19:20:49,spid70,Unknown,01E4E7C6 Module(sqlservr+00E4E7C6)
06/30/2007 19:20:49,spid70,Unknown,01E4F63E Module(sqlservr+00E4F63E)
06/30/2007 19:20:49,spid70,Unknown,0171A1E6 Module(sqlservr+0071A1E6)
06/30/2007 19:20:49,spid70,Unknown,01718FE0 Module(sqlservr+00718FE0)
06/30/2007 19:20:49,spid70,Unknown,017033EB Module(sqlservr+007033EB)
06/30/2007 19:20:49,spid70,Unknown,017031E2 Module(sqlservr+007031E2)
06/30/2007 19:20:49,spid70,Unknown,88000000 Module(UNKNOWN+00000000)
06/30/2007 19:20:49,spid70,Unknown,* Short Stack Dump
06/30/2007 19:20:49,spid70,Unknown,* -------------------------------------------------------------------------------
06/30/2007 19:20:49,spid70,Unknown,* *******************************************************************************
06/30/2007 19:20:49,spid70,Unknown,* SegSs: 00000023:
06/30/2007 19:20:49,spid70,Unknown,* Esp: 075FEE1C: 017031E2 65006900 015C37F8 075FEE3C 075F8169 00000000
06/30/2007 19:20:49,spid70,Unknown,* EFlags: 00010246: 004E005F 00000054 00610050 00680074 0043003D 005C003A
06/30/2007 19:20:49,spid70,Unknown,* SegCs: 0000001B:
06/30/2007 19:20:49,spid70,Unknown,* Ebp: 075FEEA4: 075FEFB8 017033EB 015C37F8 65006900 0109CFA4 00000001
06/30/2007 19:20:49,spid70,Unknown,* Eip: 88000000: 00040101 00010000 00001D15 00550001 00001D30 00190001
06/30/2007 19:20:49,spid70,Unknown,* Edx: 015C37F8: 0C733A1D 11CE2A1C AA00E5AD 3D774400 0C733A5D 11CE2A1C
06/30/2007 19:20:49,spid70,Unknown,* Ecx: 075FEE3C: 00000000 00936188 00000000 5E2200E8 00000000 00000000
06/30/2007 19:20:49,spid70,Unknown,* Ebx: 65006900: 00140001 0000A80D 00671B36 000AEC00 00000300 00140001
06/30/2007 19:20:49,spid70,Unknown,* Eax: 88000000: 00040101 00010000 00001D15 00550001 00001D30 00190001
06/30/2007 19:20:49,spid70,Unknown,* Esi: 6F179D58: 6F179DC8 2DA5069E 11D656C4 20005B92 3997AE35 00000000
06/30/2007 19:20:49,spid70,Unknown,* Edi: 00000000:
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* dbghelp 09660000 09774FFF 00115000
06/30/2007 19:20:49,spid70,Unknown,* sqlvdi 072B0000 072D1FFF 00022000
06/30/2007 19:20:49,spid70,Unknown,* SXS 75DA0000 75E5BFFF 000bc000
06/30/2007 19:20:49,spid70,Unknown,* adsldp 08DE0000 08E0DFFF 0002e000
06/30/2007 19:20:49,spid70,Unknown,* ATL 76A80000 76A97FFF 00018000
06/30/2007 19:20:49,spid70,Unknown,* credui 76B80000 76BADFFF 0002e000
06/30/2007 19:20:49,spid70,Unknown,* adsldpc 76DC0000 76DE6FFF 00027000
06/30/2007 19:20:49,spid70,Unknown,* activeds 76DF0000 76E22FFF 00033000
06/30/2007 19:20:49,spid70,Unknown,* cwbcomsg 08DD0000 08DDEFFF 0000f000
06/30/2007 19:20:49,spid70,Unknown,* comsvcs 75B70000 75CA8FFF 00139000
06/30/2007 19:20:49,spid70,Unknown,* CWBZMODB 08CC0000 08CC3FFF 00004000
06/30/2007 19:20:49,spid70,Unknown,* CWBSOMRI 08CA0000 08CADFFF 0000e000
06/30/2007 19:20:49,spid70,Unknown,* cwbdt 08AF0000 08AF7FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* cwbdq 08AD0000 08AEDFFF 0001e000
06/30/2007 19:20:49,spid70,Unknown,* cwbbspc 08AB0000 08AC3FFF 00014000
06/30/2007 19:20:49,spid70,Unknown,* cwbbsspi 08AA0000 08AAFFFF 00010000
06/30/2007 19:20:49,spid70,Unknown,* cwbnl 08A90000 08A94FFF 00005000
06/30/2007 19:20:49,spid70,Unknown,* cwbad 08A80000 08A83FFF 00004000
06/30/2007 19:20:49,spid70,Unknown,* cwbco 08A70000 08A74FFF 00005000
06/30/2007 19:20:49,spid70,Unknown,* cwbsv 08A60000 08A65FFF 00006000
06/30/2007 19:20:49,spid70,Unknown,* cwbunssl 08A40000 08A51FFF 00012000
06/30/2007 19:20:49,spid70,Unknown,* cwbrc 08A30000 08A3EFFF 0000f000
06/30/2007 19:20:49,spid70,Unknown,* cwbsof 08A00000 08A2EFFF 0002f000
06/30/2007 19:20:49,spid70,Unknown,* CWBUNPLA 089B0000 089F2FFF 00043000
06/30/2007 19:20:49,spid70,Unknown,* cwbad1 089A0000 089A7FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* SHFOLDER 766D0000 766D8FFF 00009000
06/30/2007 19:20:49,spid70,Unknown,* MSVCIRT 08990000 0899FFFF 00010000
06/30/2007 19:20:49,spid70,Unknown,* cwbrw 08960000 08989FFF 0002a000
06/30/2007 19:20:49,spid70,Unknown,* iertutil 08910000 08954FFF 00045000
06/30/2007 19:20:49,spid70,Unknown,* Normaliz 08900000 08908FFF 00009000
06/30/2007 19:20:49,spid70,Unknown,* WININET 08830000 088FEFFF 000cf000
06/30/2007 19:20:49,spid70,Unknown,* MFC42u 08700000 08823FFF 00124000
06/30/2007 19:20:49,spid70,Unknown,* cwbunpls 068E0000 068EBFFF 0000c000
06/30/2007 19:20:49,spid70,Unknown,* cwbcore 08610000 086F6FFF 000e7000
06/30/2007 19:20:49,spid70,Unknown,* cwbdc 085E0000 08606FFF 00027000
06/30/2007 19:20:49,spid70,Unknown,* cwbzzodb 084E0000 085DDFFF 000fe000
06/30/2007 19:20:49,spid70,Unknown,* OLEDB32R 068C0000 068D0FFF 00011000
06/30/2007 19:20:49,spid70,Unknown,* MSDART 74A50000 74A69FFF 0001a000
06/30/2007 19:20:49,spid70,Unknown,* oledb32 070B0000 07128FFF 00079000
06/30/2007 19:20:49,spid70,Unknown,* xplog70 08070000 08072FFF 00003000
06/30/2007 19:20:49,spid70,Unknown,* xplog70 08050000 0805BFFF 0000c000
06/30/2007 19:20:49,spid70,Unknown,* xpstar90 08020000 08045FFF 00026000
06/30/2007 19:20:49,spid70,Unknown,* odbcint 08000000 08016FFF 00017000
06/30/2007 19:20:49,spid70,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
06/30/2007 19:20:49,spid70,Unknown,* BatchParser90 07E90000 07EAEFFF 0001f000
06/30/2007 19:20:49,spid70,Unknown,* ODBC32 07E50000 07E8CFFF 0003d000
06/30/2007 19:20:49,spid70,Unknown,* SQLSCM90 07E30000 07E38FFF 00009000
06/30/2007 19:20:49,spid70,Unknown,* xpstar90 07DD0000 07E18FFF 00049000
06/30/2007 19:20:49,spid70,Unknown,* xpsqlbot 07DB0000 07DB5FFF 00006000
06/30/2007 19:20:49,spid70,Unknown,* msftepxy 07130000 07144FFF 00015000
06/30/2007 19:20:49,spid70,Unknown,* SQLNCLIR 007A0000 007D2FFF 00033000
06/30/2007 19:20:49,spid70,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
06/30/2007 19:20:49,spid70,Unknown,* COMCTL32 77530000 775C6FFF 00097000
06/30/2007 19:20:49,spid70,Unknown,* sqlncli 337A0000 339C3FFF 00224000
06/30/2007 19:20:49,spid70,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
06/30/2007 19:20:49,spid70,Unknown,* xpsp2res 10000000 102C4FFF 002c5000
06/30/2007 19:20:49,spid70,Unknown,* ntdsapi 766F0000 76704FFF 00015000
06/30/2007 19:20:49,spid70,Unknown,* SAMLIB 06F70000 06F7EFFF 0000f000
06/30/2007 19:20:49,spid70,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
06/30/2007 19:20:49,spid70,Unknown,* dssenh 06F80000 06FA3FFF 00024000
06/30/2007 19:20:49,spid70,Unknown,* imagehlp 76C10000 76C38FFF 00029000
06/30/2007 19:20:49,spid70,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
06/30/2007 19:20:49,spid70,Unknown,* dbghelp 06C10000 06D24FFF 00115000
06/30/2007 19:20:49,spid70,Unknown,* msfte 069B0000 06C08FFF 00259000
06/30/2007 19:20:49,spid70,Unknown,* security 06190000 06193FFF 00004000
06/30/2007 19:20:49,spid70,Unknown,* wshtcpip 05CC0000 05CC7FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* hnetcfg 05C20000 05C78FFF 00059000
06/30/2007 19:20:49,spid70,Unknown,* rasadhlp 76F80000 76F87FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
06/30/2007 19:20:49,spid70,Unknown,* winrnr 76F70000 76F76FFF 00007000
06/30/2007 19:20:49,spid70,Unknown,* DNSAPI 76ED0000 76EFEFFF 0002f000
06/30/2007 19:20:49,spid70,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
06/30/2007 19:20:49,spid70,Unknown,* VERSION 77B90000 77B97FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* MTXCLU 74F40000 74F58FFF 00019000
06/30/2007 19:20:49,spid70,Unknown,* msvcp60 780C0000 78120FFF 00061000
06/30/2007 19:20:49,spid70,Unknown,* MSDTCPRX 05B30000 05BA7FFF 00078000
06/30/2007 19:20:49,spid70,Unknown,* XOLEHLP 05B20000 05B25FFF 00006000
06/30/2007 19:20:49,spid70,Unknown,* COMRES 77010000 770D5FFF 000c6000
06/30/2007 19:20:49,spid70,Unknown,* schannel 76750000 76776FFF 00027000
06/30/2007 19:20:49,spid70,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
06/30/2007 19:20:49,spid70,Unknown,* kerberos 05A70000 05AC7FFF 00058000
06/30/2007 19:20:49,spid70,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
06/30/2007 19:20:49,spid70,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
06/30/2007 19:20:49,spid70,Unknown,* MSCOREE 05800000 05844FFF 00045000
06/30/2007 19:20:49,spid70,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
06/30/2007 19:20:49,spid70,Unknown,* rsaenh 04D20000 04D4EFFF 0002f000
06/30/2007 19:20:49,spid70,Unknown,* SQLOS 344D0000 344D4FFF 00005000
06/30/2007 19:20:49,spid70,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
06/30/2007 19:20:49,spid70,Unknown,* RESUTILS 74EF0000 74F02FFF 00013000
06/30/2007 19:20:49,spid70,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
06/30/2007 19:20:49,spid70,Unknown,* ole32 77670000 777A3FFF 00134000
06/30/2007 19:20:49,spid70,Unknown,* CLUSAPI 74DE0000 74DF1FFF 00012000
06/30/2007 19:20:49,spid70,Unknown,* instapi 48060000 48069FFF 0000a000
06/30/2007 19:20:49,spid70,Unknown,* psapi 76B70000 76B7AFFF 0000b000
06/30/2007 19:20:49,spid70,Unknown,* comctl32 77420000 77522FFF 00103000
06/30/2007 19:20:49,spid70,Unknown,* IMM32 76290000 762ACFFF 0001d000
06/30/2007 19:20:49,spid70,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
06/30/2007 19:20:49,spid70,Unknown,* SHELL32 7C8D0000 7D0D3FFF 00804000
06/30/2007 19:20:49,spid70,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
06/30/2007 19:20:49,spid70,Unknown,* opends60 333E0000 333E6FFF 00007000
06/30/2007 19:20:49,spid70,Unknown,* USERENV 76920000 769E3FFF 000c4000
06/30/2007 19:20:49,spid70,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* WS2_32 71C00000 71C16FFF 00017000
06/30/2007 19:20:49,spid70,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
06/30/2007 19:20:49,spid70,Unknown,* Secur32 76F50000 76F62FFF 00013000
06/30/2007 19:20:49,spid70,Unknown,* MSASN1 76190000 761A1FFF 00012000
06/30/2007 19:20:49,spid70,Unknown,* CRYPT32 761B0000 76242FFF 00093000
06/30/2007 19:20:49,spid70,Unknown,* GDI32 77C00000 77C48FFF 00049000
06/30/2007 19:20:49,spid70,Unknown,* USER32 77380000 77411FFF 00092000
06/30/2007 19:20:49,spid70,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
06/30/2007 19:20:49,spid70,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
06/30/2007 19:20:49,spid70,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
06/30/2007 19:20:49,spid70,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
06/30/2007 19:20:49,spid70,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
06/30/2007 19:20:49,spid70,Unknown,* kernel32 77E40000 77F41FFF 00102000
06/30/2007 19:20:49,spid70,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
06/30/2007 19:20:49,spid70,Unknown,* sqlservr 01000000 02C0AFFF 01c0b000
06/30/2007 19:20:49,spid70,Unknown,* MODULE BASE END SIZE
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* _ccost].[dbo_dim_ccostCOST_ID2_1] ) )
06/30/2007 19:20:49,spid70,Unknown,* OST_ID] ) AND ( [dimUserNameCCost].[COST_ID] = [dbo_dim
06/30/2007 19:20:49,spid70,Unknown,* ( [dbo_dim_ccost].[dbo_dim_ccostCOST_ID2_1] = [dbo_dim_ccost1].[C
06/30/2007 19:20:49,spid70,Unknown,* dimDIV_CCOST_USERNAME] ) AS [dbo_dim_ccost] WHERE (
06/30/2007 19:20:49,spid70,Unknown,* o_dim_ccostdiv2_0]<c/>[COST_ID] AS [dbo_dim_ccostCOST_ID2_1] FROM [dbo].[
06/30/2007 19:20:49,spid70,Unknown,* t] AS [dbo_dim_ccost1]<c/> ( SELECT DISTINCT [div] AS [db
06/30/2007 19:20:49,spid70,Unknown,* M dimUserNameCCost ) AS [dimUserNameCCost]<c/>[dbo].[dim_ccos
06/30/2007 19:20:49,spid70,Unknown,* SAMACCOUNTNAME + 'MEGATV' AS USR<c/> USERNAME<c/> COST_ID<c/> displayname FRO
06/30/2007 19:20:49,spid70,Unknown,* .[dbo_dim_ccostdiv2_0] AS [dbo_dim_ccostdiv2_0] FROM ( SELECT
06/30/2007 19:20:49,spid70,Unknown,* im_ccost1].[COST_DESCR] AS [dbo_dim_ccost1COST_DESCR1_0]<c/>[dbo_dim_ccost]
06/30/2007 19:20:49,spid70,Unknown,* 0_2]<c/>[dimUserNameCCost].[COST_ID] AS [dimUserNameCCostCOST_ID0_3]<c/>[dbo_d
06/30/2007 19:20:49,spid70,Unknown,* AME0_1]<c/>[dimUserNameCCost].[displayname] AS [dimUserNameCCostdisplayname
06/30/2007 19:20:49,spid70,Unknown,* NameCCostUSR0_0]<c/>[dimUserNameCCost].[USERNAME] AS [dimUserNameCCostUSERN
06/30/2007 19:20:49,spid70,Unknown,* SELECT DISTINCT [dimUserNameCCost].[USR] AS [dimUser
06/30/2007 19:20:49,spid70,Unknown,* Input Buffer 510 bytes -
06/30/2007 19:20:49,spid70,Unknown,* Access Violation occurred writing address 88000000
06/30/2007 19:20:49,spid70,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
06/30/2007 19:20:49,spid70,Unknown,* Exception Address = 88000000 Module(UNKNOWN+00000000)
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* 06/30/07 19:20:49 spid 70
06/30/2007 19:20:49,spid70,Unknown,* BEGIN STACK DUMP:
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* *******************************************************************************
06/30/2007 19:20:49,spid70,Unknown,SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
06/30/2007 19:20:49,spid70,Unknown,***Stack Dump being sent to S:MSSQLMSSQL.1MSSQLLOGSQLDump0008.txt
06/30/2007 19:20:49,spid70,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/30/2007 04:07:01,Backup,Unknown,Database backed up. Database: tvmar<c/> creation date(time): 2007/04/18(20:36:58)<c/> pages dumped: 1126<c/> first LSN: 185:4607:48<c/> last LSN: 185:4627:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#625feb9b-cc56-49ad-8b8f-24471cc2d889'}). This is an informational message only. No user action is required.
06/30/2007 04:06:59,Backup,Unknown,Database backed up. Database: msdb<c/> creation date(time): 2005/10/14(01:54:05)<c/> pages dumped: 1579<c/> first LSN: 741:216:261<c/> last LSN: 741:328:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#af5c48e2-5b0b-4042-868d-6b28f7f5d657'}). This is an informational message only. No user action is required.
06/30/2007 04:06:55,Backup,Unknown,Database backed up. Database: model<c/> creation date(time): 2003/04/08(09:13:36)<c/> pages dumped: 189<c/> first LSN: 37:416:37<c/> last LSN: 37:440:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c79803b2-6fad-4187-b658-66d71ceb315e'}). This is an informational message only. No user action is required.
06/30/2007 04:06:53,Backup,Unknown,Database backed up. Database: master<c/> creation date(time): 2007/06/28(13:34:15)<c/> pages dumped: 387<c/> first LSN: 1076:400:37<c/> last LSN: 1076:424:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c4a63fb1-ad81-44c0-8625-a2e18e1ac6ec'}). This is an informational message only. No user action is required.
06/30/2007 04:06:50,Backup,Unknown,Database backed up. Database: intranet<c/> creation date(time): 2007/03/21(14:33:52)<c/> pages dumped: 219<c/> first LSN: 27:659:37<c/> last LSN: 27:675:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#46625684-d128-4a77-8d48-bd55a043773a'}). This is an informational message only. No user action is required.
06/30/2007 04:06:48,Backup,Unknown,Database backed up. Database: facilityTest<c/> creation date(time): 2007/03/30(19:23:59)<c/> pages dumped: 7600<c/> first LSN: 242:20105:207<c/> last LSN: 242:20187:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#717e4863-92f3-4060-9a96-cfbdaf7574ca'}). This is an informational message only. No user action is required.
06/30/2007 04:06:44,Backup,Unknown,Database backed up. Database: as400<c/> creation date(time): 2007/03/29(16:40:01)<c/> pages dumped: 187<c/> first LSN: 31:81:37<c/> last LSN: 31:97:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#94c2f4db-37ad-42a0-842a-4ee151868f39'}). This is an informational message only. No user action is required.
06/30/2007 04:06:41,Backup,Unknown,Database backed up. Database: RCREW_EURO<c/> creation date(time): 2007/03/20(15:04:19)<c/> pages dumped: 787<c/> first LSN: 26:4189:37<c/> last LSN: 26:4205:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#45e46e0c-dc9e-4895-8fd6-b96ac9717094'}). This is an informational message only. No user action is required.
06/30/2007 04:06:38,Backup,Unknown,Database backed up. Database: RCREW<c/> creation date(time): 2007/03/20(14:54:00)<c/> pages dumped: 683<c/> first LSN: 27:3697:37<c/> last LSN: 27:3713:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#353bb158-7e11-45c4-8eef-c04721a42df8'}). This is an informational message only. No user action is required.
06/30/2007 04:06:36,Backup,Unknown,Database backed up. Database: ORIGINTICKER<c/> creation date(time): 2007/03/21(17:50:58)<c/> pages dumped: 1015885<c/> first LSN: 3543267:95:104<c/> last LSN: 3543267:1129:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2b249260-808e-4abf-9a46-6117c58788b6'}). This is an informational message only. No user action is required.
06/30/2007 04:04:17,Backup,Unknown,Database backed up. Database: OCCUPATION<c/> creation date(time): 2007/03/30(19:19:29)<c/> pages dumped: 10315<c/> first LSN: 29:66521:69<c/> last LSN: 29:66549:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#ff36832c-71d7-4e58-b3b6-1c2e44afcae4'}). This is an informational message only. No user action is required.
06/30/2007 04:04:13,Backup,Unknown,Database backed up. Database: NEWSLINE<c/> creation date(time): 2007/03/23(15:14:29)<c/> pages dumped: 539<c/> first LSN: 27:2842:37<c/> last LSN: 27:2858:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#953b7822-79c0-4e47-8806-2cdc01633de0'}). This is an informational message only. No user action is required.
06/30/2007 04:04:10,Backup,Unknown,Database backed up. Database: NEWSFILE<c/> creation date(time): 2007/03/23(11:49:44)<c/> pages dumped: 223872<c/> first LSN: 5679:18451:91<c/> last LSN: 5679:18498:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#e90a643f-0ab4-43af-82ed-50b85835ac65'}). This is an informational message only. No user action is required.
06/30/2007 04:03:28,Backup,Unknown,Database backed up. Database: MegaLIB<c/> creation date(time): 2007/05/17(16:20:40)<c/> pages dumped: 187<c/> first LSN: 34:1747:37<c/> last LSN: 34:1763:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c3d1693b-cc9c-4556-a5bf-f98a3e303755'}). This is an informational message only. No user action is required.
06/30/2007 04:03:25,Backup,Unknown,Database backed up. Database: INVENTORY<c/> creation date(time): 2007/03/23(12:17:43)<c/> pages dumped: 11966<c/> first LSN: 412:1404:95<c/> last LSN: 412:1443:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#901722b7-e555-46f1-8e11-f84994ef133e'}). This is an informational message only. No user action is required.
06/30/2007 04:03:19,Backup,Unknown,Database backed up. Database: INEWS<c/> creation date(time): 2007/03/23(14:23:54)<c/> pages dumped: 15643<c/> first LSN: 95:24345:79<c/> last LSN: 95:24378:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2e399870-8002-4b6c-bdad-906245fcc331'}). This is an informational message only. No user action is required.
06/30/2007 04:03:15,Backup,Unknown,Database backed up. Database: HyperionSS<c/> creation date(time): 2007/03/19(17:55:10)<c/> pages dumped: 349<c/> first LSN: 124:2015:74<c/> last LSN: 124:2045:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#5138e34c-9a19-4ff7-92e2-42a0e1af7a6a'}). This is an informational message only. No user action is required.
06/30/2007 04:03:12,Backup,Unknown,Database backed up. Database: HyperionBI<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 1099<c/> first LSN: 48:1336:37<c/> last LSN: 48:1352:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#ceeecf9e-6d4b-4ec4-b541-635cfa1a7012'}). This is an informational message only. No user action is required.
06/30/2007 04:03:09,Backup,Unknown,Database backed up. Database: HyperionAIS<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 195<c/> first LSN: 44:704:37<c/> last LSN: 44:720:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#798e76c1-c6bb-45a1-ac7c-73a7c386b090'}). This is an informational message only. No user action is required.
06/30/2007 04:03:07,Backup,Unknown,Database backed up. Database: HyperionAAS<c/> creation date(time): 2007/03/19(17:53:48)<c/> pages dumped: 491<c/> first LSN: 45:2848:37<c/> last LSN: 45:2864:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#f7d829ef-a850-43ba-a576-d7293254ccf4'}). This is an informational message only. No user action is required.
06/30/2007 04:03:04,Backup,Unknown,Database backed up. Database: HOTLINE<c/> creation date(time): 2007/03/20(10:54:42)<c/> pages dumped: 267<c/> first LSN: 25:4137:37<c/> last LSN: 25:4153:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#92a1de2a-936d-4048-8c5e-05b6ab2434d2'}). This is an informational message only. No user action is required.
06/30/2007 04:03:02,Backup,Unknown,Database backed up. Database: EMEDIA<c/> creation date(time): 2007/03/26(12:27:39)<c/> pages dumped: 235<c/> first LSN: 59:1198:58<c/> last LSN: 59:1222:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#7e28ff07-08e6-4eed-bf80-38ba1e4627ea'}). This is an informational message only. No user action is required.
06/30/2007 04:02:59,Backup,Unknown,Database backed up. Database: EKLOGES_OLD<c/> creation date(time): 2007/03/19(15:17:03)<c/> pages dumped: 291<c/> first LSN: 26:439:37<c/> last LSN: 26:455:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#dc8d9b3e-7928-42b9-9e61-32ae03d68a56'}). This is an informational message only. No user action is required.
06/30/2007 04:02:56,Backup,Unknown,Database backed up. Database: EKLOGES_2006w1<c/> creation date(time): 2007/03/19(15:13:58)<c/> pages dumped: 2475<c/> first LSN: 26:19205:37<c/> last LSN: 26:19221:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#67613979-2561-4519-a919-ce7ee21d01e5'}). This is an informational message only. No user action is required.
06/30/2007 04:02:49,Backup,Unknown,Database backed up. Database: EKLOGES_2004v<c/> creation date(time): 2007/03/19(14:59:27)<c/> pages dumped: 3143<c/> first LSN: 60:982:37<c/> last LSN: 60:998:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a19662a8-4397-4ee3-bd06-d58f2e010203'}). This is an informational message only. No user action is required.
06/30/2007 04:02:46,Backup,Unknown,Database backed up. Database: EKLOGES_2002w2<c/> creation date(time): 2007/03/19(14:52:44)<c/> pages dumped: 3555<c/> first LSN: 26:13056:37<c/> last LSN: 26:13072:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#8f1f1d10-b189-43fc-aed8-0c92ece14d41'}). This is an informational message only. No user action is required.
06/30/2007 04:02:43,Backup,Unknown,Database backed up. Database: EKLOGES_2002w1<c/> creation date(time): 2007/03/19(14:50:21)<c/> pages dumped: 2579<c/> first LSN: 25:16928:37<c/> last LSN: 25:16944:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c2c3f2e9-1ccf-4721-982b-4d17f38457a9'}). This is an informational message only. No user action is required.
06/30/2007 04:02:40,Backup,Unknown,Database backed up. Database: EKLOGES<c/> creation date(time): 2007/03/19(14:45:35)<c/> pages dumped: 6667<c/> first LSN: 40:2427:37<c/> last LSN: 40:2443:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#9cc652ff-96da-48bf-bc4c-ebc5ca53d010'}). This is an informational message only. No user action is required.
06/30/2007 04:02:35,Backup,Unknown,Database backed up. Database: EDUCATION<c/> creation date(time): 2007/03/19(15:24:25)<c/> pages dumped: 515<c/> first LSN: 25:9018:37<c/> last LSN: 25:9034:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#dbe7459f-c466-456f-ad68-4cef5d73f21f'}). This is an informational message only. No user action is required.
06/30/2007 04:02:33,Backup,Unknown,Database backed up. Database: CitrixDS<c/> creation date(time): 2007/03/26(17:43:57)<c/> pages dumped: 539<c/> first LSN: 27:7897:37<c/> last LSN: 27:7913:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#3b027d4d-4e2f-4c0e-b555-b7a4f8a25c66'}). This is an informational message only. No user action is required.
06/30/2007 04:02:29,Backup,Unknown,Database backed up. Database: CSDB7<c/> creation date(time): 2007/04/19(13:27:08)<c/> pages dumped: 2865<c/> first LSN: 198:413:37<c/> last LSN: 198:429:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#247141fd-14a3-4fdf-9de0-97688403c6fa'}). This is an informational message only. No user action is required.
06/30/2007 04:02:26,Backup,Unknown,Database backed up. Database: CSDB<c/> creation date(time): 2007/03/26(16:18:53)<c/> pages dumped: 2354<c/> first LSN: 158:464:37<c/> last LSN: 158:480:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#449a6f8a-be30-4c65-a590-8fd67a5b000f'}). This is an informational message only. No user action is required.
06/30/2007 04:02:23,Backup,Unknown,Database backed up. Database: ANALYZ72<c/> creation date(time): 2007/03/20(11:51:27)<c/> pages dumped: 307<c/> first LSN: 25:4012:37<c/> last LSN: 25:4028:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1d9869b3-cce4-4c71-8747-19e955367fec'}). This is an informational message only. No user action is required.
06/30/2007 04:02:20,Backup,Unknown,Database backed up. Database: AEPI<c/> creation date(time): 2007/03/21(16:08:39)<c/> pages dumped: 7843<c/> first LSN: 29:15235:81<c/> last LSN: 29:15268:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#4dbe1fa4-0089-48a0-8b46-54ff5679d3e5'}). This is an informational message only. No user action is required.
06/30/2007 00:00:04,spid17s,Unknown,This instance of SQL Server has been using a process ID of 4788 since 28/6/2007 1:34:28 μμ (local) 28/6/2007 10:34:28 πμ (UTC). This is an informational message only; no user action is required.
06/29/2007 23:22:15,Logon,Unknown,Login failed for user 'MEGATVsuper1'. [CLIENT: 10.1.0.90]
06/29/2007 23:22:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
06/29/2007 15:42:34,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:34,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:32,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:32,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:30,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:20,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:20,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:16,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:16,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:13,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:13,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:11,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:11,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:09,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:06,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:06,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:02,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:02,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:01,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:01,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:00,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:41:58,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:41:58,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:41:50,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:41:50,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:41:10,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:41:10,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:58,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:58,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:40,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:40,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:21,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:21,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:15,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:12,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:12,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:39:56,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:39:56,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:39:24,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:39:24,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:38:56,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:38:56,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:38:35,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:38:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:38:30,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:38:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:37:59,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:37:59,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:37:54,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:37:54,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:35,Logon,Unknown,Login failed for user 'gavogiac'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/29/2007 15:36:30,Logon,Unknown,Login failed for user 'gavogiac'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/29/2007 15:36:30,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:20,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:20,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:19,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:19,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:17,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:17,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:15,Logon,Unknown,Login failed for user 'gavogiac'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/29/2007 15:36:09,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:05,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:05,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:00,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:54,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:54,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:49,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:49,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:44,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:38,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:38,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:29,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:29,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:25,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:25,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:34:36,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:34:36,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:34:31,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:34:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:34:31,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:34:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:33:55,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:33:55,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:33:43,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:33:43,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:32:56,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:32:56,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:30:23,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:30:23,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:30:02,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:30:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:28:08,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:28:08,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:27:55,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:27:55,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 04:07:52,Backup,Unknown,Database backed up. Database: tvmar<c/> creation date(time): 2007/04/18(20:36:58)<c/> pages dumped: 1126<c/> first LSN: 185:4003:48<c/> last LSN: 185:4023:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#5687baaa-002a-4f65-8bb7-2f2ba5d735df'}). This is an informational message only. No user action is required.
06/29/2007 04:07:49,Backup,Unknown,Database backed up. Database: msdb<c/> creation date(time): 2005/10/14(01:54:05)<c/> pages dumped: 1579<c/> first LSN: 732:176:173<c/> last LSN: 732:256:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#e05a8e22-2f32-492e-8412-145e9b9b9b09'}). This is an informational message only. No user action is required.
06/29/2007 04:07:45,Backup,Unknown,Database backed up. Database: model<c/> creation date(time): 2003/04/08(09:13:36)<c/> pages dumped: 189<c/> first LSN: 37:352:37<c/> last LSN: 37:376:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1d2c5054-e7c1-4bdf-9799-b22b2c050f9d'}). This is an informational message only. No user action is required.
06/29/2007 04:07:43,Backup,Unknown,Database backed up. Database: master<c/> creation date(time): 2007/06/28(13:34:15)<c/> pages dumped: 387<c/> first LSN: 1063:488:37<c/> last LSN: 1064:16:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b18252f8-58b9-4997-9c24-f18f49a92f19'}). This is an informational message only. No user action is required.
06/29/2007 04:07:40,Backup,Unknown,Database backed up. Database: intranet<c/> creation date(time): 2007/03/21(14:33:52)<c/> pages dumped: 219<c/> first LSN: 27:635:37<c/> last LSN: 27:651:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#f16b3299-bedc-4c50-b223-b49a59247f72'}). This is an informational message only. No user action is required.
06/29/2007 04:07:37,Backup,Unknown,Database backed up. Database: facilityTest<c/> creation date(time): 2007/03/30(19:23:59)<c/> pages dumped: 7592<c/> first LSN: 242:16437:260<c/> last LSN: 242:16540:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#40b0b72f-e411-47ab-be0e-873148db25ad'}). This is an informational message only. No user action is required.
06/29/2007 04:07:32,Backup,Unknown,Database backed up. Database: as400<c/> creation date(time): 2007/03/29(16:40:01)<c/> pages dumped: 187<c/> first LSN: 31:57:37<c/> last LSN: 31:73:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#666a5305-593a-4079-8b5f-1d3b32198312'}). This is an informational message only. No user action is required.
06/29/2007 04:07:29,Backup,Unknown,Database backed up. Database: RCREW_EURO<c/> creation date(time): 2007/03/20(15:04:19)<c/> pages dumped: 787<c/> first LSN: 26:4165:37<c/> last LSN: 26:4181:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2666bdfc-27c7-4131-a923-cfafd2843977'}). This is an informational message only. No user action is required.
06/29/2007 04:07:27,Backup,Unknown,Database backed up. Database: RCREW<c/> creation date(time): 2007/03/20(14:54:00)<c/> pages dumped: 683<c/> first LSN: 27:3673:37<c/> last LSN: 27:3689:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#9230e56f-cf09-47b1-9655-f854eda23636'}). This is an informational message only. No user action is required.
06/29/2007 04:07:24,Backup,Unknown,Database backed up. Database: ORIGINTICKER<c/> creation date(time): 2007/03/21(17:50:58)<c/> pages dumped: 1013805<c/> first LSN: 3537241:231:143<c/> last LSN: 3537249:1119:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#306bb758-9bc1-48fd-88bc-68b38e83e30b'}). This is an informational message only. No user action is required.
06/29/2007 04:05:07,Backup,Unknown,Database backed up. Database: OCCUPATION<c/> creation date(time): 2007/03/30(19:19:29)<c/> pages dumped: 10315<c/> first LSN: 29:66381:78<c/> last LSN: 29:66413:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a10445fe-fb7c-4721-891a-2a588c17f8e1'}). This is an informational message only. No user action is required.
06/29/2007 04:05:02,Backup,Unknown,Database backed up. Database: NEWSLINE<c/> creation date(time): 2007/03/23(15:14:29)<c/> pages dumped: 539<c/> first LSN: 27:2818:37<c/> last LSN: 27:2834:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#43f574a6-d674-4779-b661-4ceb3659e29b'}). This is an informational message only. No user action is required.
06/29/2007 04:04:59,Backup,Unknown,Database backed up. Database: NEWSFILE<c/> creation date(time): 2007/03/23(11:49:44)<c/> pages dumped: 223800<c/> first LSN: 5678:38062:91<c/> last LSN: 5678:38108:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#e0b6624f-f9e9-4f3e-960c-abf307b31e49'}). This is an informational message only. No user action is required.
06/29/2007 04:04:11,Backup,Unknown,Database backed up. Database: MegaLIB<c/> creation date(time): 2007/05/17(16:20:40)<c/> pages dumped: 187<c/> first LSN: 34:1723:37<c/> last LSN: 34:1739:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2a63636e-9639-492e-bf69-e42085d19a47'}). This is an informational message only. No user action is required.
06/29/2007 04:04:09,Backup,Unknown,Database backed up. Database: INVENTORY<c/> creation date(time): 2007/03/23(12:17:43)<c/> pages dumped: 11798<c/> first LSN: 411:2409:65<c/> last LSN: 411:2435:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#706d845f-e3d7-4a7b-8521-629f89be2a73'}). This is an informational message only. No user action is required.
06/29/2007 04:04:04,Backup,Unknown,Database backed up. Database: INEWS<c/> creation date(time): 2007/03/23(14:23:54)<c/> pages dumped: 15627<c/> first LSN: 94:16404:72<c/> last LSN: 94:16434:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#eb05358a-f960-4c53-9eb2-6fb542b640a4'}). This is an informational message only. No user action is required.
06/29/2007 04:03:58,Backup,Unknown,Database backed up. Database: HyperionSS<c/> creation date(time): 2007/03/19(17:55:10)<c/> pages dumped: 349<c/> first LSN: 124:1380:74<c/> last LSN: 124:1410:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#3c61f90d-c761-400b-9918-3cd100842ad4'}). This is an informational message only. No user action is required.
06/29/2007 04:03:55,Backup,Unknown,Database backed up. Database: HyperionBI<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 1099<c/> first LSN: 48:1312:37<c/> last LSN: 48:1328:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#d48daf21-497e-4397-924b-3811a7260cc8'}). This is an informational message only. No user action is required.
06/29/2007 04:03:52,Backup,Unknown,Database backed up. Database: HyperionAIS<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 195<c/> first LSN: 44:680:37<c/> last LSN: 44:696:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b2194d80-1c8d-4d6c-aad5-161e090814d3'}). This is an informational message only. No user action is required.
06/29/2007 04:03:49,Backup,Unknown,Database backed up. Database: HyperionAAS<c/> creation date(time): 2007/03/19(17:53:48)<c/> pages dumped: 491<c/> first LSN: 45:2824:37<c/> last LSN: 45:2840:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b25941f5-f32e-43fb-a6c5-74d121fb3f90'}). This is an informational message only. No user action is required.
06/29/2007 04:03:47,Backup,Unknown,Database backed up. Database: HOTLINE<c/> creation date(time): 2007/03/20(10:54:42)<c/> pages dumped: 267<c/> first LSN: 25:4113:37<c/> last LSN: 25:4129:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#18c5054e-490b-473b-9e0b-5bab4593272e'}). This is an informational message only. No user action is required.
06/29/2007 04:03:44,Backup,Unknown,Database backed up. Database: EMEDIA<c/> creation date(time): 2007/03/26(12:27:39)<c/> pages dumped: 235<c/> first LSN: 58:3684:58<c/> last LSN: 58:3708:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1c62a71b-f0e6-43a5-a96c-ecd342022daf'}). This is an informational message only. No user action is required.
06/29/2007 04:03:41,Backup,Unknown,Database backed up. Database: EKLOGES_OLD<c/> creation date(time): 2007/03/19(15:17:03)<c/> pages dumped: 291<c/> first LSN: 26:416:37<c/> last LSN: 26:432:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a9b40e52-6465-4744-a401-406901789e0c'}). This is an informational message only. No user action is required.
06/29/2007 04:03:37,Backup,Unknown,Database backed up. Database: EKLOGES_2006w1<c/> creation date(time): 2007/03/19(15:13:58)<c/> pages dumped: 2475<c/> first LSN: 26:19181:37<c/> last LSN: 26:19197:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#da624ff6-6c35-4c97-9665-e6fa6c5c5765'}). This is an informational message only. No user action is required.
06/29/2007 04:03:34,Backup,Unknown,Database backed up. Database: EKLOGES_2004v<c/> creation date(time): 2007/03/19(14:59:27)<c/> pages dumped: 3143<c/> first LSN: 60:958:37<c/> last LSN: 60:974:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a52b3691-b199-4efe-ab95-792d79013466'}). This is an informational message only. No user action is required.
06/29/2007 04:03:30,Backup,Unknown,Database backed up. Database: EKLOGES_2002w2<c/> creation date(time): 2007/03/19(14:52:44)<c/> pages dumped: 3555<c/> first LSN: 26:13032:37<c/> last LSN: 26:13048:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1132c8d3-a0cb-49f8-aee0-9169489d9535'}). This is an informational message only. No user action is required.
06/29/2007 04:02:59,Backup,Unknown,Database backed up. Database: EKLOGES_2002w1<c/> creation date(time): 2007/03/19(14:50:21)<c/> pages dumped: 2579<c/> first LSN: 25:16904:37<c/> last LSN: 25:16920:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2c22053b-4415-4206-9b1e-16a19ca00293'}). This is an informational message only. No user action is required.
06/29/2007 04:02:54,Backup,Unknown,Database backed up. Database: EKLOGES<c/> creation date(time): 2007/03/19(14:45:35)<c/> pages dumped: 6667<c/> first LSN: 40:2403:37<c/> last LSN: 40:2419:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#977ee3c9-f843-42ab-830e-4c42da263a9f'}). This is an informational message only. No user action is required.
06/29/2007 04:02:50,Backup,Unknown,Database backed up. Database: EDUCATION<c/> creation date(time): 2007/03/19(15:24:25)<c/> pages dumped: 515<c/> first LSN: 25:8994:37<c/> last LSN: 25:9010:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1d554fee-ea6f-4fdc-9106-072cc02dbd1c'}). This is an informational message only. No user action is required.
06/29/2007 04:02:47,Backup,Unknown,Database backed up. Database: CitrixDS<c/> creation date(time): 2007/03/26(17:43:57)<c/> pages dumped: 539<c/> first LSN: 27:7873:37<c/> last LSN: 27:7889:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b7613cbf-8d0b-46e4-96ee-ae4641da731f'}). This is an informational message only. No user action is required.
06/29/2007 04:02:44,Backup,Unknown,Database backed up. Database: CSDB7<c/> creation date(time): 2007/04/19(13:27:08)<c/> pages dumped: 2865<c/> first LSN: 198:389:37<c/> last LSN: 198:405:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#9ab05cf5-7b40-46cc-a0ad-8beeb5ae3b9d'}). This is an informational message only. No user action is required.
06/29/2007 04:02:39,Backup,Unknown,Database backed up. Database: CSDB<c/> creation date(time): 2007/03/26(16:18:53)<c/> pages dumped: 2354<c/> first LSN: 158:440:37<c/> last LSN: 158:456:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#d37e1310-fb07-403e-a70d-1c0931a2257d'}). This is an informational message only. No user action is required.
06/29/2007 04:02:35,Backup,Unknown,Database backed up. Database: ANALYZ72<c/> creation date(time): 2007/03/20(11:51:27)<c/> pages dumped: 307<c/> first LSN: 25:3988:37<c/> last LSN: 25:4004:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#02b53ae8-417e-48f0-a73c-a22ea9e7a604'}). This is an informational message only. No user action is required.
06/29/2007 04:02:31,Backup,Unknown,Database backed up. Database: AEPI<c/> creation date(time): 2007/03/21(16:08:39)<c/> pages dumped: 7835<c/> first LSN: 29:13524:37<c/> last LSN: 29:13540:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c7479e38-213b-4a41-a7bf-6c82b12f25d1'}). This is an informational message only. No user action is required.
06/29/2007 00:00:19,spid18s,Unknown,This instance of SQL Server has been using a process ID of 4788 since 28/6/2007 1:34:28 μμ (local) 28/6/2007 10:34:28 πμ (UTC). This is an informational message only; no user action is required.
06/28/2007 19:54:57,Logon,Unknown,Login failed for user 'MEGATVpaternag'. [CLIENT: 10.1.1.43]
06/28/2007 19:54:57,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
06/28/2007 19:53:23,Logon,Unknown,Login failed for user 'MEGATVpaternag'. [CLIENT: 10.1.1.43]
06/28/2007 19:53:23,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
06/28/2007 19:53:05,Logon,Unknown,Login failed for user 'pilot'. [CLIENT: 10.1.1.43]
06/28/2007 19:53:05,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/28/2007 19:51:30,Logon,Unknown,Login failed for user 'pilot'. [CLIENT: 10.1.1.43]
06/28/2007 19:51:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/28/2007 19:50:47,Logon,Unknown,Login failed for user 'pilotusr'. [CLIENT: 10.1.1.43]
06/28/2007 19:50:47,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/28/2007 16:48:01,Server,Unknown,A user request from the session with SPID 75 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
06/28/2007 16:48:01,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
06/28/2007 16:48:01,spid75,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
06/28/2007 16:48:01,spid75,Unknown,Stack Signature for the dump is 0x975B0CDA
06/28/2007 16:48:01,spid75,Unknown,78132A36 Module(MSVCR80+00002A36)
06/28/2007 16:48:01,spid75,Unknown,781329AA Module(MSVCR80+000029AA)
06/28/2007 16:48:01,spid75,Unknown,0146753D Module(sqlservr+0046753D)
06/28/2007 16:48:01,spid75,Unknown,01466761 Module(sqlservr+00466761)
06/28/2007 16:48:01,spid75,Unknown,014676D8 Module(sqlservr+004676D8)
06/28/2007 16:48:01,spid75,Unknown,014677E1 Module(sqlservr+004677E1)
06/28/2007 16:48:01,spid75,Unknown,01006F3B Module(sqlservr+00006F3B)
06/28/2007 16:48:01,spid75,Unknown,01006D4C Module(sqlservr+00006D4C)
06/28/2007 16:48:01,spid75,Unknown,01006C26 Module(sqlservr+00006C26)
06/28/2007 16:48:01,spid75,Unknown,0104A331 Module(sqlservr+0004A331)
06/28/2007 16:48:01,spid75,Unknown,0104AB65 Module(sqlservr+0004AB65)
06/28/2007 16:48:01,spid75,Unk

View 2 Replies View Related

Error Stating Package Failure While Executing SSIS Package In Standard Edition

Feb 2, 2007

Hi,

I have developed an SSIS package for ETL purpose. I am invoking the SSIS package through .Net console application by referencing the ManagedDTS Assembly. I am able to execute the package in Sql Server 2005 Developer Edition and it runs fine till completion.

But when i try to execute the packahe in Sql Server 2005 Standard edition, by invoking the package through .Net console application the status of the package is failure.

Can any one help me how to over come this problem.



View 1 Replies View Related

Package Validation Error : The Package Designer Deletes The Code From Script Task.

Jun 14, 2006

While Creating a script task in Control Flow, I am getting "Package Validation Error". Here is the complete message:

Error at Validate File and Load Data: The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated.
(Microsoft.DataTransformationServices.VsIntegration)

As mentioned in the message, I opened the script IDE and added the code I need. When I close the VSA IDE, package designer displays the same error message.

The worst part of whole story is that if I close the package designer and reopen it, I find that all the code I wrote in the script task has been deleted by the package designer. This is not at all acceptable as I saved the package the and still lost all my work. I did all the coding from scratch for that task.

Please respond if anyone faced similar problem.

Thanks in advance!

Anand

PS: If any one from Microsoft is reading this, please see what you guys are coding there. Due to the buggy software you deliver, I am loosing my credibility.<P< P>

View 5 Replies View Related

Execute Package Task: Error 0x80070005 While Preparing To Load The Package. Access Is Denied.

Jun 8, 2007

I am having problems executing a child package from a parent package using the Execute Package Task. I am attempting to run the master package through a SQL Server Agent job.

The SQL Server Agent job is owned by sa. The step that runs the parent package is configured to load the package from the SSIS Package Store on the same server that the job is running.

I have the Execute Package Task configured as follows:

Location: SQL Server
ExecuteOutOfProcess: True
Connecting as a SQL Server login (let's say TestEtl)

I have added the db_dtsoperator database role to both the TestEtl login and the login that SQL Server Agent connects through. I have also configured the child package's reader role to include db_dtsoperator. Per http://msdn2.microsoft.com/en-US/library/ms141053.aspx, this should allow these logins to run the child package.

I have enabled logging of all events in both the parent and child packages. I see the following in the logs when the Execute Package Task executes (omitted portions unrelated to the execution of the child package task):

450939 OnPreExecute ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450940 OnPreValidate ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450941 OnPostValidate ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450942 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_pre: The object is ready to make the following external request: 'IDataInitialize::GetDataSource'.450943 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_post: 'IDataInitialize::GetDataSource succeeded'. The external request has completed.450944 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_pre: The object is ready to make the following external request: 'IDBInitialize::Initialize'.450945 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_post: 'IDBInitialize::Initialize succeeded'. The external request has completed.450946 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_pre: The object is ready to make the following external request: 'IDBCreateSession::CreateSession'.450947 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_post: 'IDBCreateSession::CreateSession succeeded'. The external request has completed.450948 OnError ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 Error 0x80070005 while preparing to load the package. Access is denied. . 450949 OnError ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 Error 0x80070005 while preparing to load the package. Access is denied. . 450950 OnTaskFailed ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450951 OnPostExecute ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450952 OnWarning ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) 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. 450953 OnPostExecute ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450954 PackageEnd ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 End of package execution.

I am sure that what I am doing is quite common, and I obviously have something misconfigured somewhere - but I'm not sure what my misconfiguration is. Can anyone enlighten me?

View 6 Replies View Related

Apostrophes In Input String Terminating Update Statement

Sep 7, 2006

Hi.

I have an update statement that accepts
a user's text input. problem is that the string
terminates the sql update statement if there is
an apostrophe in it. so, headline='i like my brother's car"
willl terminate after "brother". "s car" is read as sql.

how is this resolved?



Code:


Dim MyCmd2 As New Data.SqlClient.SqlCommand("SET ANSI_WARNINGS OFF " & _
"UPDATE EditProfile " & _
"SET headline='"+ Me.tb_headline.Value+"', about_me='"+ Me.ta_aboutme.Value+"', edit_date='"+System.DateTime.Now.ToString+"' WHERE email_address='"+Context.User.Identity.Name.ToString+"' " & _
"SET ANSI_WARNINGS ON ", MyConn)

View 4 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

Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error Accessing Windows Event Log

Dec 13, 2007



Hi,

I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.

Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error accessing Windows Event Log."

Please help me

thanks in advance

Srinivas



View 1 Replies View Related

SQL Server Is Terminating Due To &#39;stop&#39; Request From Service Control Manager

Nov 6, 2000

Hi

I have been getting this message in the event viwer and my SQL server goes down. I have to go and start the service once again. Can somebody throw some light as how to solve this problem?

Please respond.

Tks.

Zolla

View 3 Replies View Related

Spid3 SQL Server Is Terminating Due To 'stop' Request From Service Control Manager

Aug 28, 2005

Installing MSDE (SP3) on a clean updated Win-XP system with all the latest fixes installed unsuccesfully. A clean systems means a fresh installed Win-XP, updated all using webupdate. And Excel 2003 installed. Thats all (not even AntiVirus (yet))

View 19 Replies View Related

RA_Setup_IO [Bucket: 0] [slot: 0]: Process 4 Generated Access Violation; SQL Server Is Terminating T

Feb 19, 1999

dear friends/collegs:
for the past couple of weeks, we've been seeing:

SQL Server Error:
"kernel RA_Setup_IO [Bucket: 0] [slot: 0]: Process 4 generated access violation; SQL Server is terminating this process"

we're running SQL Server 6.5 sp4. on NT 4. sp3

View 2 Replies View Related

SqlDumpExceptionHandler: Process 3920 Generated Fatal Exception C0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server Is Terminating T

Jan 18, 2008



Hi Guys,

How are you. i hope you all are having fun.
well i have an issue on one of the production box.
Version of the box: Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006 11:38:51 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

As per SQL serve logs which i received couple of times.
step 1) Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0173.txt
2) SqlDumpExceptionHandler: Process 3920 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
3) Stack Signature for the dump is 0xC578316D


when i searched in google and msdn i could not found the exact solution.
if you guys have the knowledge and also got experianced about this issue.
kindly please help me in this regards and one more thing i just want to inform you all this is our production server.
I think you would understantd how criticality is this.

I really appreciate for your feedback. thank you so much,

Raghu


for the 2nd step it is haing a very huge message.
so here i have pasted some part of the message. i think this is more then enough for you all.

SqlDumpExceptionHandler: Process 3920 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 01/17/08 15:30:57 spid 97
*
* Exception Address = 0041656B
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00380008
* Input Buffer 124 bytes -
* EXEC MIS..law_ac_totals "G&A", 2008, 3, 100, 204, "emferrario"
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBEFFF 008bf000
* Invalid Address 77F80000 77FFBFFF 0007c000
* ADVAPI32 7C2D0000 7C334FFF 00065000
* KERNEL32 7C570000 7C623FFF 000b4000
* Invalid Address 77D30000 77D9EFFF 0006f000
* MSVCP71 7C3A0000 7C41AFFF 0007b000
* MSVCR71 7C340000 7C395FFF 00056000
* opends60 41060000 41065FFF 00006000
* SHELL32 7CF30000 7D175FFF 00246000
* GDI32 77F40000 77F7BFFF 0003c000
* USER32 77E10000 77E6EFFF 0005f000
* SHLWAPI 70A70000 70AD5FFF 00066000
* msvcrt 78000000 78044FFF 00045000
* COMCTL32 71710000 71793FFF 00084000
* sqlsort 42AE0000 42B6FFFF

View 2 Replies View Related







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