SQL errors upgrade from 8.0.5 to 9.0.3

[Rob_dos_Ramos]

Hi All

Tried to upgrade from 8.0.5 to 9.0.3 and I get the following errors, 

Event Type: Error

Event Source: Enterprise Vault 

Event Category: Storage Server 

Event ID: 6875

Date: 11/30/2011

Time: 7:23:42 PM

User: N/A

Computer: RBKEVA01

Description:

An error occurred attempting to update Storage database 

Reason: Failed to find an attribute in the Partition Cache.      (0xc0041aa3) 

Reference: UVSDBs/uvsdb 

Script File: C:\Program Files\Enterprise Vault\VaultStoreDB_8_Programmability.sql 

Vault Store: Mailbox Vault Store 

Vault Store Id: 19FAF97E7A281414FA3023FBF98C5630D1210000avusaevsite 

Database Name: EVMailboxVaultStore 

DSN: EVMailboxVaultStore 

For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp?EvtID=6875

Event Type: Error

Event Source: Enterprise Vault 

Event Category: Storage Management 

Event ID: 7051

Date: 11/30/2011

Time: 7:23:42 PM

User: N/A

Computer: RBKEVA01

Description:

An error occurred whilst inserting into the Vault Store Database PartitionCache table. 

VaultStoreEntry: 19FAF97E7A281414FA3023FBF98C5630D1210000avusaevsite 

PartitionEntry: All related partitions 

IdPartition: All related partitions 

Error: 0xC0041AA3 

For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp?EvtID=7051

any help would be great. thanks

[JesusWept3]

Recommend calling support ASAP, be prepared to restore your databases to pre upgrade condition

[AndrewB]

ditto

[Percy_Vere]

I suspect differing values between the dbo.partitioncache table of the vault store database in the column IdPartition when compared to IdPartition from dbo.partitionentry table in the EnterpriseVault  Directory Database .

If that's not it then I suggest you run a dtrace of StorageManagement, Directory Service and StorageService and also an SQL profiler trace whilst running the upgrade as this will help support in locating the issue with the partitioncache table - http://www.symantec.com/docs/TECH48699

[Rob_dos_Ramos · Accepted solution]

OPened a support case and it turned out that the problem was that the PTN in the extendersettings was missing infomation.

So after some SQL scripts we sorted out the issue. Would post the scripts but in the maddness of getting the server running I did not save the scripts.