Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

deleting Vault store from SQL

Created: 14 Nov 2011 | 9 comments
K.G.'s picture
0 0 Votes
Login to vote

Hi,

i want to delete 1 vault store from EV VAC.

after delete operation it says that deletion marked,it is ok normal prosedure but there is too small data in there 2 weeks passed and still in same point.

Also there are many errors in event logs,in every seconds it generetes manty erorr.EV services are down for this reason.

13360 and 6796 errors.

how can i delete this vault store from sql?

delete partition entry and vault store?(data is still using maybe sql angry to delete this data?)

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

 

11/11/2011,4:19:17 PM,Enterprise Vault ,Error,Storage Archive ,13360,N/A,ASPVAULT,"An error was detected while accessing the Vault Database 'EVvs' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010):

Could not find stored procedure 'uspi_Saveset'.

SQL Command:

uspi_Saveset

Native Error: 00002812

11/11/2011,4:19:17 PM,Enterprise Vault ,Error,Storage Archive ,6796,N/A,EVPVAULT,"A COM exception has been raised.

Discussion Filed Under:

Comments

CTEV's picture
14
Nov
2011
0 Votes 0
Login to vote

Hi K.G,What kind of Vault

Hi K.G,

What kind of Vault Store is it that you are trying to delete? i.e. Exchange mailbox, Public Folder or FSA etc.? Do you have any active archives stored on this vault store?

What kind of storage is the vault store partition stored on? Is Ev service the DBOwner of that Vault Store database?

K.G.'s picture
14
Nov
2011
0 Votes 0
Login to vote

hi,

there are 5 users in this vault store and all of the disabled state.

exchange mbx store.

normal san device is storage ,there is no resterection on deletion.

AndrewB's picture
14
Nov
2011
0 Votes 0
Login to vote

i would suggest you dtrace

i would suggest you dtrace storagedelete and restart the storage service to hopefully give some visibility into what's going on. you can post the logs here as an attachment for us to review.

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com

CTEV's picture
14
Nov
2011
0 Votes 0
Login to vote

Enable dtrace as AndrewB

Enable dtrace as AndrewB suggested and also enable SQL Server Profiler trace and attach that too. 

K.G.'s picture
16
Nov
2011
0 Votes 0
Login to vote

same lines occured many times

in dtrace there are many same errors;

 

1 14:23:11.719 [1748] (StorageArchive) <12252> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
2 14:23:11.719 [1748] (StorageArchive) <12252> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
3 14:23:11.844 [6364] (StorageArchive) <9516> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
4 14:23:11.844 [6364] (StorageArchive) <9516> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
5 14:23:11.984 [9524] (StorageArchive) <9284> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
6 14:23:11.984 [9524] (StorageArchive) <9284> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
7 14:23:12.094 [9524] (StorageArchive) <9284> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
8 14:23:12.094 [9524] (StorageArchive) <9284> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
9 14:23:12.266 [11556] (StorageArchive) <10388> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
10 14:23:12.266 [11556] (StorageArchive) <10388> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
11 14:23:12.406 [11556] (StorageArchive) <10388> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
12 14:23:12.406 [11556] (StorageArchive) <10388> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
13 14:23:12.562 [11556] (StorageArchive) <10388> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
14 14:23:12.562 [11556] (StorageArchive) <10388> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
15 14:23:12.656 [1748] (StorageArchive) <12252> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
16 14:23:12.656 [1748] (StorageArchive) <12252> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
17 14:23:12.750 [1748] (StorageArchive) <12252> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
18 14:23:12.750 [1748] (StorageArchive) <12252> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
19 14:23:12.859 [1748] (StorageArchive) <12252> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
20 14:23:12.859 [1748] (StorageArchive) <12252> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
21 14:23:12.937 [9524] (StorageArchive) <9284> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
22 14:23:12.937 [9524] (StorageArchive) <9284> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
23 14:23:13.031 [1748] (StorageArchive) <12252> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
24 14:23:13.047 [1748] (StorageArchive) <12252> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
25 14:23:13.156 [9524] (StorageArchive) <9284> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
26 14:23:13.156 [9524] (StorageArchive) <9284> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
27 14:23:13.266 [2564] (StorageArchive) <6256> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
28 14:23:13.266 [2564] (StorageArchive) <6256> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
29 14:23:13.359 [2564] (StorageArchive) <6256> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
30 14:23:13.375 [2564] (StorageArchive) <6256> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
31 14:23:13.500 [11556] (StorageArchive) <10388> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVOVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
32 14:23:13.500 [11556] (StorageArchive) <10388> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
33 14:23:13.656 [11556] (StorageArchive) <10388> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
34 14:23:13.672 [11556] (StorageArchive) <10388> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
35 14:23:13.734 [11556] (StorageArchive) <10388> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
36 14:23:13.734 [11556] (StorageArchive) <10388> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
37 14:23:13.844 [2564] (StorageArchive) <6256> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
38 14:23:13.844 [2564] (StorageArchive) <6256> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
39 14:23:13.969 [2564] (StorageArchive) <6256> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
40 14:23:13.984 [2564] (StorageArchive) <6256> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
41 14:23:14.062 [11556] (StorageArchive) <10388> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EVVS' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct  6 11:22:46 2010): |Description:  |Could not find stored procedure 'uspi_Saveset'.| | |SQL Command: | uspi_Saveset| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
42 14:23:14.062 [11556] (StorageArchive) <10388> EV~E Event ID: 6796 A COM exception has been raised. |<0x80040e14> |Internal reference |.\VaultStoreDB.cpp (CVaultStoreDB::AddSaveset) [lines {...,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2927}] built Oct  6 11:28:33 2010 | |An exception is raised when a process encounters an unexpected fault. |
Kai Schröer's picture
16
Nov
2011
0 Votes 0
Login to vote

Retention time?

Hi KG,

regardless of the errors.

It's possible that the Users has still archives in the system incl. archived elements which couldn't delete before the retention period is over.

PMCS.helpLine Software Gruppe
www.pmcs.de
Twitter: https://twitter.com/PMCS_EV

AndrewB's picture
16
Nov
2011
0 Votes 0
Login to vote

are you sure you set the

are you sure you set the dtrace to storagedelete?

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com

Paul Grimshaw's picture
16
Nov
2011
0 Votes 0
Login to vote

So USPI_Saveset is a stored

So USPI_Saveset is a stored procedure that performs inserts and so this SP is not called as part of deleting an archive. What would be called is USPD_Saveset.

So probably you are getting errors in uspi_saveset as this is trying to add savesets to another archive but cannot for whatever reason. This maybe down to blocking in SQL or something along those lines.

I would take a look and see if you have any blocking occuring on your SQL.

Did you have any archives residing in the Vault Store before you tried deleting the vault store or did you have an Empty VS and you are just trying to delete that?

EV Backline Technical Support Engineer APJ Region

Percy Vere's picture
23
Nov
2011
0 Votes 0
Login to vote

Based on your Dtrace It loos

Based on your Dtrace It loos like you may have deleted the database called 'EVVS' - is that correct? If so that would explain why the USPI_Saveset stored procedure is missing. Is there an exchange archving task for those mailboxes that existed in the deleted vault store?  If so then stop the task as it may still be trying to archive items into that VS.

A Stored Procedure called DeleteVaultStore exists under the Directory Database / Programmability section. This SP will show you the tables that record the various settings that relate to a Vault Store.