Fatal Errors With SQL (asserts, Invalid Page Reads Etc)

Jul 20, 2005

Suddenly in one database we have a lot of errors, it seams some things are
corrupted. I tried to start maintanance / database repair, but this fails
too.

When selecting in Query Analyzer a range of records from a table I get the
following message:

Location: p:sql
tdbmsstorengdrsinclude
ecord.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 68
Process ID: 1208

When I select the record that causes this error, the following error is
reported in Query Analyzer:

Could not find the index entry for RID '163748993200' in index page
(3:373352), index ID 0, database 'sal'.

In the log I see a lot of these messages:

Stack Signature for the dump is 0x&D179C48
Could not open FCD for invalid file ID 21761 in database'sal'
I/O error (bad page ID) detected during read at offset 0x00000b64d2000


How can this be fixed?
How can I rebuild the index for one table / check integrity of one table?
What kind of actions may caused this corruption (if it is corruption) ?
How can it be prevented?

I hope someone can help.

Regards,

Rene

View 5 Replies


ADVERTISEMENT

Send An Email On Non-fatal Errors From Data Flow

Apr 16, 2007

Ok, I'm incredibly new to all of this so please bear with me. I took the Integration Services tutorial, and that's pretty much all that I have done.



I'm creating my first package and I want to be able to email myself when certain non-fatal conditions occur. I still want the entire row to flow into my table.



My understanding is that this type of checking should be done in the "Data Flow" tab not the "Control Flow" tab. However, I can't see a toolbox item in "Data Flow" to create a SQL script like this. I can see that the "Lookup" toolbox item will allow me to write a SQL script but how do I get it to send out the email? Or should I really be doing this type of checking in "Control Flow" where there is an "Send email task" item?



Any help is greatly appreciated! Thanks!







View 8 Replies View Related

High Page Reads

Jan 17, 2002

SQL 6.5 - 5.5 Gig
NT

Hello,

Throughout the day our Document Management application generates high busts of physical page reads when users query the database.

What SQL configuration parameter(s) should I check/modify to insure that the database is performing at it's optimun during these bursts?

Thank You in advance.

View 1 Replies View Related

Restore Gives &#39;invalid Logical Page Number&#39; Error

Jun 24, 1999

We tried to restore an empty database from a backup and got:
'Load database encountered an invalid logical page number' error.
This then set the database as 'loading'

Anyone got any ideas?

We aren't exactly sure how big the first database was when the backup was done but if the new database isn't big enough to contain the backed up data, wouldn't we get a more meaningful error?

Janet

View 2 Replies View Related

Logical Page Errors

Jan 18, 2007

Hi,

we consistently have logical page errors on one of our SQL Servers.
The output from CHECKDB is shown below. Any ideas why this keeps happening. We recently replaced the disk thinking this would solve the problem.

DBCC results for 'TMP_tbl_Pay_Totals'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:391469) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.

AND later on

Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398376) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398377) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398378) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398379) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398448) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398449) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398450) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398451) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398452) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1

Final bit

CHECKDB found 0 allocation errors and 11 consistency errors in database 'ISS'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (ISS ).

Any help or ideas much appreciated.

View 4 Replies View Related

Getting Code Page Errors....

Feb 9, 2006

I am importing some data from my IBM DB2 Z/OS mainframe to SQL Server 2005 using the SSIS import wizard. The wizard automatically converted the DB2 string data before trying to store it to SQL Server. The code page that the wizard chose to do its conversion is the 1252 Ansi Latin. However, I am getting the following error on the address field...."one or more characters had no match in the target code page". Can someone suggest another code page? ASCII? IBM 37?

View 3 Replies View Related

Common Table Expression (CTE) T-SQL Errors:Invalid Object Name 'ProductItemPrices'.The Variablename '@TopEmp' Has Been Declared

Jan 4, 2008

Hi all,
I copied the following code from a tutorial book and executed it in my SQL Server Management Studio Express (SSMSE):
--CET.sql--

USE AdventureWorks

GO

--Use column value from a table pointed at by a foreign key

WITH ProductItemPrices AS

(

SELECT ProductID, AVG(LineTotal) 'AvgPrice'

FROM Sales.SalesOrderDetail

GROUP BY ProductID

)

SELECT p.Name, pp.AvgPrice

FROM ProductItemPrices pp

JOIN

Production.Product p

ON

pp.ProductID = p.ProductID

ORDER BY p.Name

SELECT * FROM ProductItemPrices

GO

--Display rows from SalesOrderDetail table with a LineTotal

--value greater than the average for all Linetotal values with

--the same ProductID value

WITH ProductItemPrices AS

(

SELECT ProductID, AVG(LineTotal) 'AvgPrice'

FROM Sales.SalesOrderDetail

GROUP BY ProductID

)

SELECT TOP 29 sd.SalesOrderID, sd.ProductID, sd.LineTotal, pp.AvgPrice

FROM Sales.SalesOrderDetail sd

JOIN

ProductItemPrices pp

ON pp.ProductID = sd.ProductID

WHERE sd.LineTotal > pp.AvgPrice

ORDER BY sd.SalesOrderID, sd.ProductID



--Return EmployeeID along with first and last name of employees

--not reporting to any other employee

SELECT e.EmployeeID, c.FirstName, c.LastName
JOIN HumanResources.Employee e

ON e.ContactID = c.ContactID

JOIN HumanResources.EmployeeDepartmentHistory d

ON d.EmployeeID = e.EmployeeID

JOIN HumanResources.Department dn

ON dn.DepartmentID = d.DepartmentID)

JOIN Empcte a

ON e.ManagerID = a.empid)

--Order and display result set from CTE

SELECT * Hi all,

I copied the following T-SQL code from a tutorial book and executed it in my SQL Server Management Studio Express (SSMSE):

--CTE.sql--

USE AdventureWorks

GO

--Use column value from a table pointed at by a foreign key

WITH ProductItemPrices AS

(

SELECT ProductID, AVG(LineTotal) 'AvgPrice'

FROM Sales.SalesOrderDetail

GROUP BY ProductID

)

SELECT p.Name, pp.AvgPrice

FROM ProductItemPrices pp

JOIN

Production.Product p

ON

pp.ProductID = p.ProductID

ORDER BY p.Name

SELECT * FROM ProductItemPrices

GO

--Display rows from SalesOrderDetail table with a LineTotal

--value greater than the average for all Linetotal values with

--the same ProductID value

WITH ProductItemPrices AS

(

SELECT ProductID, AVG(LineTotal) 'AvgPrice'

FROM Sales.SalesOrderDetail

GROUP BY ProductID

)

SELECT TOP 29 sd.SalesOrderID, sd.ProductID, sd.LineTotal, pp.AvgPrice

FROM Sales.SalesOrderDetail sd

JOIN

ProductItemPrices pp

ON pp.ProductID = sd.ProductID

WHERE sd.LineTotal > pp.AvgPrice

ORDER BY sd.SalesOrderID, sd.ProductID



--Return EmployeeID along with first and last name of employees

--not reporting to any other employee

SELECT e.EmployeeID, c.FirstName, c.LastName

FROM HumanResources.Employee e

JOIN Person.Contact c

ON e.ContactID = c.ContactID

where ManagerID IS NULL

--Specify top level EmployeeID for direct reports

DECLARE @TopEmp as int

SET @TopEmp = 109;

--Names and departments for direct reports to

--EmployeeID = @TopEmp; calculate employee name

WITH Empcte(empid, empname, mgrid, dName, lvl)

AS

(

-- Anchor row

SELECT e.EmployeeID,

REPLACE(c.FirstName + ' ' + ISNULL(c.MiddleName, '') +

' ' + c.LastName, ' ', ' ') 'Employee name',

e.ManagerID, dn.Name, 0

FROM Person.Contact c

JOIN HumanResources.Employee e

ON e.ContactID = c.ContactID

JOIN HumanResources.EmployeeDepartmentHistory d

ON d.EmployeeID = e.EmployeeID

JOIN HumanResources.Department dn

ON dn.DepartmentID = d.DepartmentID

WHERE e.EmployeeID = @TopEmp

UNION ALL

-- Recursive rows

SELECT e.EmployeeID,

REPLACE(c.FirstName + ' ' + ISNULL(c.MiddleName, '') +

' ' + c.LastName, ' ', ' ') 'Employee name',

e.ManagerID, dn.Name, a.lvl+1

FROM (Person.Contact c

JOIN HumanResources.Employee e

ON e.ContactID = c.ContactID

JOIN HumanResources.EmployeeDepartmentHistory d

ON d.EmployeeID = e.EmployeeID

JOIN HumanResources.Department dn

ON dn.DepartmentID = d.DepartmentID)

JOIN Empcte a

ON e.ManagerID = a.empid)

--Order and display result set from CTE

SELECT *

FROM Empcte

WHERE lvl <= 1

ORDER BY lvl, mgrid, empid

--Alternate statement using MAXRECURSION;

--must position immediately after Empcte to work

SELECT *

FROM Empcte

OPTION (MAXRECURSION 1)
====================================
This is Part 1 (due to the length of input > 50000 characters).
Scott Chang

View 5 Replies View Related

Connections Closed But Still Getting Errors On Page

Apr 16, 2007

I have a page that I have 3 connections.  I've made sure that each of these are closed when they are not being used and opened just right before being used.  I keep getting the error "There is already an open DataReader associated with this Command which must be closed first."  This error might show up as being produced by a dataadapter or sqldatareader...I have many.  I've even tried to make separate connections as some have mentioned for each...leaving me with 15+ connections.  I have added "MultipleActiveResultSets=True" to the connection strings as some have mentioned.  I just don't know where to go from here...
Is it possible that the problem lies in multiple instances of this page being opened?  Also, the data refreshes every 15 seconds.  I really need this to work, but I have no clue on how to fix this problem.  The error is easy to reproduce by opening up multiple instances, but some of the times is doesn't give an error at all?!

View 4 Replies View Related

Code Page Errors In SSIS

Nov 21, 2007



Hi All,
we have a set of packages which has to to be implemented across differnet environments.
the packages invariable uses OLEDB Source/Destination Components.
In these two components the Code Page Property is not Configurable.
so if the package has to be Deployed in a different environment than,where it is Developed it gives a Validation Error.
Is there a Workaround for this problem.
if anybody have faced the problem earlier,please post it.
thanks in advance.
cheers
srikanth

View 1 Replies View Related

DBCC Page / DBCC Checkdb Errors

Jan 9, 2007

Following the below topic:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53271

I followed the advice of Paul Randal, but Im stumped as I am not able to determin what the corruption issues are. This is SQL 2000 and the database is a Solomon database that was recently upgraded to 6.5. the error I get when running the DBCC checkdb is as follows:

Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:18645) with latch type SH. sysindexes failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

When I run select * from sysindexes, I get:

Server: Msg 3624, Level 20, State 1, Line 1

Location: blobman.cpp:1780
Expression: sourceLength == sizeof (TextPointer)
SPID: 53
Process ID: 256

Connection Broken

When I run dbcc page (dbname, 1, 18645, 3)
dbcc traceon(3604), It finishes with what appears to be no errors log is as follows:


PAGE: (1:18645)
---------------

BUFFER:
-------

BUF @0x0144C880
---------------
bpage = 0x681B4000 bhash = 0x00000000 bpageno = (1:18645)
bdbid = 12 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000

PAGE HEADER:
------------

Page @0x681B4000
----------------
m_pageId = (1:18645) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2
m_objId = 2 m_indexId = 0 m_prevPage = (1:505)
m_nextPage = (1:213) pminlen = 82 m_slotCnt = 16
m_freeCnt = 3988 m_freeData = 5796 m_reservedCnt = 0
m_lsn = (42700:4549:10) m_xactReserved = 0 m_xdesId = (0:2539719)
m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:16176) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED

Slot 0 Offset 0xf8c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4F8C: 00520030 013f142a 00004012 00000000 0.R.*.?..@......
681B4F9C: 00010000 00000000 02600000 00010001 ..........`.....
681B4FAC: 00000000 00000000 00000000 00000000 ................
681B4FBC: 00000000 00000000 027a0000 00000022 ..........z."...
681B4FCC: 00000000 00000000 00000000 00000000 ................
681B4FDC: 001b0000 00000000 00800003 80a60096 ................
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
681B500C: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B501C: 00680063 00000030 002a869d 00570000 c.h.0.....*...W.
681B502C: 00010000 0007 ......
id = 20911146
status = 16402
first = 0
indid = 1
root = 0
minlen = 608
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 634
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
name = smInvBatch0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647062528 RowId = (1:87:7)

Slot 1 Offset 0x12c4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B52C4: 00520030 013f142a 00000000 00000000 0.R.*.?.........
681B52D4: 00020000 00000000 00150000 00010003 ................
681B52E4: 00000000 00000000 00000000 00000000 ................
681B52F4: 00000000 00000000 00260000 0000002c ..........&.,...
681B5304: 00000000 00000000 00000000 00000000 ................
681B5314: 001b0000 00000000 00c00003 80e600d6 ................
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
681B5384: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B5394: 00680063 00000031 002a869f 00570000 c.h.1.....*...W.
681B53A4: 00010000 0008 ......
id = 20911146
status = 0
first = 0
indid = 2
root = 0
minlen = 21
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 38
maxirow = 44
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
name = smInvBatch1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647193600 RowId = (1:87:8)

Slot 2 Offset 0x1440
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B5440: 00520030 01584911 00004012 000000c6 0.R..IX..@......
681B5450: 00010001 00000095 09a20001 00010001 ................
681B5460: 00000001 00000005 00000005 00000000 ................
681B5470: 00000000 00000003 09ba0000 0000001a ................
681B5480: 00000000 00000096 00000001 00000000 ................
681B5490: 001b0000 00000000 00800003 80a60096 ................
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
681B54C0: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B54D0: 0065006d 00000030 002a87a9 03a00000 m.e.0.....*.....
681B54E0: 00010000 0019 ......
id = 22563089
status = 16402
first = 0
indid = 1
root = 0
minlen = 2466
keycnt = 1
groupid = 1
dpages = 1
reserved = 5
used = 5
rowcnt = 0
rowmodctr = 3
reserved3 = 0
reserved4 = 0
xmaxlen = 2490
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
name = RptRuntime0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664626176 RowId = (1:928:25)

Slot 3 Offset 0x15bc
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B55BC: 00520030 01584911 00000000 000000e6 0.R..IX.........
681B55CC: 00020001 000000e6 00470001 00010003 ..........G.....
681B55DC: 00000001 00000002 00000002 00000000 ................
681B55EC: 00000000 00000000 00580000 0000005e ..........X.^...
681B55FC: 00000000 00000161 00000001 00000000 ....a...........
681B560C: 001b0000 00000000 00c00003 80e600d6 ................
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
681B567C: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B568C: 0065006d 00000031 002a87ab 3eb70000 m.e.1.....*....>
681B569C: 00010000 0004 ......
id = 22563089
status = 0
first = 0
indid = 2
root = 0
minlen = 71
keycnt = 3
groupid = 1
dpages = 1
reserved = 2
used = 2
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 88
maxirow = 94
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
name = RptRuntime1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664757248 RowId = (1:16055:4)

Slot 4 Offset 0xc04
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4C04: 00520030 0175b502 00004012 00000000 0.R...u..@......
681B4C14: 00010000 00000000 040c0000 00010001 ................
681B4C24: 00000000 00000000 00000000 00000000 ................
681B4C34: 00000000 00000000 04270000 00000022 ..........'."...
681B4C44: 00000000 00000000 00000000 00000000 ................
681B4C54: 001b0000 00000000 00800003 80a60096 ................
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
681B4C84: 006f0057 006b0072 00650043 0074006e W.o.r.k.C.e.n.t.
681B4C94: 00720065 00000030 002a84b7 55880000 e.r.0.....*....U
681B4CA4: 00010000 0007 ......
id = 24491266
status = 16402
first = 0
indid = 1
root = 0
minlen = 1036
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1063
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
name = WorkCenter0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182615212032 RowId = (1:21896:7)

Slot 5 Offset 0xb64
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4B64: 00520030 01ab548a 00004012 00000000 0.R..T...@......
681B4B74: 00010000 00000000 038e0000 00010001 ................
681B4B84: 00000000 00000000 00000000 00000000 ................
681B4B94: 00000000 00000000 03b00000 0000001a ................
681B4BA4: 00000000 00000000 00000000 00000000 ................
681B4BB4: 001b0000 00000000 00800003 80a00090 ................
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
681B4BE4: 004f0053 00650053 00750074 00300070 S.O.S.e.t.u.p.0.
681B4BF4: 84010000 0000002a 00000f23 00070001 ....*...#.......
id = 28005514
status = 16402
first = 0
indid = 1
root = 0
minlen = 910
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 944
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
name = SOSetup0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182603284480 RowId = (1:3875:7)

Slot 6 Offset 0x58c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B458C: 00520030 01c4f563 00004012 00000000 0.R.c....@......
681B459C: 00010000 00000000 04c70000 00010002 ................
681B45AC: 00000000 00000000 00000000 00000000 ................
681B45BC: 00000000 00000000 04e80000 00000027 ............'...
681B45CC: 00000000 00000000 00000000 00000000 ................
681B45DC: 001b0000 00000000 00a00003 80c400b4 ................
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
681B462C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B463C: 00300074 82fd0000 0000002a 0000068a t.0.....*.......
681B464C: 00490001 ..I.
id = 29685091
status = 16402
first = 0
indid = 1
root = 0
minlen = 1223
keycnt = 2
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1256
maxirow = 39
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
name = PurOrdDet0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586245120 RowId = (1:1674:73)

Slot 7 Offset 0x650
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4650: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4660: 00020000 00000000 002e0000 00010003 ................
681B4670: 00000000 00000000 00000000 00000000 ................
681B4680: 00000000 00000000 003f0000 00000045 ..........?.E...
681B4690: 00000000 00000000 00000000 00000000 ................
681B46A0: 001b0000 00000000 00c00003 80e400d4 ................
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
681B4710: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4720: 00310074 83040000 0000002a 0000068a t.1.....*.......
681B4730: 004a0001 ..J.
id = 29685091
status = 0
first = 0
indid = 2
root = 0
minlen = 46
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 63
maxirow = 69
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
name = PurOrdDet1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586703872 RowId = (1:1674:74)

Slot 8 Offset 0x734
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4734: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4744: 00030000 00000000 00340000 00010004 ..........4.....
681B4754: 00000000 00000000 00000000 00000000 ................
681B4764: 00000000 00000000 00450000 0000004b ..........E.K...
681B4774: 00000000 00000000 00000000 00000000 ................
681B4784: 001b0000 00000000 00e00003 810400f4 ................
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
681B4814: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4824: 00320074 83050000 0000002a 0000068a t.2.....*.......
681B4834: 004b0001 ..K.
id = 29685091
status = 0
first = 0
indid = 3
root = 0
minlen = 52
keycnt = 4
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 69
maxirow = 75
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
name = PurOrdDet2

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586769408 RowId = (1:1674:75)

Slot 9 Offset 0x838
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4838: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4848: 00040000 00000000 00120000 00010005 ................
681B4858: 00000000 00000000 00000000 00000000 ................
681B4868: 00000000 00000000 00230000 00000029 ..........#.)...
681B4878: 00000000 00000000 00000000 00000000 ................
681B4888: 001b0000 00000000 01000003 81240114 ..............$.
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
681B4938: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4948: 00330074 83060000 0000002a 0000068a t.3.....*.......
681B4958: 004c0001 ..L.
id = 29685091
status = 0
first = 0
indid = 4
root = 0
minlen = 18
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 35
maxirow = 41
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
name = PurOrdDet3

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586834944 RowId = (1:1674:76)

Slot 10 Offset 0x95c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B495C: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B496C: 00050000 00000000 003a0000 00010005 ..........:.....
681B497C: 00000000 00000000 00000000 00000000 ................
681B498C: 00000000 00000000 004b0000 00000051 ..........K.Q...
681B499C: 00000000 00000000 00000000 00000000 ................
681B49AC: 001b0000 00000000 01000003 81240114 ..............$.
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
681B4A5C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4A6C: 00340074 83070000 0000002a 0000068a t.4.....*.......
681B4A7C: 004d0001 ..M.
id = 29685091
status = 0
first = 0
indid = 5
root = 0
minlen = 58
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 75
maxirow = 81
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
name = PurOrdDet4

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586900480 RowId = (1:1674:77)

Slot 11 Offset 0xa80
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4A80: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4A90: 00060000 00000000 00200000 00010003 .......... .....
681B4AA0: 00000000 00000000 00000000 00000000 ................
681B4AB0: 00000000 00000000 00310000 00000037 ..........1.7...
681B4AC0: 00000000 00000000 00000000 00000000 ................
681B4AD0: 001b0000 00000000 00c00003 80e400d4 ................
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
681B4B40: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4B50: 00350074 83080000 0000002a 0000068a t.5.....*.......
681B4B60: 004e0001 ..N.
id = 29685091
status = 0
first = 0
indid = 6
root = 0
minlen = 32
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 49
maxirow = 55
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
name = PurOrdDet5

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586966016 RowId = (1:1674:78)

Slot 12 Offset 0xcac
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4CAC: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4CBC: 00070000 00000000 00110000 00010003 ................
681B4CCC: 00000000 00000000 00000000 00000000 ................
681B4CDC: 00000000 00000000 00220000 00000028 ..........".(...
681B4CEC: 00000000 00000000 00000000 00000000 ................
681B4CFC: 001b0000 00000000 00c00003 80ee00de ................
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
681B4D6C: 00750070 006f0072 00640072 00650064 p.u.r.o.r.d.d.e.
681B4D7C: 005f0074 00740073 00610072 0000006e t._.s.t.r.a.n...
681B4D8C: 002a84c7 78450000 00010000 001d ..*...Ex......
id = 29685091
status = 0
first = 0
indid = 7
root = 0
minlen = 17
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 34
maxirow = 40
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
name = purorddet_stran

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182616260608 RowId = (1:30789:29)

Slot 13 Offset 0xd4
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B40D4: 00520030 01d345b0 00004012 00000000 0.R..E...@......
681B40E4: 00010000 00000000 019b0000 00010006 ................
681B40F4: 00000000 00000000 00000000 00000000 ................
681B4104: 00000000 00000000 01b00000 0000007b ............{...
681B4114: 00000000 00000000 00000000 00000000 ................
681B4124: 001b0000 00000000 01200003 81460136 .......... .6.F.
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
681B41F4: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4204: 006c0063 00000030 002a8221 4d150000 c.l.0...!.*....M
681B4214: 00010000 003f ....?.
id = 30623152
status = 16402
first = 0
indid = 1
root = 0
minlen = 411
keycnt = 6
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 432
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
name = OptDepExcl0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182571827200 RowId = (1:19733:63)

Slot 14 Offset 0x21c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B421C: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B422C: 00020000 00000000 00640000 00010008 ..........d.....
681B423C: 00000000 00000000 00000000 00000000 ................
681B424C: 00000000 00000000 00750000 0000007b ..........u.{...
681B425C: 00000000 00000000 00000000 00000000 ................
681B426C: 001b0000 00000000 01600003 81860176 ..........`.v...
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
681B437C: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B438C: 006c0063 00000031 002a8224 4d150000 c.l.1...$.*....M
681B439C: 00010000 0040 ....@.
id = 30623152
status = 0
first = 0
indid = 2
root = 0
minlen = 100
keycnt = 8
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 117
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
name = OptDepExcl1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572023808 RowId = (1:19733:64)

Slot 15 Offset 0x3a4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B43A4: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B43B4: 00030000 00000000 00660000 0001000b ..........f.....
681B43C4: 00000000 00000000 00000000 00000000 ................
681B43D4: 00000000 00000000 00770000 0000007d ..........w.}...
681B43E4: 00000000 00000000 00000000 00000000 ................
681B43F4: 001b0000 00000000 01c00003 81e601d6 ................
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
681B4564: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4574: 006c0063 00000032 002a8225 4d150000 c.l.2...%.*....M
681B4584: 00010000 0041 ....A.
id = 30623152
status = 0
first = 0
indid = 3
root = 0
minlen = 102
keycnt = 11
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 119
maxirow = 125
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
name = OptDepExcl2

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572089344 RowId = (1:19733:65)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Now, the bad news. I am a bit of a novice and have picked this up from someone who left my company. It appears the latch error has been around for some time and only reared up when I instituted a new back up system that runs a dbcc check befor backing up. I don't think I have any clean backups.

Any help would be greatly appreciated.

Alex Mauer

View 17 Replies View Related

Reporting Services :: All Record Are Displaying On One Page - How To Display Page By Page

Nov 11, 2015

I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.

View 3 Replies View Related

SQLDescribeParam With Subselect: Invalid Parameter Number/Invalid Descriptor Index

Apr 21, 2008

Hello,

I've got the following query:

SELECT zA."ID" AS fA_A
, zA."TEXT" AS fA_B
, (
SELECT COUNT(zC."ID")
FROM Test."Booking" AS zC
) AS fA_E
FROM Test."Stack" AS zA
WHERE zA."ID" = ?

With this query I call:
- SQLPrepare -> SQL_SUCCESS=0
- SQLNumParams -> SQL_SUCCESS=0, pcpar = 1
- SQLDescribeParam( 1 ) -> SQL_ERROR=-1, [Microsoft][ODBC SQL Server Driver]Invalid parameter number", "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"

Is there a problem with this calling sequence or this query? Or is this a problem of SQL Server?

Regards
Markus

View 7 Replies View Related

Fatal Error 682 - What Is It And How Do You Fix It?

Feb 3, 2006

When trying to improve my app, I actually broke it (as you do) and came up with the error message reproduced herein. Any help in understanding the nature of the error and how to go about resolving it would be more than handy  
Server Error in '/' Application.


Warning: Fatal error 682 occurred at Feb  3 2006  9:26PM. Note the error and time, and contact your system administrator.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Warning: Fatal error 682 occurred at Feb  3 2006  9:26PM. Note the error and time, and contact your system administrator.Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:



[SqlException (0x80131904): Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857242
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734854
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlDataReader.HasMoreRows() +150
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +214
System.Data.SqlClient.SqlDataReader.Read() +9
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +156
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +153
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +172
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +175
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
Thank you in advance.

View 4 Replies View Related

SQL Fatal Error

Aug 18, 2006

Extended error: [What='Offending SQL: Select max(CommitTime) as LastChangeTime from ChangeTable;Warning: Fatal error 823 occurred at Aug 18 2006 8:42AM. '] [LCID='1024'] [SourceFile=''] [SourceFileLine='-1'] [DebugInfo=''] [RecommendedAction='The ODBC data source may be incorrectly configured, the database may not be running, or there may be incorrect data in the database.'] [ExtraInfo=''] [UniqueErrorId='4005'] [Severity='5'] [Source='(ISOK File serverwrapper.cpp, Line 501)'] [CategoryId='0']

what does this error means & how it cud be resolved.

View 3 Replies View Related

SQL Fatal Error

Jun 22, 2008

Here is the SQLDump log from our system. This database has not been backed up for a long time and a recent backup attempt failed. Without a recent backup, what would you advise our next step be?

=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server
version 9.00.3054.00
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.


Computer type is AT/AT COMPATIBLE.
Bios Version is INTEL - 20030825
BIOS Date: 08/25/03 14:08:08 Ver: 08.00.09
Current time is 14:38:58 06/20/08.
1 Intel x86 level 15, 3 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 2.

Memory
MemoryLoad = 69%
Total Physical = 3054 MB
Available Physical = 929 MB
Total Page File = 4416 MB
Available Page File = 2393 MB
Total Virtual = 2047 MB
Available Virtual = 322 MB


DBCC RESULTS
--------------------
<DbccResults>
<Dbcc ID="0" Error="8966" Severity="16" State="2">Unable to read and latch page (1:258137) with latch type SH. 23
(Data error (cyclic redundancy check).) failed. </Dbcc>
<Dbcc ID="1" Error="8966" Severity="16" State="2">Unable to read and latch page (1:260400) with latch type SH. 23
(Data error (cyclic redundancy check).) failed. </Dbcc>
<Dbcc ID="2" Error="8954" Severity="10" State="1">CHECKDB found 0 allocation errors and 2 consistency errors not
associated with any single object.</Dbcc>
<Dbcc ID="3" Error="2533" Severity="16" State="1">Table error: page (1:258137) allocated to object ID 885682303,
index ID 16, partition ID 72057594204127232, alloc unit ID 72057594215858176 (type In-row data) was not seen. The
page may be invalid or may have an incorrect alloc unit ID in its header.</Dbcc>
<Dbcc ID="4" Error="8976" Severity="16" State="1">Table error: Object ID 885682303, index ID 16, partition ID 720
57594204127232, alloc unit ID 72057594215858176 (type In-row data). Page (1:258137) was not seen in the scan alth
ough its parent (1:257976) and previous (1:258136) refer to it. Check any previous errors.</Dbcc>
<Dbcc ID="5" Error="8978" Severity="16" State="1">Table error: Object ID 885682303, index ID 16, partition ID 720
57594204127232, alloc unit ID 72057594215858176 (type In-row data). Page (1:258138) is missing a reference from p
revious page (1:258137). Possible chain linkage problem.</Dbcc>
<Dbcc ID="6" Error="8990" Severity="10" State="1">CHECKDB found 0 allocation errors and 3 consistency errors in t
able 'ActivityPointerBase' (object ID 885682303).</Dbcc>
<Dbcc ID="7" Error="2533" Severity="16" State="1">Table error: page (1:260400) allocated to object ID 1339971950,
index ID 1, partition ID 72057594205503488, alloc unit ID 72057594217365504 (type In-row data) was not seen. The
page may be invalid or may have an incorrect alloc unit ID in its header.</Dbcc>
<Dbcc ID="8" Error="8976" Severity="16" State="1">Table error: Object ID 1339971950, index ID 1, partition ID 720
57594205503488, alloc unit ID 72057594217365504 (type In-row data). Page (1:260400) was not seen in the scan alth
ough its parent (1:14431) and previous (1:260391) refer to it. Check any previous errors.</Dbcc>
<Dbcc ID="9" Error="8978" Severity="16" State="1">Table error: Object ID 1339971950, index ID 1, partition ID 720
57594205503488, alloc unit ID 72057594217365504 (type In-row data). Page (1:260401) is missing a reference from p
revious page (1:260400). Possible chain linkage problem.</Dbcc>
<Dbcc ID="10" Error="8990" Severity="10" State="1">CHECKDB found 0 allocation errors and 3 consistency errors in
table 'AsyncOperationBase' (object ID 1339971950).</Dbcc>
<Dbcc ID="11" Error="8989" Severity="10" State="1">CHECKDB found 0 allocation errors and 8 consistency errors in
database 'Mindsharp_MSCRM'.</Dbcc>
<Dbcc ID="12" Error="8957" Severity="-1" State="1">DBCC CHECKDB (Mindsharp_MSCRM) WITH no_infomsgs executed by MI
NDSHARPAdministrator found 8 errors and repaired 0 errors. Elapsed time: 0 hours 7 minutes 16 seconds.</Dbcc>
<Dbcc ID="13" Error="8958" Severity="10" State="1">repair_allow_data_loss is the minimum repair level for the err
ors found by DBCC CHECKDB (Mindsharp_MSCRM).</Dbcc>
</DbccResults>
**Dump thread - spid = 62, PSS = 0x52C0D320, EC = 0x52C0D328
***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLLOGSQLDump0002.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/20/08 14:38:58 spid 62
*
* DBCC database corruption
*
* Input Buffer 82 bytes -
* DBCC CHECKDB WITH NO_INFOMSGS
*
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump

PSS @0x52C0D320
---------------



CSession @0x52C0C278
--------------------
m_spid = 62 m_cRef = 14 m_rgcRefType[0] = 1
m_rgcRefType[1] = 1 m_rgcRefType[2] = 11 m_rgcRefType[3] = 1
m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x52C0C040
m_pstackBhfPool = 0x00000000 m_dwLoginFlags = 0x83e0 m_fBackground = 0
m_fClientRequestConnReset = 0 m_fUserProc = -1 m_fConnReset = 0
m_fIsConnReset = 0 m_fInLogin = 0 m_fAuditLoginSent = 1
m_fAuditLoginFailedSent = 0 m_fReplRelease = 0 m_fKill = 0
m_ulLoginStamp = 540428 m_eclClient = 5 m_protType = 6
m_hHttpToken = FFFFFFFF

m_pV7LoginRec
---------------------
00000000: 3c010000 03000a73 00100000 00000006 840c0000 †<......s............

00000014: 00000000 e0830000 00000000 00000000 5e000500 †................^...

00000028: 00000000 00000000 68002e00 c4000500 ce000000 †........h...........

0000003C: ce001c00 06010000 06010000 0007e959 912e0601 †...............Y....

00000050: 36003c01 00003c01 00000000 0000†††††††††††††††6.<...<.......



CPhysicalConnection @0x52C0C188
-------------------------------
m_pPhyConn->m_pmo = 0x52C0C040 m_pPhyConn->m_pNetConn = 0x52C0C7B0 m_pPhyConn->m_pConnList = 0x52C0C260
m_pPhyConn->m_pSess = 0x52C0C278 m_pPhyConn->m_fTracked = -1 m_pPhyConn->m_cbPacketsize = 4096
m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0

CBatch @0x52C0CAB8
------------------
m_pSess = 0x52C0C278 m_pConn = 0x52C0CA18 m_cRef = 3
m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1
m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x0085B4C8


EXCEPT (null) @0x3447B748
-------------------------
exc_number = 0 exc_severity = 0 exc_func = 0x02416380



Task @0x0085B4C8
----------------
CPU Ticks used (ms) = 118929 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x00000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x00000000 SchedulerId = 0x0
ThreadId = 0x141c m_state = 0 m_eAbortSev = 0



EC @0x52C0D328
--------------
spid = 62 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0 __fSubProc = 1
ec_dbccContext = 0x3447F560 __pSETLS = 0x52C0CA58 __pSEParams = 0x52C0CCF8
__pDbLocks = 0x52C0D618

SEInternalTLS @0x52C0CA58
-------------------------
m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x0085B4C8
m_activeHeapDatasetList = 0x52C0CA58 m_activeIndexDatasetList = 0x52C0CA60


SEParams @0x52C0CCF8
--------------------
m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x276C06B8 m_pSessionLocks = 0x52C0D828
m_pDbLocks = 0x52C0D618 m_execStats = 0x525CA508 m_pAllocFileLimit = 0x00000000




Thank you,

Tim

View 2 Replies View Related

Fatal Error 682 And SqlCacheDependency

Oct 16, 2007

Hello,

I have tried two ways for executing a query and creating a dependency
on it, one using plain Sql commands, the other using Enterprise
Library wrapped commands.

I keep getting:

Warning: Fatal error 682 occurred at Oct 12 2007 11:01AM. Note the
error and time, and contact your system administrator.

string xml = cmd.ExecuteScalar() as string;

When I execute it. Does anyone know what could cause this.

I have read both of these posts and have not yet been able to
investigate the SQL machine's event viewer though:

http://forums.asp.net/p/959871/1188606.aspx#1188606

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1203630&SiteID=1

The "value" column is an XML datatype field.

Thanks,
Josh



        public static ContentXmlUtilResult GetContentXml(
            string key,
            bool createDependency)
        {
            ContentXmlUtilResult result = new ContentXmlUtilResult();

            string connString = Global.Current.ConnectionString;

            using (SqlConnection conn =
                new SqlConnection(connString))
            {
                SqlCommand cmd =
                    new SqlCommand(
                        "SELECT Value FROM dbo.ContentXml WHERE [Key]
= '" + key + "'",
                        conn);

                if (createDependency)
                {
                    System.Web.Caching.SqlCacheDependency dependency =
                        new SqlCacheDependency(cmd);

                    result.Dependency = dependency;
                }

                conn.Open();

                string xml = cmd.ExecuteScalar() as string;

                conn.Close();

                result.Content = xml;
            }

            return result;

            //SqlCommand cmd = (SqlCommand)
            //    Global.Current.Database.GetSqlStringCommand(
            //    //@"SELECT Value FROM dbo.ContentXml WHERE [Key] =
@Key");
            //    @"SELECT Value FROM dbo.ContentXml WHERE [Key] = '"
+ key + "'");

            ////cmd.Parameters.Add("@Key", SqlDbType.VarChar).Value =
key;

            //if (createDependency)
            //{
            //    System.Web.Caching.SqlCacheDependency dependency =
            //        new System.Web.Caching.SqlCacheDependency(cmd);

            //    result.Dependency = dependency;
            //}

            //string xml = Global.Current.Database.ExecuteScalar(cmd)
as string;

            //result.Content = xml;

            //return result;
        }

View 1 Replies View Related

Fatal System Error

Jul 23, 2005

Whats happening:Error#: 40002Error Item: 01000: [Microsoft...][ODBC...][SQL...]The Statement hasbeen terminated. > GETID 'INSERT INTO Table(Column1, Column2, Column 3,Column4, Column5, Column6) VALUES("","Value1","Value2","Value3","Value4","Value5")'Error Message: 01000: Microsoft...][ODBC...][SQL...]The statement hasbeen terminated.Active Form: frmFormForm Name:---GETID Stored Procedure:---CREATE PROCEDURE GETID @strsql text ASPRINT cast(@strsql as varchar(4000))EXEC(" "+@strsql + " select @@identity as id")GO---Anyone know what could be causing it? The database has changed - thefrontend code hasn't, so it has to be a database problem. Whathappened was a few tables became incorrect so we restored them from abackup. Everything else seems to work, apart from adding a new recordto this table.You can edit current records etc..just not add.Thanks in advance,

View 1 Replies View Related

Fatal Error While Booting Up

May 13, 2008



While staring up ( XP home edition) I have the following error message: Fatal Error-Open Reg Key ex0 Failed, followed by Load Failed message.
The system boots up but the desktop item/icons & task bar keeps going on and off for awhile until only wallpaper is displayed. Mouse pointer still active but right/left click not responding.The system does not respond anymore at this point. When rebboting same thing happens.

Any idea what caised the problem and how to fix it?............thanks, LP

View 1 Replies View Related

EXECUTE AS , Fatal Exception

Oct 11, 2006

Hi There

If i add a new sysadmin login and that login is a user in a DB. If i execute the command EXECUTE AS 'LoginName':

I get the following error:

SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

WHats up with this?

If my dbo for this db is linked to a sysadmin login i have no problem with EXECUTE as 'dbo'.

WHy do i get fatal errors when trying to execute as a a login name that is sysadmin?

On the net all referencing to the fatal error have nothing to do with EXECUTE AS?

Thanx

View 7 Replies View Related

Internal Connection Fatal Error.

Oct 25, 2006

Hi all,I don’t know what happened to this function which was working OK for a few month and today it doesn’t work.In debug mode I kip getting “InvalidOperationaException was unhandled by user code”On this line:dtrResults = cmdSelect.ExecuteReader()Same behaviour on developping PCI cant find anithing that would create that problem. Function GetUserInfo(ByVal myUsr As String, ByVal strRequest As String) As String
Dim strConString As String
Dim conUsers As SqlConnection
Dim cmdSelect As SqlCommand

strConString = ConfigurationSettings.AppSettings("conString2")
conUsers = New SqlConnection(strConString)
Dim dtrResults As SqlDataReader
Dim intField As Integer
Dim usr As String
usr = "select " & strRequest & " user_ID from userlist where ul_user='"
usr &= myUsr & "'"
conUsers.Open()
cmdSelect = New SqlCommand(usr, conUsers)
dtrResults = cmdSelect.ExecuteReader()
While dtrResults.Read()
For intField = 0 To dtrResults.FieldCount - 1
GetUserInfo = dtrResults(intField).ToString()
Next
End While
conUsers.Close()
dtrResults.Close()
Return GetUserInfo
End Function   Any Help will highly appriciated.Alex.

View 1 Replies View Related

: Fatal Exception C0000005 EXCEPTION_ACCESS_VIOLATION

Feb 7, 2002

Hi guys

Recently, I noticed a monthly-run stored procedure (sp_insertAnnualRenewalLetterPrintedStatus) has been causing the aformentioned error, and it ended up creating all these .dmp files...
This stored proc was created 10 months ago, and the error only started happenin' for the last 3-4 months! Also, for approx. every one out of 10 times the stored proc ran OK!

Enclosed here is a sample content at the beginning of these .dmp files...
Anyone can shed some light? THANKS IN ADVANCE

SImon
================================================== ===================
BugCheck Dump
================================================== ===================

This file is generated by Microsoft SQL Server 1792.961
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is AT/AT COMPATIBLE.
Bios Version is Dell Remote Assistant Card v2.0 detected.
Phoenix ROM BIOS PLUS Version 1.10 A01
Current local time is Wed Feb 06 15:48:46 2002
2 Intel x86 level 6, 531 Mhz processor(s).
Windows NT 4.0 Build 1381 CSD Service Pack 6.


Memory
------
MemoryLoad = 38% TotalPhys = 255 MB AvailPhys = 2 MB
TotalPageFile = 493 MB

Stack Dump being sent to e:SQLdatalogSQL00024.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 02/06/02 15:48:46 spid 28
*
* Exception Address = 0064EBF2 (COpenLockBytesSSWrapper::OpenLockBytes + 40)
* Exception Code = c0000005 E
* Access Violation occurred reading address 00000004
* Input Buffer 126 bytes -
* s p _ i n s e r t A n n u a l R e n e w a l L e t t e r P r i n t e d S
* t a t u s ' 2 5 / 0 1 / 2 0 0 2 ' , 6 6 , 0

View 2 Replies View Related

SSIS OLE DB Command Fatal Error

Mar 24, 2008

I have a pretty simple senario.

In a data flow task, I have a OLE DB Source, which is a simple select statement. That is then connected to a OLE DB Command object, which executes a stored procedure on a different server, with the columns of the source as parameters to the stored procedure. I then have that connected to another OLE DB Command object, that will update the row in the source, marking it processed if there wasn't an error (no errors raised) in the stored procedure.

This seems to work just fine. Rows that had errors will error out, but I have the max allowed errors set very high to prevent the task from stopping. The problem that I have noticed is that if the very last row of the original source has an error, the component will fail with a fatal error and not go back and mark the rows that did succed as processed.

The fatal error looks like this:
Error: 0xC0047022 at OrderItems, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Insert OrderItem" (97) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

At this point I really believe this is a bug in SSIS, because if the last row succeeds, reguardless of how many rows failed in the middle, the last step runs, and updates the source as processed for the rows that did not fail. But if the last row fails, it doesn't execute the next step.

Has anyone experienced this before. I really hope there is a minor configuration change that can be made so I do not have to redesign the package. My only alternative at this point is to redesign the stored procedure to not raise an error, and return any errors in an output parameter, and then use a conditional split to determine what rows to go back and update at the source, and then rather than relying on the package output to see the errors, I'll have to write the errors to a table somewhere.

- Eric

View 1 Replies View Related

Fatal Error 1109 And Msdb Corrupt

Feb 9, 1999

Has anyone ever seen fatal error 1109, I cannot find any info on it. Also, our msdb was either corrupted at a clients site or someone deleted it and tried to recreate it to cover themselves....any how...all of the stored procedures are missing from it and it will not let us back up data or schedule tasks...do I need to re-install SQL Server 6.5 to fix this?

Thank you.

View 1 Replies View Related

Fatal Exception C0000005 Caught / EXCEPTION_ACCESS_VIOLATION

Feb 27, 2007

Hi,

I want to share an experience

Here are our server specs:
Intel Xeon 3.40Ghz [Duo]
4 Gb Memory
Raid 1 120Gb HDD
Windows 2000 Server
SQL Server 2000 Enterprise Edition


we tweaked the configuration in sp_configure

changed the following parameters
sp_configure 'max server memory (MB)',3000
go
reconfigure with override
go
--old value: 2002


sp_configure 'min server memory (MB)', 2500
go
reconfigure with override
go
--old value: 2048

sp_configure 'open objects', 2147000000
go
reconfigure with override
go
--old value: 2147483647

sp_configure 'awe enabled', 1
go
reconfigure with override
go
--old value: 0

sp_configure 'max worker threads', 255
go
reconfigure with override
go
--old value: 255

shutdown the database and out came this:

* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000008
*
************************************************** *****************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 00408E8B Module(sqlservr+00008E8B)
* 00408F5E Module(sqlservr+00008F5E)
* 00409056 Module(sqlservr+00009056)
* 00408E5E Module(sqlservr+00008E5E)
* 004020A8 Module(sqlservr+000020A8)
* 00401FCB Module(sqlservr+00001FCB)
* 00572114 Module(sqlservr+00172114) (SQLExit+0000A61D)
* 005655FD Module(sqlservr+001655FD)
* 7C2DCF43 Module(ADVAPI32+0000CF43) (GetNamedSecurityInfoW+000000E6)
* -------------------------------------------------------------------------------
2007-02-27 13:08:53.43 server Stack Signature for the dump is 0x0323EE71
2007-02-27 13:08:53.43 server SQL Server is aborting. Fatal exception c0000005 caught.

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



database won't start, what we did was to start the sql server with -f parameter and went back to the old settings

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

SqlDumpExceptionHandler: Process 145 Generated Fatal Exception

Apr 23, 2007

Hello,

we've recently upgraded a database from sql 2000 to sql 2005. There is one report that creates a fatal exception and sql dump whenever it is run. It ran without error in 2000.



The report is using several sql views and one stored proc. Running these individually via sql don't cause any errors. All other reports and processes run fine in 2005.



I'm at a loss as to what to check next. Any ideas?



Please let me know if I can provide any more details to help troubleshoot the issue.



thanks,

joe

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

Many Reads

Mar 25, 2008

Hi!
I was assigned to solve performance problems for an application. I fired up Sql Server profiler and started a trace. Downloaded Sql Server Trace Analyzer. It's a trial version so it's very limited. What I found is that one stored procedure generates almost 400 000 reads everytime it's used and it's used everytime the user wants to see his orders. I've tried to translate the t-sql to english from swedish, it looks something like this:


select top 100
o.orderid,
o.name,
o.latestdeldate,
os.name as OrderStatus,
os.orderstatusID,
p.placeID,
p.name as place,
p.address,
p.city,
a.name as worktype,
noOfActions=(select count(*) from actions a where a.order_orderid=o.orderid),
noOfServiceObjects = (select count(*) from Serviceobject s, Actions a where s.Place_PlaceID = o.Place_PlaceID and a.order_orderid = o.orderid and a.Serviceobject_serviceobjectid = s.serviceobjectid),
...
...
...


It has 8 select count(*) in the select statement then in the where statement it has 2 more select count(*).

I know it's very difficult for you to come up with a solution but do you know a better way than to use select count(*) everywhere? The count is used for to show different status flags on the website.

/Magnus

Jesus saves. But Gretzky slaps in the rebound.

View 19 Replies View Related

SQL 2005 Developer Edition Fails With Fatal Error

Aug 22, 2006

Hi,

I created one Installation file with below settings

[Options]
USERNAME=Developer
COMPANYNAME=Worldspan
INSTALLSQLDIR="C:SQL Server"
INSTALLSQLSHAREDDIR="C:SQL Server"
INSTALLSQLDATADIR="C:SQL Server"
INSTALLASDATADIR="C:SQL Server"
ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_FullText,Notification_Services,NS_Engine,NS_Client,SQL_DTS,Client_Components,Connectivity,SQL_Tools90,Tools_Legacy,SQL_Documentation,SQL_BooksOnline,SQL_AdventureWorksSamples,SQL_Samples
SAMPLEDATABASESERVER=".LOCALDEV2005"
INSTANCENAME=LOCALDEV2005
SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM"
SQLACCOUNT="NT AUTHORITYSYSTEM"
AGTACCOUNT="NT AUTHORITYSYSTEM"
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
AGTAUTOSTART=1
SECURITYMODE=SQL
SAPWD=L0ca1Dev$a
DISABLENETWORKPROTOCOLS=2

If I do the installation with the default path the installation goes fine or else the Installation fails with a fatal error. I have pasted the error log below :

Microsoft SQL Server 2005 Setup beginning at Mon Aug 21 22:13:33 2006
Process ID : 3060
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/7/21 22:13:33
Complete: LoadResourcesAction at: 2006/7/21 22:13:33, returned true
Running: ParseBootstrapOptionsAction at: 2006/7/21 22:13:33
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/7/21 22:13:33, returned true
Running: ValidateWinNTAction at: 2006/7/21 22:13:33
Complete: ValidateWinNTAction at: 2006/7/21 22:13:33, returned true
Running: ValidateMinOSAction at: 2006/7/21 22:13:33
Complete: ValidateMinOSAction at: 2006/7/21 22:13:33, returned true
Running: PerformSCCAction at: 2006/7/21 22:13:33
Complete: PerformSCCAction at: 2006/7/21 22:13:33, returned true
Running: ActivateLoggingAction at: 2006/7/21 22:13:33
Complete: ActivateLoggingAction at: 2006/7/21 22:13:33, returned true
Running: DetectPatchedBootstrapAction at: 2006/7/21 22:13:33
Complete: DetectPatchedBootstrapAction at: 2006/7/21 22:13:33, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__3060" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2006/7/21 22:13:33
Complete: PerformDotNetCheck2 at: 2006/7/21 22:13:33, returned true
Running: InvokeSqlSetupDllAction at: 2006/7/21 22:13:33
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [LHDQSKUMARR]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
Instance Name = LOCALDEV2005
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Machine = LHDQSKUMARR, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = XMLDomDocument, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = Processor, Result = 70010 (0x1117a)
Machine = LHDQSKUMARR, Article = PhysicalMemory, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = OSVersion, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = OSServicePack, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = OSType, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = iisDep, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = AdminShare, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = PendingReboot, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = PerfMon, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = IEVersion, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = COMPlus, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = LHDQSKUMARR, Article = MDAC25Version, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: LHDQSKUMARR
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: Warning
Description: Minimum hardware requirements are not met, therefore, some components may not perform as expected. Action: Make sure minimum hardware requirements are met. Please refer to the readme for minimum requirements.
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2006/7/21 22:13:54, returned true
Running: SetPackageInstallStateAction at: 2006/7/21 22:13:54
Complete: SetPackageInstallStateAction at: 2006/7/21 22:13:54, returned true
Running: DeterminePackageTransformsAction at: 2006/7/21 22:13:55
Complete: DeterminePackageTransformsAction at: 2006/7/21 22:13:55, returned true
Running: ValidateSetupPropertiesAction at: 2006/7/21 22:13:55
Complete: ValidateSetupPropertiesAction at: 2006/7/21 22:13:55, returned true
Running: OpenPipeAction at: 2006/7/21 22:13:55
Complete: OpenPipeAction at: 2006/7/21 22:13:55, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2006/7/21 22:13:55
Complete: CreatePipeAction at: 2006/7/21 22:13:55, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2006/7/21 22:13:56
Complete: PopulateMutatorDbAction at: 2006/7/21 22:13:56, returned true
Running: GenerateRequestsAction at: 2006/7/21 22:13:56
SQL_Engine = 3
SQL_Data_Files = 3
SQL_Replication = -1
SQL_FullText = 3
SQL_SharedTools = 3
SQL_BC_DEP = 3
Analysis_Server = -1
AnalysisDataFiles = -1
AnalysisSharedTools = -1
RS_Server = -1
RS_Web_Interface = -1
RS_SharedTools = -1
Notification_Services = 3
NS_Engine = 3
NS_Client = 3
SQL_DTS = 3
Client_Components = 3
Connectivity = 3
SQL_Tools90 = 3
SQL_WarehouseDevWorkbench = -1
SDK = -1
SQLXML = -1
Tools_Legacy = 3
TOOLS_BC_DEP = 3
SQL_Documentation = 3
SQL_BooksOnline = 3
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = 3
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = 3
Complete: GenerateRequestsAction at: 2006/7/21 22:13:57, returned true
Running: CreateProgressWindowAction at: 2006/7/21 22:13:57
Complete: CreateProgressWindowAction at: 2006/7/21 22:13:57, returned true
Running: ScheduleActionAction at: 2006/7/21 22:13:57
Complete: ScheduleActionAction at: 2006/7/21 22:13:58, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result.
Running: InstallDTSAction.11 at: 2006/7/21 22:13:58
Installing: sqlsupport on target: LHDQSKUMARR
Complete: InstallDTSAction.11 at: 2006/7/21 22:14:0, returned true
Running: InstallDTSAction.12 at: 2006/7/21 22:14:0
Installing: sqlncli on target: LHDQSKUMARR
Complete: InstallDTSAction.12 at: 2006/7/21 22:14:2, returned true
Running: InstallDTSAction.18 at: 2006/7/21 22:14:2
Installing: owc11 on target: LHDQSKUMARR
Complete: InstallDTSAction.18 at: 2006/7/21 22:14:4, returned true
Running: InstallDTSAction.22 at: 2006/7/21 22:14:4
Installing: bcRedist on target: LHDQSKUMARR
Complete: InstallDTSAction.22 at: 2006/7/21 22:14:7, returned true
Running: InstallDTSAction.9 at: 2006/7/21 22:14:7
Installing: msxml6 on target: LHDQSKUMARR
Complete: InstallDTSAction.9 at: 2006/7/21 22:14:8, returned true
Running: InstallNSAction.11 at: 2006/7/21 22:14:8
Installing: sqlsupport on target: LHDQSKUMARR
Complete: InstallNSAction.11 at: 2006/7/21 22:14:10, returned true
Running: InstallNSAction.12 at: 2006/7/21 22:14:10
Installing: sqlncli on target: LHDQSKUMARR
Complete: InstallNSAction.12 at: 2006/7/21 22:14:12, returned true
Running: InstallNSAction.18 at: 2006/7/21 22:14:12
Installing: owc11 on target: LHDQSKUMARR
Complete: InstallNSAction.18 at: 2006/7/21 22:14:21, returned true
Running: InstallNSAction.22 at: 2006/7/21 22:14:22
Installing: bcRedist on target: LHDQSKUMARR
Complete: InstallNSAction.22 at: 2006/7/21 22:14:24, returned true
Running: InstallNSAction.9 at: 2006/7/21 22:14:24
Installing: msxml6 on target: LHDQSKUMARR
Complete: InstallNSAction.9 at: 2006/7/21 22:14:25, returned true
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result.
Running: InstallSqlAction.11 at: 2006/7/21 22:14:26
Installing: sqlsupport on target: LHDQSKUMARR
Complete: InstallSqlAction.11 at: 2006/7/21 22:14:28, returned true
Running: InstallSqlAction.12 at: 2006/7/21 22:14:28
Installing: sqlncli on target: LHDQSKUMARR
Complete: InstallSqlAction.12 at: 2006/7/21 22:14:30, returned true
Running: InstallSqlAction.18 at: 2006/7/21 22:14:30
Installing: owc11 on target: LHDQSKUMARR
Complete: InstallSqlAction.18 at: 2006/7/21 22:14:32, returned true
Running: InstallSqlAction.21 at: 2006/7/21 22:14:32
Installing: sqlwriter on target: LHDQSKUMARR
Complete: InstallSqlAction.21 at: 2006/7/21 22:14:34, returned true
Running: InstallSqlAction.22 at: 2006/7/21 22:14:34
Installing: bcRedist on target: LHDQSKUMARR
Complete: InstallSqlAction.22 at: 2006/7/21 22:14:36, returned true
Running: InstallSqlAction.9 at: 2006/7/21 22:14:36
Installing: msxml6 on target: LHDQSKUMARR
Complete: InstallSqlAction.9 at: 2006/7/21 22:14:38, returned true
Running: InstallToolsAction.11 at: 2006/7/21 22:14:38
Installing: sqlsupport on target: LHDQSKUMARR
Complete: InstallToolsAction.11 at: 2006/7/21 22:14:41, returned true
Running: InstallToolsAction.12 at: 2006/7/21 22:14:41
Installing: sqlncli on target: LHDQSKUMARR
Complete: InstallToolsAction.12 at: 2006/7/21 22:14:43, returned true
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis:
No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.18 at: 2006/7/21 22:14:43
Installing: owc11 on target: LHDQSKUMARR
Complete: InstallToolsAction.18 at: 2006/7/21 22:14:46, returned true
Running: InstallToolsAction.20 at: 2006/7/21 22:14:46
Installing: BOL on target: LHDQSKUMARR
Complete: InstallToolsAction.20 at: 2006/7/21 22:15:36, returned true
Running: InstallToolsAction.22 at: 2006/7/21 22:15:36
Installing: bcRedist on target: LHDQSKUMARR
Complete: InstallToolsAction.22 at: 2006/7/21 22:15:38, returned true
Running: InstallToolsAction.9 at: 2006/7/21 22:15:38
Installing: msxml6 on target: LHDQSKUMARR
Complete: InstallToolsAction.9 at: 2006/7/21 22:15:40, returned true
Running: InstallDTSAction at: 2006/7/21 22:15:40
Installing: dts on target: LHDQSKUMARR
Failed to install package
Fatal error during installation.
Setting package return code to: 1603
Complete: InstallDTSAction at: 2006/7/21 22:16:30, returned false
Error: Action "InstallDTSAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Running: InstallNSAction.10 at: 2006/7/21 22:16:30
Installing: sqlxml4 on target: LHDQSKUMARR
Complete: InstallNSAction.10 at: 2006/7/21 22:16:32, returned true
Running: InstallSqlAction at: 2006/7/21 22:16:32
Installing: sql on target: LHDQSKUMARR
******* Got commit request from MSI *******
Complete: InstallSqlAction at: 2006/7/21 22:19:4, returned true
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run. Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Running: InstallNSAction at: 2006/7/21 22:19:4
Installing: ns on target: LHDQSKUMARR
Failed to install package
Fatal error during installation.
Setting package return code to: 1603
Complete: InstallNSAction at: 2006/7/21 22:20:17, returned false
Error: Action "InstallNSAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Running: InstallToolsAction at: 2006/7/21 22:20:17
Installing: tools on target: LHDQSKUMARR
Failed to install package
Fatal error during installation.
Setting package return code to: 1603
Complete: InstallToolsAction at: 2006/7/21 22:22:8, returned false
Error: Action "InstallToolsAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis:
No install request found for package: "bcRedist", install will be skipped as a result.
Skipped: UninstallForMSDE2000Action
Skipped: Action "UninstallForMSDE2000Action" was not run. Information reported during analysis:
No install request found for package: "patchMSDE2000", install will be skipped as a result.
Skipped: UninstallForSQLAction
Skipped: Action "UninstallForSQLAction" was not run. Information reported during analysis:
No install request found for package: "patchLibertySql", install will be skipped as a result.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2006/7/21 22:22:9
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097

I have a pentium PC with 599 MHZ speed and 1.5 GB of RAM with Windowsxp SP2. I already have an instance of SQL 2005 running at my box. Let me know if you need any more logs. When I tried to start the sql server it is working fine.



View 1 Replies View Related

Dirty Reads

Aug 1, 2001

If I'm doing a dirty reads and a someone updates a record when I'm trying to read it is it possible to read both the old and new records thereby retrieving two records?

View 2 Replies View Related

Reads / Writes Per Second.

Oct 30, 2006

How can You find the reads and writes per second of your hard drives in sql. I am reading my SQL book and it says that your average disk should have 125 or less i/o's. And it gave the forumal but as mentioned I don't know how to find the reads and writes.

View 4 Replies View Related

Reads, Clustering, Etc

May 1, 2008

server: QAT on clustering server ----> 23 seconds
----------------------------------------------------
SS 2000 developer edition SP4
win NT 5.2 (3790) SP4
MeM 7935 MB
processors 4
root directory C:program files...
use a fixed memeroy size 640 MB

reserve physical memory for sql server
minimum query memory 1024 kb

use all available processors
minimum query plan threshold for considering 5

PROFILER READS = 5234




server: MILLER ----> 3 seconds
----------------------------------------------------
SS 2000 developer edition no service pack
win NT 5.2 (3790) SP4
MeM 2047 MB
processors 4
root directory f:MSSQL$INAQAT

dynamically configure sql server memory

use all available processors
minimum query plan threshold for considering 5
PROFILER READS = 598





----------------------------------------------------
Making story short. I got an application that hits only 1 database called RECORDS. I'm getting different duration when running an application. 23 and 3 seconds.
Same database, same objects and same application.
SERVER QAT is our staging server, means lots of databases
SERVER MILLER is just a server i just assembled, means just one database (RECORDS).

Not sure if it's because it's a clustering server that is causing the issue nor the reads. If its the reads, what is causing it? Do you think is the how the memory is configured?. Will the experts pls stand up?

View 20 Replies View Related

More Reads Then Expected

Jul 18, 2006

So I€™m at a dead-end looking for the reason behind the following behavior. Just to make sure no one misses it, the 'behavior' is the difference in the number of reads between using sp_executesql and not.

The following statements are executed against a SQL 2000 database that contains >1,000,000 records in the act_item table. They are run using Query Analyzer and the Duration and Reads come from SQL Profiler

SQL 1:
exec sp_executesql N'update act_item set Priority = @Priority where activity_code = @activity_code', N'@activity_code nvarchar(40),@Priority int', @activity_code = N'46DF335F-68F7-493F-B55E-5F9BC6CEBC69', @Priority = 0

Reads: ~22000
Duraction: 250-350 ms

SQL 2:
DECLARE @Priority int
DECLARE @Activity_Code char(36)

SET @Priority = 0
SET @Activity_Code = '46DF335F-68F7-493F-B55E-5F9BC6CEBC69'
update act_item set Priority = @Priority where activity_code = @activity_code

Reads: ~160
Duration: 0 ms

Random information:

Activity_code is an indexed field on the table, although it is not the primary key. There are a total of four indexes on the table, none of which include the priority as one of the fields.
There are two triggers on the table, neither of which is executed for this SQL statement (there is an IF UPDATE(fieldname) surrounding the code in the trigger)
There are no foreign relationships
I checked (using perfmon) to see if a compilation/recompilation was happening. No it's not.
Any suggestions as to avenues that could be examined would be appreciated.

TIA

View 3 Replies View Related







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