This problem occured after upgrade to 3.5, and before the upgrade we did have not seen it for some time.
But of course I can not be sure it is 3.5 related.
During an attempt to share two files from the Vault client app, we receive an error. The following text is found in the Vault log.
----9-13-2006 14:16:28 Roman_Kazmin--139.88.66.63(139.88.66.63)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#50AAF015__519F144E'. Cannot insert duplicate key in object 'dbo.@tbl'.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddFSObjectShares(VaultSqlConn conn, Int32 nRepID, String strXml, Int64 nObjVerID, Int64 nFolderObjVerID, Int64 nTxID, Int32 nTxItem, String strItemPath, String strComment, VaultDateTime dtMod) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddFSObjectShares(VaultSqlConn conn, Int32 nRepID, String strXml, Int64 nObjVerID, Int64 nFolderObjVerID, Int64 nTxID, Int32 nTxItem, String strItemPath, String strComment, VaultDateTime dtMod)
Best regards,
Hans Olav Nymand
Problem after upgrade to 3.5
Moderator: SourceGear
-
Hans Olav Nymand
- Posts: 55
- Joined: Wed Sep 29, 2004 8:09 am
- Location: Denmark, Copenhagen
- Contact:
What are you running as your server OS and what version of SQL server are you using?
It looks like there could possibly be some sort of corruption in your database. Could you run a checkdb on your database? Here's a link to an article with more details on what to do to fix errors (under Database Health): http://support.sourcegear.com/viewtopic.php?t=2924
It looks like there could possibly be some sort of corruption in your database. Could you run a checkdb on your database? Here's a link to an article with more details on what to do to fix errors (under Database Health): http://support.sourcegear.com/viewtopic.php?t=2924
-
Hans Olav Nymand
- Posts: 55
- Joined: Wed Sep 29, 2004 8:09 am
- Location: Denmark, Copenhagen
- Contact:
>What are you running as your server OS and what version of SQL server are you using?
1) Windows on which IIS for Vault server is running:
MS Windows 2000 Server SP4 (5.0.2195)
2) Windows on which SQL Server for Vault is running:
Windows Server 2003 R2 Standard x64 Edition SP1 (5.2.3790)
3) SQL Server for Vault:
SQL Server 2005 Standard x64 Edition
>It looks like there could possibly be some sort of corruption in your database. Could you run a checkdb on your database?
I did a CHECKDB run on the 'sgvault' database, but it reports no problems.
"CHECKDB found 0 allocation errors and 0 consistency errors in database 'sgVault'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator."
Please find a full copy of the CHECKDB output below.
Best regards,
Hans Olav Nymand
----------------------------------------------------------------------------------
DBCC results for 'sgVault'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1318 rows in 14 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 188 rows in 2 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 201 rows in 4 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1318 rows in 12 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 188 rows in 2 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 201 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 181 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 688 rows in 17 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 2237 rows in 56 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 20 rows in 1 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 52 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 386 rows in 8 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 831 rows in 5 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 742 rows in 372 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 15 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 498 rows in 4 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 3086 rows in 35 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'tblfolderentrypins'.
There are 8044 rows in 38 pages for object "tblfolderentrypins".
DBCC results for 'tblfsobjectattrs'.
There are 0 rows in 0 pages for object "tblfsobjectattrs".
DBCC results for 'tblfsobjectattrvalues'.
There are 0 rows in 0 pages for object "tblfsobjectattrvalues".
DBCC results for 'tblfsobjecthistoryitemmisc'.
There are 623218 rows in 6089 pages for object "tblfsobjecthistoryitemmisc".
DBCC results for 'tblfsobjecthistoryitems'.
There are 1189605 rows in 7481 pages for object "tblfsobjecthistoryitems".
DBCC results for 'tblfsobjectorigins'.
There are 195040 rows in 1309 pages for object "tblfsobjectorigins".
DBCC results for 'tblfsobjects'.
There are 605061 rows in 3238 pages for object "tblfsobjects".
DBCC results for 'tblfsobjectversionattrs'.
There are 0 rows in 0 pages for object "tblfsobjectversionattrs".
DBCC results for 'tblfsobjectversionattrvalues'.
There are 0 rows in 0 pages for object "tblfsobjectversionattrvalues".
DBCC results for 'tblfsobjectversionorigattrvalues'.
There are 0 rows in 0 pages for object "tblfsobjectversionorigattrvalues".
DBCC results for 'tblfsobjectversionfileinfos'.
There are 688314 rows in 4248 pages for object "tblfsobjectversionfileinfos".
DBCC results for 'tblfsobjectversionnames'.
There are 606055 rows in 4023 pages for object "tblfsobjectversionnames".
DBCC results for 'tblfsobjectversions'.
There are 1481597 rows in 12344 pages for object "tblfsobjectversions".
DBCC results for 'tblfulltreerevisionfolders'.
There are 104 rows in 2 pages for object "tblfulltreerevisionfolders".
DBCC results for 'tblgroups'.
There are 17 rows in 1 pages for object "tblgroups".
DBCC results for 'tblgroupmembers'.
There are 157 rows in 1 pages for object "tblgroupmembers".
DBCC results for 'tbllicensekeys'.
There are 7 rows in 1 pages for object "tbllicensekeys".
DBCC results for 'tblmergeablefileextensions'.
There are 1130 rows in 6 pages for object "tblmergeablefileextensions".
DBCC results for 'tblrepositories'.
There are 22 rows in 1 pages for object "tblrepositories".
DBCC results for 'tblfsobjectlabelviews'.
There are 1285014 rows in 19087 pages for object "tblfsobjectlabelviews".
DBCC results for 'tbltransactiondetailattrs'.
There are 1 rows in 1 pages for object "tbltransactiondetailattrs".
DBCC results for 'tblfsobjectlabels'.
There are 454 rows in 12 pages for object "tblfsobjectlabels".
DBCC results for 'tbltransactiondetailattrvalues'.
There are 40826 rows in 748 pages for object "tbltransactiondetailattrvalues".
DBCC results for 'tbltransactiondetails'.
There are 583414 rows in 6346 pages for object "tbltransactiondetails".
DBCC results for 'tbltransactionattrs'.
There are 1 rows in 1 pages for object "tbltransactionattrs".
DBCC results for 'tbltransactionattrvalues'.
There are 15133 rows in 257 pages for object "tbltransactionattrvalues".
DBCC results for 'tbltransactions'.
There are 111062 rows in 624 pages for object "tbltransactions".
DBCC results for 'tblfsobjectshares'.
There are 3210 rows in 82 pages for object "tblfsobjectshares".
DBCC results for 'tblschemaversions'.
There are 1 rows in 1 pages for object "tblschemaversions".
DBCC results for 'tblfsobjectlabelchanges'.
There are 179 rows in 2 pages for object "tblfsobjectlabelchanges".
DBCC results for 'tblsessions'.
There are 98 rows in 3 pages for object "tblsessions".
DBCC results for 'tblhistoryfavorites'.
There are 0 rows in 0 pages for object "tblhistoryfavorites".
DBCC results for 'tblhistoryfavoriteitems'.
There are 0 rows in 0 pages for object "tblhistoryfavoriteitems".
DBCC results for 'tblusers'.
There are 74 rows in 2 pages for object "tblusers".
DBCC results for 'tblusersecuritychanges'.
There are 1628 rows in 8 pages for object "tblusersecuritychanges".
DBCC results for 'tblfsobjectlabelchangedeltas'.
There are 7895 rows in 126 pages for object "tblfsobjectlabelchangedeltas".
DBCC results for 'tblvaultsettings'.
There are 1 rows in 1 pages for object "tblvaultsettings".
DBCC results for 'tblsessionlabelqueries'.
There are 0 rows in 1 pages for object "tblsessionlabelqueries".
DBCC results for 'tblsessionrecursivelabelqueries'.
There are 0 rows in 1 pages for object "tblsessionrecursivelabelqueries".
DBCC results for 'tbltreerevisionfolderdeltas'.
There are 1632706 rows in 13404 pages for object "tbltreerevisionfolderdeltas".
DBCC results for 'tbluserrepositories'.
There are 1572 rows in 4 pages for object "tbluserrepositories".
DBCC results for 'tbltreerevisionfolders'.
There are 221751 rows in 1737 pages for object "tbltreerevisionfolders".
DBCC results for 'tblsessionfolderexports'.
There are 377 rows in 11 pages for object "tblsessionfolderexports".
DBCC results for 'tblpendingtransactionobjects'.
There are 0 rows in 1 pages for object "tblpendingtransactionobjects".
DBCC results for 'tblsecurityassignments'.
There are 172 rows in 1 pages for object "tblsecurityassignments".
DBCC results for 'tblsecurityassignmentspaths'.
There are 72 rows in 2 pages for object "tblsecurityassignmentspaths".
DBCC results for 'tblplugins'.
There are 0 rows in 0 pages for object "tblplugins".
DBCC results for 'tblwatchers'.
There are 16 rows in 2 pages for object "tblwatchers".
DBCC results for 'tblfilefolderexclusions'.
There are 482 rows in 3 pages for object "tblfilefolderexclusions".
DBCC results for 'sys.queue_messages_1543728602'.
There are 0 rows in 0 pages for object "sys.queue_messages_1543728602".
DBCC results for 'sys.queue_messages_1575728716'.
There are 0 rows in 0 pages for object "sys.queue_messages_1575728716".
DBCC results for 'sys.queue_messages_1607728830'.
There are 0 rows in 0 pages for object "sys.queue_messages_1607728830".
DBCC results for 'tbltransactionfsobjectversions'.
There are 0 rows in 1 pages for object "tbltransactionfsobjectversions".
DBCC results for 'tbldelayusersecuritychanges'.
There are 0 rows in 0 pages for object "tbldelayusersecuritychanges".
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object "dtproperties".
DBCC results for 'tbldelaysecurityassignments'.
There are 0 rows in 0 pages for object "tbldelaysecurityassignments".
DBCC results for 'tbltransactionrepositorycounts'.
There are 0 rows in 1 pages for object "tbltransactionrepositorycounts".
DBCC results for 'tblbackups'.
There are 1 rows in 1 pages for object "tblbackups".
DBCC results for 'tblkeywordextensions'.
There are 456 rows in 2 pages for object "tblkeywordextensions".
DBCC results for 'tblbranchedhistoryitems'.
There are 708843 rows in 2456 pages for object "tblbranchedhistoryitems".
DBCC results for 'tblclientoptions'.
There are 5536 rows in 55 pages for object "tblclientoptions".
DBCC results for 'tblcloaks'.
There are 333 rows in 9 pages for object "tblcloaks".
DBCC results for 'tbldeletedfsobjects'.
There are 224108 rows in 1010 pages for object "tbldeletedfsobjects".
DBCC results for 'tblcheckoutlists'.
There are 3790 rows in 17 pages for object "tblcheckoutlists".
DBCC results for 'tbldeletions'.
There are 12025 rows in 86 pages for object "tbldeletions".
DBCC results for 'tblcheckoutlistitems'.
There are 1300925 rows in 50677 pages for object "tblcheckoutlistitems".
DBCC results for 'tbleolconversion'.
There are 5 rows in 1 pages for object "tbleolconversion".
DBCC results for 'tblfileinfo'.
There are 549621 rows in 3396 pages for object "tblfileinfo".
DBCC results for 'tblfolderentries'.
There are 12197418 rows in 41802 pages for object "tblfolderentries".
DBCC results for 'tblloginattempts'.
There are 0 rows in 1 pages for object "tblloginattempts".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'sgVault'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
1) Windows on which IIS for Vault server is running:
MS Windows 2000 Server SP4 (5.0.2195)
2) Windows on which SQL Server for Vault is running:
Windows Server 2003 R2 Standard x64 Edition SP1 (5.2.3790)
3) SQL Server for Vault:
SQL Server 2005 Standard x64 Edition
>It looks like there could possibly be some sort of corruption in your database. Could you run a checkdb on your database?
I did a CHECKDB run on the 'sgvault' database, but it reports no problems.
"CHECKDB found 0 allocation errors and 0 consistency errors in database 'sgVault'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator."
Please find a full copy of the CHECKDB output below.
Best regards,
Hans Olav Nymand
----------------------------------------------------------------------------------
DBCC results for 'sgVault'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1318 rows in 14 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 188 rows in 2 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 201 rows in 4 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1318 rows in 12 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 188 rows in 2 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 201 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 181 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 688 rows in 17 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 2237 rows in 56 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 20 rows in 1 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 52 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 386 rows in 8 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 831 rows in 5 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 742 rows in 372 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 15 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 498 rows in 4 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 3086 rows in 35 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'tblfolderentrypins'.
There are 8044 rows in 38 pages for object "tblfolderentrypins".
DBCC results for 'tblfsobjectattrs'.
There are 0 rows in 0 pages for object "tblfsobjectattrs".
DBCC results for 'tblfsobjectattrvalues'.
There are 0 rows in 0 pages for object "tblfsobjectattrvalues".
DBCC results for 'tblfsobjecthistoryitemmisc'.
There are 623218 rows in 6089 pages for object "tblfsobjecthistoryitemmisc".
DBCC results for 'tblfsobjecthistoryitems'.
There are 1189605 rows in 7481 pages for object "tblfsobjecthistoryitems".
DBCC results for 'tblfsobjectorigins'.
There are 195040 rows in 1309 pages for object "tblfsobjectorigins".
DBCC results for 'tblfsobjects'.
There are 605061 rows in 3238 pages for object "tblfsobjects".
DBCC results for 'tblfsobjectversionattrs'.
There are 0 rows in 0 pages for object "tblfsobjectversionattrs".
DBCC results for 'tblfsobjectversionattrvalues'.
There are 0 rows in 0 pages for object "tblfsobjectversionattrvalues".
DBCC results for 'tblfsobjectversionorigattrvalues'.
There are 0 rows in 0 pages for object "tblfsobjectversionorigattrvalues".
DBCC results for 'tblfsobjectversionfileinfos'.
There are 688314 rows in 4248 pages for object "tblfsobjectversionfileinfos".
DBCC results for 'tblfsobjectversionnames'.
There are 606055 rows in 4023 pages for object "tblfsobjectversionnames".
DBCC results for 'tblfsobjectversions'.
There are 1481597 rows in 12344 pages for object "tblfsobjectversions".
DBCC results for 'tblfulltreerevisionfolders'.
There are 104 rows in 2 pages for object "tblfulltreerevisionfolders".
DBCC results for 'tblgroups'.
There are 17 rows in 1 pages for object "tblgroups".
DBCC results for 'tblgroupmembers'.
There are 157 rows in 1 pages for object "tblgroupmembers".
DBCC results for 'tbllicensekeys'.
There are 7 rows in 1 pages for object "tbllicensekeys".
DBCC results for 'tblmergeablefileextensions'.
There are 1130 rows in 6 pages for object "tblmergeablefileextensions".
DBCC results for 'tblrepositories'.
There are 22 rows in 1 pages for object "tblrepositories".
DBCC results for 'tblfsobjectlabelviews'.
There are 1285014 rows in 19087 pages for object "tblfsobjectlabelviews".
DBCC results for 'tbltransactiondetailattrs'.
There are 1 rows in 1 pages for object "tbltransactiondetailattrs".
DBCC results for 'tblfsobjectlabels'.
There are 454 rows in 12 pages for object "tblfsobjectlabels".
DBCC results for 'tbltransactiondetailattrvalues'.
There are 40826 rows in 748 pages for object "tbltransactiondetailattrvalues".
DBCC results for 'tbltransactiondetails'.
There are 583414 rows in 6346 pages for object "tbltransactiondetails".
DBCC results for 'tbltransactionattrs'.
There are 1 rows in 1 pages for object "tbltransactionattrs".
DBCC results for 'tbltransactionattrvalues'.
There are 15133 rows in 257 pages for object "tbltransactionattrvalues".
DBCC results for 'tbltransactions'.
There are 111062 rows in 624 pages for object "tbltransactions".
DBCC results for 'tblfsobjectshares'.
There are 3210 rows in 82 pages for object "tblfsobjectshares".
DBCC results for 'tblschemaversions'.
There are 1 rows in 1 pages for object "tblschemaversions".
DBCC results for 'tblfsobjectlabelchanges'.
There are 179 rows in 2 pages for object "tblfsobjectlabelchanges".
DBCC results for 'tblsessions'.
There are 98 rows in 3 pages for object "tblsessions".
DBCC results for 'tblhistoryfavorites'.
There are 0 rows in 0 pages for object "tblhistoryfavorites".
DBCC results for 'tblhistoryfavoriteitems'.
There are 0 rows in 0 pages for object "tblhistoryfavoriteitems".
DBCC results for 'tblusers'.
There are 74 rows in 2 pages for object "tblusers".
DBCC results for 'tblusersecuritychanges'.
There are 1628 rows in 8 pages for object "tblusersecuritychanges".
DBCC results for 'tblfsobjectlabelchangedeltas'.
There are 7895 rows in 126 pages for object "tblfsobjectlabelchangedeltas".
DBCC results for 'tblvaultsettings'.
There are 1 rows in 1 pages for object "tblvaultsettings".
DBCC results for 'tblsessionlabelqueries'.
There are 0 rows in 1 pages for object "tblsessionlabelqueries".
DBCC results for 'tblsessionrecursivelabelqueries'.
There are 0 rows in 1 pages for object "tblsessionrecursivelabelqueries".
DBCC results for 'tbltreerevisionfolderdeltas'.
There are 1632706 rows in 13404 pages for object "tbltreerevisionfolderdeltas".
DBCC results for 'tbluserrepositories'.
There are 1572 rows in 4 pages for object "tbluserrepositories".
DBCC results for 'tbltreerevisionfolders'.
There are 221751 rows in 1737 pages for object "tbltreerevisionfolders".
DBCC results for 'tblsessionfolderexports'.
There are 377 rows in 11 pages for object "tblsessionfolderexports".
DBCC results for 'tblpendingtransactionobjects'.
There are 0 rows in 1 pages for object "tblpendingtransactionobjects".
DBCC results for 'tblsecurityassignments'.
There are 172 rows in 1 pages for object "tblsecurityassignments".
DBCC results for 'tblsecurityassignmentspaths'.
There are 72 rows in 2 pages for object "tblsecurityassignmentspaths".
DBCC results for 'tblplugins'.
There are 0 rows in 0 pages for object "tblplugins".
DBCC results for 'tblwatchers'.
There are 16 rows in 2 pages for object "tblwatchers".
DBCC results for 'tblfilefolderexclusions'.
There are 482 rows in 3 pages for object "tblfilefolderexclusions".
DBCC results for 'sys.queue_messages_1543728602'.
There are 0 rows in 0 pages for object "sys.queue_messages_1543728602".
DBCC results for 'sys.queue_messages_1575728716'.
There are 0 rows in 0 pages for object "sys.queue_messages_1575728716".
DBCC results for 'sys.queue_messages_1607728830'.
There are 0 rows in 0 pages for object "sys.queue_messages_1607728830".
DBCC results for 'tbltransactionfsobjectversions'.
There are 0 rows in 1 pages for object "tbltransactionfsobjectversions".
DBCC results for 'tbldelayusersecuritychanges'.
There are 0 rows in 0 pages for object "tbldelayusersecuritychanges".
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object "dtproperties".
DBCC results for 'tbldelaysecurityassignments'.
There are 0 rows in 0 pages for object "tbldelaysecurityassignments".
DBCC results for 'tbltransactionrepositorycounts'.
There are 0 rows in 1 pages for object "tbltransactionrepositorycounts".
DBCC results for 'tblbackups'.
There are 1 rows in 1 pages for object "tblbackups".
DBCC results for 'tblkeywordextensions'.
There are 456 rows in 2 pages for object "tblkeywordextensions".
DBCC results for 'tblbranchedhistoryitems'.
There are 708843 rows in 2456 pages for object "tblbranchedhistoryitems".
DBCC results for 'tblclientoptions'.
There are 5536 rows in 55 pages for object "tblclientoptions".
DBCC results for 'tblcloaks'.
There are 333 rows in 9 pages for object "tblcloaks".
DBCC results for 'tbldeletedfsobjects'.
There are 224108 rows in 1010 pages for object "tbldeletedfsobjects".
DBCC results for 'tblcheckoutlists'.
There are 3790 rows in 17 pages for object "tblcheckoutlists".
DBCC results for 'tbldeletions'.
There are 12025 rows in 86 pages for object "tbldeletions".
DBCC results for 'tblcheckoutlistitems'.
There are 1300925 rows in 50677 pages for object "tblcheckoutlistitems".
DBCC results for 'tbleolconversion'.
There are 5 rows in 1 pages for object "tbleolconversion".
DBCC results for 'tblfileinfo'.
There are 549621 rows in 3396 pages for object "tblfileinfo".
DBCC results for 'tblfolderentries'.
There are 12197418 rows in 41802 pages for object "tblfolderentries".
DBCC results for 'tblloginattempts'.
There are 0 rows in 1 pages for object "tblloginattempts".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'sgVault'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
-
Hans Olav Nymand
- Posts: 55
- Joined: Wed Sep 29, 2004 8:09 am
- Location: Denmark, Copenhagen
- Contact:
Hi Beth,
We tried doing the same transaction again with Debug logging enabled.
The log output follows.
Regards,
Hans Olav
----------------------------------------------------------------------------------
----9-14-2006 11:19:51 sgvaultsystem--()--
System Started
Version 3.5.0.4741
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINNT\Temp\sgvault
Log Level = Debug
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain =
SGVault Working Directory = C:\WINNT\Temp
SGVault Server URL = http://svrfreja.pdc.xx/VaultService
Identity = PDC\sa sgVault
----9-14-2006 11:19:51 --()-- Beginning SQL transaction 125
----9-14-2006 11:19:51 --()-- SQL transaction 125 successfully committed.
----9-14-2006 11:19:51 --()-- Beginning SQL transaction 124
----9-14-2006 11:19:51 --()-- SQL transaction 124 successfully committed.
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 236
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 236 successfully committed.
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Login
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetUserOptions returned: Success
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Success
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetUserList returned: Success
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositories returned: Success
----9-14-2006 11:20:14 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Getting repository Structure-> Rep ID: 3 Base: 111363 Target: -1
----9-14-2006 11:20:14 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: Filling empty cache with current tree.
----9-14-2006 11:20:23 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:11 RepID:3 Base:111363 Target:111370 Calling VaultTreeManager.GetRepositoryDelta() - db tree diff.
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositoryStructure returned: Success
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Getting list of checkout changes.
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 111370
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled VaultServiceAPI::GetCheckoutListChanges() Status:0 UserID:11 RepID:3 FolderSecurity:True BaseList:138844 Target List:138870 RefreshFlag:False
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetCheckOutListChanges returned: Success
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetUserEmailOptions returned Success
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 111370
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled ListWatchers returned Success
----9-14-2006 11:20:29 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled ListCloakedObjects returned: Success
----9-14-2006 11:20:29 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositoryOptions returned: Success
----9-14-2006 11:20:29 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositories returned: Success
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled BeginTx beginning transaction
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 111370
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled (374f7bfd-4759-41f7-8ead-1c5a56ed2a6a) BeginTx returned: Success
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled (374f7bfd-4759-41f7-8ead-1c5a56ed2a6a) Share: $/eMap/Source/eMapServer/Work/src/eMapServerSolution/eMapServer/MapComm/compatibility.cpp to $/eMap/Source/eMapServer/Work/src/ShapeSolution/Shape returned: Success
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Ending transaction
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 327
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Attempting to acquire repository lock.
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Acquired repository lock.
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager Signal - Tx Begin - CacheLockId:328
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: A transaction is pending, but it belongs to the current user. Returning cached tree, revID 111370
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#1B64C7A6__1C58EBDF'. Cannot insert duplicate key in object 'dbo.@tbl'.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddFSObjectShares(VaultSqlConn conn, Int32 nRepID, String strXml, Int64 nObjVerID, Int64 nFolderObjVerID, Int64 nTxID, Int32 nTxItem, String strItemPath, String strComment, VaultDateTime dtMod) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddFSObjectShares(VaultSqlConn conn, Int32 nRepID, String strXml, Int64 nObjVerID, Int64 nFolderObjVerID, Int64 nTxID, Int32 nTxItem, String strItemPath, String strComment, VaultDateTime dtMod)
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled EndTx(): Failed commit changes for TxID 111371
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 327 successfully rolled back.
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 440
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 440 successfully committed.
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager Signal - Tx End - TxID:111371 CacheLockId:328 RepID:3
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled (374f7bfd-4759-41f7-8ead-1c5a56ed2a6a) EndTx (Revision - 0) returned: FailDBFault
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled (374f7bfd-4759-41f7-8ead-1c5a56ed2a6a) Share: $/eMap/Source/eMapServer/Work/src/eMapServerSolution/eMapServer/MapComm/compatibility.cpp to $/eMap/Source/eMapServer/Work/src/ShapeSolution/Shape returned: FailDBFault
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Getting repository Structure-> Rep ID: 3 Base: 111370 Target: -1
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 111370
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:11 RepID:3 Base:111370 Target:111370 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositoryStructure returned: Success
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Getting list of checkout changes.
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetCheckOutListChanges returned: Success
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Logout
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 493
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 493 successfully committed.
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 494
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 494 successfully committed.
We tried doing the same transaction again with Debug logging enabled.
The log output follows.
Regards,
Hans Olav
----------------------------------------------------------------------------------
----9-14-2006 11:19:51 sgvaultsystem--()--
System Started
Version 3.5.0.4741
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINNT\Temp\sgvault
Log Level = Debug
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain =
SGVault Working Directory = C:\WINNT\Temp
SGVault Server URL = http://svrfreja.pdc.xx/VaultService
Identity = PDC\sa sgVault
----9-14-2006 11:19:51 --()-- Beginning SQL transaction 125
----9-14-2006 11:19:51 --()-- SQL transaction 125 successfully committed.
----9-14-2006 11:19:51 --()-- Beginning SQL transaction 124
----9-14-2006 11:19:51 --()-- SQL transaction 124 successfully committed.
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 236
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 236 successfully committed.
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Login
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetUserOptions returned: Success
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Success
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetUserList returned: Success
----9-14-2006 11:20:12 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositories returned: Success
----9-14-2006 11:20:14 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Getting repository Structure-> Rep ID: 3 Base: 111363 Target: -1
----9-14-2006 11:20:14 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: Filling empty cache with current tree.
----9-14-2006 11:20:23 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:11 RepID:3 Base:111363 Target:111370 Calling VaultTreeManager.GetRepositoryDelta() - db tree diff.
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositoryStructure returned: Success
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Getting list of checkout changes.
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 111370
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled VaultServiceAPI::GetCheckoutListChanges() Status:0 UserID:11 RepID:3 FolderSecurity:True BaseList:138844 Target List:138870 RefreshFlag:False
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetCheckOutListChanges returned: Success
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetUserEmailOptions returned Success
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 111370
----9-14-2006 11:20:28 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled ListWatchers returned Success
----9-14-2006 11:20:29 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled ListCloakedObjects returned: Success
----9-14-2006 11:20:29 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositoryOptions returned: Success
----9-14-2006 11:20:29 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositories returned: Success
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled BeginTx beginning transaction
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 111370
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled (374f7bfd-4759-41f7-8ead-1c5a56ed2a6a) BeginTx returned: Success
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled (374f7bfd-4759-41f7-8ead-1c5a56ed2a6a) Share: $/eMap/Source/eMapServer/Work/src/eMapServerSolution/eMapServer/MapComm/compatibility.cpp to $/eMap/Source/eMapServer/Work/src/ShapeSolution/Shape returned: Success
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Ending transaction
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 327
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Attempting to acquire repository lock.
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Acquired repository lock.
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager Signal - Tx Begin - CacheLockId:328
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: A transaction is pending, but it belongs to the current user. Returning cached tree, revID 111370
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__#1B64C7A6__1C58EBDF'. Cannot insert duplicate key in object 'dbo.@tbl'.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddFSObjectShares(VaultSqlConn conn, Int32 nRepID, String strXml, Int64 nObjVerID, Int64 nFolderObjVerID, Int64 nTxID, Int32 nTxItem, String strItemPath, String strComment, VaultDateTime dtMod) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.AddFSObjectShares(VaultSqlConn conn, Int32 nRepID, String strXml, Int64 nObjVerID, Int64 nFolderObjVerID, Int64 nTxID, Int32 nTxItem, String strItemPath, String strComment, VaultDateTime dtMod)
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled EndTx(): Failed commit changes for TxID 111371
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 327 successfully rolled back.
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 440
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 440 successfully committed.
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager Signal - Tx End - TxID:111371 CacheLockId:328 RepID:3
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled (374f7bfd-4759-41f7-8ead-1c5a56ed2a6a) EndTx (Revision - 0) returned: FailDBFault
----9-14-2006 11:20:59 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled (374f7bfd-4759-41f7-8ead-1c5a56ed2a6a) Share: $/eMap/Source/eMapServer/Work/src/eMapServerSolution/eMapServer/MapComm/compatibility.cpp to $/eMap/Source/eMapServer/Work/src/ShapeSolution/Shape returned: FailDBFault
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Getting repository Structure-> Rep ID: 3 Base: 111370 Target: -1
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 111370
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:11 RepID:3 Base:111370 Target:111370 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetRepositoryStructure returned: Success
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Getting list of checkout changes.
----9-14-2006 11:21:00 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled GetCheckOutListChanges returned: Success
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Logout
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 493
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 493 successfully committed.
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled Beginning SQL transaction 494
----9-14-2006 11:21:05 Hans_Olav_Nymand--hon.pdc.xx(139.88.66.61)--SSL Disabled SQL transaction 494 successfully committed.